How to Reconcile in QuickBooks Online (and What to Do When It Won't Match)
Step-by-step QuickBooks Online reconciliation guide plus the five most common reasons your bank balance won't agree — and how to fix each one without breaking prior periods.
Short answer
To reconcile in QuickBooks Online: go to Accounting > Reconcile, pick the account, enter the bank statement's ending date and balance, then check off every transaction that cleared the bank. Difference should be $0. If it isn't, the five most common causes are uncleared transactions from prior months, duplicates, missing transactions, a wrong beginning balance, or a bank feed glitch — each has a specific fix that doesn't break your prior periods.
Checklist
- Get the bank or credit card statement open for the period you're reconciling
- Open Accounting > Reconcile and pick the account
- Confirm the beginning balance matches the prior statement's ending balance
- Enter the ending balance and ending date from the statement
- Check off each transaction that cleared the bank
- Look at the Difference field — it should read $0.00
- If not $0, do not force-finish — fix the discrepancy first
- Save and finish only when the difference is exactly zero
Common mistakes
- Clicking Finish Now when the difference isn't zero — this creates an adjustment entry that hides the real problem
- Letting old uncleared transactions accumulate for years instead of clearing them out monthly
- Forgetting to reconcile credit card accounts (not just bank accounts)
- Reconciling out of order — always reconcile month-by-month, never skip ahead
- Editing or deleting transactions from already-reconciled periods (it silently breaks reconciliations)
Examples for service businesses
- Service business: usually only need to reconcile one checking, one savings, and one credit card monthly
- Contractor: reconcile every credit card separately and the operating account — many trades miss the fuel card
- Product seller: reconcile every payment processor (Stripe, Square, PayPal) as a separate account
What reconciliation actually is
Reconciliation is the process of confirming that your QuickBooks records match your bank's records — that every transaction the bank cleared is recorded in QuickBooks, and nothing fake is in QuickBooks that the bank didn't see.
When QuickBooks reconciles to the penny, your reports are reliable. When it doesn't, your P&L is wrong, your Balance Sheet is wrong, and your CPA can't file an accurate tax return. This is why reconciliation is the single most important monthly habit in bookkeeping.
How to reconcile in QuickBooks Online: step-by-step
The QBO reconciliation flow is the same for every account type. Here it is in seven steps:
- 1. Open Accounting > Reconcile from the left sidebar
- 2. Select the account you want to reconcile and click Reconcile
- 3. Enter the ending date and ending balance from your bank or credit card statement
- 4. Click Start reconciling — QuickBooks shows every transaction in the period
- 5. Check off each transaction that appears on the statement (use Match column to confirm dates)
- 6. Watch the Difference field in the top-right — it should drop to $0.00 as you check items off
- 7. When Difference is exactly $0.00, click Finish now
When the difference isn't zero — the five common causes
If you've checked everything off and the difference still isn't zero, do not click Finish now and let QuickBooks create an adjustment. That hides the real problem and creates an unexplained line on your books that haunts you later. Instead, work through these five causes in order:
Cause 1: Uncleared transactions from prior months
Old checks or deposits that never actually cleared the bank stay in QuickBooks forever, dragging your reconciliations off. Look at the Uncleared transactions section — anything older than 90 days is suspicious.
Fix: confirm whether the transaction is real. If a check was lost, void it (in the original period, not today). If a deposit was reversed, enter the reversal. Don't simply delete — deletion breaks the original period's reconciliation.
Cause 2: Duplicate transactions
Duplicate transactions happen when the same transaction is entered manually and also imported from the bank feed. Both show up; both want to be cleared; the books are off by the duplicated amount.
Fix: in the Banking center, the Match column should show the bank feed transaction matching the existing manual entry. If you see two separate transactions for the same amount on the same date, delete one — usually the manual entry, keeping the feed-imported one.
Cause 3: Missing transactions
The opposite of a duplicate — the bank shows a transaction QuickBooks never received. This is common with cash transactions, transfers between accounts, or bank fees the feed somehow missed.
Fix: enter the missing transaction manually with the correct date and category. Then it will be available to check off in the reconciliation.
Cause 4: Wrong beginning balance
If your beginning balance in the reconciliation screen doesn't match the prior statement's ending balance, you have a problem in a prior period. Something was edited, deleted, or added after that period was reconciled.
Fix: run a Reconciliation Discrepancy report (Reports > Reconciliation Discrepancy). It shows every change made to reconciled transactions. Reverse those changes — or, if the change was legitimate, re-reconcile the affected prior periods.
Cause 5: Bank feed glitch
Occasionally the bank feed reports a transaction with the wrong date or amount, especially around weekends, holidays, or pending charges that later post differently. The QuickBooks transaction won't match the statement.
Fix: edit the QuickBooks transaction to match the statement (date and amount). The bank statement is always the source of truth, not the feed.
When to call for help
If you've worked through all five causes and the difference still isn't zero, stop. Force-finishing creates an adjusting entry that hides — but doesn't fix — the problem. Every month after that, your prior-period reconciliations get harder to trust.
At that point, a single 90-minute Training Intensive session is the cheapest fix. We share screens, find the issue, fix it, and explain what to do differently next month.
Get Help with QuickBooks Reconciliations
If reconciliation is the part of QuickBooks that always feels wrong, a 90-minute Training Intensive session is built exactly for this. We share screens, walk through your real file, and fix what's broken so you can do it yourself next month.
Get Help with QuickBooks ReconciliationsRelated resources
QuickBooks Online Setup Checklist
Set up QBO correctly — the source of most reconciliation problems is bad setup.
Chart of Accounts Template
A clean chart of accounts makes reconciliations dramatically easier.
QuickBooks Cleanup Checklist
If reconciliations are years behind, a cleanup project is the right fix.
Related support from Sabillon Advisory
If this guide describes the bookkeeping problem you are dealing with, these services are the most relevant next step.