How to clean up QuickBooks, step by step

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.

First: is this actually a cleanup?

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.

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. 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

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 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, something that was already reconciled has since been changed or deleted — QuickBooks' reconciliation discrepancy report points to the transaction responsible, and you fix that before matching anything, or the error just rolls forward into every month that follows. 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. Trace it to the account it belongs to rather than journaling it away — 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 ageing: 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 cheques — 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. 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.

1. 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.
2. 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.
3. Opening Balance Equity is zero, and undeposited funds holds only deposits genuinely in transit.
4. The profit and loss by month contains no movement you cannot explain in one sentence.
5. 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”, Abid, Certified QuickBooks ProAdvisor · https://qbspecialist.com/resources/guides/how-to-clean-up-quickbooks/#finish-test · reviewed September 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. 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.