Vendion
    Staff & Scheduling

    Why do Analytics and the Z report show different tips?

    4 min read
    Categories and articles

    Different tip totals can result from refunds or different date boundaries. This guide helps you compare matching periods and trace the difference before finalising the tip pool.

    Two figures, two questions

    QuestionWhere you see itWhat it is
    What passed through the POS?The Z reportGross — all tips that were rung up
    What amount remains in the data?Analytics ▸ Kassapunkter, and the Dricksfördelning tabNet — recorded tips after deducting fully refunded bills

    The Z report is a fiscal document. It reports what went through the POS that day, and it must not be changed afterwards. Analytics and the Dricksfördelning tab answer the practical question: how much do I hand out to the staff?

    What the difference consists of

    One possible difference is tips on bills recorded as fully refunded.

    Vendion removes the tip from the payable pool when the bill is recorded as fully refunded. Also check that the guest’s refund has actually been completed; the tip view is not bank confirmation.

    But the Z report for the original day is already closed, and it must not be changed. A refund therefore never reduces an already closed Z report — follow the refund separately in your accounting.

    The arithmetic is simple:

    net + refunded tips = the Z report gross

    An example using the same selection: a restaurant has 40,303.09 SEK in its Z reports and 38,022.09 SEK in Analytics for the same period. The difference of 2,281.00 SEK was tips on four refunded bills. Analytics was right about what should be paid out, the Z report was right about what passed through the POS.

    How to reconcile

    Analytics shows you the difference when there is one. Under Analytics ▸ Kassapunkter it states in plain language that Total Dricks shows payable tips, how much sits on refunded bills, and what the sum becomes if you add it back.

    The same happens in Personal ▸ Dricksfördelning: when you click Hämta från POS the deduction stays on screen — how much refunded tip was deducted and across how many refunded bills. The pot you distribute is therefore net from the start.

    If you want to check against the bookkeeping: start with recorded tips increasing the liability and refunded tips reducing it. Do not deduct a refund again from an amount that is already net.

    The explanatory line appears when Vendion finds refunded tips in the selection. Its absence does not rule out other differences. Compare matching date ranges, restaurant and filters, and check when the original sale occurred. The pool may also have been edited manually after fetching.

    The day boundary can also differ

    There is a second, smaller reason two figures can drift apart: they count days differently.

    • Analytics counts business days. The restaurant sets when the day begins — the default is 04:00 — so a night shift running past midnight lands on the evening it belonged to.
    • Older distribution methods fetch the pool by calendar day: 00:00 to 23:59. Under instämplad tid uses payment timestamps within the period's calendar days.
    • Per servicepass uses your service cutoffs and evening closing. An overnight payment before, for example, 01:30 belongs to the previous service evening. Z mode uses the restaurant's Z closing, with tip boundaries correctable during review.

    If tips are recorded between midnight and the start of the business day, the same selected week can cover different payments in the two views. Check those payments too when comparing the totals.

    Which figure should I pay out?

    Start with the reviewed net evidence in Dricksfördelning: Beräkna & granska for Under instämplad tid and Per servicepass, or Hämta från POS for older methods. Reconcile the period, completed refunds and manual adjustments before finalising the pool. Check it against the tip liability in your books; a fetched figure does not certify that the accounts have been reconciled.

    Money that went back to a guest in a refund is not there to hand out. If you pay out the gross, you are paying tips the restaurant never got to keep.

    If the figures still differ, check the source data before approving distribution. Dricksfördelning is the distribution basis, but date boundaries and manual changes can produce a different figure from Analytics.

    This feature is part of Vendion Staff.

    Curious how it looks in practice? Read more about the product or book a short demo.

    Was this article helpful?