When Your Bank Reconciliation Won't Balance: A Field Guide to Finding the Difference

The night it won't tie

A bank reconciliation is a simple idea: your book balance, adjusted for the items the bank has not caught up on yet, should equal the bank's balance, adjusted for the items you have not caught up on. When it works, it is quietly reassuring. When it does not — when you are staring at a difference of $47.13 with no idea where it came from — it is one of the more maddening experiences in bookkeeping, precisely because the mechanics are so simple that the failure feels like it should be obvious.

It almost never is. But an out-of-balance reconciliation is not a mystery to be stared at; it is a search to be run in a disciplined order. The difference always has a cause, and the cause is almost always one of a small handful of usual suspects. This guide walks through those suspects, the arithmetic shortcuts that identify several of them on sight, and a repeatable order of attack so you spend your time eliminating possibilities instead of re-adding the same column. (This is general educational information about bookkeeping mechanics, not accounting advice for your specific situation.)

First, trust the framework

Before hunting the difference, make sure the two sides are actually set up right, because a "difference" is often a setup error rather than a missing transaction. The reconciliation ties two adjusted balances:

• Book side: your general-ledger cash balance, plus deposits or credits the bank has recorded that you have not, minus bank charges, fees, or automatic payments the bank took that you have not booked yet.
• Bank side: the bank statement's ending balance, plus deposits in transit (money you recorded that has not cleared), minus outstanding checks or payments (money you recorded and issued that has not cleared).

If you are reconciling to the wrong statement date, or your opening balance this period does not equal last period's reconciled closing balance, no amount of transaction-hunting will help. So the very first check is: did last month reconcile, and does this month start where last month ended? A broken opening balance is the most common reason a reconciliation that "used to work" suddenly will not.

The usual suspects

Most out-of-balance differences trace to one of these, roughly in order of how often they are the culprit:

• A transaction you never recorded. Bank fees, monthly service charges, interest earned, automatic payments, and card processing fees hit the bank directly and are the single most common miss — the bank knows about them, your books do not. These are also the easiest to fix: you simply book them.
• A transaction recorded twice. A payment entered manually and then again from the bank feed, or a deposit split and also entered whole. Duplicates are sneaky because both entries look legitimate in isolation.
• A wrong amount — the transposition. You typed $54.00 where the bank shows $45.00. Single most common data-entry error, and it has a mathematical fingerprint (below).
• A wrong sign or direction. A payment recorded as a deposit or vice versa. This one has a fingerprint too: the difference is exactly twice the transaction amount.
• A transaction in the wrong period. Recorded in the wrong month, or dated so it falls outside the statement window on one side but not the other.
• An uncleared item wrongly cleared, or a cleared item left unmarked. You ticked something as cleared that has not actually cleared, or missed ticking one that did.
• A prior-period item. An outstanding check from two months ago that finally cleared, or a stale deposit in transit that never did.

The arithmetic that finds the error for you

Before you go transaction by transaction, run the difference through a few quick tests. Each one, if it hits, points straight at a category of error and can save you an hour:

• Is the difference evenly divisible by 9? If so, you almost certainly have a transposition — two digits swapped, like 54 typed as 45. The gap between a number and its digit-swapped version is always a multiple of 9: type $540 as $450 and you are off by $90; type $54.00 as $45.00 and you are off by $9.00. So when a difference like $9.00, $18.00, $0.90, or $270.00 divides cleanly by 9, stop and hunt for two swapped digits before you do anything else. This one trick resolves a huge share of "off by a weird amount" nights.
• Is the difference exactly twice a transaction you can find? A difference of, say, $124.00 where you have a transaction for $62.00 means that item was recorded with the wrong sign — as a deposit instead of a payment, or vice versa. Reversing the direction is a double-sized swing, which is why the difference is exactly 2×.
• Is the difference exactly equal to a single transaction? Then that transaction is either missing from one side or recorded twice on the other. Search both books and statement for that exact amount.
• Is the difference a round, familiar number? A difference of exactly $15.00 or $35.00 is very often a bank fee or service charge you have not booked. Scan the statement for a matching charge.
• Does the difference end in a suspicious cent value? Small odd-cent differences frequently come from a fee, a rounding issue, or a foreign-currency or payment-processor deposit recorded gross when it landed net of fees.

These tests take under a minute combined and resolve the majority of out-of-balance nights outright.

A repeatable order of attack

When the quick tests do not immediately crack it, work the problem in a fixed order so you never go in circles:

1. Confirm the opening balance. Does this period start exactly where the last reconciled period ended? If not, stop — the error is a broken roll-forward, not a missing transaction.
2. Re-verify the two ending balances. Make sure you are using the correct statement ending balance and the correct book balance as of the same date. An off-by-one-day cutoff creates phantom differences.
3. Run the arithmetic tests above. Divisible by 9, twice a transaction, equals a transaction, round number. Let the math point you.
4. Book the bank-only items. Fees, interest, service charges, automatic drafts — anything on the statement that is not on your books. Very often the reconciliation ties the moment these are entered.
5. Hunt duplicates. Sort your cleared transactions by amount and scan for pairs. This is where feed-plus-manual double entries surface.
6. Compare cleared items one to one. Tick each bank transaction against a book transaction. What is left unmatched on either side is your difference, now isolated to specific items.
7. Check the prior-period outstanding list. An old outstanding check or deposit in transit that should have cleared — or should have been written off — can carry a difference forward silently.

Working top to bottom, you either find the item or you narrow it to a specific unmatched transaction. You almost never need to re-add whole columns.

Fix it the right way — never force it

The one thing you must not do is make the difference disappear with a plug — a fudge entry to "cash over/short" just to get the reconciliation to tie. A plug hides the real error, and the real error is often meaningful: a missed fee understates expenses, a duplicated deposit overstates revenue, a wrong-sign entry misstates cash in both directions. Forcing the balance trades a known, findable discrepancy for a permanent, invisible misstatement.

When you find the cause, correct it properly. A missing fee gets booked. A duplicate gets removed — and if it was already in a closed period, corrected with an adjusting entry rather than by editing history, the same discipline that governs a void versus a delete. A transposed amount gets fixed to the right number. Each correction is deliberate and explainable, which is the entire reason you reconcile in the first place: not to make a number match, but to prove the number is true.

The reconciliation is also a fraud check

It is easy to think of a reconciliation as pure arithmetic — make two numbers agree — but the reason it matters so much is that the difference sometimes is not an innocent typo. A bank reconciliation is one of the few routine controls that can surface unauthorized activity, and an unexplained difference deserves a moment of suspicion before you assume it is a data-entry slip.

Watch for the patterns that separate an error from something worse: a cleared transaction on the statement that has no matching entry in your books at all — money that left the account for a payment you never made — is not a transposition, it is a withdrawal you need to explain. A check that cleared for a different amount or payee than you recorded, a debit to an unfamiliar vendor, or a recurring small charge you never authorized are all things a disciplined match catches and a rushed one misses. This is exactly why you should never resolve a difference by plugging it: the plug does not just hide a bookkeeping error, it can hide a genuine loss. When the unmatched item is on the bank side and you cannot tie it to anything you authorized, treat it as a security question, not an accounting one — verify it with the bank before you book it.

Stopping the problem before it starts

Most out-of-balance nights are preventable with a few habits:

• Reconcile every month, promptly. A reconciliation covering four weeks has far fewer transactions to search than one covering four months. Small, frequent reconciliations are the single biggest defense.
• Book bank-only items as they happen. If you record fees, interest, and automatic payments when you see them on the feed rather than at reconciliation time, they never become mystery differences.
• Be disciplined about the bank feed. Duplicate entries almost always come from mixing manual entry with feed imports for the same transaction. Pick one path per transaction and stick to it — and use feed rules and consistent categorization so the same transaction is not entered two ways.
• Never carry an unexplained difference forward. The moment you let one slide "to fix later," it compounds with next month's, and now you are searching two months of transactions for two errors at once.

An out-of-balance reconciliation is not a sign you are bad at bookkeeping — it is a normal, routine event with a normal, findable cause. Approached as a search rather than a stare, run through the arithmetic tests and the fixed order of attack, it goes from a dreaded late night to a ten-minute exercise. The difference is always hiding in the same few places; you just need to look in the right order.

Hosting Books matches your imported bank transactions against your books, flags duplicates and unbooked fees, and carries the reconciled balance forward each period so a broken opening balance can't quietly become next month's mystery difference.

This article is general educational information about bank-reconciliation mechanics and is not accounting advice for your specific situation. Any figures used here are illustrative examples only.