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.

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 the single most common reason 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 is usually a duplicate, or an entry that never actually happened 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 · 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.