Bank Reconciliation Doesn't Balance? Find the Difference

Quick Answer: When a bank reconciliation won't balance, measure the gap first and let its size point you to the cause. A difference divisible by 9 usually means transposed digits; a difference equal to one transaction means something is missing or entered twice; a difference equal to twice a transaction means a sign was flipped. If the reconciled balance still disagrees with the trial balance, look for entries posted to the cash account after the statement date or a changed opening balance.

Most reconciliations that refuse to balance fail for one of about a dozen reasons, and the dollar amount of the difference narrows the list quickly. Work from the cheapest test to the most expensive: confirm the starting and ending figures, run the arithmetic tests on the gap, then compare line by line only if those tests come up empty.

Start by writing the difference down

Before you touch a single transaction, record three numbers on a scrap of paper: the adjusted bank balance, the adjusted book balance, and the gap between them. Note whether the books are higher or lower than the bank. That direction matters. If the books show more cash than the bank, you are probably missing a withdrawal in the ledger or you have a deposit recorded that never reached the account. If the books show less, look for a deposit the ledger never captured or a payment entered twice.

Also confirm the gap is stable. Re-add both sides once. A surprising share of "unbalanced" reconciliations are a single mis-keyed ending balance on the reconciliation screen itself, such as typing the statement's available balance instead of its ending balance, or picking up last month's closing figure from the wrong page of the PDF.

What does the size of the difference tell you?

The gap is a clue. Run these tests in order; each takes seconds.

The divide-by-9 rule works because swapping two adjacent digits always changes a number by a multiple of 9. If $3,418 was keyed as $3,148, the error is $270, and 270 ÷ 9 = 30. For a swap of two neighbouring digits, the quotient also says how far apart they are: 30 means the two digits differ by 3 and sit in the hundreds and tens places, so you can skip every amount whose digits could not produce that gap.

A doubled entry is the most common cause in software that imports bank data. A transaction comes in through a feed, someone also keys it by hand from a receipt, and both copies get marked as cleared. Sort the cleared list by amount and scan for twins with the same or nearby dates.

The diagnostic checklist

If the arithmetic tests do not land on the answer, go through this list. It is ordered so that the checks that need the least work come first.

1. Opening balance. The reconciliation's beginning balance must equal the ending balance of the last completed reconciliation. If someone edited, deleted or re-dated a transaction that was already reconciled, the starting point moves and every later month inherits the gap.
2. Statement dates. The ending date on the reconciliation screen must match the statement's period end. One day off can pull in or push out a transaction.
3. Ending balance. Use the closing (ledger) balance, not "available balance" or a figure from the summary box of a different account on a combined statement.
4. Transactions dated after the statement end. Items you entered for the following month should not be ticked as cleared.
5. Uncleared items that the bank actually processed. A check that cleared on day 29 but sits unticked will make the books look richer than the bank.
6. Fees and interest. Monthly maintenance fees, wire fees and small interest credits are easy to miss because they never generate a receipt.
7. Reversed or returned items. A deposited check that bounced appears twice on the statement (credit then debit). If you recorded only the first, the books are high.
8. Sign errors. Refunds keyed as purchases and transfers keyed in the wrong direction produce a gap of twice the amount.
9. Wrong account. With several accounts at one bank, a transfer between them can be posted to the right ledger but the wrong bank account.
10. Bank errors. Rare, but real: a deposit credited for the wrong amount or another customer's debit. See the note on deadlines below.
11. Voided checks still in the register. A check you voided and reissued may be in the books twice.
12. Split deposits. One bank deposit of $2,340 may be three customer payments in your books. Match the total, not the pieces.

When you work through items 4 and 5, it helps to have the statement as rows rather than a PDF you scroll. Pasting the bank side into a spreadsheet lets you sort by amount and use a formula to flag anything that appears on one side only. Our guide to building the reconciliation in Excel shows a matching layout, and the PDF to Excel converter can turn a bank-generated statement into a sheet of dated, signed amounts so you are not retyping fifty lines to find one.

Why does the reconciled balance not match the trial balance?

This is a different problem from a reconciliation that will not balance. Here the reconciliation itself closed with a zero difference, yet the cash line on the trial balance shows another number. Common reasons:

• Different dates. The reconciliation reflects cash as of the statement date (say, March 31). The trial balance you are reading may be run as of today, so it includes April activity. Rerun the trial balance as of the statement end date before comparing.
• Outstanding items. The reconciled bank figure plus deposits in transit, minus checks not yet presented, should equal the ledger. If you compare the raw bank ending balance to the trial balance, they will not agree, and they should not.
• Back-dated entries. Someone posted a journal entry to the cash account dated inside a period you already reconciled. The reconciliation report is a snapshot of the day you finished; the trial balance is live, so it picks up the late entry. Most accounting packages can list changes made to reconciled transactions, and that list is the first place to look. If you need to re-open the period, see how to undo a past reconciliation in QuickBooks Online.
• Several bank accounts rolled into one line. If the trial balance groups checking, savings and a sweep account under "Cash," add all their reconciled balances together before you compare.
• Cash on hand or clearing accounts. Undeposited funds, petty cash and payment-processor clearing accounts are cash on the trial balance but are not on any bank statement.

How do you balance a bank reconciliation that is still off?

If the checklist is exhausted, narrow the window. Split the month in half: total the bank's transactions for days 1 to 15 and compare them with the ledger's total for the same dates. Whichever half disagrees holds the error. Split that half again. Four rounds of halving usually reduce a month to two or three days of activity, which you can compare line by line in a couple of minutes.

A second technique is to reconcile counts as well as amounts. If the statement lists 47 debits and your cleared list has 46, you know you are hunting for one missing payment, not a transposition.

Avoid the shortcut of posting a plug entry to "Reconciliation Discrepancies" or "Ask My Accountant" just to reach zero. Some software will offer to create that adjustment for you. A plug hides the real cause, and next month's reconciliation starts from a wrong figure. If you truly cannot find a small difference and the period must close, document what you tested, post the adjustment to a clearly named account, and revisit it when the next statement arrives, since the missing item often shows up there.

When the bank made the mistake

Occasionally the ledger is right and the statement is wrong. For personal (consumer) accounts, federal Regulation E gives you a limited window: the CFPB's text of 12 CFR 1005.11 requires the bank to receive your notice no later than 60 days after it sent the statement on which the error first appeared, and it counts computational or bookkeeping errors by the institution as errors. Business accounts are usually governed by the account agreement instead, and the deadlines there can be shorter, so read yours. Either way, put it in writing, keep a copy, and record the bank's correction when it posts rather than adjusting your books in advance.

Keep next month from repeating it

Most recurring gaps trace back to a process, not arithmetic:

• Reconcile within a week of the statement date, while the month is fresh.
• Lock or close the period in your accounting software after reconciling, so reconciled transactions cannot be edited silently.
• Pick one entry path per transaction type. If bank-feed rules handle card purchases, nobody keys them by hand.
• Save the reconciliation report as a PDF with the statement. When a gap appears in June, you can see exactly what was cleared in May.

If you reconcile from statements rather than a live bank feed, the conversion step is worth tightening too. QuickBankConvert reads the opening and closing balance from the statement and shows them above the transaction preview, which gives you a quick sanity check that the rows add up from one figure to the other before you start matching. Scanned or photographed statements are read less accurately than bank-generated PDFs, so on those, compare the row totals with the printed totals before trusting them. The free account covers 3 statements a month, and the pricing page lists the larger plans.

Related guides

• Bank statement reconciliation guide: the full procedure from start to finish.
• Bank reconciliation example: worked numbers you can check your method against.
• What you need before you reconcile: the documents to gather first.