← BlogGuideMarch 22, 2026·10 min read
Bank Reconciliation Statement: How to Reconcile a Bank Statement
Your bank statement ending balance and your own records almost never match — and that's normal. Bank reconciliation is the process of explaining exactly why they differ and confirming that both arrive at the same correct figure. This guide walks through the full process, with a sample bank reconciliation statement format you can use right away.
What Is Bank Reconciliation?
Bank reconciliation is the process of comparing your bank statement (what the bank says your balance is) against your own financial records (what you think your balance is) to make sure they agree.
The two balances will almost always be different because of timing differences — transactions you've recorded that the bank hasn't processed yet, or transactions the bank has processed that you haven't recorded yet. Reconciliation explains every difference and confirms neither figure has an error.
Catches errors
Wrong amounts, duplicate entries, missing transactions
Detects fraud
Unauthorized charges, forged checks, ACH fraud
Accurate books
Your reported balance reflects reality
Required for audits
Banks, lenders, and tax authorities expect reconciled records
Bank Balance vs. Book Balance — What's the Difference?
Before you start reconciling, it's important to understand the two balances you're working with:
Bank Balance
(Statement Balance)
•What your bank says you have
•Based on transactions that have cleared the bank
•May not include very recent deposits or checks
•Found on your monthly bank statement
Book Balance
(Ledger Balance)
•What your internal records say
•Includes everything you've recorded, even uncleared items
•May include bank fees you haven't entered yet
•From your checkbook, accounting software, or spreadsheet
How to Reconcile a Bank Statement in 6 Steps
Follow these steps in order. The goal is to reach the same "adjusted balance" from both the bank side and the book side.
1
Get your bank statement and your records
You need two things side-by-side: your bank statement (from your bank) and your internal records — whether that's a checkbook register, accounting software (QuickBooks, Xero), or a spreadsheet. Both should cover the same date range.
2
Start with the ending balance
Write down two numbers: your bank statement ending balance and your book (internal records) ending balance. These will almost certainly be different. Your job is to explain why, and confirm they reconcile to the same adjusted figure.
3
Add outstanding deposits (deposits in transit)
Look for deposits you recorded in your books that don't appear on the bank statement yet. These are called 'deposits in transit' — you made the deposit, but the bank hasn't processed it by the statement date. Add these to the bank statement balance.
4
Subtract outstanding checks
Find checks or payments you've issued that haven't cleared the bank yet. These are 'outstanding checks' — you've recorded the expense, but the bank hasn't paid them. Subtract these from the bank statement balance.
5
Adjust your book balance for bank items
Now look for things the bank recorded that you haven't entered in your books yet: bank fees, interest earned, NSF (returned) checks, automatic payments. Add credits and subtract debits from your book balance.
6
Compare adjusted balances — they must match
After your adjustments, the adjusted bank balance and adjusted book balance should be identical. If they match: you're reconciled. If they don't: there's an error somewhere. Common causes are arithmetic mistakes, duplicate entries, or a transaction recorded in the wrong amount.
Here is the standard bank reconciliation statement format, filled in with a sample example. Both adjusted balances must equal the same number.
SAMPLE COMPANY
Bank Reconciliation Statement
For the month ending March 31, 2026 · Account: ••••4821
Bank Balance
Ending balance per bank statement$8,450.00
Add: Deposits in Transit
Deposit 3/30 (not cleared)+ $1,200.00
Less: Outstanding Checks
Check #1042 — Supplier− $340.00
Check #1043 — Utilities− $185.00
Adjusted Bank Balance$9,125.00
Book Balance
Ending balance per books$9,215.00
Add: Credits Not Recorded
Interest earned+ $10.00
Less: Debits Not Recorded
Monthly bank fee− $15.00
NSF check from client− $85.00
Adjusted Book Balance$9,125.00
Reconciled — both adjusted balances equal $9,125.00 Common Discrepancies and How to Fix Them
If your balances don't match, here are the most likely causes and what to do:
| Discrepancy | Cause | How to fix |
|---|
| Outstanding check | Check issued but not yet cashed by recipient | List in reconciliation as outstanding; follow up if over 90 days old |
| Deposit in transit | Deposit made near statement date, not yet processed | Add to bank balance in reconciliation; confirm it posts next period |
| Bank error | Bank charged wrong amount, debited wrong account | Contact bank immediately; note on reconciliation as 'bank error' |
| NSF check | A check you deposited bounced (not sufficient funds) | Remove from your book balance; contact payer for replacement |
| Bank fees | Monthly maintenance fee, overdraft fee, wire fee not recorded | Deduct from book balance; add as expense in your records |
| Interest earned | Interest credit on savings/checking not recorded in books | Add to book balance; record as income |
| Timing difference | ACH transfer initiated before statement cutoff but processed after | Note as outstanding item; it will appear on next statement |
| Arithmetic error | Wrong amount recorded in books (transposition, rounding) | Re-check each entry; look for differences divisible by 9 (transposition clue) |
How Often Should You Reconcile?
Daily
High-volume businesses
Restaurants, retailers, any business with 100+ daily transactions
Weekly
Active small businesses
Service businesses, e-commerce stores, active freelancers
Monthly
Most businesses & individuals
The standard. Reconcile at each statement period end.
Quarterly
Low-activity accounts only
Only for accounts with very few transactions. Risky for fraud detection.
Never let more than 90 days pass without reconciling. The longer you wait, the harder it is to track down discrepancies — vendors close, records get lost, and fraud can go undetected for months.
- Go to Accounting → Reconcile
- Select your bank account and enter the statement ending date + ending balance
- Check off each transaction that appears on your bank statement
- When Difference = $0.00, click Finish Now
XL
Microsoft Excel / Google Sheets
- Create two columns: Bank Statement transactions and Book transactions
- Use VLOOKUP or manual matching to find items in both lists
- Flag unmatched items — these are your outstanding items
- Build the reconciliation template shown above in separate cells
- Go to Accounting → Bank Accounts → select account → Reconcile
- Xero automatically imports bank transactions via bank feed
- Match imported transactions to your Xero entries
- Any unmatched items are flagged for review
Frequently Asked Questions
What is bank reconciliation?+
Bank reconciliation is the process of matching your internal financial records (your books) against your official bank statement to make sure they agree. It confirms that every transaction is accounted for and catches errors, fraud, or missing entries before they become bigger problems.
How often should you reconcile bank statements?+
Monthly is the standard for most businesses and individuals. Reconcile at the end of each statement period. High-volume businesses (with hundreds of daily transactions) may reconcile weekly or even daily. Never go longer than 90 days without reconciling — errors compound quickly.
What is the difference between a bank statement and a bank reconciliation statement?+
A bank statement is an official document from your bank showing all transactions in an account for a period. A bank reconciliation statement is a document YOU create to explain the difference between your bank balance and your book balance, listing outstanding items and adjustments.
What if the adjusted balances still don't match?+
Work backwards: check for duplicate entries, wrong amounts (transposition errors — try dividing the difference by 9, a divisible result usually means transposed digits), or missing transactions. Also check that you're using the correct statement period. If you can't find it, have a second person review the reconciliation.
Can I use bank reconciliation to detect fraud?+
Yes — this is one of its most important uses. Reconciliation catches unauthorized transactions (someone using your account number), forged checks, altered check amounts, and fraudulent ACH debits. Regular reconciliation is one of the strongest internal controls a business can have.
What is a bank reconciliation statement format?+
A standard format has two sections: (1) Bank Balance section — start with bank ending balance, add deposits in transit, subtract outstanding checks = adjusted bank balance. (2) Book Balance section — start with book ending balance, add bank credits not recorded, subtract bank debits not recorded = adjusted book balance. Both adjusted figures must be equal.
How do I reconcile a bank statement in QuickBooks Online?+
In QuickBooks Online: go to Accounting → Reconcile. Select the account and enter the ending date and ending balance from your bank statement. QuickBooks will show your cleared and uncleared transactions. Check off each transaction that matches your bank statement. When the 'Difference' field shows $0.00, click Finish.
Skip the spreadsheet
Upload your bank statement and get every transaction automatically categorized and analyzed — no manual matching required.
Analyze my bank statement — free
