What Is Bank Reconciliation? A Bookkeeper's Complete Guide

Bank reconciliation is the process of comparing your internal financial records — your bookkeeping ledger, accounting software register, or spreadsheet — to the transactions on your bank statement, and resolving any differences. It is one of the most fundamental controls in accounting, and one of the most frequently skipped.

Why Bank Reconciliation Matters

Your bank statement and your books are two independent records of the same money. They should always agree. When they do not, something is wrong — and if you do not find it, the error compounds over time. Bank reconciliation catches:

• Data entry errors — a $1,200 invoice recorded as $120
• Missing transactions — bank fees, interest charges, or payments that were never entered
• Duplicate entries — the same transaction recorded twice
• Bank errors — rare, but banks do make mistakes
• Fraud — unauthorised withdrawals, altered checks, or ghost transactions
• Timing differences — checks that have not yet cleared, deposits in transit

The Two Records Being Compared

Every bank reconciliation compares two records:

• The bank statement — the external record maintained by your bank, showing every transaction that passed through the account during the period. This is considered the authoritative record because the bank holds the actual money.
• The book balance — your internal record in QuickBooks, Xero, FreshBooks, or your spreadsheet. This reflects what you have entered, which may differ from the bank statement due to timing, errors, or omissions.

Common Reasons the Two Records Differ

A difference between your books and your bank statement is called a "reconciling item." Most reconciling items fall into a few predictable categories:

• Outstanding checks — checks written and recorded in your books, but not yet cleared at the bank
• Deposits in transit — deposits recorded in your books but not yet credited by the bank
• Bank service charges — fees the bank deducted that were not recorded in your books
• Interest earned — interest credited by the bank that was not recorded in your books
• NSF (non-sufficient funds) checks — a payment you deposited that was returned unpaid
• Errors — any mistake in either the books or the bank record

How the Reconciliation Process Works

1. Gather both records — download your bank statement CSV and export your bookkeeping register for the same date range.
2. Match transactions — go through each bank transaction and find the corresponding entry in your books. Mark matched pairs.
3. Identify unmatched items — any transaction in the bank that has no match in your books, and vice versa, needs investigation.
4. Adjust your books — add any missing entries (bank fees, interest, NSF charges) and correct any errors.
5. Verify the closing balance — your adjusted book balance should equal the bank statement closing balance. If it does, the reconciliation is complete.

How Often Should You Reconcile?

Monthly is the standard for most businesses, timed to the monthly bank statement cycle. High-volume businesses (retail, restaurants, e-commerce) may reconcile weekly to catch errors before they compound. The absolute minimum is quarterly — but anything less than monthly makes it very difficult to catch errors before they become expensive to fix.

Bank Reconciliation vs. Account Reconciliation

Bank reconciliation specifically compares your bank statement to your books. Account reconciliation is a broader term that includes reconciling any balance sheet account — accounts receivable, accounts payable, inventory, loans payable. Bank reconciliation is one type of account reconciliation and is typically the first step in a complete month-end close.

Tools for Bank Reconciliation

• Excel or Google Sheets™ — manual matching using VLOOKUP. Works for simple accounts with low transaction volume.
• QuickBooks Online or Desktop — built-in reconciliation module. Works well when your bank feed is clean and the bank statement matches the import exactly.
• Xero — similar to QuickBooks with a bank feed reconciliation screen.
• LedgerMatch — purpose-built for bookkeepers who work with CSV exports. Handles any bank format, matches on amount + date + fuzzy description, and surfaces only the exceptions that need manual review.