Reports, the till and the bank show different totals
Why Reports, the cash count at close and your bank payout rarely match to the cent, and how to work out each difference.
On this page
Reports, the till count and your bank statement each measure something different, so they are not supposed to be equal. In almost every case the gap is one of the causes below, and you can account for all of it.
Quick answer
- Reports vs the till: the till holds cash only. Reports include card, QR, online and gift card payments, and show sales without VAT and tips.
- Reports vs the bank: the bank receives card payments only, after fees, refunds and disputes, and on a payout schedule, not day by day.
- Reports vs another report or tool: check the period, the location, the Order type filter and the business day setting first.
Compare Reports with the till
The till (the cash count at End-of-day count) and Reports answer different questions. Work through these in order.
- Payment method. The till only knows cash. Subtract card, QR, online and gift card payments from the figure in Reports before comparing. Reports › Overview › Payments shows takings per payment method.
- VAT and tips. The Net sales figure has no VAT. Total collected includes VAT and tips, which is the figure to compare with money received. Tips are never part of net sales, see Tips.
- Cash movements. Cash paid in, paid out and dropped during the day moves the till without being a sale. See Record cash in and out.
- The business day. The till session runs from open to close. A report day runs to the Business day ends at time of the location. If you close the till at midnight but the day ends at 04:00, late sales fall on different days. See Set the end of your business day.
- Still short or over? That is a cash difference, not a report difference. See Understand a cash difference.
Compare Reports with the bank
Your bank only sees payouts from Verimly Payments. A payout is not one day of sales.
- Fees are taken out. Each card payment carries the card processing fee and a flat Verimly fee of €0.05. Both are deducted before the money reaches you. Payments shows the Processing fee, Verimly fee and Net of every payment. See Fees on card payments.
- Refunds and disputes are taken out. A refund reduces a payout, and the Verimly fee is not given back. A lost dispute also reduces it. See Refund a payment and Disputes.
- Tips are included. Card tips arrive in the payout with the payment even though they are not sales.
- Cash and gift cards are not in the payout. Only card payments are paid out.
- Timing. You choose a payout schedule under Payments › Payouts: every business day, every week or every month. A payment is paid out when it has settled, so a Friday evening sale may arrive in Monday's or next week's payout. Balance shows what is Available, Settling and Held by Stripe, and the next payout. Your first payout appears a few days after your first card payment.
- Your bank's date. The payout shows an arrival date. Your bank may book it on a different day.
To reconcile, open the payout under Payments › Payouts. It lists every payment, refund, dispute and fee inside it with the totals Payments, Refunds, Disputes, Processing fees, Verimly fees, Other and Paid out. Export CSV puts it in a spreadsheet. The full walk-through is in Match a payout to your sales.
Why two reports in Verimly can differ
- Business day vs calendar day. The sales pages follow the business day of each location. The VAT report uses calendar days in the business time zone, so a sale just after midnight, but before your cut-off, counts in different days on each. See Read the VAT report.
- When a refund counts. In Reports a refund reduces net sales on the business day the refund was made, not the day of the sale. A past day does not change after you have looked at it.
- Lost disputes. A card dispute that you lose takes its sales part off net sales, like a refund.
- Gift cards. Selling a gift card is not a sale, so it is not in Net sales. It appears as Gift cards sold. Paying with a gift card is a normal sale.
- Open orders. Orders and bar tabs that are not paid are not in the reports yet.
- Filters. The period, the Order type filter, the location in the menu and a comparison all change what you see. Check them first.
- Voided items and comps. Voided items never count as sold. Comped items appear on the Comps line at menu price, so gross sales is higher than what was charged.
Still not matching?
Send support the details so they can trace it: the location, the period or the exact date, the figure you expected and the figure you see, the payout date and amount, and whether the difference is in cash or card. See Contact support.