How to Reconcile a Bank Statement (Step-by-Step Guide)

Reconciling a bank statement means confirming that every transaction in your bank account matches a corresponding entry in your accounting records — and investigating anything that does not. Done correctly, it catches errors, detects fraud, and gives you a verified cash balance. This guide walks you through the complete process from start to finish.

What You Need Before You Start

• Your bank statement for the period (download the CSV export — do not use the PDF)
• Your bookkeeping records (ledger, POS report, or accounting software export) for the same date range
• The ending balance from the previous reconciliation
• A list of any deposits in transit or outstanding checks from last month

Step 1: Verify the Opening Balance

Your bank statement opening balance for the current period should equal the closing balance you recorded last month. If they do not match, stop here and resolve the prior-period discrepancy first — otherwise every number in this reconciliation will be wrong.

Step 2: Match Every Bank Transaction to Your Records

Go through each bank transaction line by line and find the matching entry in your ledger. For each matched pair, mark both as reconciled. A transaction is a match when the amount, date (within a 1–3 day window for weekends and processing delays), and description are consistent.

Step 3: Identify Discrepancies

Anything left unmatched after Step 2 is a discrepancy. The five most common causes are:

• Outstanding checks — issued but not yet cleared at the bank
• Deposits in transit — recorded in your books but not yet posted by the bank
• Bank fees and interest — auto-debited by the bank but not entered in your ledger
• Data entry errors — wrong amount typed into the ledger
• Duplicate transactions — the same payment entered twice on either side

Step 4: Adjust Your Records

For each discrepancy, make the correction in the right place. Bank fees that are missing from your ledger get added as new entries. A duplicate ledger entry gets deleted. An outstanding check stays on a carry-forward list until it clears. Do not adjust the bank balance — adjust your books to match reality.

Step 5: Confirm the Closing Balance

After all adjustments: Book balance + deposits in transit − outstanding checks = Bank statement ending balance. When these agree, the reconciliation is complete. Save or export your reconciliation report as documentation.

How Long Should Bank Reconciliation Take?

A manual reconciliation for 200–400 transactions typically takes 1–3 hours in Excel. Common mistakes — misaligned date formats, wrong sign conventions, manual lookup errors — regularly turn that into a full day. With automated matching, the same reconciliation takes under 10 minutes, leaving you time only for the exceptions that actually need your judgment.