What does bank reconciliation actually involve?
Reconciliation is not reading the whole statement — it is finding the handful of lines that do not fit. Most lines should match themselves on amount, date and counterparty. What matters is that an automatic match can be undone: matching on amount alone is right most of the time and wrong in exactly the cases that cost you — two identical invoices, a part payment, a refund that mirrors a sale. What stays unmatched is the work.
The point is the exceptions
If a hundred lines come in and ninety-four match themselves, the job is the six. A reconciliation screen that makes you look at all hundred has not helped.
Where automatic matching goes wrong
| Case | Why it fools a matcher |
|---|---|
| Two identical invoices | Same amount, same week |
| A part payment | Amount does not match any single invoice |
| A refund | Mirrors a sale amount exactly |
| A combined payment | One transfer, five invoices |
None of these is exotic. All of them are routine for a business with repeat customers, which is why the undo button is not optional.
Unmatched is not the same as wrong
Three different situations hide in an unmatched line:
- The record exists and was not recognised — link it.
- The record does not exist yet — create it.
- The money belongs to nothing yet — hold it as an advance until it does.
The third is the one that gets forced into the nearest invoice, and that is how customer balances start to drift.
Checklist
- Can every automatic match be reversed?
- Is the unmatched list short enough to clear in one sitting?
- Are unexplained payments held as advances rather than force-matched?
- Does a statement import handle banks with no API?
Frequently asked questions
What is bank reconciliation?
Matching each line on a bank statement to a record in your books — an invoice, an expense, a transfer — so that the two agree.
Should automatic matching be trusted?
It should be used and it must be reversible. Amount-and-date matching is right most of the time; the exceptions are where the money is.
What do I do with unmatched lines?
Investigate them. An unmatched line is either a missing record, a duplicate, or a payment that belongs to something not yet invoiced.