Basic accounting tracks, records, and analyzes financial transactions to keep a business’s income, expenses, assets, and liabilities accurate and current.
What's happening with my books and bank statement?
Your books don’t match your bank statement—usually because of unreconciled items or data entry mistakes.
Most mismatches come from uncleared checks, missing deposits, bank fees, or simple typos in your records. QuickBooks Desktop 2026 and QuickBooks Online (2026 release) flag these issues automatically, but you still need to review them yourself. A variance under 1% is often just rounding; anything bigger demands closer inspection.
How do I fix this step by step?
Reconcile your accounts by following the exact menu path for your QuickBooks version and matching every transaction line by line.
-
Open the Reconciliation Window
- QuickBooks Desktop 2026: Go to
Banking → Reconcile - QuickBooks Online 2026: Navigate to
Accounting → Reconcile
- QuickBooks Desktop 2026: Go to
-
Verify the Opening Balance
QuickBooks compares the opening balance with your bank statement. If they don’t line up, fix the difference before moving forward—otherwise, small errors snowball into bigger ones.
-
Match Each Transaction
For every line in the bank feed, click the green check or type the amount yourself. Red rows show unmatched transactions; hover over them to see exactly what’s off.
-
Investigate the usual suspects
- Checks that haven’t cleared yet but were written before the statement cutoff
- Bank service charges that you logged as expenses but didn’t appear on the statement
- Duplicate transactions from import glitches or accidental double-clicks
-
Pull the Reconciliation Discrepancy Report
- Desktop:
Reports → Banking → Reconciliation Discrepancy - Online:
Reports → Accountant Reports → Reconciliation Discrepancy
This report shows every change since your last reconciliation, so you can spot the exact entry that threw everything off.
- Desktop:
-
Fix the problematic entry
- Search for the transaction with
Ctrl+F(Desktop) or the search bar (Online). - Adjust the amount, date, or account as needed.
- Save your changes and run the reconciliation again.
- Search for the transaction with
What if the standard steps don’t resolve the discrepancy?
Try these fallback strategies when the usual reconciliation steps don’t clear the mismatch.
-
Restore a backup
Before touching live data, make a backup: In QuickBooks Desktop 2026, go to
File → Back Up Company → Create Local Backup. If the problem sticks around, restore yesterday’s backup and only re-enter today’s transactions. -
Undo the last reconciliation
Only available in QuickBooks Desktop 2026, use
Banking → Reconcile → Undo Last Reconciliationto roll back to the state before the last reconciliation—no prior work disappears. -
Compare the raw bank CSV
Grab the transaction CSV straight from your bank’s website. Line up decimals, fees, and cutoff dates with the QuickBooks register; feeds sometimes drop cents or skip fees.
How can I prevent this from happening again?
Adopt these habits to keep future reconciliation mismatches to a minimum and maintain accurate books all year.
-
Import daily, reconcile weekly
Set bank feeds to pull in every morning and reconcile every Friday before closing the books. Catching errors early beats untangling a month-end disaster.
-
Require dual approval for large checks
Make a second signature mandatory for checks over $1,000. In Desktop:
Company → Set Up Users and Passwords → New. In Online:Gear → Manage Users → New. -
Give your accountant monthly access
Invite your CPA as a “Read-Only” user: In Desktop:
Company → Manage Users → Add User. In Online:Gear → Manage Users → Add User. They’ll catch oddities before they turn into audit headaches.
