What does it mean to reconcile a bank statement?

Confirming the transactions you have recorded match what the bank actually reported — and identifying the specific entries that do not.

How do I reconcile a bank statement step by step?

Start from the opening balance, apply each transaction in order, and compare your running total to the balance printed after that row. The first divergence is the error.

Do I need my bank login to reconcile?

No. Everything needed is printed on the statement itself.

Can I reconcile a scanned statement?

Yes, though scans are where extraction errors concentrate — which is exactly why the row-level check matters more there.

Reconcile a Bank Statement Automatically — and Prove It

The three ways to catch a conversion error, worst to best

Eyeball it. Skimming three hundred rows for a wrong digit is the manual work you were trying to escape, and people miss transposed numbers reliably. This is not a control.

Reconcile the totals. Add a formula — opening balance, running sum of the amount column, compare to the printed closing. If they differ, something is wrong, but you do not know what. Better than nothing, and it still misses anything that does not change the total, like a swapped date or a mangled narration.

Reconcile every row. Recompute the running balance transaction by transaction and compare each to the balance printed on the statement. The first row where your computed figure diverges is the exact row that is wrong. Instead of reviewing three hundred rows, you review the three that do not tie.

The rule the numbers have to obey

Opening balance plus every credit minus every debit equals the closing balance. And after each row, the previous balance plus or minus that transaction equals the running balance printed on the statement. That is the entire method. It works on any bank's format because it uses figures the bank itself printed rather than anything the converter inferred.

The free Excel template

A plain Excel workbook with the opening balance, the running check and the difference column already wired up. Paste your transactions in and it tells you whether the file ties out and where it stops tying. It includes a worked example containing a deliberate error — a cheque for 48,500 read as 4,850 — so you can see exactly what the check catches before you trust it with your own numbers.

No signup. It is just a spreadsheet, and it will be useful whether or not you ever use the tool.

What the balance check cannot catch

It catches anything that changes the arithmetic. It cannot catch an error that leaves the total intact — a misread narration, a swapped date, or a debit and credit of equal value transposed between two rows. It is a strong control, not a complete one, and it is worth being clear about that.

Common questions

What does it mean to reconcile a bank statement?: Confirming the transactions you have recorded match what the bank actually reported — and identifying the specific entries that do not.
How do I reconcile a bank statement step by step?: Start from the opening balance, apply each transaction in order, and compare your running total to the balance printed after that row. The first divergence is the error.
Do I need my bank login to reconcile?: No. Everything needed is printed on the statement itself.
Can I reconcile a scanned statement?: Yes, though scans are where extraction errors concentrate — which is exactly why the row-level check matters more there.