8 Common Bank Reconciliation Mistakes, and How to Fix Each One

Most reconciliations that "never quite balance" fail for one of a small set of well-known reasons. Here are the eight that come up constantly, with the fix for each.

1. Starting from a beginning balance that was never actually confirmed

If last period's reconciliation did not close clean, or a transaction in an already-closed period got edited afterward, this period's beginning balance is wrong before you have entered a single new transaction, and no amount of careful work on the current period will fix it. Fix:confirm last period's adjusted bank and book balances actually agreed before starting a new period; if they did not, resolve the prior period first.

2. Mixing up which side an adjustment belongs on

Outstanding checks and deposits in transit adjust the bank balance (things your books already know about that the bank has not processed). Bank fees, interest and NSF checks adjust the book balance (things the bank already knows about that your books have not recorded). Putting an item on the wrong side makes the reconciliation drift further apart, not closer. Fix:ask "does my ledger already have this transaction and I'm just waiting on the bank" (bank-side adjustment) or "does the bank know about this and I have not recorded it yet" (book-side adjustment, needs a journal entry).

3. Recording a bank transfer as income or expense

A transfer between your own checking and savings account, or to a linked credit card payment account, is not revenue or an expense; it is money moving between your own accounts. Recorded as income or expense by mistake, most often through an over-eager bank feed rule, it inflates both the P&L and the apparent unmatched difference. Fix: use a transfer or clearing account, not a revenue or expense category, for movements between your own accounts.

4. Duplicating a transaction between manual entry and the bank feed

Entering a bill payment by hand and then also letting the bank feed "add" the matching bank line as a new transaction, rather than matching it to the one you already entered, doubles it. Fix:always use your accounting software's "match" action for anything already entered manually; reserve "add" for genuinely new transactions.

5. Getting the credit card sign convention backward

Card issuer statements list charges as positive (increasing what you owe); many ledger exports record the same charges as negative. Imported without adjustment, every single line looks unmatched even though nothing is actually wrong. Fix:if an otherwise clean credit card import shows a wall of unmatched lines, invert one side's amounts before assuming the data is bad; see credit card reconciliation for a worked example.

6. Treating a suspense or unidentified-deposit balance as "later"

An unidentified deposit or an ambiguous payment gets parked in a suspense account "to sort out later," and later never quite comes. A growing, unexplained suspense balance is one of the clearest signs that a real discrepancy, or a real payer, is being ignored rather than resolved. Fix: review the suspense account every close, not occasionally, and treat any balance older than one period as a task with an owner and a deadline.

7. Assuming a small unmatched difference is "just rounding"

Genuine floating-point rounding differences on currency amounts are vanishingly rare in practice; accounting systems and banks both work in whole cents. A small unexplained difference is far more often a missed transaction, a duplicate, or a data entry error that happens to be small. Fix: investigate every unmatched line regardless of size until it has a specific explanation, rather than writing off small amounts by assumption.

8. Reconciling from memory instead of the actual statement

Working from "I'm pretty sure that cleared" instead of the bank's own statement or CSV export reintroduces exactly the kind of error reconciliation exists to catch. Fix:always reconcile against the bank's own export for the period, not a register you are confident is already correct; the entire point of the exercise is to test that confidence against an independent source.

For the correct step-by-step process these mistakes usually derail, see how to do a bank reconciliation, and for a full worked example from raw statement to closed reconciliation, see reconcile a bank statement.