Old uncleared items in QBO bank recs: how pros handle them

When the bank is “reconciled” but the numbers still feel wrong

You open a new QuickBooks Online file, pull up the checking register, and see it: a long trail of uncleared checks and card charges from months ago. The client proudly tells you, "But my bank is reconciled every month." Technically true. Economically? Not so much.

This is one of the most common cleanup landmines in QBO: old uncleared items sitting in reconciled bank and credit card accounts. The reconciliation report shows everything tied out to the statement, but the register is full of stale checks, duplicate charges, and phantom payments that never hit the bank.

Left alone, these items quietly distort cash and card balances, confuse owners, and make your cleanup scope harder to explain and price. Handled well, they become a quick win: you tighten the balance sheet, improve trust in the numbers, and show the client you’re catching things their last bookkeeper never did.

Where this problem hides inside QuickBooks Online

You’ll see this most clearly when you compare the reconciliation history to the account register or a Transaction Detail by Account report.

Take a checking account reconciled through 06/30/2024. In the register, you spot five checks dated between 01/10/2024 and 02/05/2024, all still marked as uncleared, totaling $3,000. The June statement is clean, but those checks are 140–170 days old relative to the latest rec date. That’s not “timing”; that’s a problem.

In another account, you might see an uncleared check dated 03/01/2024 for $500, and a cleared check dated 03/02/2024 for $500 to the same vendor. Same amount, same payee, one cleared, one not. That uncleared one is very likely a duplicate entry.

The basic pattern:

• Bank or credit card account shows as reconciled through a recent date.
• Register still has uncleared transactions dated on or before that reconciliation end date.
• Some of those uncleared items are older than a reasonable age threshold (often 60+ days).
• The count and/or total dollar amount is big enough that you can’t just shrug.

Key red flags to look for:

• Uncleared checks older than 60–90 days relative to the latest reconciliation date.
• Uncleared credit card charges or payments from prior statement cycles.
• Old uncleared items that match cleared transactions by amount, date window, and payee.
• A reconciled account where the register balance is far off from the actual bank balance once you mentally strip out the stale items.
• Clients who say vendors are complaining they never got paid, but QBO shows checks long ago “written.”

What happens if you just live with it

Old uncleared items are one of those things everyone thinks they’ll circle back to later. Then year-end comes, tax returns get filed, and those ghosts are still in the system.

The damage inside your numbers

From a pure accounting standpoint, stale uncleared items do a few nasty things:

• Overstate or understate cash and card balances. A pile of old uncleared checks makes cash look lower than it really is; duplicate card charges make liabilities look higher.
• Distort working capital and liquidity metrics. Owners think they’re tight on cash when they’re not, or vice versa.
• Create fake vendor and customer stories. A vendor “paid” in QBO but never actually cashed a check, or a refund that never hit the card.
• Pollute trend analysis. When you finally void or delete these items, they often hit the current period, making this month’s P&L or balance sheet look odd unless you handle them carefully.

If you’re doing advisory or controller-level work, this undermines the very KPIs and dashboards you’re trying to build. You can’t talk cash runway with a straight face if the cash account is off by several thousand dollars of stale checks.

The damage in client conversations

There’s also a relationship cost.

When an owner realizes that “reconciled” didn’t mean what they thought, they start questioning everything:

• "If the bank rec was wrong, what else is wrong?"
• "Why didn’t my last accountant catch this?"
• "Are my tax returns based on bad numbers?"

If you don’t address old uncleared items early, you may end up explaining later why you missed them on your initial review. That’s not a fun conversation.

On the flip side, when you proactively surface, quantify, and explain these items, you show that your firm has a real diagnostic process—not just a checklist that says "bank recs done."

A practical way to clean up old uncleared items

The good news: this is very fixable if you approach it systematically instead of one transaction at a time.

Here’s a straightforward workflow you can standardize across cleanups:

1. Identify in-scope accounts. From the Chart of Accounts, pull all Bank and Credit Card accounts. For each, confirm there’s at least one completed reconciliation. Skip accounts that have never been reconciled; that’s a different project.
2. Anchor to the latest reconciliation end date. For each reconciled account, note the most recent reconciliation end date from the reconciliation history or Bank Reconciliation report. That’s your reference point.
3. Pull uncleared items as of that date. Use the register or a Transaction Detail by Account report, filter to that account, Cleared = Uncleared, and date on or before the latest reconciliation end date.
4. Apply an age threshold. Decide what counts as “old” for this engagement—often 60 days (roughly 1–2 statement cycles) is a good starting point. Anything older than that relative to the latest rec date goes on your stale list.
5. Assess materiality by count and amount. Tally how many old uncleared items you have and their total dollar impact. A single $15 stale check may not be worth a deep dive; ten items totaling $3,000 definitely is.
6. Check for duplicates. For larger or suspicious items, scan for a matching cleared transaction in the same account: same amount, similar date (±3 days), and ideally same payee. If you find a match, you likely have a duplicate entry that can be reversed.
7. Decide the accounting treatment. For each old item or group:
   • Void and reissue if the check truly went stale but the obligation still exists.
   • Void to a prior period adjustment account if it was never cashed and the liability is gone.
   • Delete or reverse if it’s clearly a duplicate of a cleared transaction.
   • Leave it alone (with documentation) if it’s legitimately outstanding and the client confirms it.
8. Document decisions. Note what you did, why, and as of what date. This matters for future reconciliations, year-end tie-outs, and when another team member picks up the file.

Baking this into your firm’s standard review

The firms that stay sane on cleanups don’t rediscover this problem every time—they turn it into a standing diagnostic.

You can build a simple step into your onboarding review: for every reconciled bank and card account, run an “old uncleared items” check with a consistent age threshold and materiality filter. Tools like CleanupOwl can run this check automatically and hand you the list it used to take 30–60 minutes to assemble by hand.

From there, your team just has to make decisions, not hunt for transactions.

Once you’ve standardized the logic—age, count, and dollar thresholds—you can train staff to follow the same pattern every time. Senior reviewers then just spot-check the decisions and ensure any prior-year impacts are handled appropriately.

If you prefer to front-load diagnostics, you can have a pre-cleanup scan (manually or via a diagnostic tool like CleanupOwl) that flags all accounts with significant old uncleared items before you finalize scope and timeline.

The patterns you’ll keep seeing in client files

Here’s how this tends to show up across different clients and situations:

Your response shouldn’t be the same in every case. When the items are recent, few, and small, you mostly need to confirm they’re real and move on. When they’re older, numerous, or add up to a meaningful dollar amount, you treat them as a dedicated mini-project inside the cleanup.

Making this part of your cleanup playbook

Old uncleared items are too common—and too impactful—to leave to chance. They deserve their own line on your cleanup checklist, right alongside undeposited funds and negative A/R.

When your team knows exactly how to spot, triage, and resolve these items, you get cleaner cash balances, smoother reconciliations, and fewer "why is my bank balance different from QuickBooks?" emails. You also differentiate your firm: you’re not just ticking the "reconciled" box; you’re validating that reconciled actually means something.

If you’re a business owner reading this, this is the kind of question you can ask your accountant: "Are you checking for old uncleared checks and card charges that might be distorting my cash?" Whether they do it manually or with a diagnostic tool like CleanupOwl, you want to know someone is looking.

For firms, building this into your standard diagnostic—ideally with an automated scan from CleanupOwl before you quote or start work—turns a messy, error-prone area into a repeatable, documented process.