QuickBooks Online Reconciliation Not Balancing: What's Actually Going Wrong and How to Fix It
A reconciliation that won't hit $0.00 almost always traces back to one of four causes: a missing transaction, a wrong amount, a duplicate entry, or an incorrect opening balance. QuickBooks compares your register line by line against your bank statement, so isolating which of these four categories applies gets most discrepancies fixed in minutes, not hours.
The transactions matched. The dates matched. And the difference still won't move to zero. If you've stared at that number refusing to budge, you already know reconciling isn't just clicking through a checklist, it's detective work. This guide goes past the basic setup steps and into what's actually happening under the hood: what reconciling verifies that your bank feed doesn't, and the exact order to check things when your numbers won't agree.
What does reconciling actually verify that my bank feed doesn't?
Your bank feed syncing automatically is not the same as being reconciled. The feed just imports transactions into QuickBooks; reconciliation is the separate, monthly proof that those imported transactions are recorded correctly against your actual bank or credit card statement.
Reconciling compares the transactions in your QuickBooks register against the transactions on your statement to confirm they match: same transactions, same amounts, same dates. When the difference counter hits $0.00, QuickBooks and your bank agree on every transaction for that period. A connected bank feed can look complete and still be wrong underneath, if a transaction was categorized to the wrong account, entered twice, or never downloaded at all, the feed won't flag it. Reconciliation is the step that catches it.
What happens after I finish a reconciliation?
QuickBooks automatically saves a reconciliation report the moment you finish. You can find every past report from the Reconcile page by selecting History by account, which shows every transaction included in that period along with the opening and closing balances.
This report is worth saving or downloading after each reconciliation, not just glancing at. If a discrepancy shows up two months from now, having the historical reports on hand is what makes it possible to trace exactly where things went off track instead of re-checking every period from scratch.
Why won't my reconciliation difference hit $0.00?
This is the most common sticking point, and it almost always traces back to one of four causes.
| Cause | What it looks like | How to check it |
|---|---|---|
| Missing transaction | Something's recorded on one side but not the other | Look for anything in QuickBooks dated before your statement period that you haven't checked off, then compare it against the statement itself |
| Wrong amount | A transaction is checked off, but the dollar amount doesn't match | Compare the amounts for every checked item against your statement, line by line |
| Duplicate entry | The same transaction was entered twice | Search for duplicates, especially near the start of the statement period |
| Incorrect opening balance | A past reconciliation was edited or undone after the fact | Pull the prior period's report from Reports > Reconciliation Reports and compare opening balances |
Work through these in order. Missing and duplicate transactions are the most common causes and the fastest to spot; an incorrect opening balance is rarer but harder to trace, since it means the problem started further back than the period you're currently working on.
Should I ever use the "adjustment" option to force it to zero?
Rarely, and only for small amounts you genuinely can't trace. QuickBooks does let you finish a reconciliation with a non-zero difference by selecting Add adjustment and finish, which creates an expense or income transaction (depending on the direction of the difference) to force the account to balance. That transaction gets labeled a reconciliation discrepancy in your books.
This option exists for a reason: sometimes a few cents are left over from rounding, and tracking down the source isn't worth the time. But it's not a shortcut for a real, larger discrepancy. Using it to paper over a mismatch you haven't actually explained just moves the error into a new transaction instead of fixing it, and it's the kind of thing an accountant will flag immediately if they review your books later.
How often should I actually reconcile?
Monthly is the standard, once per bank statement, as soon as it's available. The longer you wait, the harder it gets to remember why a transaction is there or why it's missing, which turns a five-minute check into a longer investigation. Some businesses reconcile weekly or even daily for tighter cash flow visibility, but monthly is the minimum for keeping your books accurate.
FAQ
Why does my bank feed show everything's fine, but my reconciliation still won't balance? A synced bank feed just means transactions downloaded successfully. It doesn't confirm they were categorized correctly, entered only once, or matched to the right account. Reconciliation is the separate check that catches those issues.
Can I just force the difference to zero? You can, using the "Add adjustment and finish" option, but it should be reserved for a few cents you genuinely can't trace, not a real discrepancy. Forcing a larger difference just relabels the error as a reconciliation discrepancy transaction instead of fixing it.
What's the difference between a reconciliation report and my bank statement? Your bank statement is the external record you're comparing against. The reconciliation report is QuickBooks' own record of what was included in that reconciliation, confirming the opening and closing balances matched.
How far back can a reconciliation discrepancy actually go? As far back as the last time your opening balance was correct. If a past reconciliation was edited or undone, the error can carry forward into every period after it until someone catches it.
Is it bad if I haven't reconciled in months? It's not catastrophic, but it does mean more transactions to check and a higher chance of duplicates or categorization errors compounding. Reconcile the oldest unreconciled period first, then work forward.
Do connected bank accounts still need to be reconciled? Yes. A connected feed automates the import, not the verification. Reconciliation is still the step that confirms everything was recorded and categorized correctly.
Key Takeaways
- A bank feed syncing automatically is not the same as being reconciled; reconciliation is the separate, monthly proof that what's recorded is correct.
- A non-zero difference almost always traces back to a missing transaction, a wrong amount, a duplicate entry, or an incorrect opening balance.
- Work through those four causes in order rather than re-checking the whole reconciliation from scratch.
- The "Add adjustment and finish" option should be used only for small, untraceable amounts, never as a shortcut for a real discrepancy.
- Reconcile monthly at minimum; waiting longer makes every discrepancy harder to trace.
Still not hitting zero?
If you've worked through all four causes and the difference still won't move, drop the details in the comments below and we'll help you track it down.
Helpful Resources
- Reconcile an account in QuickBooks Online: the official step-by-step setup
- Learn the reconcile workflow in QuickBooks Online: the full reconciliation hub, including opening balances and older transactions
- Fix issues at the end of a reconciliation in QuickBooks Online: official troubleshooting steps for a non-zero difference
- Enter an adjusting entry for a reconciliation in QuickBooks Online: how the adjustment option actually works
- How to Reconcile Your Accounts in QuickBooks Online: the basic setup walkthrough
- How to Avoid Reconciliation Mistakes in QuickBooks Online: preventive habits to build before you're stuck