Why won't my bank reconciliation balance? A 7-step checklist
Short answer: most differences come from one of a few causes: the wrong balances, timing items (uncleared checks, deposits in transit), bank fees or interest not yet recorded, or a data-entry mistake (swapped digits, a duplicate, a reversed sign). Work through them in this order and you'll usually find it.
The checklist
- Check the statement adds up. Opening balance + every transaction on the statement = ending balance. If it doesn't, your download or export is missing lines (often the first or last day).
- Use the same date on both sides. Your book balance must be as of the statement's ending date, not today.
- List items in your books but not on the statement. These are usually timing items: checks you wrote that haven't cleared, and deposits made on the last day. They're normal. Anything more than a month or two old deserves a closer look.
- List items on the statement but not in your books. Usually bank fees, interest, or transactions nobody entered yet. Record them.
- Look at the size of the remaining difference:
- Divisible by 9: likely swapped digits.
- Equal to one transaction: something is missing or entered twice.
- Exactly double a transaction: entered with the wrong sign (a refund recorded as an expense, for example).
- Check the edges of the period. Book entries dated before the statement starts may belong to last month's reconciliation; entries after the end date belong to next month.
- Re-check matches you didn't make yourself. Automatic matching can pair the wrong transaction when two amounts are the same. Confirm the date and payee, not just the amount.
A worked example
Statement ending balance $35,383.71; book balance $35,434.27. Here is how the difference is explained:
| Item | Amount |
|---|---|
| Statement ending balance | $35,383.71 |
| + Checks and entries in books, not yet on the statement | −$40.62 |
| Adjusted bank balance | $35,343.09 |
| Book balance | $35,434.27 |
| + Fees, interest and other bank items not yet in the books | −$91.18 |
| Adjusted book balance | $35,343.09 |
The adjusted balances agree, so the reconciliation is done once the bank items are recorded and any mistakes found along the way are corrected.
Common mistakes
- Forcing the difference into an "adjustment" entry instead of finding it. The difference usually hides a real error.
- Trusting a match because the amount is the same: check the date and payee too.
- Reconciling against a statement balance that includes pending transactions.
Want this done for a whole statement? RecProof matches every line, explains each match, and lists exactly what's left, including likely typos, duplicates, reversed signs and last month's leftovers. It's free and runs in your browser, so nothing is uploaded. Open the free self-check →
General guidance, not accounting or tax advice.