Why Your Bank Balance and Your Books Disagree

Your bank says $8,412.65. Your books say $9,067.40. The difference is $654.75 and you have no idea where it came from.

This is normal. The two numbers are supposed to differ most of the time — and the process of proving the difference is entirely explainable is called reconciliation. It is the single most valuable hour of bookkeeping you will do each month, because it is the only step that verifies everything else.

Five reasons the numbers differ

1. Timing. You wrote a check on the 28th; it cleared on the 3rd. You recorded it, the bank has not seen it. Between those dates your books are correct and the bank is correct and they disagree. This is the most common cause by a wide margin, and it needs no fix at all — it resolves itself.

2. Something the bank knows and you don't. Monthly account fees, wire charges, interest earned, a card processor's cut taken before deposit, an automatic transfer. These hit the account without ever passing through your invoicing or bill-paying. Nobody tells you; they just appear.

3. Something you recorded twice. A payment entered manually and then imported again from the bank feed. Duplicates are quietly the worst category, because both entries look correct in isolation.

4. A typing error. $541 entered as $514. Almost always a transposition — two adjacent digits swapped — and there is a trick for finding those, below.

5. Something genuinely missing. A cash purchase nobody wrote down, a personal card used for a business expense, a customer payment applied to the wrong invoice.

Only the first is harmless. The other four are errors in your books, and every report you run — profit and loss, balance sheet, your tax return — inherits them until they are found.

What reconciliation actually is

Take the bank's closing balance for a period. Add back everything you have recorded that the bank has not yet seen. Subtract everything the bank has recorded that you have not. If you land exactly on your book balance, everything is accounted for.

Written as arithmetic:

  Bank statement balance
+ Deposits in transit        (you recorded, bank hasn't)
− Outstanding payments       (you recorded, bank hasn't)
± Bank items you missed      (bank recorded, you hadn't)
= Your book balance

A worked reconciliation

Back to the $654.75. Here is the month.

Starting position

Bank statement closing balance     8,412.65
Book balance                       9,067.40
Difference                          (654.75)

Step 1 — Outstanding payments. Two checks written in the last week of the month have not cleared: #1043 for $890.00 and #1044 for $215.50.

8,412.65 − 890.00 − 215.50 = 7,307.15

Now the books are $1,760.25 higher than the adjusted bank figure. It got worse, which is fine — the point is to account for everything, not to converge monotonically.

Step 2 — Deposits in transit. A $2,450.00 customer payment deposited on the 30th posted on the 2nd.

7,307.15 + 2,450.00 = 9,757.15

Now the adjusted bank figure is $689.75 higher than the books.

Step 3 — Bank items you never recorded. The statement shows a $35.00 monthly service fee, $12.40 in wire fees, and $2.15 of interest earned. None are in the books.

9,757.15 − 35.00 − 12.40 + 2.15 = 9,711.90

Still $644.50 apart.

Step 4 — Hunt the remainder. $644.50. Scan the statement for that exact amount and there it is: a supplier payment that left the account and was never entered. Record it.

Book balance 9,067.40 + 644.50 = 9,711.90 ✓

Reconciled. Three of those four steps found real errors that were silently wrong in every report the business had run that month.

When it will not balance

You have checked everything and you are still out by some maddening amount. Before going line by line through 200 transactions, try the arithmetic.

Is the difference divisible by 9? Almost certainly a transposition — two digits swapped. $541 typed as $514 is out by 27; $1,260 typed as $1,620 is out by 360. Both divide by 9. Divide the difference by 9 and the result tells you roughly where in the number the swap sits. Then search for amounts near that figure.

Is the difference exactly twice a transaction on your list? A sign error. Something entered as a deposit that was a withdrawal, or the reverse. Halve the difference and search for that amount — you will usually find it immediately.

Is the difference exactly one transaction? Something is missing or duplicated. Search the statement and the books for that precise amount.

Is it a round number like $100 or $1,000? Look for a decimal in the wrong place or a missing digit.

Does the difference match last month's difference? Then the error is not in this month at all — it is an opening-balance problem carried forward, and you should reconcile the previous period first.

If none of that lands, reconcile a shorter window. Do the first week alone. If it balances, do the second. Bisecting a month takes three or four passes to isolate the day, and beats reading every line.

Doing it monthly, and why

Reconcile within a few days of each statement arriving. Not because it is virtuous, but because of how the cost scales:

• This month's discrepancy: perhaps twenty transactions to scan, and you remember most of them.
• Six months of discrepancies: several hundred transactions, compounding errors, and no memory of any of it. This is the state in which people give up and pay someone to fix it.

The other reason is that unreconciled books are unverified books. Your P&L, your balance sheet, your quarterly filings — all built on records nobody has checked against an outside source. Reconciliation is that outside check, and it is the only one you get.

Making it faster

Connect the bank feed. Automatic import removes the main source of typos, because you are matching what the bank says rather than retyping it.

Match, don't re-enter. When a feed transaction lines up with something already in your books, match them. Entering it fresh is exactly how duplicates get created.

Record cash the day it happens. Cash spending is the leading cause of the genuinely-missing category, because there is no automatic trail to catch it later.

Never force it. Every accounting system offers some way to book the leftover to a suspense or adjustment account. It closes the reconciliation and hides a real error — which is still in your numbers, still wrong, and now much harder to find. An hour of searching now is cheaper than an accountant unpicking it in March.

The habit

Once a month, in one sitting: open the statement, open the register, work the four steps, chase the remainder. First time it may take an hour. By the third month it is fifteen minutes, because there is nothing left to find.

That is the actual payoff. Not a tidy account — a set of books you can trust without checking, and reports you can act on without wondering.