- Restaurant
Data in the restaurant industry: How to use reports to optimize your operations
Discover how you can optimize your restaurant operations with reports from an efficient restaurant system. Gain insight and improve your efficiency!
Cash reconciliation is the daily check that what your POS system says you sold matches what is actually in the cash drawer, on the card terminal and on your gift cards. Do it in the same order every night and it is a short routine. Do it differently each time and you end up counting coins for the third time at 11:40 pm.
The quick version: start with a fixed float, close every open table, run the Z report, count the cash, match card and contactless payments against the terminal's end-of-day batch, check gift cards and tips, and have two people sign off. Below you'll find the step-by-step checklist, the most common causes of cash discrepancies, what to check in the rules for your POS, and how an integrated POS system speeds up the job.
The terms often get mixed up:
Why every day? Because a discrepancy is easy to explain the same evening, while the receipts and the shift are fresh in everyone's mind. A week later it is close to impossible to trace.
Many discrepancies happen because the day was not properly closed. Three things need to be in place:
Use the same order every night. That keeps it fast, even when a new team member closes.
| Payment method | Figure in the POS system | Match against |
|---|---|---|
| Cash | Cash sales on the Z report | Amount counted minus the float |
| Cards, Apple Pay, Google Pay | Card sales on the Z report | The terminal's end-of-day batch, later the payout from your card acquirer |
| Gift cards | Gift cards sold and redeemed | The gift card overview (balances and redemptions) |
| Tips | Tips recorded | Tips on the terminal and cash tips |
Card payments also carry fees that you only see when the payout reaches your account. If you have not looked at them for a while, read how to save on acquiring and terminal fees.
Card tips are included in the terminal total, but they are not your revenue. If they are not recorded separately in the POS system, you'll see an overage on cards and a shortage somewhere else. Card tips are paid into the business account, and in many countries tips paid out through payroll are taxed as wages. Cash tips handed straight to an employee are often treated differently. Check with your tax authority or accountant how tips are handled where you operate.
A gift card is a debt to the guest until it is used. If you sell a gift card worth 50, that is not 50 in revenue on the day you sell it.
Before you suspect theft, check the ordinary mistakes. Often it is a typo or a payment recorded under the wrong payment method.
| Cause | Typical sign | Where to look |
|---|---|---|
| Wrong payment method | Overage in cash and a matching shortage on cards (or vice versa) | Checks matching the amount of the overage |
| Float error | The discrepancy equals a note or a roll of coins | The morning count and the float |
| Voids and refunds | Shortage in the drawer with no visible cause | Voided checks and refunds in the log |
| Terminal not linked to the POS | Wrong amount keyed into a standalone terminal | The terminal's transaction list against card sales in the POS |
| Tips mixed with sales | Card overage that equals the day's tips | The tip field on the terminal |
| Open tables and parked checks | The Z report is lower than expected | The list of open tables |
| Gift card recorded incorrectly | The discrepancy equals a gift card amount | The gift card overview |
If you see the same kind of discrepancy again and again on certain shifts, it is a training issue, not a math problem. To spot patterns like that, you need to be able to pull data, as described in the guide to reports in the restaurant industry.
The simplest control is the four-eyes principle: one person counts, another approves. It protects the employee too, because no one is left to explain a discrepancy alone.
Decide in advance how large a discrepancy must be before it needs a written explanation, and what happens if it cannot be explained. Then it becomes routine rather than an argument at 11 pm.
There is no single set of rules. Many countries regulate cash registers, and the requirements depend on where your restaurant is. Typical areas are:
Three examples show how different the rules are:
These are examples, not a complete overview, and rules change. Check the current requirements with your national tax authority and your accountant, and ask your POS provider, including us, which of them the system covers in your country.
A manual cash up is slow because the figures sit in several places, and every time a number is retyped, a mistake can creep in. When the POS system, the terminal and the accounting software are connected, several of the usual causes of discrepancies disappear:
Flexybox's POS system, FlexyPOS, integrates with terminals that accept card and contactless payments. You create, sell and redeem gift cards directly in the POS system, and the system logs all register activity. When the day's cash reconciliation is completed, the system calculates the difference between the actual cash and what it expects, and flags any cash discrepancy so you can decide what to do about it. The daily reporting gives you insight into discrepancies, revenue and the day's labor cost percentage. For accounting, Flexybox integrates with systems such as Visma, Fortnox, Datev, e-conomic, Microsoft Dynamics 365 and Business Central (see all integrations). The POS system also works alongside online table booking and shift scheduling from Flexybox.
Thinking about switching systems? Read the guide to POS systems.
A fast and accurate cash reconciliation is less about counting quickly and more about doing it the same way every day:
Want to see how the POS system, terminal and accounting connect in one system for your restaurant? Book a presentation below.
Contact us, if we have left you curious on our products and benefits by collecting your operation to one system.
It’s non-binding to have a call or book a presentation.