Bank Statement Reconciliation: A Practical Guide

Reconciliation is the process of confirming that two records of the same money agree: your books (a ledger, a spreadsheet, or an accounting system) and the bank's record (the statement). When they match, you have confidence that nothing is missing, duplicated or miscoded. When they don't, the gap between them is a precise signal of what to investigate.

Why reconciliation matters

• It catches errors early — a missed transaction, a duplicated entry, or a transposed figure surfaces as a specific dollar discrepancy rather than a vague sense that something's off.
• It catches fraud and unauthorised charges before they compound.
• It's the foundation of trustworthy financial statements: a P&L or balance sheet built on unreconciled data is built on a guess.
• For anyone applying for lending or filing accounts, reconciled books are the difference between defensible numbers and numbers you hope are right.

The core reconciliation check

A step-by-step process

1. Fix the period. Reconcile one statement period at a time, using the statement's own opening and closing balance as the anchors.
2. Get a complete, correctly-signed transaction list from the statement — every row, money out negative and money in positive (charges positive-owed on a credit card).
3. Match each transaction to a line in your books. Tick off matches; flag anything on the statement that isn't in your books (unrecorded) and anything in your books that isn't on the statement (timing differences like uncleared checks, or errors).
4. Explain every unmatched item. Timing differences resolve next period; genuine errors get corrected now.
5. Confirm the identity holds. Opening + net movement should equal the closing balance. If it does and every line is matched or explained, the period is reconciled.

Common reasons a reconciliation won't balance

• A transaction is missing from one side — the discrepancy equals that transaction's amount.
• A sign is wrong — a debit entered as a credit throws the balance off by twice the amount.
• A transposed digit — $52.19 entered as $51.29; the discrepancy is divisible by 9, a classic transposition tell.
• A row was merged or split when copying data off a PDF statement, so the count is right but a total is wrong.

Reconciling a statement you've converted from PDF

When your starting point is a PDF — a bank that isn't connected to your accounting software, a client who only sends statements, or a historical account — the riskiest step is getting a complete, correctly-signed transaction list out of the document. That's exactly where a silent extraction error becomes a reconciliation headache weeks later.

Ledgerary runs the core reconciliation check as part of every conversion: it extracts every transaction from the statement, then verifies opening balance + net movement against the printed closing balance and reports a pass/fail plus a confidence score. A pass means the extracted list is complete and correctly signed before it ever reaches your books; a fail flags the exact discrepancy so you can fix the row before importing. Export the reconciled data to Excel, CSV or JSON free, or QuickBooks, Xero, Sage or OFX on Pro.