Where the daily reconciliation actually breaks
Reconciliation rarely fails on the sales figure. It fails on tender. Cash counted at the till, card settlements that reach the bank a day or two later, vouchers redeemed against a liability nobody has posted, cash collected by a delivery driver, and refunds issued in a tender that was never taken in the first place. Each of those has a different timing and a different owner. When the daily routine treats them as one lump, the gap between the till total and the bank statement becomes a monthly investigation rather than a five minute check.
The design that works is unremarkable. Every tender type gets its own control account and its own expected settlement date, so the system knows what should have arrived and when. Store banking is declared at the till rather than reconstructed later from the safe. Card settlement files are imported and matched automatically, with unmatched lines queued for a named person instead of being absorbed into suspense. Anything that cannot be matched is visible the next morning, attached to a store and a shift, while the people involved still remember the day.
Refunds and exchanges deserve separate attention, because that is where both error and loss concentrate. A refund with no link to an original transaction is an open door. So is an exchange processed as a zero value sale. Requiring the original receipt reference where it exists, capturing a reason code where it does not, and reporting refund activity by operator gives management something concrete to look at. Most of what surfaces is honest mistake. The point is that both kinds of problem appear in the same report.
- One control account per tender type, with an expected settlement date
- Card settlement files imported and matched overnight
- Unmatched lines queued to a named person, never to suspense
- Refunds tied to an original transaction reference or a reason code
- Banking declared at the till rather than reconstructed from the safe