When QuickBooks says “reconciled” but the bank still isn’t right

When the bank says one thing and QuickBooks swears it’s reconciled

You open a new QBO cleanup file. The owner proudly tells you, "But my bank is reconciled every month." You click into Reconcile, and sure enough, the status shows "Reconciled" for the checking and credit card accounts.

Then you look at the actual bank balance and the GL balance. They’re off by thousands. Or you open Reconciliation History and see a neat list of completed recs… but the beginning balance on March doesn’t match February’s ending balance. Something’s been undone, deleted, or papered over.

This is the mess: accounts that look reconciled in QuickBooks Online, but the reconciliation trail is broken. Beginning balances don’t tie to prior endings, QBO has quietly posted a Reconciliation Discrepancies adjustment, or there hasn’t been a real reconciliation in months despite constant activity.

If your firm does cleanup work, this is where you either:

• Catch the problem early and scope it correctly, or
• Walk into a time bomb that blows up halfway through the engagement.

Let’s talk about how to see these issues clearly and deal with them systematically.

Where this problem hides inside QuickBooks Online

There are three main places this shows up:

1. Reconciliation History (broken sequences)
2. The Reconciliation Discrepancies account (forced adjustments)
3. The account register / activity vs. last completed rec (gaps)

Broken reconciliation sequences

Start in Accounting → Reconcile → History by account.

Pick a bank or credit card account and scan the list of completed reconciliations. For each period, compare the beginning balance to the prior period’s ending balance.

Example:

• 6/30/2024 reconciliation
  • Ending balance: $45,320.17
• 7/31/2024 reconciliation
  • Beginning balance: $44,000.17

That $1,320 difference didn’t come from nowhere. It usually means a previously reconciled transaction was deleted, edited, or added with a date before the last reconciliation, and someone forced the next rec to "work" anyway.

Forced reconciliation adjustments

Next, run a Transaction Detail by Account report on the Reconciliation Discrepancies account:

• Report period: your cleanup period (or at least the last 12 months)
• Filter: Account = Reconciliation Discrepancies

If you see entries like:

• 07/15/2024 Journal "Reconciliation Adjustment – Checking" $-1,320.00

click in and look at the other side. If it’s your bank or credit card account, you know someone used a plug to get the reconciliation to zero.

Gaps in recent reconciliations

Finally, check whether the account has ongoing activity but no recent reconciliations.

In Reconciliation History:

• Last completed rec statement date: 06/30/2024

In the register or a Transaction Detail by Account report:

• Do you see checks, deposits, or card charges through 2025? If yes, and there’s no completed rec in that period, the account is not truly reconciled, no matter what the client thinks.

Quick red flags to watch for

• Beginning balance on a reconciliation doesn’t equal prior ending balance.
• Any posting at all to the Reconciliation Discrepancies account.
• Last completed reconciliation is many months back, but the account has regular activity.
• Big one-time "Reconciliation Adjustment" journal entries.
• Client insists everything is reconciled, but the bank balance doesn’t match the GL.

What happens if you just live with it

You can ignore these issues and still get through a tax return. But you’ll pay for it later—in credibility, in rework, and sometimes in real dollars.

The damage inside your numbers

When reconciliations are broken or propped up with adjustments, you lose the most basic assurance: that cash and card balances are real.

Common consequences:

• Cash is overstated or understated because deleted/edited transactions were never re-reconciled.
• Credit card balances don’t match the statement, so interest and fees are wrong.
• Reconciliation Discrepancies plugs hide fraud, duplicate entries, or missing transactions.
• Prior-year tax returns might have been filed on numbers that never actually tied to the bank.

You also lose your audit trail. When beginning balances don’t match prior endings, you can’t easily trace what changed. Every future reconciliation becomes harder and more time-consuming.

The damage in client conversations

Broken reconciliations also create trust issues.

You tell the client:

• "Your books say you have $120k in cash, but the bank has $105k."

They respond:

• "But my last accountant reconciled everything."

Now you’re not just fixing numbers; you’re explaining why "reconciled" didn’t actually mean reconciled. If you don’t catch this early and bake it into your scope, you either:

• Eat the extra hours trying to unwind old recs, or
• Leave the problems in place and hope they don’t come back to bite you.

Neither is a great look for a firm that wants to be seen as the adult in the room.

How solid firms clean this up

Here’s a simple, repeatable way to handle reconciliation integrity during cleanup.

1. Inventory all in-scope accounts.

   • From the Chart of Accounts, list every Bank and Credit Card account that should be reconciled.

2. Review reconciliation history for each account.

   • Open Reconciliation History and scan for:
     • Beginning balances that don’t match prior endings.
     • Long gaps with no completed recs.

3. Pull Reconciliation Discrepancies detail.

   • Run a Transaction Detail by Account on the Reconciliation Discrepancies account for your cleanup window (or last 12 months).
   • Tie each entry back to the affected bank/credit card account.

4. Decide your lookback and materiality.

   • For small, old differences, you may document and leave them if they’re outside your agreed period and immaterial.
   • For recent or large differences, plan to re-do reconciliations properly.

5. Repair the reconciliations.

   • Undo the impacted reconciliations where feasible.
   • Re-enter or correct deleted/edited transactions.
   • Reconcile again without using Reconciliation Discrepancies as a plug.

6. Lock down once fixed.

   • Set a closing date and password after you’ve restored a clean reconciliation sequence.
   • Document the last "trusted" reconciliation date in your workpapers.

Tools like CleanupOwl can run this kind of check across all bank and credit card accounts before you even quote the job, so you know which accounts have broken sequences, adjustments, or missing recent recs.

Turning reconciliation integrity into a firm standard

This shouldn’t be a one-off hero move; it should be a checkbox in your standard diagnostic.

• Add "Reconciliation integrity review" to your cleanup intake checklist.
• Standardize the reports: Reconciliation History screenshots, Reconciliation Discrepancies detail, and a short summary note per account.
• Use a simple status for each bank/credit card account:
  • Green – clean sequence, no discrepancies, current recs.
  • Yellow – minor issues or short gaps, documented.
  • Red – broken sequences, adjustments, or long gaps that require repair.

A diagnostic tool like CleanupOwl can hand you that per-account status automatically, with dates and amounts, so your team isn’t spending the first hour of every engagement just hunting for these patterns.

The patterns you’ll keep seeing in client files

Your reaction shouldn’t be the same in every case.

For small, old, isolated differences, you may decide to document them, confirm they’re outside your cleanup window, and move on. For recent or recurring issues—especially where reconciliations are missing for months—you treat it as a structural problem that needs real time in the scope.

Making this part of your cleanup playbook

Reconciliations aren’t just another task on the list; they’re the backbone of whether you can trust the file at all. An account that says "Reconciled" but has broken sequences or reconciliation adjustments is more dangerous than an account that’s openly unreconciled, because it gives everyone a false sense of security.

Give reconciliation integrity its own line item in your diagnostic checklist. Treat every bank and credit card account as either reliable or not, based on the history, the presence of adjustments, and whether recent activity is actually reconciled.

If you’re a business owner reading this, this is exactly the kind of question to ask your accountant: "Do you check whether my reconciliations are consistent and free of adjustments, or just whether QuickBooks says they’re done?" And if they’re using a diagnostic tool like CleanupOwl, they should be able to show you that assessment per account.

For firms, the goal is simple: no cleanup engagement starts without clarity on which cash and credit card balances you can trust, and what it will take to fix the ones you can’t.