Key takeaways
- Reconcile every day, by tender type, while the shift is still fresh. Month-end reconciliation turns small errors into mysteries.
- Match three layers: POS totals to what staff counted or settled, then settlements to bank deposits when they arrive.
- Vouchers, stored value and loyalty redemptions are not new money on the day. Reconcile them separately.
- Agree a written tolerance, log every variance with a reason, and look for patterns rather than one-off cents.
- IRAS expects you to keep sales records and evidence of payment for at least five years.
Every outlet has a closing routine, but not every outlet reconciles. Counting the drawer and printing a Z-report is only half the job. Reconciliation means taking each number the POS produces and proving it against something outside the POS: the cash in the bag, the terminal settlement, the PayNow notifications, the delivery platform’s statement and, a few days later, the bank.
This guide gives you a nightly routine and a way to handle the differences you will find. It builds on our guide to POS reports, which explains X- and Z-reports and the payment summary, and our guide to restaurant cash control, which covers floats, blind counts and theft. Read those for the controls; use this one for the daily matching.
What daily sales reconciliation is (and is not)
Daily sales reconciliation answers one question: for every dollar the POS recorded today, where is it now? The answer is split by tender type because each tender lands somewhere different.
- Cash should be in the drawer, the safe or the bank bag.
- Cards and NETS should appear on the terminal’s settlement or batch report, then in the bank net of fees.
- PayNow, PayLah! and other QR payments should appear in the business bank account or the payment provider’s report.
- Delivery orders should appear on the platform’s statement, then in its payout.
- Vouchers and stored value reduce what you owe customers. They do not bring in money on the day.
It is not the same as a stock take, a food cost review or month-end bookkeeping. Those depend on it, though. If daily sales are wrong, your food cost percentage, your GST return and your profit and loss will all be wrong too. Our GST F5 filing guide for F&B shows how the return is prepared.
What you need before you start
Set these up once so the nightly routine is quick:
- A fixed float for each drawer, counted and signed at opening. Our opening and closing checklist has a template.
- One login per staff member, so every sale, void and refund has a name attached.
- A reconciliation sheet or form with one row per tender and columns for POS total, counted or settled amount, difference and reason.
- Access to each settlement source: terminal reports, the PayNow or QR provider’s portal, the bank’s app and each delivery platform’s merchant portal.
- A written tolerance. Decide what size of difference needs a manager’s note and what size needs an investigation. There is no official figure; pick one that suits your cash volume and apply it consistently.
- A separate business bank account. IRAS recommends keeping personal and business accounts apart, and it makes matching deposits far easier.
The end-of-day routine, step by step
- Close off open bills. Settle or transfer any open tables and tabs. An open bill left overnight is the most common reason the POS and the drawer disagree.
- Check that offline orders have synced. If the internet dropped during service, make sure every order taken offline has uploaded before you close the day. Our cashier and closing SOP examples put the cash-up into numbered steps.
- Print or export the day-end report with the payment summary, voids, refunds and discounts.
- Count cash blind. The person counting records the total before seeing the expected figure. Remove the float first.
- Settle each card and NETS terminal and keep the settlement slip or screenshot.
- Total the day’s PayNow and e-wallet receipts from the provider’s report or bank notifications.
- Pull each delivery platform’s daily order list.
- Fill in the sheet: POS figure, actual figure, difference, reason.
- Manager review and sign-off. Anything outside tolerance gets a written note before staff leave.
- Bag and log the cash for banking, with the bag number and amount on the sheet.
Steps 1 to 10 are the nightly routine. The final layer, matching settlements to actual bank deposits, happens a few days later because card, QR and delivery money arrives on a delay. Add it to the manager’s morning checklist.
Matching each tender: cash, cards, NETS, PayNow and e-wallets
| Tender | Compare the POS total with | Typical reasons for a difference |
|---|---|---|
| Cash | Blind count less float | Wrong change, cash sale keyed as card, unrecorded payout from the till, open bill |
| Visa and Mastercard | Terminal settlement report | Payment taken on a standalone terminal but not recorded on the POS, tip or split keyed incorrectly, reversal on one side only |
| NETS | Terminal settlement report | Same as cards; also a NETS sale keyed as a credit card sale |
| PayNow and PayLah! | Bank or provider transaction list | Customer paid the wrong amount, screenshot accepted without checking the bank, payment arrived after close |
| Other e-wallets | Provider report | Refunds processed on the provider portal but not on the POS |
Two habits remove most card and QR differences. First, integrate payments where you can, so the terminal reports the result straight to the POS instead of staff choosing a tender by hand. Second, never accept a PayNow screenshot as proof of payment. Check the notification on the business account. Our guide to accepting PayNow as a business explains the options.
When settlements reach the bank, they are usually net of fees and may combine several days. Keep the acquirer’s statement so you can split each deposit back into days and fees. Our guide to payment processing fees helps you check you are being charged what you agreed. Settlement timing varies by provider and contract, so check it on your acquirer’s statement rather than assuming.
Delivery platforms and online orders
Delivery sales are the easiest to reconcile badly, because what the diner pays, what the platform charges you and what lands in your bank are three different numbers.
- Daily: match the number of orders and the gross order value in the POS to the platform’s order list. Missing orders usually mean a tablet order that was never punched into the POS, or a cancelled order that was.
- At payout: match the payout to the platform statement: gross sales, less commission, less any promotions you funded, less refunds, plus or minus adjustments.
- Record fees as costs, not as reductions of sales, so your food cost and menu margins stay honest.
Payout timing depends on the platform and your agreement. Grab’s GrabFood merchant page, for example, describes settlement “as soon as the next day”. Check your own contract. Our GrabFood merchant guide covers commissions and set-up.
Orders from your own online ordering page or QR pre-order flow reconcile like card or PayNow sales, against the payment provider’s report.
Vouchers, stored value and other non-cash tenders
Some tenders on the payment summary never bring money in on the day:
- Gift vouchers and stored value. The money came in when the voucher was sold or the balance was topped up. Redemption reduces the balance you owe the customer. Reconcile the total redeemed against the voucher or stored-value report, not the bank. Our guide to restaurant gift vouchers explains the liability.
- Top-ups sold today are real money in, but they are not sales. Keep them on a separate line so your daily sales figure is not inflated.
- Loyalty point redemptions and complimentary items are discounts, not tenders. Check them against the discount report and your approval rules.
- Corporate accounts or house charges become receivables. Check that each one has a signed chit or an invoice.
Handling variances: tolerance, investigation and write-ups
Some differences are normal. What matters is how you treat them.
- Record every variance, including ones inside tolerance. A log is the only way to see patterns.
- Look for the obvious first. Open bills, a sale keyed to the wrong tender, a payment taken on a second terminal, an offline order still syncing, a refund done on one system but not the other.
- Check the audit trail. Voids after payment, refunds without a manager login and discounts outside policy all show up in exception reports.
- Escalate patterns, not single events. A shortage on the same shift or the same drawer week after week needs attention even if each one is small.
- Handle people fairly. Our cash control guide sets out how to investigate suspected theft and the employment rules to follow before you act.
A tender-level mismatch that nets to zero is still worth fixing. If cash is $50 over and card is $50 under, someone keyed a card payment as cash. That affects your payment summary, and it can hide a real shortage in a later shift.
Keeping the records IRAS expects
Reconciliation is also part of your tax records. IRAS’s page on keeping records says GST-registered businesses must keep business and accounting records for at least five years. The income records it lists include serially numbered receipts or cash register tapes to explain each sales transaction, and evidence that you have received payment, such as bank statements. You do not need IRAS approval to keep records electronically, as long as you follow its record keeping guide.
Companies have a parallel rule for income tax. IRAS’s record keeping requirements ask companies to keep source documents, accounting records and bank statements for at least five years from the relevant Year of Assessment. IRAS also notes that good records help you spot internal fraud or theft, which is exactly what a daily reconciliation does.
In practice, keep the day-end report, the signed reconciliation sheet, terminal settlements and platform statements together by date. If you use accounting software such as Xero, attach them to the daily sales entry. Our guide to Xero for restaurants covers how POS sales and fees should post.
How ChaChaCha helps
A sample nightly reconciliation sheet
One sheet per outlet per day is enough. The figures below are illustrative, to show how the columns work.
| Tender | POS total (S$) | Counted or settled (S$) | Difference (S$) | Reason or note |
|---|---|---|---|---|
| Cash (less float) | 412.50 | 410.50 | -2.00 | Within tolerance; logged |
| Visa and Mastercard | 1,286.00 | 1,286.00 | 0.00 | Settlement slip attached |
| NETS | 534.20 | 534.20 | 0.00 | Settlement slip attached |
| PayNow and PayLah! | 318.40 | 318.40 | 0.00 | Checked on bank app |
| Delivery platform | 9 orders | 9 orders | 0 | Matched to order list |
| Vouchers and stored value | 60.00 | 60.00 | 0.00 | Matched to redemption report |
Add a footer with the cash bag number, the person who counted, the manager who signed off and the time. Keep a second column for the bank deposit date, filled in a few days later when card, QR and platform money arrives. Over a month, the reason column shows patterns that single nights hide. Our guide to POS reports shows where each POS figure comes from.
ChaChaCha, powered by AppsPOS, takes PayNow, PayLah!, NETS, Visa and Mastercard, and GrabPay through DBS, UOB and 2C2P, with split payments and automated reconciliation, as described on our POS payments page. That means matching POS payments against settlements does not have to be done line by line in a spreadsheet. The POS keeps taking orders if the internet drops and syncs later, and staff permissions control who can void, refund or discount.
ChaChaCha also integrates with GrabFood, supports stored value and vouchers through its loyalty features, and connects to Xero. Ask us to confirm which reports your outlet would use for each step above and how they map to your acquirer and bank, or talk to us.