Guide · the full method

How to clean up QuickBooks, step by step

Cleaning up QuickBooks means backing up, reconciling every account to its statement oldest month first, correcting categorization, clearing the opening-balance and undeposited-funds issues that distort reports, and locking the finished periods with a closing date. This guide walks the whole method, with QuickBooks' own menu paths — do it yourself, or hand the file to us.

Call (850) 842-6767

Last reviewed October 2026 by a Certified QuickBooks ProAdvisor

What this page is based on: our own reconciliation-first cleanup methodology and Intuit’s own published bookkeeping cleanup steps. Where the two differ, the difference is stated rather than smoothed over.

First: is this actually a cleanup?

A cleanup is not one task — it's a sequence. Work it in order and the books come back into agreement with the real world one account at a time.

Three different problems get called "cleanup", and they need different work in a different order. Sorting yours first saves the most time of anything in this guide.

The books exist but are wrong — accounts that won't reconcile, miscategorized history, balances nobody can explain. That is a cleanup, and this guide is the method.
Whole months were never entered. That is catch-up bookkeeping — there is nothing to correct yet, because nothing was recorded. Catch up first, then clean up what the catching-up exposes.
The file itself is broken — it won't open, won't balance, or is corrupt. That is a rescue, and no amount of bookkeeping helps until the file is sound.

Many files need two of the three, in that order. If you are not sure which you have, the finish test at the end of this guide is the same test we use, and it works whoever runs it.

Starting over is the other option people reach for, and Intuit keeps it narrow. Its purge, which deletes all company data, works only on QuickBooks Online Essentials, Plus and Advanced, and only for a company less than 60 days old; an older company, or one on Simple Start, has to be canceled and replaced with a new one, with read-only access to the old data for a year (Intuit, checked October 2026). Either way the history goes, and Intuit warns that bank and app connections can break — which is why fixing the file in place is usually the better route (can QuickBooks be fixed without starting over?).

1 · Establish the cleanup starting point

Before touching a single transaction, back up the company file and confirm the cleanup start date with whoever owns the books. In QuickBooks Desktop that is File → Back Up Company → Create Local Backup, followed by File → Utilities → Verify Data: if Verify reports damage, run Rebuild Data (it makes its own backup first) or stop and get file repair before any bookkeeping, because corrections made inside a damaged file can vanish. QuickBooks Online keeps no restorable copy you can roll back to, so save the profit and loss, balance sheet and each account's last reconciliation report as PDFs before you start. Everything before that date is history you reconcile; everything after is what you'll keep current.

Skipping this step is how cleanups turn into do-overs. Establishing that point means three concrete checks. First, find the last month every account reconciled with a zero difference — that is your true starting line, whatever the calendar says. Second, gather the bank and credit-card statements for every account from that month forward, in one place, before you open a single register; reconciliation stalls the moment a statement is missing, so collect them all now. Third, note the last tax year that was filed. Periods already reported to the IRS shouldn't be silently rewritten — corrections that touch a filed year belong in entries your CPA can see and explain, so flag them as you go rather than changing history without a trail.

2 · Reconcile every account

Read this as text

A bar chart of a typical cleanup by phase: reconciliation is the largest share of the work, then recategorization, then opening balances, then review. Illustrative, not a measured statistic.

Where cleanup time tends to go, by phase — reconciliation is the bulk of it. Illustrative, not a measured statistic.

Reconciliation is the spine of the cleanup. For each bank and credit-card account, tie the QuickBooks balance to the statement, month by month, until the difference is zero.

Unreconciled accounts are one of the first things to check when a small-business file can't be trusted. This phase is also what sets the schedule — how fast a cleanup can realistically finish depends mostly on how many accounts and months it covers.

In QuickBooks Online the mechanics are the same every month. Open the reconcile screen — Intuit's current path is All apps → Accounting → Reconcile (older menus show it under Settings → Reconcile) — with the statement in front of you, and check the beginning balance first: it must equal the prior month's ending balance. If it doesn't, QuickBooks shows an alert that the beginning balance is off; its link opens the Reconcile Discrepancy Report, which, in Intuit's words, "lists what changed, how it affected your balance, and what you can do to fix each item" (Intuit, updated September 2026, checked October 2026). Fix each item before matching anything, or the error rolls forward into every month that follows — and heed Intuit's caution to fix only changes made in error, checking with your accountant before touching a reconciled period or an opening balance. Then work the statement line by line, ticking each transaction until the difference reads exactly zero. Never force a stubborn month closed with an adjusting entry; a plug doesn't fix the problem, it hides it where the next person has to dig it out.

Pay attention to what's left over. A check or deposit that has sat uncleared for months needs investigation; it may be a legitimate outstanding item, a duplicate, or an entry that never cleared at the bank — either way it needs a decision, not another month of being ignored. Trace it, and either void it or find out why the bank never saw it. The bank reconciliation reference covers the underlying logic if any of this is new.

3 · Correct categorization

With balances tied out, fix how transactions are classified: miscategorized expenses, personal charges booked to the business, duplicates, and the undeposited-funds account that silently inflates income. Consistent categorization is what makes the P&L mean something.

Work this in review passes rather than one transaction at a time. First, run the profit and loss by month and scan for anything that jumps out — a category that doubles for a single month, income in a period with no sales, an expense account you don't recognize. Each anomaly is a thread to pull. Second, open the accounts where problems collect — Uncategorized Expense, Uncategorized Income, Ask My Accountant, and whatever miscellaneous catch-all the file has grown — and empty each one into the account where the transaction actually belongs. Third, review vendor by vendor: the same vendor should land in the same category all year, and where it doesn't you've found either a miscoding to fix or a bank rule that's been filing things wrong on autopilot.

A note on undeposited funds

The undeposited-funds account is where deposits go to be grouped before they hit the bank. Left unmanaged, it accumulates phantom balances that overstate revenue. Clearing it is tedious and worth every minute.

To clear it, open the account's register and match each payment sitting there to a real deposit on the bank statement. Payments that correspond to a deposit already recorded another way are the classic case — the money was usually entered straight into the bank account as a second deposit, so the same income now exists twice. Group the legitimate payments into bank deposits that match the statement to the penny, and remove the duplicates so revenue is counted once. When the account holds nothing but deposits genuinely in transit, it's done.

A stale undeposited-funds balance is one of the most common things we find in reviewed files — if yours carries one, clearing it belongs on the cleanup list, not the someday list.

4 · Clear the balance-sheet accounts where problems hide

Once cash is proven and categorization is consistent, the remaining errors are almost always sitting in a handful of balance-sheet accounts. Each has a specific QuickBooks mechanic that proves it right, and each is worth checking explicitly rather than assuming.

Opening Balance Equity should be zero. Anything left in it is an opening balance that was entered without a real counterpart. Errors — a doubled or wrong opening balance — are fixed by correcting the opening entry itself; what remains that is genuinely the owner's money or earlier profit moves to its real equity account with a documented journal entry, never one blind entry that zeroes the lot. The Opening Balance Equity reference explains the account and the OBE fix walks the trace.
Undeposited Funds should hold only deposits genuinely in transit (step 3 above). A stale balance there is the most common cause of overstated income — see the undeposited funds fix.
Accounts receivable should age to real invoices. Run the A/R aging: anything years old is either uncollectable or already paid and never applied. A/R cleanup covers the decision.
Accounts payable should age to bills you still owe. Bills paid outside QuickBooks and never closed sit here forever — A/P cleanup.
Loan balances should match the lender's statement, with interest split out rather than buried in principal.
Payroll liabilities should agree with the returns you filed. If they don't, that is payroll cleanup, and it is its own engagement.
Sales-tax payable should agree with the returns you filed and paid. If it keeps climbing after you pay, remittances were likely recorded as ordinary checks — sales-tax cleanup.
The chart of accounts should be readable by someone who doesn't work there. If it isn't, chart of accounts cleanup is the structural fix, and it is safer after reconciliation than before.

Duplicates deserve their own pass: duplicate transactions are among the most common things a bank feed introduces, and they distort both the P&L and the reconciliation you just finished.

5 · Review and hand back

Finish with a pass over the financial statements — does the balance sheet balance, does the P&L read the way the business actually ran? Document every material change so the owner (or their CPA) can follow what happened and why.

A cleanup nobody can audit isn't finished. The final pass is a short list, checked in order: every bank and card account reconciles with a zero difference through the end date; every balance-sheet balance agrees with a real document — bank and card statements, loan statements for loan balances; Opening Balance Equity sits at zero; undeposited funds holds nothing but deposits genuinely in transit; and the P&L by month shows no spikes you can't explain in one sentence. Then write the change log — what was corrected, in which period, and why. That written trail is what lets a CPA rely on the file instead of re-auditing it.

Last, lock what you proved. Set QuickBooks' closing date to the cleanup end date so a later edit can't quietly undo the work: in QuickBooks Online, Settings → Account and settings → Advanced, edit Accounting, turn on Close the books, enter the closing date and choose whether changes need a warning or a warning and a password (Intuit's lock-your-books steps, updated September 2026, checked October 2026); Desktop has its own closing date and password. Choose the password, and keep it with the owner.

And if you're still weighing whether to work this method yourself or hand it off, the honest breakdown of doing the cleanup yourself versus hiring it out covers where each path makes sense.

The finish test: what "clean" measurably means

"Clean" is not a feeling about the file. It is five checks, and a cleanup is finished when all five pass — whoever did the work.

Every in-scope account reconciles to its statement with a difference of exactly zero, every month through the end date — not "close", and not forced with an adjusting entry.
Every balance-sheet account that should tie to an external record agrees with that record — bank and card statements, loan statements, filed payroll records, sales-tax returns; internally derived balances have a documented supporting reconciliation.
Opening Balance Equity is zero, and undeposited funds holds only deposits genuinely in transit.
The profit and loss by month contains no movement you cannot explain in one sentence.
A written change log exists listing each material change, the period it touched, and why — and prior filed periods still tie to what was filed.

If any one of those fails, the cleanup is not done, regardless of how tidy the screen looks. This is the same test we run before handing a file back, and it is deliberately published so you can hold anyone to it — including us.

How to cite the finish test: “The five-check finish test”, QBSpecialist (reviewed by a Certified QuickBooks ProAdvisor) · https://qbspecialist.com/resources/guides/how-to-clean-up-quickbooks/#finish-test · reviewed October 2026. Quote it, link it, or hold us to it — it is published to be used.

When to stop doing it yourself

This method works when you have the time and the file is merely wrong. If you would rather hand the whole job over, that is our QuickBooks cleanup service — the same method, at a fixed fee quoted after a free review. Stop and hand it over when any of these is true, because each one costs more to unpick than to do properly the first time:

A reconciliation will not tie and the discrepancy report points at a period you have already filed on.
The beginning balance is broken and you cannot find the transaction that changed it.
More than one entity, or multi-currency, or inventory is involved — each carries its own method.
The gap is measured in years rather than months, so errors compound faster than you can work.
A deadline is close enough that a wrong number costs more than the fee.

If that is your file, the same method is available as a done-for-you QuickBooks cleanup, or start with a free, view-only review — which will also tell you honestly when you don't need us. The DIY versus professional breakdown covers where each path makes sense.

Questions about cleaning up QuickBooks yourself

Can I clean up QuickBooks myself?

Yes — the method in this guide is the same one a specialist follows. The realistic limits are time and the trickier messes (opening balances, multi-year reconciliation, a file that won't reconcile). If you get stuck on those, that's the moment to bring in help.

How far back should I go?

As far back as the books need to be trustworthy for their purpose — usually the current tax year at minimum, often the prior year too. If you're filing or seeking financing, reconcile every period that will be relied on.

What do I need before I start?

A backup of the company file, statements for every bank and credit-card account in the cleanup period, and admin access to QuickBooks. Gathering the statements in one place before you begin is what keeps reconciliation moving month by month.

How long does it take to clean up QuickBooks?

It scales with the number of accounts and the number of months, because reconciliation is the bulk of the work. One account a few months behind is a weekend project; several accounts across several years is a real project, and the honest schedule depends on that volume — not on willpower.

How do I know the cleanup is finished?

Every account reconciles to the statement with a zero difference, the balance sheet balances, the P&L reads the way the business actually ran, and every material change is documented. If any of those is missing, the cleanup isn't done yet.

Talk to a QuickBooks specialist.

Describe the file and a specialist will tell you which of these you are dealing with — including when the answer is that you don't need us.

Call (850) 842-6767 Talk to a specialist

Or start with a free, view-only review

How to clean up QuickBooks, step by step

A note on undeposited funds

Questions about cleaning up QuickBooks yourself

More on this topic

Talk to a QuickBooks specialist.