Bank Reconciliation: Step-by-Step Guide for Small Business
Every month, your bank statement says one thing. Your accounting software says another. Bank reconciliation is the process of finding out why — and making sure your books reflect reality.
Most business owners know they should reconcile their bank accounts. Fewer do it consistently. The ones who don't end the year with financial records that don't match their tax filings, cash flow surprises, and missed transactions.
This guide walks through bank reconciliation from start to finish.
What Is a Bank Reconciliation?
A bank reconciliation is the process of comparing your internal cash records (your accounting software or ledger) with your bank's records (the bank statement) to identify differences and ensure they are legitimate.
Differences are normal — checks that haven't cleared, deposits in transit, bank fees, and interest are all common reconciling items. The goal is to understand every difference, not to eliminate the bank statement.
Why Bank Reconciliation Matters
For accuracy: Your cash balance is the starting point for most financial decisions. If it's wrong, everything downstream is wrong.
For fraud detection: Regular reconciliation catches unauthorized transactions, forged checks, and billing errors while they're still recoverable.
For month-end close: You can't prepare accurate financial statements without knowing your true cash position.
For tax accuracy: Your tax return starts with your cash balance. If your books don't match your bank, your tax filing is based on incorrect numbers.
Best practice: Reconcile monthly, on the same day every month. Make it part of your closing process — not something you do "when you have time."
What You Need
Before you start, gather: 1. Bank statement for the period (month-end) 2. Cash GL from your accounting software — the register for your main checking account 3. Previous month's reconciliation — to carry forward the starting balance
The 8-Step Bank Reconciliation Process
Step 1: Note the Bank Statement Ending Balance
Start with the bank statement's ending balance for the month. Write it down.
Example: Bank statement ending balance, March 31: $24,876.50
Step 2: Note the GL Cash Balance
Find the ending balance in your accounting software's cash account register.
Example: GL cash balance, March 31: $23,451.00
Step 3: Identify Deposits in Transit
A deposit in transit is money you've recorded in your books but that hasn't cleared the bank yet — it was deposited close to month-end and hadn't posted before the statement printed.
Look for: Deposits recorded in your GL on the last few days of the month that don't appear on the bank statement.
Example: March 30 deposit of $2,500 recorded in GL but not on bank statement.
Adjust the GL balance by adding deposits in transit.
Step 4: Identify Outstanding Checks
An outstanding check is a check you've written and recorded in your books but that the recipient hasn't yet deposited or cleared the bank.
Look for: Checks recorded in the GL that don't appear on the bank statement. Look at the cleared check list on the bank statement and cross-reference with your GL.
Example: Check #2041 for $850 recorded in GL but not cleared.
Adjust the GL balance by subtracting outstanding checks.
Step 5: Account for Bank Fees and Interest
Bank fees (monthly service charges, wire fees, overdraft fees) and interest earned appear on the bank statement but may not be in your GL yet.
Look for: Any debits or credits on the bank statement that aren't in your GL.
Example: Bank monthly fee of $25 — not yet recorded in GL. Interest earned of $3.12 — not yet recorded.
Adjust the GL balance: - Subtract bank fees - Add interest earned
Step 6: Account for NSF Checks
An NSF (non-sufficient funds) check is a check you received that bounced — the payer didn't have sufficient funds and the bank returned it. You've already recorded the deposit in your GL, so you need to reverse it.
Look for: Bank notification of returned items or debits for NSF.
Example: A customer check for $500 deposited March 15 has been returned NSF.
Adjust the GL balance: Subtract the NSF amount from your GL cash (and flag the customer receivable for follow-up).
Step 7: Identify Errors
Errors can be on either side — your books or the bank's.
On your side (GL errors): - Transposed digits: $1,500 entered as $1,050 - Entered in the wrong period - Entered in the wrong bank account
On the bank's side: - Posting errors by the bank (rare but possible)
Example: GL shows check #2089 for $320 — bank shows $230. If the bank is correct, you need to adjust your GL.
Step 8: Verify the Reconciliation Balances
After making all adjustments, your GL balance should equal your bank balance.
The formula:
Adjusted GL Balance = GL Balance
+ Deposits in transit
− Outstanding checks
− Bank fees
+ Interest earned
− NSF checks
− Other bank adjustments
If they match: Reconciliation is complete.
If they don't match: Go back through steps 3–7. Common culprits: missed deposits in transit, missed outstanding checks, bank fees not recorded, transposed numbers in entries.
Bank Reconciliation: An Example
| Item | Amount |
|---|---|
| GL Cash Balance, March 31 | $23,451.00 |
| Add: Deposit in transit (Mar 30) | +$2,500.00 |
| Less: Outstanding check #2041 | −$850.00 |
| Less: Bank fee (March) | −$25.00 |
| Add: Interest earned | +$3.12 |
| Less: NSF check (J. Smith) | −$500.00 |
| Adjusted GL Balance | $24,579.12 |
| Item | Amount |
|---|---|
| Bank Statement Balance, March 31 | $24,579.12 |
| Note: Outstanding checks on statement | $850.00 (check #2041) |
| Note: Deposit in transit (per GL) | $2,500.00 |
| Note: Bank fee | −$25.00 |
| Note: Interest earned | +$3.12 |
| Note: NSF returned item | −$500.00 |
| Adjusted Bank Balance | $24,579.12 ✓ |
Bank Reconciliation in Accounting Software
Modern accounting software automates most of this process:
- QuickBooks Online: Banking → Reconcile → Select account → Enter statement date and ending balance → Match transactions
- Xero: Accounting → Bank Accounts → [Account] → Reconcile
- Wave: Accounting → Bank Connections → [Account] → Reconcile
The software pulls transactions directly from your bank feed, making matching faster. You still need to identify timing differences (deposits in transit, outstanding checks) manually.
Common Reconciliation Problems
| Problem | Cause | Fix |
|---|---|---|
| GL balance doesn't match bank after all adjustments | Missed a transaction | Start over from the beginning |
| Recurring bank fee not in GL | Forgot to record monthly fees | Set up recurring journal entry for monthly fees |
| Deposits in transit growing each month | Didn't reconcile last month | Catch up on prior months first |
| NSF items appearing months later | Customer paid with bad check after you've recorded revenue | Remove from AR, follow up on collection |
| Opening balance doesn't match prior reconciliation | GL was changed after prior close | Review prior reconciliation; check for GL corrections |
How Often Should You Reconcile?
Monthly, without exception. The minimum is monthly — more frequently if you have high transaction volume. Weekly reconciliation is even better for businesses with significant cash movement.
Set a recurring calendar reminder: "Bank reconciliation — last day of month." Do it the day after the month ends, while the bank statement is fresh.
The Bottom Line
Bank reconciliation is a non-negotiable part of financial management. It takes 15–30 minutes once you understand the process. The reward: books that match reality, fraud that gets caught immediately, and financial statements you can trust.
Draft prepared by CMO | 2026-04-09 For AccountingTitan Phase 2 — queued for Week 5+
