Bank Reconciliation Not Balancing: How to Find the Difference

When a bank reconciliation does not balance, the difference is almost always one of six things: a transaction on the bank statement that was never recorded in your books, a transaction in your books that never reached the bank, an amount entered incorrectly, a duplicate entry on one side, a transaction posted to the wrong account or the wrong period, or a beginning balance that changed after the last reconciliation was completed. The fastest way to find it is to work from the shape of the difference rather than reading the statement line by line.

Last updated July 2026.

That last point is the part most people skip. A difference of $37.50 and a difference of $4,500 are not the same problem, and neither is a difference that happens to be exactly twice one of your deposits. The number itself carries information, and using it narrows the search from a thousand lines to a handful before you start ticking anything.

Why is my bank reconciliation not balancing?

Your reconciliation is not balancing because one side has something the other does not, or because the two sides disagree about an amount. Timing differences such as outstanding checks and deposits in transit are expected and get adjusted for. What is left after those adjustments is a real discrepancy, and it comes from a short list of causes that repeat across almost every set of books.

Work down this list in order. It is sorted by how often each cause turns up and how quickly you can rule it out, which is not the same as the order they appear on the statement.

How do you find the difference in a bank reconciliation?

Start with the size and shape of the difference, not the statement. Check whether it divides by 9, whether it equals a transaction amount, and whether it equals exactly double one. Then confirm the opening balance, then look for uncleared items, then compare totals rather than lines. Ticking every transaction one by one is the slowest method and should be the last thing you try, not the first.

Here is the sequence that finds most differences in under fifteen minutes.

1. Confirm the opening balance. This period's beginning balance must equal last period's ending balance. If it does not, someone edited, voided, or deleted a transaction that was already reconciled, and the difference is not in this period at all.
2. Test the difference for a transposition. Divide it by 9. If it comes out even, two digits were swapped somewhere, and the quotient tells you the size of the swap.
3. Search your ledger for the exact difference amount. If you find it, you are probably looking at a duplicate or an entry that was recorded once and cleared twice.
4. Halve the difference and search for that. A match here means a transaction was recorded in the wrong direction, which moves the balance by twice its value.
5. Compare totals, not lines. Total the deposits on the statement and the deposits in your ledger for the period, then do the same for withdrawals. Whichever side disagrees tells you which half of the statement to actually read.
6. Sort both sides by amount and compare. Sorting by amount, rather than date, puts identical figures next to each other and makes a missing or duplicated item obvious without reading dates at all.

Only after those six steps is line-by-line ticking worth the time, and by then you usually know which week and which direction to look in.

What does it mean if the difference is divisible by 9?

A difference that divides evenly by 9 almost always means a transposition, two digits entered in the wrong order. Writing $1,530 as $1,350 leaves a difference of $180, and 180 divided by 9 is 20. The rule works because swapping any two adjacent digits always changes the value by a multiple of 9, which makes it one of the most reliable shortcuts in accounting.

The quotient is a hint about scale. A small quotient points to a swap in the lower digits of a smaller number; a larger one points at a bigger figure. It is not precise enough to identify the entry outright, but it tells you whether to be scanning your hundreds or your tens of thousands.

What if the difference is exactly twice a transaction amount?

A difference equal to double a transaction means that transaction was recorded in the wrong direction. If a $600 customer deposit was entered as a $600 payment, your ledger is understated by the $600 that should have been added plus the $600 that was wrongly subtracted, so the reconciliation is off by $1,200. The fix is to correct the direction, not to post an adjustment for the full difference.

The same doubling shows up with refunds recorded as sales, vendor credits recorded as bills, and transfers between accounts booked in one direction only. Whenever the difference is an even number and half of it matches a real transaction you can find, direction is the first thing to check.

My bank reconciliation does not balance in QuickBooks. What do I do?

In QuickBooks the most common cause is a changed beginning balance: a previously reconciled transaction was edited, voided, or deleted after the fact, so the opening figure no longer matches. Run the Reconciliation Discrepancy report, which lists exactly which reconciled transactions were changed and when. Fix or re-enter those first, before looking at anything in the current period.

The other frequent culprits in QuickBooks are transactions sitting in undeposited funds that never got grouped into a deposit, bank feed items accepted twice as both a match and a new transaction, and a reconciliation run against a statement end date that does not match the statement you are holding. Our walkthrough of bank rec in QuickBooks Online covers the full sequence including where each of these hides.

Why does the bank reconciliation not match the trial balance?

Usually because the reconciliation was completed but the adjusting entries were never posted, so the ledger still carries the old figure. The reconciliation is a working paper; it does not change your books by itself. Until you actually record the bank fees, the interest, and the corrections you identified, the trial balance keeps showing the unadjusted cash balance.

The second cause is scope. If you have more than one bank account mapped to the same general ledger cash account, reconciling one of them will never agree with the combined trial balance figure. Check that the account you reconciled and the account on the trial balance are the same account, covering the same date range.

What do you do when you cannot find the difference at all?

Stop hunting and change the data you are hunting in. Pull the full transaction detail from both sides for the period into a single view, sorted by amount, and let the mismatch surface structurally rather than visually. Most stubborn differences survive because the two sides are being compared in different formats, on different screens, on different days.

If your bank only supplies the period as a PDF, get it into a format your ledger and your spreadsheet can both read before you start; you can turn a PDF bank statement into an importable QBO file instead of re-keying several hundred lines and introducing the exact kind of transposition you are trying to find. Once both sides are in a comparable format, sorting by amount usually exposes the item in a couple of minutes.

If it is still missing after that, look at the boundaries. Transactions dated on the first or last day of the period, transfers between your own accounts, and anything posted by an integration rather than a person are where differences hide longest. Our guide to the common causes of reconciliation discrepancies works through each of these in more detail.

When is it acceptable to write off the difference?

A small unexplained difference can be written off to an appropriate expense or income account, but only after you have satisfied yourself it is not a symptom of something larger, and only with a documented reason and a review by someone other than the preparer. Materiality is a judgment your controller or auditor sets, not a fixed dollar figure, and a recurring small difference is a control problem regardless of size.

The thing to watch is repetition. A one-time $4.12 rounding difference on a foreign currency payment is noise. The same $4.12 appearing every month is a process that is quietly wrong, and writing it off each period hides it rather than resolving it. Aging your reconciling items so nothing carries forward unnoticed is the habit that catches this, and it is one of the standard balance sheet reconciliation controls.

How do you stop this happening every month?

Reconcile more often than monthly, and let software do the matching. Most of the effort in an unbalanced reconciliation goes into finding the difference, not fixing it, and that search cost falls sharply when the period being searched is a week rather than a month and both sides are compared automatically rather than by eye. Reconciling weekly is only realistic if the statement side arrives without anyone fetching it, which is what a bank feed connection handles: the lines land daily, so a difference is a week old at worst when you go looking for it.

Reconciler connects your bank accounts, corporate cards, and payment processors alongside QuickBooks, Xero, NetSuite, Sage Intacct, or Business Central read-only, matches both sides on amount, date, memo, and reference, and returns a short list of what did not tie with the reason attached to each line. A duplicate shows up as two ledger entries competing for one bank line. An unrecorded fee shows up as a bank debit with no counterpart. A transposition shows up as two amounts that nearly match. It never moves money and never posts an entry on its own, so a person still reviews and decides every correction.

The bank reconciliation software page shows how the matching and the exception list work, discrepancy detection covers what gets flagged and why, and if you want the whole monthly sequence rather than just the cash tie-out, the step-by-step guide to reconciling bank statements and the month end close checklist put it in order. For the timing items that make a reconciliation look wrong when nothing is actually broken, see outstanding checks vs deposits in transit.