What Is Basic Accounting?

What's happening with my books and bank statement?

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?

1. Open the Reconciliation Window

   • QuickBooks Desktop 2026: Go to Banking → Reconcile
   • QuickBooks Online 2026: Navigate to Accounting → Reconcile

2. 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.

3. 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.

4. 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

5. 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.

6. Fix the problematic entry

   1. Search for the transaction with Ctrl+F (Desktop) or the search bar (Online).
   2. Adjust the amount, date, or account as needed.
   3. Save your changes and run the reconciliation again.

What if the standard steps don’t resolve the discrepancy?

• 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 Reconciliation to 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?

• 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.