Answers

QuickBooks cleanup and diagnostic file reviews

QuickBooks and QuickBooks Online are widely used small-business accounting systems. A cleanup engagement repairs a company file that has drifted from reality; a diagnostic review measures the drift before anyone quotes the repair. These answers cover what each involves and how to tell when a file needs one.

Reviewed September 10, 2026 by Timothy A. Wijtenburg, CPA · Florida license #AC49291

What is a QuickBooks cleanup service?

A QuickBooks cleanup is the repair of an existing company file so that its balances match reality and its reports can be relied on. The typical work list: reconciling every bank, credit-card, and loan account to its statements; clearing transactions parked in uncategorized or suspense accounts; removing duplicates, commonly created when bank-feed transactions were added on top of manually entered ones; resolving undeposited-funds buildup where customer payments were never matched to their deposits; correcting accounts-receivable and accounts-payable aging that still shows invoices and bills settled long ago; and tying the resulting balance sheet to external reality (bank statements and loan balances) and, where the last filed return includes a balance sheet, checking that the books agree with it, since a return's balance sheet is prepared per books. The finished state is measurable rather than aesthetic: accounts reconciled, no material balances sitting in holding accounts, and reports that agree with the documents behind them.

What is a QuickBooks diagnostic or file review?

A bounded examination of a company file that answers two questions before anyone commits to a repair: what is wrong, and how much work will it take to fix. A thorough diagnostic checks each account's reconciliation status and last-reconciled date; the size of uncategorized, suspense, and miscellaneous balances; the undeposited-funds balance; negative balances that signal sign errors; receivable and payable aging for stale items; opening-balance equity, which should not be carrying a balance in a settled file; and whether the balance sheet reconciles to bank statements and, where the last filed return includes a balance sheet, agrees with the one filed. The output is a findings list with a scope (which months and which accounts need repair) rather than a lump-sum guess. The diagnostic-first sequence exists because a cleanup priced before the file is opened has to cover the range of possible conditions; a file review replaces that range with a work list.

How do you know if your QuickBooks books are wrong?

The signals are visible to an owner without accounting training. Bank and credit-card accounts that have never been reconciled, or were last reconciled many months ago. A cash balance in QuickBooks that does not match the bank's own number. Large balances in accounts named uncategorized expense, uncategorized income, suspense, or ask my accountant. An undeposited-funds balance that grows and never clears. Negative balances where none make sense: a negative credit-card liability, negative payroll liabilities. Accounts receivable showing customers who paid long ago, or accounts payable showing bills already settled. Profit that swings sharply month to month without a business reason, often from duplicated or misdated transactions. And one worth checking with a preparer: where the last filed return includes a balance sheet, books that disagree with it. A return's balance sheet is prepared per books, so the two should agree. Any one of these is worth investigating; several together mean the reports should not be used for decisions until the file is repaired.

How much does a QuickBooks cleanup cost?

Cleanup cost tracks the depth of the repair more than the size of the business. The drivers: how many accounts are unreconciled and for how many months; the volume of transactions sitting in holding accounts; the extent of duplication between bank feeds and manual entries; whether payroll, sales tax, or inventory are involved, each of which adds a layer of complexity; and whether the repaired books must also be tied back to previously filed tax returns. The number a provider can put a scope behind before opening the file is a diagnostic fee; the cleanup quote follows the findings. Cleanup and catch-up bookkeeping are often bought together when some months are missing entirely and others were entered badly; a diagnostic scopes both at once. Against the fee sits what unrepaired books cost: decisions made on wrong numbers, and tax returns prepared from reports that cannot be substantiated.

Is it better to clean up QuickBooks or start a new file?

Repair the existing file when its history matters and the damage is bounded (reconciliations behind, holding accounts bloated, duplicates) because history is what makes year-over-year reports and lender requests answerable. Start a new file when the existing one is structurally unusable: years of commingled entities, a chart of accounts rebuilt repeatedly, balances no one can explain, or a file so large or corrupted it cannot be worked on. A restart does not erase obligations. The old file still contains the records behind previously filed returns, and federal law generally requires keeping the records that support a return for as long as the period of limitations for that return remains open; the old file or its reports must be retained for that period, not deleted. And a new file's opening balances have to come from somewhere defensible (normally the last filed tax return, where it includes a balance sheet, plus reconciled statements), or the new file inherits the old file's uncertainty on day one.

What does a QuickBooks cleanup have to do with taxes?

The tax return is prepared from the books, so the file's reliability sets the return's reliability. IRS recordkeeping guidance places the responsibility to substantiate entries, deductions, and statements made on a return (the burden of proof) on the taxpayer, and a company file whose accounts reconcile to statements is where that substantiation is organized; the supporting documents behind the entries are what actually proves them. A cleanup that ends with the books agreeing with the last filed return (where that return includes a balance sheet) gives the next return a defensible starting point, and it surfaces the items that commonly turn up: revenue sitting unrecorded in merchant-deposit mismatches, expenses paid personally and never captured, and loan payments booked entirely to expense with the principal never reducing the liability. Most of that is arithmetic the return inherits, in whichever direction it runs; how expenses an owner paid personally get picked up is a treatment question for the preparer rather than a correction.

General educational information about United States federal tax rules, current as of the review date above. Tax law changes and every situation turns on its own facts. This is not tax, legal, or financial advice and does not create a client relationship. Inflation-adjusted figures should be confirmed for the year in question before relying on them.

Related

Other answer topics

Have a version of this question about your own practice?

General rules only go so far. Bring the specifics and get an answer that accounts for them.

Get a Free Strategy Call