Check every register of your venue from the back office: reconcile each cashier's drawer, review sales, VAT and payments, and export every transaction line.
This dashboard shows all cashiers and all shifts of your venue. It is the manager's version of the Cashier report POS, which each cashier sees scoped to their own sales.
Who this is for
Primary: venue and POS managers closing the day across several registers.
Secondary: finance and accounting reviewing cash reconciliation, VAT and payments, or exporting transactions.
When to use it
At the end of the day or the week, to check that every drawer balances, to see what was sold and how customers paid, and to export the transaction lines for your accounting.
Why use this dashboard
One place for the whole venue: the shift and cash figures of every cashier, the sales and VAT tables, the payment methods, and a full transaction report with ticket validity, scan status, location, VAT code and customer details on every line.
Access and default filters
How to access: app.smeetz.com > Analytics > Dashboards > Cashier Report (BO)
Scope: all shifts and sales of your venue, every cashier.
Date basis: the sales, VAT, payment and transaction tables follow the transaction date; the shift tables follow the shift opening date. The previous report grouped sales by the shift's closing date, so a shift closed after midnight or the next morning can appear on a different day than before. Monthly totals are unchanged.
How current the data is: the dashboard shows a Last data refresh time in its header; the data refreshes every 4 hours.
Filter guide
Shift date: filters the shift and reconciliation tables by the day a shift was opened.
Transaction date: filters the sales, VAT, payment and transaction tables by the day of the transaction.
Cashier (shifts) and Cashier (sales): narrow the report to one cashier on the shift tables and on the sales tables.
Category and Product: show only a chosen category or product.
Payment method: show only a chosen payment method.
Visuals explained
Shift and cash reconciliation
Open / closure overview lists every shift (register session) of the venue, one row per shift and currency: cashier, open and close date, currency, opening float, counted cash, expected cash (opening float plus net cash sales), cash difference (counted minus expected) and whether the shift balanced. These amounts are the closing summary recorded by the POS when the shift was closed: where the cashier does not enter a count, the counted amount equals the expected amount and the shift shows as balanced. Shifts closed without a cash closing (card-only shifts) show no float, counted or expected amounts. The last column, Receipt, has a Download link on each row that opens the closure receipt (PDF) of that shift.
Multi-currency reconciliation breaks cash movements down per currency: cash in, cash out, refunds, net cash sales, transfers (cash moved to or from the drawer, such as a drop to the safe), total counted, total expected and total variance.
Sales and VAT
Grouped tables you can expand and collapse like a pivot.
VAT report: sales grouped by accounting code, tax name, VAT code and VAT rate, with items sold, net sales, VAT amount and total including tax. Cancellations are netted.
Sales details: a breakdown by accounting code, category, product, item and price option, with the VAT code and rate applied, items sold, net sales, discounts, VAT amount and total including tax.
Payments
Payment method report: payments grouped by gateway and method, with number of transactions, total payments, total refunds and the net amount.
Transaction report: a line-by-line log of each payment and refund (date and time, type, product and item, method and gateway, order reference, amount and tax).
Transaction report (all columns)
One row per transaction line, newest first, with everything the venue needs for accounting and support: dates (creation, transaction, modification, shift close), transaction and order references, product, item, category and price option, ticket validity dates and scan status, accounting code, VAT rate, VAT code and tax name, amounts with and without tax, payment method, gateway and reference, cashier, cash location and POS configuration, customer details, and the booking source (referrer and campaign tags). The table shows up to 10,000 rows; open the tile menu (the three dots at the top right of the table) and choose Download for a CSV or Excel export of the full result. It follows the Transaction date, Product, Category, Payment method and Cashier (sales) filters.
Example scenarios
Did every drawer balance today? Read Cash difference and Balanced in the Open / closure overview, filtered on today's Shift date.
You need the receipt of a shift. Find the shift in the Open / closure overview and click Download in its Receipt column.
Where is a shortfall coming from? Filter Cashier (shifts) on the cashier, then open Multi-currency reconciliation and the Transaction report.
What VAT did the venue collect this month? Set the Transaction date to the month and open the VAT report.
Accounting needs every line of September. Set the Transaction date, open Transaction report (all columns) and download the results from the tile menu.
Data freshness
The Last data refresh tile shows the date and time the dashboard last received fresh data. The data refreshes every 4 hours.
Known limitations
Fees are not shown yet: booking and payment fees per transaction (fixed, variable, interchange, scheme and other fees, and the VAT on fees) will be added once the accounting data is available in the new dashboards.
Expected cash is opening float plus net cash sales; cash drops or transfers to the safe appear in the multi-currency reconciliation, not in expected cash.
Multi-currency reconciliation is shown per currency; the exchange rate and rounding difference per payment method of the previous report are not available yet.
Transaction report (all columns) shows up to 10,000 rows on screen; use the tile menu's Download for the full list.
