How to reconcile daily sales and cash (and find where the money went)
Reconciliation is the habit that turns "sales felt good today" into "sales were Rs 187,400 and every rupee is accounted for". This guide shows how to match each payment method against your records, read a variance properly, and catch small gaps before they become the kind of shortage we covered in finding cash shortages in retail.
Sales and collections are two different numbers
The first thing to understand is that "today's sales" and "today's money" are related but not identical. Sales is what your receipts say you sold. Collections is what actually reached your drawer, card account and wallet. They differ whenever something was sold on udhaar, a delivery is still out for COD, or a supplier payment left the drawer mid-day.
Reconciliation is the daily proof that the difference between those two numbers is fully explained — every rupee of the gap has a name: this customer's credit, that supplier payment, the float from this morning. An unexplained gap is called a variance, and variance is what you are hunting.
The formula that runs the whole process
Write it as one line per payment method. If a shop opened with Rs 5,000 float, made Rs 96,000 in cash sales, refunded Rs 2,500 in cash and paid a supplier Rs 15,000 from the drawer, expected cash is Rs 83,500. If the count shows Rs 82,900, the variance is Rs 600 — small enough to trace tonight, large enough not to ignore.
Reconcile each payment method separately
The mistake that makes reconciliation useless is counting one mixed total. A Pakistani counter collects through at least five channels, and each must be proven on its own:
- Cash — counted drawer minus float and cash-outs, matched against cash sales.
- Card — the machine's own settlement report against card sales in your records.
- JazzCash / EasyPaisa / QR — the day's incoming transaction list on the wallet phone against wallet sales.
- Bank transfer / cheque — confirmed credits only, not promises or screenshots.
- Credit (udhaar) — new credit sales added to customer balances, today's khata recoveries subtracted.
When each column has its own expected and actual, a problem shows itself in one cell instead of hiding inside a blended total. A cashbook that is fed by the POS does this automatically — the expected column is already filled because every sale was recorded at the counter.
Trace a variance in the right order
When a number does not match, resist the urge to recount the same drawer five times. Work through the likely causes in order of probability:
- Recount once, calmly — counting errors beat theft as an explanation.
- Check the float. A wrong opening count poisons every later total.
- List the day's cash-outs and confirm each was logged with a reason.
- Look for a payment saved under the wrong method — cash recorded as card moves money between columns without changing the total.
- Check refunds and cancelled bills — an approved refund with no cash leaving creates a phantom shortage.
- On wallets, look for a duplicate transfer or a customer who sent the amount twice.
Most variances die in the first three steps. What survives is information: a repeated Rs 400–600 shortfall on one shift is a process problem to fix, not a mystery to fear.
Make it a written record, not a memory
A reconciliation that lives in the owner's head helps only that owner, only that evening. Write the day's expected, counted and variance per method, with a one-line note for anything explained: "Rs 600 short — courier COD not yet deposited". Tomorrow's reader should understand today's numbers without asking anyone.
This is also what turns reconciliation into management. After two weeks of written closes, patterns appear that no single evening could show — one payment method always off, one weekday always short, one cashier's refunds always high. The day close screen keeps this history automatically, so the pattern work takes minutes instead of a notebook review.
Daily, not monthly
Reconciliation has a shelf life of about twelve hours. The cashier remembers the odd transaction, the wallet notification is still on the phone, the delivery rider can still be called. Wait a month and the same Rs 600 becomes archaeology.
If your shop is not doing this daily yet, start tomorrow with cash only — one method, five minutes. Once it holds, add card, then wallets, then credit. For the full end-of-day sequence that wraps reconciliation into closing, see the daily closing process for a retail business.
Frequently asked questions
What is daily sales reconciliation?
Proving that the sales your system recorded today equal the money that actually arrived — cash counted, card totals, wallet transfers and new credit — before the day closes.
Why does the cash drawer not match my sales?
Usually an unlogged cash-out, a payment saved under the wrong method, an unrecorded refund, a wrong float, or a duplicated wallet transfer. Theft is possible but rarely the real cause.
How often should a shop reconcile?
Every day, before locking up. A variance found the same evening takes minutes to explain; found at month end, it is untraceable.