How to Reconcile Bank Statements

Reconciliation isn't bookkeeping tidying. It's a verification step. You're not categorising spend or chasing receipts; you're answering one question: do the numbers actually tie out? Everything below is how to get to that yes.

What reconciling a bank statement actually means

A bank statement and your books are two separate records of the same money. Your records are what you *think* happened in the account; the statement is what the bank says happened. Reconciliation lines the two up and confirms they tell the same story. Where they drift apart, one of them is wrong — or there's a timing difference with a good explanation.

There's an identity underneath all of it, and most reconciliation problems are really a failure of this one line:

Opening balance + money in − money out = closing balance.

The bank does this maths for you in the running-balance column, recalculating after every transaction. Your job is to recompute the same thing from your own figures and check you land on the bank's closing balance to the penny. If you do, the period reconciles. If you're out by even a small amount, something between the opening and closing balance doesn't match, and you keep going until you find it. That's the whole concept. The rest is method.

The two halves: matching, then proving

Reconciliation has two distinct jobs, and people often do the first and skip the second.

The first half is matching. You tie each statement entry to a record in your books — this 42.50 card payment, that 1,800 invoice receipt, this direct debit — confirming the entries you *have* are real and correctly recorded.

The second half is proving. Matching can't tell you about a line you never saw: a payment dropped during data entry, a receipt that fell off the bottom of a page, a transfer that wasn't keyed. The only check that catches a *missing* entry is recomputing the balance from the opening figure forward and seeing whether you arrive at the bank's closing balance. Where your total stops agreeing with the bank's running balance is where the gap sits. A reconciliation that "looks done" because every visible line is ticked is only half-reconciled — the proving step is the half a quick eyeball will never replace.

How to reconcile a bank statement, step by step

Work in this order. Each step builds on the one before it, so don't jump ahead until the current one holds.

1. Check the opening balance ties to last period. The opening balance on this statement should equal the closing balance you reconciled last time. If it doesn't, you've inherited a gap — fix that before touching the new period, because reconciling forward won't close a hole that opened in the past.
2. Pin down the exact statement dates. Note the first and last day the statement covers. Reconcile period by period with no overlaps. A single day counted in two statements double-books whatever fell on the boundary.
3. Match every line to your records. Tie each statement entry to an entry in your books — same date, same amount, same direction. Keep money in and money out separate so a credit and a debit of similar size can't quietly cancel a mistake.
4. Recompute the balance and prove it. Start from the opening figure and apply each transaction in date order. Your running total should equal the bank's running balance at every row, and your final figure should equal the printed closing balance. This is the step that actually reconciles the statement.
5. Explain any timing differences. If your book balance and the bank balance differ by a known item — an uncleared cheque, a deposit in transit — list it as a reconciling item rather than treating it as an error. More on this below.
6. Drive the difference to zero. "Nearly balanced" isn't balanced. Whatever's left, chase it to its cause and correct it, then re-run the maths until you hit a clean zero.
7. Close the period and keep the evidence. Once it reconciles, mark it done and keep the statement, your worked figures, and a note of any timing items. You'll be glad of the trail at year end or in an audit.

For a printable version of these steps with extra checks, the bank reconciliation checklist lays them out in sequence.

Timing differences: the gaps that aren't errors

Not every mismatch is a mistake. Some differences between your book balance and the bank balance are perfectly legitimate — they exist because money takes time to move. The usual ones:

• Outstanding cheques. You've written and recorded a cheque, but the recipient hasn't banked it yet, so it's in your books and not on the statement.
• Deposits in transit. You've received and recorded a payment, but it hasn't cleared the bank by the statement date.
• Cross-period payments. A payment that left your account on the 31st but cleared the bank on the 1st sits in different periods on each side.
• Bank-only items. Fees, interest, standing orders, and direct debits often hit the statement before they reach your books. These you *do* post — then re-check the balance.

The discipline here is simple: list a timing difference and explain it; don't post it away. Treat an outstanding cheque as an error and "correct" it, and you've introduced a real mistake while removing an imaginary one. A reconciliation can legitimately end with the bank balance and the book balance differing — as long as every pound of that difference is named.

Reconciling a statement that started as a PDF

Plenty of statements never arrive as tidy data. They come as a PDF download, a scan, or a photo taken on a phone. The reconciliation method doesn't change, but there's an extra failure point to watch: getting the numbers *out* of the file without breaking them.

When you copy-paste from a PDF or retype a scan, errors creep in that look nothing like errors. A 3 misread as an 8, a wrapped description counted as two rows, a column nudged left so debits read as credits. None change how the spreadsheet *looks* — they only break the maths. And a broken sum is exactly what reconciliation is meant to catch, so an extraction slip can send you hunting for a bookkeeping error that was never there.

This is where converting the statement properly pays off, and it's the heart of how Export Bank Statement is built. It converts the PDF — including scanned and photographed statements, via OCR — into clean Excel or CSV, then recomputes opening balance + transactions against the printed closing balance and flags any statement that doesn't reconcile. So a misread digit or a dropped line surfaces on the spreadsheet before you trust the figures, not after you've posted a month of entries. Converting to a reconciled spreadsheet is what makes the reconciliation *provable* — you watch the running balance tie out row by row instead of taking it on faith.

From the reconciled spreadsheet, getting into your accounting software is convert, then import the CSV. Export Bank Statement produces the native bank-import format for Xero, QuickBooks, and Zoho Books, so the lines arrive as reconcilable statement lines. It does not push transactions through a live bank-feed API — that's a separate, certified integration — so think of it as a verified import file you load yourself, not a one-click sync. You stay in control of what gets posted, which during a reconciliation is exactly where you want to be.

When the maths won't tie out

If you've matched everything and the balance still won't reconcile, the shape of the difference points at the cause. A gap equal to one transaction amount means a line is missing or duplicated. A difference divisible by 9 is the classic signature of transposed digits — 54 entered as 45. A difference equal to your opening figure means the brought-forward balance is wrong. Walk the running balance to the first row where your number and the bank's diverge; that row, not the whole statement, is where to start. Common reconciliation errors and why extracted transactions don't reconcile cover the usual causes in depth.