Why your bank reconciliation doesn't balance — and which entry did it
It is late, the column has been read three times, and the two numbers still will not meet. The advice everywhere is the same: check your entries again.
You do not have to. The difference is not a random number — it is the fingerprint of whatever went wrong, and there are only a handful of things that go wrong. Each leaves a shape you can recognise in the number itself, before you look at a single line.
First, make the two balances comparable
Nothing below means anything until both sides are adjusted for the things that are simply late:
- Add to the statement deposits the bank has not shown yet.
- Subtract from the statement payments that have not cleared.
- Subtract from your records bank charges you have not entered.
- Add to your records interest credited that you have not entered.
Only what is left over after that is an error. On the example used throughout this article, your records come to $5,633.45, the adjusted statement to $4,913.45, and the difference is $720.00.
If the difference divides by nine, two digits were swapped
This is the most useful single fact in bookkeeping, and almost nobody is taught it.
Swap two adjacent digits in any number and the value always moves by a multiple of nine. Write fifty-four where you meant forty-five and the value moves by nine. Write five hundred and forty where you meant four hundred and fifty and it moves by ninety. It is never an approximation and it has no exceptions — it follows from the place values, and the tool behind this article proves it by trying every adjacent swap in 200,000 numbers rather than quoting a textbook.
So $720.00 dividing by nine is not a coincidence. On this example the entry $1,198.75 was keyed as $1,918.75 — first two digits swapped — and that single transposition accounts for the whole difference.
If the difference divides by nine but no entry on your list explains it, the swap is still there — it is in a line you have not listed, or in the opening balance. Divide the difference by nine: you get the gap between the two swapped digits, already multiplied by the place they sit in. A small gap high up in a number and a large gap low down produce the same result, which is why the tool names the entry when it can and says so honestly when it cannot.
If the difference is exactly twice one of your entries, it is on the wrong side
An amount put in where it should have been taken out is wrong twice: once for the subtraction that never happened, and once for the addition that should never have been there.
An entry of $1,240.00 posted the wrong way leaves you out by $2,480.00. So when the difference is exactly double something on your list, halve it and you are looking straight at the culprit.
These are the errors that hide best, because the entry itself looks perfectly correct — right date, right payee, right amount. Only the direction is wrong, and nothing about the line looks unusual.
If the difference is nine times an amount, the decimal point moved
The nine test catches a second mistake for the same reason.
$120.00 keyed as $1,200.00 leaves the books $1,080.00 out — nine times the smaller amount, exactly. Ten times a figure minus the figure is nine times the figure; that is the whole of it. This is why one test catches the two commonest keying mistakes at once, and why "divides by nine" is worth checking before anything else.
If the difference equals an entry, it is recorded on one side only
The simplest case, and worth checking before the clever ones: the difference is exactly one of your amounts. That entry sits on one side and not the other — either it is missing from one of them, or it is recorded twice on the other.
Search both sides for that exact figure. If it appears once on one side and not at all on the other, it is missing. If it appears twice on one side and once on the other, it is a duplicate.
A near relative: the difference is the sum of two entries. One payment split across two lines, or one day skipped, is posted or missed as a unit far more often than chance would suggest.
If the difference is under a dollar, stop looking for a typo
A difference of a few cents is almost never a keying mistake. It is a monthly fee, a card charge, an interest credit, a foreign-exchange rounding — a real line on the statement that is not yet in your records. Read the statement for small entries rather than re-reading your own column.
If nothing fits, the error is probably not in this period
This is the part a template will never tell you, and it is the one that saves the most time.
If the difference does not divide by nine, is not twice or equal to any of your amounts, is not the sum of two of them, and is not small enough to be a fee — for example $731.11 — then no keying error inside this month is likely to explain it. What is left:
- The opening balance was already wrong. If the period began out, nothing inside the period will ever reconcile it, and every hour spent on this month's entries is wasted. Reconcile the opening balance first.
- A whole transaction on the statement is not in your records at all — a direct debit, a card fee, a transfer between your own accounts.
- Two errors are overlapping and partly cancelling, leaving a difference whose shape belongs to neither. This is the honest weakness of every signature test, and a tool that always names an answer is lying to you about it.
Do it on your own numbers
The bank reconciliation difference finder takes your two balances, your deposits in transit, outstanding payments, charges and interest, and the individual amounts in your records. It runs each of the tests above and returns the amount, the class of error and the arithmetic that proves it — or tells you plainly that no signature fits, which is itself information.
It is free, needs no sign-up, runs entirely in your browser and stores nothing. The arithmetic is the same in any currency.
What this does not replace
This narrows a search; it does not audit anything. It cannot tell you whether a transaction should exist, only whether the difference has a recognisable shape. And when two mistakes overlap it will say nothing fits rather than pick the nearest answer — which is the right behaviour, but it does mean the evening is not always over.
