When journal entries quietly clear old uncleared bank items
The journal entry that makes the bank rec "work"
You open a new QuickBooks Online file and head straight to the credit card register. The balance looks fine, the reconciliation screen says everything is current, and the client proudly tells you, "But my bank is reconciled every month."
Then you scroll back a year or two and see it: a big, tidy journal entry to the credit card account. Same reconciliation as a cluster of old uncleared charges from the prior year. The JE amount just happens to equal the pile of stale transactions that had been hanging around.
On the surface, the reconciliation is clean. Underneath, someone used a journal entry as a broom to sweep old uncleared items under the rug.
This is one of those patterns that doesn’t scream "error" but absolutely deserves your attention. Sometimes it’s a legitimate write‑off or a deliberate cleanup. Other times it’s a prior bookkeeper forcing a reconciliation to match the statement without actually understanding what went wrong.
Your job in a cleanup isn’t just to make the bank rec window say "Reconciled". It’s to understand how it got there.
Where this pattern hides inside QuickBooks Online
The telltale sign is a journal entry hitting a bank or credit card account that gets cleared in the same reconciliation as one or more older transactions that had been sitting uncleared.
In practice, you’ll usually spot it by:
- Running a Transaction Detail by Account (or GL) report for each Bank and Credit Card account.
- Filtering for Type = Journal Entry.
- Looking at which JEs are marked cleared and when.
- Comparing those JEs to older uncleared items that suddenly get cleared in the same reconciliation.
A classic example:
- Credit card account has two uncleared expenses from 2020: $100.00 and $53.54.
- On 01/01/2021, someone books a JE: debit the original expense accounts, credit the credit card account for $153.54.
- On the 01/26/2021 reconciliation, both 2020 expenses and the 01/01/2021 JE are marked cleared together.
Nothing in QBO screams "this JE was used to clear old stuff". You have to look at dates, cleared status, and amounts side by side.
Typical red flags:
- Journal entries posted directly to Bank or Credit Card accounts.
- JE date is much later than the original transactions it seems to offset.
- The JE amount (or net impact on that account) closely matches one or more older transactions.
- The JE and those older items all become cleared in the same reconciliation.
- The older items were sitting uncleared for 30, 60, 90+ days before that reconciliation.
If you’re short on time, sort the bank or credit card register by Cleared status, then by Date. Look for reconciliations where a JE and several older items all flip to cleared together.
What happens if you just live with it
If you assume every JE like this is fine because "the account reconciles", you’re taking on risk you can’t see on the face of the statements.
The damage inside your numbers
When a journal entry is used to clear old uncleared items, one of a few things is happening:
- A real transaction never got recorded, and the JE is forcing the balance to match the bank.
- A duplicate or erroneous transaction was never properly voided/removed, and the JE is offsetting it.
- A legitimate expense or payment from a prior period is being reversed or reclassified without clear documentation.
The impact can include:
- Misstated operating expenses (e.g., prior‑year charges reversed into the current year).
- Distorted period‑to‑period comparisons because old activity is effectively "moved" into a later period.
- Tax reporting that doesn’t line up with what actually cleared the bank or card.
- Confusion when auditors or future accountants try to trace what happened.
Even if the net cash balance is right, the path you took to get there matters. A forced JE can hide:
- Unmatched deposits or payments.
- Duplicate entries.
- Misapplied vendor payments or card charges.
The damage in client conversations
From the client’s perspective, the account reconciles and the statements look fine. If you later discover that prior reconciliations were "forced" with JEs, you’re the one explaining:
- Why prior‑year numbers might need adjustment.
- Why their tax preparer saw one thing and you’re now showing another.
- Why their internal reports never quite matched the bank the way they thought.
If you don’t surface these JEs early in your diagnostic, you risk:
- Under‑scoping the cleanup (you thought it was a simple rec; it’s not).
- Having to walk back earlier assurances about file quality.
- Burning time reverse‑engineering someone else’s undocumented fixes mid‑engagement.
How to review these journal entries without losing a day
You don’t need to interrogate every JE that hits cash. You do want a systematic way to find the ones that look like they were used to clear old uncleared items.
Here’s a practical workflow:
-
Identify the target accounts.
- From the Chart of Accounts, focus on all Bank and Credit Card accounts you care about for the cleanup scope.
-
Pull the JE activity.
- For each account, run a Transaction Detail by Account report for your analysis window (e.g., from file start or a reasonable lookback through today).
- Filter to Type = Journal Entry.
- Add columns for Cleared status and, if available, Reconciliation status/date.
-
Filter to cleared JEs.
- Start with JEs that are marked cleared in that bank/credit card account.
- Note the reconciliation date or period where they were cleared.
-
Look back for older uncleared items.
- For each JE, look at transactions in that same account dated before the JE date that were uncleared for a long time (e.g., 60–90+ days).
- Check whether those older items and the JE all became cleared in the same reconciliation.
-
Compare amounts.
- Compare the JE’s net impact on the bank/credit card account to:
- Single older uncleared transactions, and
- Combinations of multiple older items.
- If the JE amount closely matches (within a small dollar or percentage tolerance), you likely have a "cleanup" JE.
- Compare the JE’s net impact on the bank/credit card account to:
-
Decide and document.
- For each suspect JE, decide: intentional write‑off/reclass, or masking a deeper problem?
- Add a short workpaper note: what it offset, why it was done, and whether you’re keeping it, reversing it, or replacing it with a cleaner fix.
Tools like CleanupOwl can run this kind of check automatically and hand you a list of JEs that look like they were used to clear older uncleared items, along with the specific transactions they appear to offset. That turns an hour of detective work into a focused review list.
Set your own thresholds. Many firms only care about older items (e.g., 60–90+ days before the JE date) and use a tight matching tolerance (like $1 or 1%) so they’re only reviewing clear patterns, not every minor mismatch.
Building this into your standard cleanup checklist
This shouldn’t be a one‑time "interesting" analysis; it should be a standard line item in your diagnostic.
A simple way to operationalize it:
- Add a checklist step under Bank/Credit Card: "Review JEs used to clear old uncleared items".
- Define your firm standard: what age counts as "old", what dollar level is worth investigating, and how far back you’ll look in closed years.
- Have staff flag any JE where:
- The JE hits a bank/credit card account,
- It clears with older items in the same reconciliation, and
- The amounts line up within your tolerance.
- Require a short note on each: intentional adjustment vs. potential error.
A diagnostic tool like CleanupOwl can run this check before you even quote the job, so you know whether you’re walking into a simple rec or a file where prior reconciliations were patched with JEs.
The patterns you’ll keep seeing in client files
You’ll see the same few scenarios over and over:
| Situation | What you see in QBO | Risk if you shrug it off |
|---|---|---|
| Old credit card charges reversed with a JE | Several 2020 charges sit uncleared; a 01/01/2021 JE to the card equals their total; all clear together in Jan 2021 rec | Prior‑year expenses quietly reversed or moved; tax and comparability issues |
| Bank deposit timing error "fixed" by JE | A missing/duplicate deposit from months ago; JE to the bank account equals the old item; both clear in same rec | Cash receipts don’t tie to customer activity; A/R and revenue may be wrong |
| Vendor payment mis‑posting offset by JE | Old check or bill payment never matched; JE to bank equals the old payment; both clear together | Vendor balances and expense timing off; potential duplicate or missing payment |
| Legitimate write‑off of immaterial stale items | Small, very old items cleared with a single JE and documented memo | Usually acceptable, but needs clear documentation and consistency |
| Current‑period reclass JE only | JE hits bank/credit card but matches a current‑period item and doesn’t clear with older transactions | Low risk; likely a simple reclass, not a forced reconciliation |
Your reaction doesn’t have to be the same in every case. For small, very old items with clear memos, you may accept the JE as a practical write‑off and just document it. For larger or more recent items, or when the pattern is repeated, you may decide to:
- Rebuild the reconciliation properly.
- Reverse the JE and fix the underlying transactions.
- Adjust prior‑year balances and coordinate with the tax preparer.
Be careful in closed tax years. Before undoing or reworking JEs that cleared old items, check what was filed, whether the prior accountant documented a position, and get explicit client approval for any changes that affect prior‑year numbers.
Making this part of your cleanup playbook
Journal entries used to clear old uncleared bank and credit card items are one of those subtle patterns that separate a surface‑level reconciliation from a real diagnostic review. If you don’t look for them, you’ll miss how prior reconciliations were actually achieved.
This deserves its own line on your cleanup checklist because it:
- Reveals whether prior bookkeepers were forcing reconciliations.
- Highlights potential misstatements in expenses and cash.
- Helps you scope the true complexity of the cleanup before you commit.
You can do this manually with reports and filters, or you can let a diagnostic tool like CleanupOwl scan the file and hand you the list of suspect JEs and their matched transactions. Either way, the key is to review, decide, and document—not to blindly trust that "reconciled" means "correct".
If you’re a business owner, this is the kind of question you can ask your accountant: "Do you check for journal entries that were used to clear old bank or card items, or do you just rely on the reconciliation status?" The answer will tell you a lot about how deep their review really goes.
Ready to run deeper QuickBooks diagnostics?
Use CleanupOwl to automatically flag issues like this before you quote or start your next cleanup project.
Start Free Trial