Bank reconciliation is the bread and butter of bookkeeping — and it's the first thing that reveals whether a business's financial records are trustworthy. If you can't reconcile the bank, nothing else in the financials is reliable.
This guide walks you through the complete bank reconciliation process with a real example, common pitfalls, and the advisory angle that turns a routine task into a value-add service.
What Is Bank Reconciliation?
Bank reconciliation is the process of matching your accounting records (the book balance) with the bank's records (the bank statement balance) and explaining every difference. When done correctly, both balances should agree after adjustments.
Bank Reconciliation Example
Starting Information (December 31, 2025)
- Bank Statement Balance: $47,250
- Book Balance (General Ledger): $45,890
- Difference: $1,360 — needs to be reconciled
Step 1: Adjust the Bank Balance
| Item | Amount |
|---|---|
| Bank Statement Balance | $47,250 |
| + Deposits in Transit (deposited Dec 31, not yet on statement) | +$3,200 |
| − Outstanding Check #4521 | −$1,800 |
| − Outstanding Check #4525 | −$2,400 |
| Adjusted Bank Balance | $46,250 |
Step 2: Adjust the Book Balance
| Item | Amount |
|---|---|
| Book Balance (GL) | $45,890 |
| + Interest Earned (on bank statement, not in books) | +$85 |
| + Customer Direct Deposit (not yet recorded) | +$500 |
| − Bank Service Fee | −$35 |
| − NSF Check (bounced customer check) | −$190 |
| Adjusted Book Balance | $46,250 |
Step-by-Step Process
- Get the bank statement for the period (monthly)
- Get the GL cash balance from your accounting system
- Compare deposits: Match every deposit in the books to the bank statement. Any in the books but not on the statement = deposits in transit
- Compare withdrawals: Match every check/payment. Any in the books but not on the statement = outstanding checks
- Identify bank-only items: Interest, fees, direct deposits, NSF checks — these are on the statement but not in your books. Record them!
- Adjust both sides until they match
- Record journal entries for all book adjustments (fees, interest, NSF checks, etc.)
Common Reconciliation Issues
- Stale outstanding checks: Checks more than 6 months old that were never cashed — may need to be written back to income
- Duplicate entries: Same transaction recorded twice (often from bank feed imports)
- Wrong amounts: Check written for $540, recorded as $450 (transposition error)
- Unrecorded automatic payments: Loan payments, subscription charges, payroll taxes
- Timing differences at month-end: Transactions on Dec 31 that post Jan 1
Bank Reconciliation as an Advisory Service
Most bookkeepers treat bank reconciliation as a chore. Advisors treat it as an insight opportunity:
- Cash flow patterns: Identify when cash is tight and when it peaks
- Fraud detection: Unexplained debits, unfamiliar payees, or altered check amounts
- Fee analysis: Are bank fees excessive? Should the client switch banks?
- Collection issues: Frequent NSF checks indicate credit policy problems
- Process improvements: Suggest auto-pay for recurring expenses, faster invoicing for faster collections
Bank Reconciliation in QuickBooks & Xero
Modern accounting software automates much of the process, but you still need to:
- Review and match imported bank transactions (don't just "accept all")
- Handle bank feed errors and duplicates
- Reconcile at month-end to lock the period
- Investigate and resolve any discrepancies
Master Bookkeeping Fundamentals & Beyond
Fractional CFO School teaches the complete bookkeeping workflow — from double-entry basics through bank reconciliation to financial statement analysis.
Explore Programs →