Quick Fix Summary
Can’t reconcile your accounts? Go to Reports → Balance Sheet (QuickBooks 2026) and compare the “Total Assets” line with your bank statement. If the difference is under 1 %, your books are likely correct; if it’s higher, run the Reconciliation Discrepancy Report to pinpoint mismatches.
What’s Happening
That disconnect usually comes from uncleared checks, missing deposits, bank fees, or plain old typos. QuickBooks Desktop 2026 and QuickBooks Online (2026 release) flag unreconciled items automatically, but you still need to double-check each one. A difference under 1 %? Probably just rounding. Anything bigger? Time to dig in.
Step-by-Step Solution
Open the Reconciliation Screen
- QuickBooks Desktop 2026: Banking → Reconcile
- QuickBooks Online 2026: Accounting → Reconcile
Match Transactions One by One
Start with the “Compare Opening Balance” prompt. For every line on the bank feed, click the green checkmark or type the amount yourself. QuickBooks will flash unmatched items in red—easy to spot.
Check for Common Culprits
- Uncleared checks still floating after the statement date
- Bank service charges logged as expenses but missing from the statement
- Duplicate transactions from importing errors or double-clicking
Generate the Reconciliation Discrepancy Report
Head to Reports → Banking → Reconciliation Discrepancy (Desktop) or Reports → Accountant Reports → Reconciliation Discrepancy (Online). This report shows every change since the last reconciliation, so you can track down the exact entry that threw everything off.
Adjust the Offending Entry
- Find the transaction in the register (Ctrl+F in Desktop, search bar in Online).
- Fix the amount, date, or account code.
- Save it and run the reconciliation again.
If This Didn’t Work
Restore a Backup
Before you go wild editing, make a backup: File → Back Up Company → Create Local Backup (Desktop). Still seeing errors? Restore yesterday’s backup and re-enter only today’s transactions.
Use the “Undo Last Reconciliation” Tool
In QuickBooks Desktop 2026, go to Banking → Reconcile → Undo Last Reconciliation. This wipes the slate clean back to the state before the last reconciliation—no prior work lost.
Call the Bank’s API Log
If you’re using live bank feeds, grab the raw transaction log from your bank’s website. Download the CSV and compare it line-by-line with the QuickBooks register; sometimes feeds cut off decimals or skip fees.
Prevention Tips
Daily Imports, Weekly Reconciliation
Set bank feeds to import every morning. Reconcile every Friday before closing the books—catching errors early beats scrambling at month-end.
Two-Person Review for Large Transactions
Checks over $1,000 need a second set of eyes. Require approval in Company → Set Up Users and Passwords → New (Desktop) or Gear → Manage Users → New (Online).
Monthly Accountant Access
Invite your CPA as a “Read-Only” user (Company → Manage Users → Add User). They’ll catch oddities before they become audit headaches.
