What Is Basic Accounting?

What's happening with my books and bank statement?

Usually it's because checks haven't cleared yet, deposits got entered twice, or a bank fee slipped by unnoticed. A 2025 Intuit QuickBooks report found 68% of small businesses run into this exact problem—mostly because they skip monthly reconciliations. A tiny variance (under 1%) is probably just rounding; anything bigger signals an unrecorded transaction or a wrong amount. The IRS recommends reconciling bank statements at least monthly to catch these gaps early. QuickBooks Online (2026 release) and QuickBooks Desktop 2026 will flag mismatches, but you still need to double‑check them yourself.

How do I fix this step by step?

1. Open the Reconciliation Window

   • QuickBooks Desktop 2026: Head to Banking → Reconcile
   • QuickBooks Online 2026: Jump over to Accounting → Reconcile

2. Verify the Opening Balance

   QuickBooks compares your opening balance with the starting figure on your bank statement. If they don't line up, fix the difference before moving forward—otherwise, little mistakes can snowball into big headaches.

3. Match Each Transaction

   For every line in your bank feed, click the green check or type in the amount manually. Red rows? Those are your problem children. Hover over them to see exactly what's missing or messed up.

4. Investigate the usual suspects

   • Checks you wrote right before the statement cutoff that haven't cleared yet
   • Bank fees that got logged as expenses but aren't on the statement yet
   • 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 track down the exact entry that threw everything off.

6. Fix the problematic entry

   1. Search for the transaction using 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.

Investopedia notes that a systematic, line‑by‑line approach reduces the chance of lingering errors by over 90%.

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

• Restore a backup

  Never tweak live data without a safety net. 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 to avoid making things worse.

• Undo the last reconciliation

  This trick only works in QuickBooks Desktop 2026. Head to Banking → Reconcile → Undo Last Reconciliation to roll back to the state before the last reconciliation—no prior work gets lost.

• Compare the raw bank CSV

  Download 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, creating sneaky mismatches that the software won't catch. Wikipedia explains that CSV imports preserve the exact values banks transmit, making them a reliable audit trail.

How can I prevent this from happening again?

• Import daily, reconcile weekly

  Set your bank feeds to pull in transactions every morning and reconcile every Friday before closing the books. Spotting errors early beats untangling a month‑end mess every single time.

• 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. This cuts down on fraud risks and accidental overpayments.

• 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. Regular professional review catches subtle drift before it compounds.