Skip to main content

Journal entries dashboard

The journal entries dashboard provides all the raw data needed to integrate seamlessly with your accounting system.

Updated over a week ago

Purpose

The Journal Entries dashboard surfaces every financial movement produced by Smeetz at ticket‑line level so that you can feed the data straight into your accounting stack (general ledger, analytics warehouse, BI, etc.).

These are the different types of rows you will see:

  • Sales → can either be:

    • Sale :revenue independent from whether it’s paid.

    • Discount.

    • Cancellation (either of the sale or of the discount).

  • Payment → Either a payment or a refund.

Example – A booking containing 1 Child ticket + 1 Adult ticket that are both paid will create 4 entries (2 × Sales + 2 × Payment). If there was a discount applied on the Adult ticket then there will be an extra row that records the discount. If the child ticket was cancelled and refunded you will have 2 extra entries, one that is the refund and one cancelling the original sale.


Column Reference

Column

Description

Creation date

Timestamp when the journal line was generated.

Modification date

Timestamp of the last update to this line.

Sales recognition date

Date when revenue is recognized in your books.

Status

Lifecycle status of the entry – Completed, Refunded, Pending

Journal entry ID

Internal unique identifier for the journal entry.

Transaction type

Sales or Payment.

Booking reference

Public order reference visible to the customer.

Booking statement ID

Booking statement ID visible in Booking statements page in the back-office.

Seller (full name)

Name of the operator or POS user that executed the sale.

Closure ID

Identifier of the POS closure this line belongs to.

Sales opening date & time

When the POS sales session was opened.

Sales closing date & time

When the POS sales session was closed.

Product name

Name of the product or experience sold.

Item name

Name of the ticket / Item sold.

Item category

Type of item sold: Ticket, Retail, Membership, Donation.

Includes a ticket with a B2B tag

True/False flag indicating if any ticket in the booking carries the B2B tag.

Includes a ticket with a birthday tag

True/False flag indicating if any ticket in the booking carries the Birthday tag.

Price name

Name of the applied price.

Price type

Paid, Free

Ticket start date

Start of the validity period.

Ticket end date

End of the validity period.

Ticket / Item ID

Internal ID of the ticket.

Ticket / Item token

Unique token encoded in the QR‑code for scanning.

Accounting code

Code assigned to prices to group revenue.

Analytic code

Price excl. tax (before discounts)

Unit price before discounts & VAT.

Discount excl. tax

Absolute discount amount (without VAT).

Price excl. tax (after discounts)

Net price after discounts (without VAT).

VAT rate

VAT % applied (if any).

VAT amount

Calculated VAT value.

Total incl. tax

Gross price (Net + VAT).

Payment value

Amount paid by the customer in case of payment.

Refund value

Amount refunded in case of refund.

Valid tickets

1 in case of sale, 0 in case of payment, discount or refund. -1 in case of cancellation. Used to count sum of sold tickets.

Ticket is scanned

True/False flag

Number of scans

Total scans for the specific ticket.

Last scan date

Timestamp of the most recent scan.

Payment method

Payment method used, set in payment entries.

Booking fees excl. tax

Payment fees fixed excl. tax

Payment fee variable excl. tax

Interchange fee excl. tax

Scheme fee excl. tax

Other payment fees excl. tax

Total fees excl. tax

Sum of all fees without VAT.

VAT on fees

VAT amount applied to fees.

Other tax

Additional non‑VAT taxes.

Total fees incl. tax

Fees including VAT.

User Agent

Identifier of the application that created the booking – POS, Online, Kiosk, API.

Sales channel

Channel label (POS, Back-office, E-commerce, OTA, Kiosk, Chatbot)

Customer company / Customer first name / last name / email / phone / zip code / birth date

Self‑explanatory fields pulled from the order form.

Location name / zip code / city

Venue location tied to the event.


Filter Reference

Filter

What it does

Date type filter

Selects which date column the range applies to (Transaction, Creation, Sales recognition…).

Date range

Quick presets (Today, Week‑to‑date, Month, Custom…) or absolute dates.

Product name

Only show entries belonging to selected product(s).

Ticket / Item name

Filter by a specific ticket or add‑on.

Price name

Filter by a particular price name.

Price type

Paid, Free

Ticket type

Ticket, Add‑on, Subscription, Gift card…

Sales channel

Online, POS, Kiosk, API, Reseller…

Option

Retail option name

Accounting code

Show only lines mapped to a given GL account.

Category

Product category.

Payment method

Payment method used, will filter only for payment transactions.

Booking reference

Search by specific booking code.

Segment

Customer segment tag.

Toolbar actions

  • Apply filters – run the query.

  • Refresh – reload latest data and recalculate totals.

  • Share – Share the dashboard externally or Download/send to email as PDF or image.

  • Columns ⚙️ – show/hide and rename columns.

  • Inline filter icon 🔍 – add quick column‑specific filters.

  • Download ⬇️ – export the current table as PDF, to CSV or XLSX.

Did this answer your question?