Bank reconciliation is the most important routine in bookkeeping. This walkthrough covers the full process in QuickBooks Online — including how to fix the errors that cause a non-zero difference.
What is bank reconciliation and why does it matter?
Bank reconciliation is the process of matching your QuickBooks records to your actual bank statement. When they agree, your books are accurate. When they don't, something is wrong — either in QuickBooks, at the bank, or both.
For small businesses, monthly reconciliation serves three critical purposes:
- Catches bank errors (they happen more often than you'd expect)
- Catches data entry errors and duplicate transactions in QuickBooks
- Ensures your financial reports and tax filings are based on accurate numbers
Monthly reconciliation takes 10–20 minutes. Quarterly takes hours once you find a problem from three months ago. Monthly is always worth it.
What you need before starting
- Your bank statement for the period (PDF or paper copy)
- QuickBooks Online access
- The ending balance and statement date from your bank
Step-by-step walkthrough
Open the Reconcile screen
In QuickBooks Online: Accounting → Reconcile (left menu). Select the bank account you want to reconcile.
Enter your statement details
Enter the Ending Balance from your bank statement exactly as shown. Enter the Statement Ending Date. Click "Start Reconciling."
Match transactions
QuickBooks shows deposits on the right, payments on the left. Check off every transaction that appears on your bank statement. The Difference counter at the bottom moves toward $0 as you match.
Reach $0 difference
When the Difference field shows exactly $0.00 — click "Finish Now." QuickBooks marks all checked transactions as reconciled (shown with "R" in transaction lists).
When the difference isn't zero
This is where most people get stuck. A non-zero difference means something doesn't match. Here's how to diagnose it:
Small difference (under $10)
Usually a bank fee or rounding error. Check your bank statement for any small transactions not in QuickBooks — monthly service fees, ATM fees, interest income.
Difference equals a specific transaction amount
Search QuickBooks for that exact dollar amount. Either it's missing from QuickBooks (needs to be added), or it's dated to the wrong period (shows up in the wrong month's reconciliation).
Difference is exactly double a transaction
Almost always a duplicate entry. Search QuickBooks for that amount and look for two identical transactions. Delete the duplicate.
Difference carries over from a prior period
If you've never reconciled or a prior reconciliation was wrong, the error carries forward. You'll need to find and fix the prior period's mistake first.
This creates a journal entry that hides the real problem and causes downstream issues in your financial reports. Track down the actual discrepancy instead.
Using the bank feed to save time
QuickBooks Online's bank feed auto-downloads transactions from your bank daily. With the feed connected, most transactions are already in QuickBooks — you just need to match and categorize them. Go to Banking → Connect Account to link your business bank. Most major US banks are supported.
How often should you reconcile?
| Business Type | Frequency | Time Needed |
|---|---|---|
| Freelancer / sole prop | Monthly | 10–20 min |
| Small business (1–10 employees) | Monthly | 20–45 min |
| High transaction volume | Weekly | 15–30 min/week |
| Any business with payroll | After every payroll run | 10 min |
Note: Screenshots and menu paths are based on QuickBooks Online as of early 2025. Intuit updates the interface periodically — use the search bar (Ctrl+Alt+F) to find any feature that has moved.