How to Reconcile Bank Statements: Complete Step-by-Step Guide

What Is Bank Reconciliation?

Bank reconciliation is the process of comparing your company's accounting records against your bank statement to ensure they match. This critical monthly task catches errors, prevents fraud, and maintains accurate financial records.

Why Bank Reconciliation Matters

• Accuracy: Catches data entry errors and mistakes
• Security: Identifies unauthorized transactions and fraud
• Cash Flow: Ensures you know your actual cash position
• Compliance: Required for tax filings and audits
• Discrepancy Resolution: Identifies timing differences and outstanding items

Step-by-Step Manual Bank Reconciliation Process

Step 1: Gather Your Documents

• Your bank statement (usually provided monthly)
• Your accounting records (general ledger)
• Checkbook register or transaction list
• Previous month's reconciliation (for reference)

Step 2: Compare Opening Balances

Check that your accounting software's opening balance matches your last month's closing bank balance. If it doesn't match, there's likely an unreconciled item from the previous month.

Step 3: Mark Cleared Transactions

Go through each transaction on your bank statement and mark it as "cleared" in your accounting records when you find a match. Match on:

• Amount
• Date
• Description/Reference

Step 4: Identify Outstanding Items

Items that appear in your accounting records but NOT on the bank statement are "outstanding." These typically include:

• Outstanding Checks: Checks you've written but the recipient hasn't cashed yet
• Deposits in Transit: Deposits you've recorded but the bank hasn't processed yet

Step 5: Identify Unrecorded Items

Items on the bank statement that are NOT in your records should be recorded in your accounting system:

• Bank fees
• Interest income
• Direct deposits (payroll, transfers)
• Automatic payments or deductions

Step 6: Calculate the Reconciling Items

Use the reconciliation formula:

Step 7: Make Adjusting Entries

In your accounting software, record any previously unrecorded items (bank fees, interest, automatic payments).

Step 8: Verify Balances Match

After making adjusting entries, your accounting records should exactly match the bank statement. If they don't, find the discrepancy and adjust.

How Long Does Manual Reconciliation Take?

Common Reconciliation Mistakes to Avoid

• Transposed numbers: Writing 321 instead of 312 can throw off your reconciliation
• Forgetting bank fees: Easy to miss, but they affect your balance
• Timing differences: Not accounting for deposits in transit or outstanding checks
• Duplicate entries: Recording the same transaction twice
• Not following up: Outstanding items should eventually clear

How Automated Bank Reconciliation Works

Modern automated reconciliation tools like BankStatementMatcher eliminate the manual process:

1. Upload your bank statement (PDF, CSV, Excel)
2. Upload your expected payments list
3. Automated matching by reference number and amount
4. Results in seconds: matched, missing, and unidentified payments
5. Export report for your records

Benefit: What takes 2-4 hours manually takes 30 seconds with automation.

Best Practices for Bank Reconciliation

• Do it monthly: Reconcile on a fixed schedule, ideally the day after month-end
• Don't wait: Resolve discrepancies immediately
• Document everything: Keep reconciliation records for audit trail
• Review outstanding items: Check old outstanding items regularly
• Use automation: For high transaction volumes, use software
• Separate duties: Have someone other than who records transactions review reconciliation

Try Automated Bank Reconciliation Today

Ready to eliminate hours of manual reconciliation? Our automated tool matches bank statements to expected payments in seconds with 99%+ accuracy.

Related Guides

• → Bank Reconciliation for Small Business: Complete Guide
• → 10 Common Bank Reconciliation Mistakes and How to Avoid Them
• → What Is Bank Statement Reconciliation?