Skip to content

Guides · checklist

The bookkeeping cleanup checklist — in the only order that works.

Messy books don't get fixed by effort; they get fixed by sequence. Scope the damage, repair the structure, rebuild oldest-first, prove every month against its statement, then lock it. The full working checklist, phase by phase.

Written from the process our operators run on real cleanup engagements. General education, not advice for your specific situation.

Five phases · eighteen checks Operator-written · 40 years
THE MESS duplicates · gaps · suspense 1 SCOPE 2 STRUCTURE 3 REBUILD 4 PROVE 5 LOCK PROVEN BOOKS EVERY ACCOUNT · EVERY MONTH DIFFERENCE $0.00 · LOCKED

In brief

The cleanup in four answers.

What's the sequence?

Scope → structure → rebuild oldest-first → prove by reconciling every month → lock. Eighteen checks across five phases, and the order is the method.

Where do I start?

At the last trustworthy month — the most recent month every account reconciled. No such month? Anchor to the closing balances of your last filed tax return.

Why oldest month first?

Errors ripple forward. Fix March and April may fix itself; fix June first and March's error makes you redo June. Upstream before downstream, always.

When is it done?

When it proves — every account reconciled to now, suspense empty, books matching the filed return, period locked. "Looks right" isn't a finish line.

The checklist

Five phases, eighteen checks.

Run in order, one phase at a time. If a check won't pass, that's not an obstacle to the cleanup — that is the cleanup.

Phase 1 · Scope the damage

You can't clean what you haven't measured — and you must be able to undo anything.

Back up before touching anything

Export the full transaction history and current reports. Every deletion in a cleanup is permanent unless you kept a copy of before.

Find the last trustworthy month

For each account: when was it last reconciled to a statement? The oldest of those answers is where your cleanup starts.

List every account in play

Bank, credit card, loan, payroll, sales tax — a cleanup that misses an account isn't finished, it's paused.

Pull the filed tax returns

The last filed return is your external anchor: closing balances the cleanup must eventually agree with.

Phase 2 · Fix the structure first

Repairing transactions inside a broken chart of accounts is wasted work.

Merge duplicate accounts

Two 'Office Supplies', three flavors of 'Insurance' — pick one of each, merge, and stop the split before recategorizing anything.

Retire what you don't use

Deactivate the noise accounts so future categorization has fewer wrong doors to walk through.

Check opening balances against the return

If the file's opening balances disagree with the filed return, resolve that now — every later month inherits the gap.

Phase 3 · Rebuild, oldest month first

Errors ripple forward — fix upstream and the downstream often fixes itself.

Work one month at a time, forward

Start at the oldest broken month and move chronologically. Never patch a recent month while an older one is still wrong.

Enter what's missing, delete what's doubled

Statement in hand: add transactions the books never got, remove feed duplicates — keeping the original, not the copy.

Empty the parking lots

Ask My Accountant, Uncategorized Expense, Opening Balance Equity — every parked transaction gets a real category with a defensible reason.

Split loan payments correctly

Principal to the loan, interest to expense, per the amortization schedule — the single most common DIY miscategorization.

Clear stale receivables and payables

Open invoices that were actually paid — or never will be — and bills showing due that cleared long ago: match them, write them off, or void them with a dated note.

Phase 4 · Prove every month

A cleanup isn't done when it looks right — it's done when it reconciles.

Reconcile each account, each month, in order

Difference $0.00 against every statement, month by month up to the present. This is the proof phase — no exceptions, no forced adjustments.

Clear undeposited funds to zero

Everything in the holding account matched to a real bank deposit; anything left is an error still hiding.

Tie liabilities to filings

Payroll and sales-tax liability balances agree with what was actually filed and paid — where wrong books get expensive.

Phase 5 · Close it out — and keep it closed

An unprotected cleanup decays back into the mess you just fixed.

Read both reports, line by line

P&L for anything absurd, balance sheet for balances that don't match a statement or a story you can say out loud.

Lock the cleaned period

Set the closing date in QuickBooks with a password, so nothing you just proved can quietly change.

Start the monthly rhythm immediately

The first month-end close lands within weeks of finishing. A cleanup without a rhythm behind it is a countdown to the next one.

Phase 4 is pure reconciliation, and the mechanics have their own walkthrough: how to reconcile in QuickBooks Online → If you're still deciding whether your books need this at all, the six signs is the five-minute read that answers it.

A Westgate framework · why sequence beats effort

The Oldest-First Rule.

The Oldest-First Rule says a cleanup always repairs the oldest broken month first and moves forward chronologically, reconciling each month before touching the next — because bookkeeping errors flow downstream, never up. Every month's balances are built on the month before. A duplicate deposit in March doesn't stay in March; it inflates April's beginning balance, then May's, then every report anyone runs for the rest of the year. Fix June while March is still wrong and you haven't repaired June — you've decorated it. The moment March is corrected, June's numbers move again, and the work has to be redone.

MARCH THE ERROR LIVES HERE fix first · reconcile · pin APRIL inherits the error often self-corrects MAY inherits it too reconcile · pin JUNE three months of drift last · reconcile · lock ERRORS RIPPLE FORWARD → THE FIX MOVES ONE WAY: OLDEST → NEWEST, RECONCILING AS IT GOES START WITH JUNE BECAUSE IT'S RECENT  — redone the moment March changes
The Oldest-First Rule: the March error distorts every month after it, so the fix starts in March and moves forward, reconciling each month to pin it down. Starting with the most recent month feels productive and guarantees rework.

The rule has a second half that saves DIY cleanups from disaster: each repaired month gets reconciled before you move to the next. Reconciliation is how you pin a month down — once it proves against its statement, you'll know instantly if later work disturbs it, because the beginning balance will shout. Cleanups that save "all the reconciling" for the end lose this tripwire and routinely have to re-walk months they thought were finished.

The honest section

DIY this, or hand it off?

If the damage is a few months deep on one or two accounts and you can spare a disciplined weekend, this checklist is genuinely enough — the phases are the same ones we run, and nothing in them requires a license. Take the backup seriously, obey the two rules that protect you (oldest first; reconcile before moving on), and a modest mess is very fixable by its owner.

The honest handoff line is judgment density, not effort. A year or more unreconciled, payroll or sales-tax liabilities that don't tie to filings, an opening balance nobody can explain, loans that were never split — those aren't more checkboxes; they're accounting decisions with tax consequences, and each wrong call compounds quietly. That's the point of a professional bookkeeping cleanup — same sequence, senior judgment, documented fixes — with the QuickBooks file-repair version when the software layer itself is the mess. What the cleanup costs and why is published, plainly, in the cleanup cost guide.

Not sure how deep the damage goes? The free assessment scopes it from your actual file — including "this is a weekend job, here's your starting month."

Free books assessment

Cleanup checklist FAQ · Updated July 2026

The questions owners ask mid-cleanup.

Five phases, in strict order. Scope: back up everything, find the last month each account was reconciled, and pull the filed tax returns as your anchor. Structure: merge duplicate accounts and settle opening balances before touching transactions. Rebuild: work oldest month first, adding what's missing, deleting duplicates, clearing stale receivables and payables, and emptying suspense accounts. Prove: reconcile every account, every month, forward to the present. Close: review both reports, lock the period, and start a monthly close so it doesn't decay again. The order is the method — each phase makes the next one possible.
At the last trustworthy month — the most recent month where every account reconciled to its statement. Everything before it is proven; everything after is the cleanup zone. If no month qualifies, fall back to your last filed tax return and treat its closing balances as the starting truth. What you don't do is start at today and work backward: recent months sit downstream of older errors, so fixing them first means fixing them twice.
Because errors flow downstream, not up. A duplicated deposit in March quietly distorts every balance from March forward — so if you patch June first and then fix March, June is wrong again and you've done the work twice. Fix March and the ripple often corrects the following months on its own. This is also why each repaired month gets reconciled before you move on: the reconciliation pins that month down, so the ground you've covered stays covered.
Occasionally that's honestly the right call — a file that's years past its last reconciliation with no trustworthy month anywhere, or a business that changed entity type, can be faster to restart with clean opening balances from the last filed return. The cost is real, though: you lose in-file history, year-over-year comparatives, and the audit trail, and any unresolved question from the old file stays unresolved forever. Rule of thumb: if there's a trustworthy month to anchor to within the last couple of years, cleaning up preserves more value than starting over.
Four tests, all pass/fail. Every account reconciles to its current statement with a zero difference. The suspense accounts — Ask My Accountant, Uncategorized, Opening Balance Equity — are empty. The books agree with your last filed tax return at its closing date. And the cleaned period is locked. 'The reports look right' passes none of these — looking right is what messy books do best, which is exactly why the finish line is proof, not appearance.
Deleting or editing without a safety net — usually one of three ways: bulk-recategorizing transactions on a guess, deleting 'duplicates' that were actually the only copy, or editing a transaction inside a previously reconciled month and breaking every reconciliation after it. All three feel like progress in the moment and each can make the file worse than the mess you started with. The protections are boring and absolute: back up first, work oldest-first, reconcile each month before moving on, and when a change would touch reconciled history, stop and make a dated correcting entry instead.

Deeper than a weekend job? That's what the cleanup service is for. More guides: the guides hub →

Call Free books review