Nobody loves the bank reconciliation, and that is exactly the point — a bank rec should be boring. It exists because your ledger's record of cash and the bank's record of your cash are kept by two different organisations with different cut-offs, and they will never agree by accident. The reconciliation is the proof that every difference between the two is known, classed and temporary. When it stops being boring — when items sit unreconciled for months, when balances are force-matched to make the report look clean — that is where duplicates, omissions and fraud live.
There are only four kinds of difference
Every reconciling item you will ever see falls into one of four classes, and knowing the class tells you the action:
- Timing — deposits in transit and unpresented cheques. Recorded on one side, not yet the other. They clear next cycle; the only work is confirming they actually do.
- Bank-side entries you had not booked — bank charges, interest earned or charged, card fees, direct debits, stop orders. The bank knew first; journal them in.
- Errors on your side — a transposed amount, a payment posted to the wrong account, a duplicate entry. Fix the ledger entry, not the rec.
- The dangerous category — differences with no obvious explanation. A receipt in the bank with no matching source. A payment you cannot find. These get investigated the same day, not parked.
The discipline that makes it fast
Monthly archaeology is the slow way. The fast way is frequency plus rules. Match weekly — or daily if volume justifies it — so each run touches a handful of items instead of a hundred. Keep one ledger cash account per bank account, so the rec is a comparison rather than a puzzle. Treat the unreconciled items report as a work queue with an owner, not as an appendix. And never force-match: ticking two amounts against each other because they are both roughly L5,000 does not reconcile anything, it just defers the discovery to a month with worse optics.
Reading an aged reconciliation like an auditor
Auditors read your reconciliation backwards: they go to the items older than one cycle first, because age is the tell. A deposit in transit from three months ago is not a deposit in transit — it is either an error or a story. The same reading applies to directors and owners reviewing their own books: the age of the oldest unreconciled item is one of the best single-number health checks in accounting. Under a month is routine. Over a quarter, something is being avoided.
| Difference you see | Action it demands |
|---|---|
| Deposit in transit, current cycle | Confirm it clears next period; flag if it does not |
| Unpresented cheque going stale | Follow up with payee; write back per policy if dead |
| Bank charge or card fee | Journal it in; claim input VAT where the charge attracts it |
| Receipt with no matching source | Investigate same day — never book it to suspense and move on |
| Balance force-matched to bank | Un-match it. A clean report that hides a difference is worse than a dirty one |
If your current process is a spreadsheet with a formula everyone is afraid to touch, the migration path is simple: last completed rec as the opening state, everything after it through the matching queue, and a standing rule that no item ages past one cycle unexplained. Boring, achievable, and worth more than almost any other hour of finance admin you currently spend.
Written by the FinSage team
FinSphere Solutions · Maseru, Lesotho · IFRS-compliant cloud accounting for SMEs and practices