The 7 Most Common Causes — and How to Diagnose Each
| # | Cause | How to Diagnose | Fix |
|---|---|---|---|
| 1 | Previously reconciled transaction was edited or deleted | Reports → Banking → Reconciliation Discrepancy Report — shows all changes to reconciled transactions | Restore or re-enter the original transaction, then re-reconcile |
| 2 | Duplicate transactions (bank feed + manual entry) | Look for two entries with the same amount and date — one from bank feed, one entered manually | Delete the duplicate — keep the bank feed version |
| 3 | Wrong opening balance when account was set up | Compare the Opening Balance in QBO to your actual bank statement on the setup date | Edit the opening balance transaction to match the actual bank statement |
| 4 | Transactions outside the reconciliation date range | Check whether any transactions are dated outside the statement period you are reconciling | Correct the transaction date to the actual posting date |
| 5 | Prior reconciliation was forced (adjusting entry) | Check your Opening Balance Equity account — unexplained balance here means a prior forced reconciliation | Undo prior reconciliation and redo it properly; remove the adjusting entry |
| 6 | Bank feed connected to wrong account | Verify that the QBO account linked to the bank feed matches the actual bank account number | Disconnect and reconnect the correct bank account |
| 7 | Uncleared outstanding checks or deposits | List of outstanding checks/deposits carries forward — legitimate if items truly have not cleared the bank | Verify with bank — void if stale, leave outstanding if genuinely uncleared |
Never click "Finish Now" with a remaining discrepancy. QuickBooks creates an adjusting journal entry that posts to Opening Balance Equity — it looks like the reconciliation is done but it is not. Your balance sheet is now wrong. The discrepancy is still there, just hidden. Each forced reconciliation compounds the problem. Fix the source, never mask it.
Step-by-Step: How to Diagnose a Reconciliation Discrepancy
Step 1: Run the Reconciliation Discrepancy Report — Reports → Banking → Reconciliation Discrepancy. This is your first tool for every unmatched reconciliation.
Step 2: Note the exact discrepancy amount. Check if it matches any single transaction exactly (or is exactly double a transaction — a common duplicate pattern).
Step 3: Check your Opening Balance Equity account. Any unexplained balance means a prior forced reconciliation.
Step 4: If multiple months are off, stop. Each new attempt at fixing adds complexity. Hand it to a professional.
When to Stop and Get Help
Stop trying to self-fix your reconciliation when:
- The discrepancy has existed across more than 2 months
- You have already tried to fix it and made it worse
- Your Opening Balance Equity account has an unexplained balance
- You cannot find the source transaction in the Reconciliation Discrepancy Report
- Tax season is approaching and your books need to be clean within days
Sharma Jyoti and Co: share your QuickBooks as an accountant user, we review within 2 business days, provide a fixed-price cleanup quote, and restore clean reconciliation from the first error month forward.