Resource guide · QuickBooks cleanup
The complete QuickBooks cleanup guide.
A QuickBooks cleanup brings a messy or behind file back to a clean, reconciled, reportable state — rebuilding reconciliations, clearing Undeposited Funds, fixing Opening Balance Equity, removing duplicates, and correcting opening balances. This guide explains the signs your file needs one, how the process works step by step, what each tier costs, and when it’s a do-it-yourself job versus a ProAdvisor call. If you’re ready for the actual repair, see the QuickBooks cleanup service. Independent firm, not affiliated with Intuit Inc.
A QuickBooks cleanup is the structured work of bringing a messy or behind QuickBooks file back to a clean, reconciled, reportable state — rebuilding reconciliations against actual statements, clearing an Undeposited Funds backlog, zeroing out Opening Balance Equity, removing duplicate and miscategorized transactions, and correcting wrong opening balances. The most reliable sign a file needs one is reconciliations that no longer tie to the bank, with the difference growing month over month. Cleanup is priced by scope — from a focused single-issue fix to a multi-year rebuild — and runs $1,500–$15,000+ overall. This guide is the explainer; the cleanup service is where an independent Certified ProAdvisor does the work.
Reference maintained by the Certified QuickBooks ProAdvisor team at TechBrot Inc., an independent firm — not Intuit, and not Intuit’s official software support. Not affiliated with Intuit Inc.
QuickBooks cleanup, in five questions.
What is a QuickBooks cleanup?
A QuickBooks cleanup is the structured work of bringing a messy or behind QuickBooks file back to a clean, reconciled, reportable state — rebuilding reconciliations against actual statements, clearing an Undeposited Funds backlog, removing duplicate and miscategorized transactions, correcting wrong opening balances, and zeroing out the Opening Balance Equity account. The goal is a file you can trust for taxes, lending, and decisions.
How do I know my QuickBooks file needs a cleanup?
Common signs: reconciliations that no longer tie to the bank, a growing balance in Undeposited Funds, a nonzero Opening Balance Equity, duplicate transactions from broken bank feeds, expenses landing in the wrong categories, and opening balances that were entered incorrectly. If your reports don’t match reality or your accountant flagged the file, it likely needs cleanup.
How does a QuickBooks cleanup work?
It follows a sequence: a diagnostic of the file’s condition, then reconciliation rebuild period by period, Undeposited Funds resolution, duplicate and miscategorization fixes, opening-balance and Opening Balance Equity correction, and a final validation with a written summary of every fix. Reputable cleanups scope the work in writing before any changes are made.
How much does a QuickBooks cleanup cost?
Cleanup is priced by scope, not by hour, and overall ranges from $1,500 to $15,000+ depending on how far behind the file is. As a guide: a focused single-issue cleanup runs $1,200–$3,000, a standard multi-issue cleanup $3,000–$7,500, and a complex multi-year rebuild $7,500–$12,000+. A free file review and written scope come first.
Should I do a QuickBooks cleanup myself or hire a ProAdvisor?
A single small issue — a couple of months of categorization, a feed reconnect — is often DIY-able. But once reconciliations won’t tie, Undeposited Funds and Opening Balance Equity are out of control, or you’re multiple years behind, a Certified ProAdvisor is faster and safer — the wrong fix can compound the mess and put your tax filing at risk.
What a QuickBooks cleanup actually is.
A QuickBooks cleanup is the work of taking a file that has drifted — messy, behind, or never set up right — and bringing it back to a clean, reconciled, reportable state. In practice that means reconciling every account against the actual bank and credit-card statements, clearing out the Undeposited Funds backlog, zeroing the Opening Balance Equity account, finding and removing duplicate transactions, re-categorizing what landed in the wrong place, and correcting opening balances that were entered incorrectly. The end product is a file you can trust for taxes, lending, and decisions.
A cleanup is not the same as ongoing bookkeeping, and it’s not the same as our cleanup service — this page is the guide that explains the work; the service is where an independent Certified ProAdvisor performs it against a written scope. The reason a cleanup matters is that errors compound: an unreconciled month carries its difference into the next, a wrong opening balance taints every period built on top, and a broken feed quietly doubles transactions until the reports no longer reflect reality. The longer a file drifts, the more it costs to bring back.
Signs your QuickBooks file needs a cleanup.
Any one of these is worth a look; two or more together usually means a cleanup is overdue. The cleanup process below addresses them in roughly the same order.
Sign 01 · Reconciliations no longer tie to the bank
The most reliable tell. When the reconciled balance in QuickBooks stops matching the bank statement — and the difference grows month over month — the file has drifted. Each unreconciled period carries its error into the next, so the gap compounds until reports can no longer be trusted.
Sign 02 · Undeposited Funds keeps growing
Undeposited Funds is meant to be a temporary holding account between recording a payment and depositing it. When months or years of old balances sit there uncleared, payments were recorded but never matched to a real deposit — inflating income and signaling that the deposit workflow has broken down.
Sign 03 · Opening Balance Equity has a balance
Opening Balance Equity is a setup account that should net to zero once a file is properly configured. A lingering balance almost always means opening balances were entered without an offsetting entry, or an account was added mid-stream incorrectly. A nonzero balance here is a classic sign of an unfinished or rushed setup.
Sign 04 · Duplicate transactions from broken feeds
Bank feeds that disconnected and were re-linked — or transactions that were both imported and keyed by hand — leave duplicates scattered through the registers. Duplicates overstate expenses or income and quietly break every reconciliation downstream until they’re found and cleared.
Sign 05 · Transactions in the wrong categories
When transactions are miscategorized at scale — owner draws booked as expenses, transfers booked as income, personal spending mixed into the business — the profit-and-loss and balance sheet stop reflecting reality. Reports look plausible but lead to wrong decisions and a harder tax filing.
Sign 06 · Wrong opening balances
If the balances a file started with were entered incorrectly — or carried over wrong from a prior system or a prior accountant — every period built on top inherits the error. Wrong opening balances are why a file can reconcile each month and still be fundamentally off.
How a QuickBooks cleanup works, step by step.
Six stages, in order. A reputable cleanup diagnoses first and scopes the work in writing before changing anything — never forcing a balance to make a number look right.
Diagnose the file’s condition
Before changing anything, assess how far the file has drifted: which accounts reconcile, how large the Undeposited Funds and Opening Balance Equity balances are, how many periods are behind, and where the duplicates and miscategorizations cluster. This diagnostic is what sets the scope — and it’s why a free file review comes first.
Rebuild reconciliations, period by period
Work forward from the last point the file was known good, reconciling each month against the actual bank and credit-card statements. Investigate every difference rather than forcing a balance — forcing it just buries the error. This is the backbone of a cleanup and where most of the time goes.
Resolve Undeposited Funds
Match each open item in Undeposited Funds back to a real bank deposit, clearing what was genuinely deposited and documenting anything that can’t be traced. Done right, the account returns to zero or to a justified, explained balance — not a forced write-off.
Remove duplicates and fix miscategorizations
Identify duplicate transactions across feeds, manual entries, and connected apps, and remove them carefully so no real transaction is deleted. Then re-categorize what landed in the wrong account — correcting the chart of accounts where needed so the same mistakes don’t recur.
Correct opening balances and Opening Balance Equity
Fix the balances the file started with, then clear Opening Balance Equity to zero by re-posting setup entries to their correct accounts. This is what makes the foundation sound — without it, a file can reconcile month to month and still be wrong at the base.
Validate and document every fix
Run the corrected reports, confirm each reconciliation ties, and produce a written summary of what was wrong and what was changed, with before-and-after evidence. A clean file you can’t explain isn’t finished — the documentation is what makes it CPA-ready and audit-defensible.
When to do it yourself vs hire a ProAdvisor.
It’s a single, contained issue
One broken feed to reconnect, a couple of months of categorization to tidy, or a single account to reconcile is often a reasonable DIY job — provided the rest of the file is sound. If you can isolate the problem and the books otherwise tie, start there before paying for help.
Reconciliations won’t tie and the mess compounds
Once reconciliations stop balancing, Undeposited Funds and Opening Balance Equity are out of control, or duplicates are scattered across periods, a DIY fix often makes it worse — the wrong correction buries the real error deeper. This is the point where a Certified ProAdvisor is faster and safer.
You’re years behind or facing a deadline
Multiple years of catch-up, a file headed for a tax filing or a loan application, or a setup so off that opening balances are wrong — these carry real financial risk. A ProAdvisor scopes the work, fixes the foundation, and delivers a file your CPA and lender will accept.
Not sure how far behind your file really is?
A Certified ProAdvisor reviews the file free, then scopes the cleanup in writing — a focused fix is typically $1,200–$3,000, a standard cleanup $3,000–$7,500, and a complex rebuild $7,500–$12,000+ ($1,500–$15,000+ overall). Independent firm.
A Certified ProAdvisor scopes the cleanup and rebuilds the foundation.
The hard part of a cleanup isn’t entering transactions — it’s judgment: deciding which difference to investigate, which duplicate is real, where a wrong opening balance is poisoning every period, and how to clear Undeposited Funds and Opening Balance Equity without burying the error. A Certified QuickBooks ProAdvisor with active Online and Desktop certifications does that against a written scope, fixes the foundation rather than the symptom, and validates each reconciliation before closing. Independent firm — not Intuit, and not Intuit’s software support; an Intuit account, login, or billing matter stays with Intuit.
Free
file review first — we diagnose before we scope
$1,500–$15,000+
cleanup by scope across the three tiers, fixed-fee
Independent
Certified ProAdvisor firm — not Intuit, not Intuit’s software support
What people ask about QuickBooks cleanups.
Is this Intuit’s official QuickBooks support?
What is a QuickBooks cleanup, exactly?
How do I know if my QuickBooks file needs a cleanup?
What is Opening Balance Equity and why does it matter?
Why does Undeposited Funds keep growing?
How long does a QuickBooks cleanup take?
How much does a QuickBooks cleanup cost?
Should I clean up QuickBooks myself or hire a ProAdvisor?
What’s the difference between this guide and your cleanup service?
Think your file needs a cleanup?
Find out exactly what’s wrong before you spend a dollar.
If the signs in this guide describe your file — reconciliations that won’t tie, an Undeposited Funds backlog, a nonzero Opening Balance Equity, or duplicates from broken feeds — start with a free file review. From there a cleanup is scoped in writing: a focused fix is typically $1,200–$3,000, a standard multi-issue cleanup $3,000–$7,500, and a complex multi-year rebuild $7,500–$12,000+ — $1,500–$15,000+ overall depending on how far behind. Independent ProAdvisor firm, written scope before any work begins.