Bank Reconciliation Checklist Template for Bookkeepers: Free Download 2026
Bank Reconciliation Checklist Template for Bookkeepers: Free Download 2026
Bank reconciliation is the foundation of accurate bookkeeping. If your reconciliations are clean, everything else tends to work. If they're messy, problems compound month after month until you're looking at six months of work to untangle.
Here's a bank reconciliation checklist and system that works for every client, regardless of which accounting software you use.
What is a Bank Reconciliation?
A bank reconciliation matches the transactions in your accounting software against the transactions on the bank statement. At the end of the process, both balances should agree (with adjustments for outstanding checks and deposits in transit).
If they don't agree, something is wrong: a transaction was entered twice, a transaction was missed, an amount was entered incorrectly, or there's fraud.
How Often to Reconcile
- Monthly: Standard for most clients. Reconcile within 10-15 days of month end.
- Weekly or biweekly: High-transaction businesses (restaurants, retail, e-commerce)
- Daily: Very high-volume or fraud-sensitive situations
For most solo bookkeeping clients, monthly reconciliation done promptly is sufficient. The key word is "promptly" — reconciling 60-day-old statements creates problems that reconciling 30-day statements doesn't.
The Bank Reconciliation Checklist
Before You Start
- ☐ Confirm the bank feed is current and up to date in your accounting software
- ☐ Obtain the bank statement (download from bank portal or wait for mail)
- ☐ Note the statement ending date and closing balance
- ☐ Note any transactions on the statement that aren't in the software
Step 1: Match Deposits
- ☐ Compare all deposits on the bank statement to deposits in the accounting software
- ☐ Verify dates match (allow 1-2 business days for processing lag)
- ☐ Verify amounts match exactly
- ☐ Identify any deposits in transit (recorded in software, not yet on statement)
- ☐ Identify any deposits on statement not in software (add them)
Step 2: Match Cleared Checks and Payments
- ☐ Match every check on the statement to a payment in the software
- ☐ Match every ACH/EFT payment
- ☐ Match all bank fees and interest charges
- ☐ Identify outstanding checks (in software, not yet cleared)
- ☐ Flag outstanding checks older than 60 days for follow-up
Step 3: Investigate Discrepancies
If the balances don't match after completing steps 1 and 2, work through this checklist systematically:
- ☐ Check for data entry errors (transposed numbers like 1,290 vs 1,920)
- ☐ Check for duplicated transactions
- ☐ Check for missing transactions
- ☐ Verify the opening balance matches last month's reconciled balance
- ☐ Check for bank errors (rare but it happens)
- ☐ Look for NSF (bounced) checks that need to be reversed
Step 4: Complete and Document
- ☐ Reconciliation report shows $0.00 difference
- ☐ Save reconciliation report as PDF (file in client folder)
- ☐ Note any outstanding items in your working notes
- ☐ Update client tracker with reconciliation completion date
Credit Card Reconciliation Checklist
Credit card reconciliation follows the same logic as bank reconciliation, with a few additional steps:
- ☐ Download credit card statement for the period
- ☐ Verify each charge on the statement is in the accounting software
- ☐ Verify each charge is categorized to the correct expense account
- ☐ Identify any personal charges mixed in (ask client to reimburse or reclassify)
- ☐ Verify the credit card payment was recorded as a reduction in credit card liability
- ☐ Ending balance on statement matches ending balance in software
Common Bank Reconciliation Problems (and How to Fix Them)
The reconciliation is off by a small amount ($0.01–$5)
Likely cause: Rounding error, bank fee not recorded, or interest income missed.
Fix: Check for any small unmatched items on the statement. If you can't find it after 15 minutes, force the adjustment and document it. Your time is worth more than chasing $0.37.
The reconciliation is off by a specific amount
Likely cause: One transaction entered at the wrong amount, or a transaction missing entirely.
Fix: Search for the exact amount, or half the amount (common with duplicated transactions).
The reconciliation is off by a round number
Likely cause: A transaction was entered at the wrong amount (e.g., $500 instead of $540).
Fix: Look for transactions near that round number on both sides.
Opening balance doesn't match
Likely cause: Someone modified or deleted a transaction from a prior period.
Fix: In QuickBooks, run the Audit Log report. In Xero, check the Account Transactions report sorted by modified date.
Reconciliation Records to Keep
For each month's reconciliation, file:
- The reconciliation report from your accounting software
- The bank statement PDF
- Any notes on outstanding items or unusual transactions
Keep 7 years minimum. Use a consistent naming convention: ClientName_BankRec_2026-03.pdf
Download the Template
The Operator Atlas Bookkeeping Ops Pack includes a bank reconciliation checklist template and tracking sheet. It covers checking accounts, savings accounts, and credit cards — with a built-in discrepancy log and instructions for the most common reconciliation problems.