8 Signs a Client's QuickBooks Needs a Cleanup

Most messy files give themselves away in the first ten minutes if you know where to look. The signs below are diagnosable from a few reports and balances, not vague gut feel. Each one tells you something specific about what went wrong and how much work it implies. Run through them in order and you'll have a defensible read on the file before you ever quote a price.

1. Opening Balance Equity isn't zero

What to look for: Open the Balance Sheet and find Opening Balance Equity (OBE). It should be zero.

Why it matters: OBE is a temporary account QuickBooks uses during setup. Once setup is done, it should hold nothing. A non-zero balance means an opening balance was entered wrong, an account was created with a bad starting balance, or a journal entry posted to the wrong equity account. It does not self-correct, and it distorts true owner equity and retained earnings. This is one of the single most reliable signals that a file was set up sloppily. We go deeper on this in how to read and fix Opening Balance Equity.

2. A large uncategorized or Ask My Accountant balance

What to look for: Check the Uncategorized accounts (Uncategorized Income, Uncategorized Expense) and the older Ask My Accountant account. Material balances here are a red flag.

Why it matters: These are holding buckets for transactions nobody assigned to a real account. A big balance means the P&L is wrong: income and expenses are landing in placeholder accounts instead of where they belong. The size of these balances is a rough proxy for how many transactions need to be reviewed and recoded.

3. Bank and credit card accounts aren't reconciled

What to look for: Open the reconciliation history for each bank and card account. Look for gaps, accounts that have never been reconciled, or a reconciliation discrepancy.

Why it matters: If accounts aren't reconciled to statements, you have no proof the books match reality. Unreconciled accounts hide duplicates, missing transactions, and bad balances. Until the bank and card accounts tie to statements, every report sitting on top of them is suspect.

4. Duplicate transactions

What to look for: Same amount, same date, same payee appearing twice. The classic cause is a transaction entered manually and then accepted again from the bank feed.

Why it matters: Duplicates overstate income or expenses and quietly break reconciliation. They're common when someone posts a payment and also accepts the bank-feed version of the same deposit. A few duplicates are an easy fix; a pattern of them points to a workflow problem the client will keep repeating.

5. Missing payees

What to look for: Transactions with no name in the Payee field across the expense and check registers.

Why it matters: Missing payees make spend impossible to audit and break vendor reporting. At year end they also create real friction for 1099s, because you can't tally what you paid a vendor you never named. It's usually a symptom of bank-feed transactions accepted without review.

6. Stuck Undeposited Funds

What to look for: Open the Undeposited Funds account and look for old payments sitting there that never got grouped into a deposit.

Why it matters: Undeposited Funds is meant to hold payments briefly until you record the deposit that hits the bank. When payments get stranded there, it usually means deposits were posted straight to the bank from the feed while the matching received payment never cleared, which overstates income and leaves the account impossible to reconcile. A growing Undeposited Funds balance is one of the most common findings in real cleanup work. Here's how to clear old Undeposited Funds.

7. Negative asset balances or a weird Balance Sheet

What to look for: A negative bank balance that shouldn't be negative, negative inventory or fixed assets, or accounts that simply don't make sense on the Balance Sheet.

Why it matters: Assets generally shouldn't carry negative balances. When they do, it points to miscategorized transactions, transfers booked as income or expense, or payments recorded against the wrong account. A Balance Sheet that doesn't read cleanly is a fast tell that the underlying coding is off.

8. Negative liabilities and other coding tells

What to look for: Negative credit card or loan balances, sales tax payable that looks wrong, or a chart of accounts cluttered with near-duplicate accounts ("Office Supplies" and "Office Supply" and "Supplies").

Why it matters: These point to transfers and payments coded to the wrong place and to a chart of accounts that nobody maintains. A bloated, redundant chart of accounts makes every future categorization decision harder and is a strong sign the file needs structural cleanup, not just transaction fixes.

Cleanup vs. catch-up: which problem do you actually have?

These two terms get used interchangeably, but they describe different jobs, and you should quote them differently.

• Cleanup fixes what's wrong inside an existing file: miscategorized transactions, duplicates, a messy chart of accounts, unreconciled accounts, a non-zero OBE. The data is there, it's just incorrect. Cleanup makes the reports accurate.
• Catch-up fills in what's missing: months or years where transactions were never entered. The job is completeness, not correction. Catch-up makes the records complete.

Many files need both, and when they do, cleanup usually comes first, because you can't complete missing months correctly on top of records that are already wrong. The eight signs above mostly point to cleanup. If you instead find long stretches with no transactions at all, that's a catch-up. Knowing which one you're looking at keeps your scope and your quote honest.

How to self-assess fast

You don't need to read every transaction to make the call. Pull the Balance Sheet and P&L, scan OBE, the uncategorized and Ask My Accountant balances, reconciliation status, and Undeposited Funds, and look for anything negative that shouldn't be. That's a ten-minute read that tells you whether the file is solid or needs work. For a structured pass, follow our QuickBooks diagnostic review, work through the QuickBooks Online cleanup checklist, and learn what a books-health check covers so you know exactly what you're confirming.

Want to confirm the read in under a minute instead of clicking through reports by hand? Export the QuickBooks Online file and run a free books-health check on CleanupLedger. It flags the exact signals above, non-zero Opening Balance Equity, uncategorized balances, duplicates, missing payees, and unreconciled accounts, so you can scope the work with evidence in hand. (CleanupLedger is not affiliated with Intuit.)