OPS-Automate Blog

The QuickBooks Cleanup Checklist Every Accountant Should Work From

Published 2026-08-03 · OPS-Automate Team

Every accountant knows the moment: a new client hands over their QuickBooks file, you open it, and the balance sheet tells you a story that can't possibly be true. Negative cash, a five-figure undeposited funds balance, an A/R aging full of invoices from three years ago. Cleanup work is some of the most valuable work a firm does — and some of the easiest to underprice when you don't scope it with a checklist.

Here's the 12-step sequence our accountants work through on every cleanup engagement. It's ordered deliberately: diagnosis first, structural fixes second, transaction-level work third, verification last.

Phase 1 — Diagnose before you touch anything

1. Pull the opening picture

Run a balance sheet and P&L for the full period, on both cash and accrual basis. Save PDFs — these are your "before" photos, and you'll want them when the client asks what changed.

2. Check the audit trail and user list

Who has been posting? How many users, and are any of them ex-employees or third parties who should no longer have access? Cleanup scope is very different when four people have been coding transactions with four different philosophies.

3. List the accounts that can't be right

Negative bank or credit card balances, negative payroll liabilities, a swollen undeposited funds account, an opening balance equity account that never got zeroed out, and suspense/ask-my-accountant balances. This list becomes your scope document.

Phase 2 — Fix the structure

4. Repair the chart of accounts

Merge duplicates (Meals, Meals & Entertainment, meals-other), deactivate what's unused, and align the structure to how the returns are actually prepared. Don't renumber mid-year without a note to the tax preparer.

5. Clean the vendor and customer lists

Merge duplicate vendors (Amazon, Amazon.com, AMZN), fix names that are actually categories, and flag vendors who'll need W-9s before 1099 season.

6. Review recurring transactions and bank rules

Old bank rules are how one miscoding becomes three hundred. Audit every rule; delete the ones auto-posting to the wrong account.

Phase 3 — Transaction-level cleanup

7. Empty undeposited funds

Match every stranded receipt to its actual deposit. If the deposit was recorded separately (the classic duplicate-income error), remove the duplicate and link the payment properly.

8. Work the A/R and A/P aging

Invoices that will never be paid get written off with proper documentation; bills that were paid outside QuickBooks get matched or cleared. An aging report full of ghosts makes every future report a lie.

9. Reconcile every account, every month, in order

Bank, credit card, and loan accounts — chronologically, oldest first, no force-balancing. Every discrepancy gets a note. This is the longest step and the one where a dedicated reconciliation workflow pays for itself.

10. Tie payroll to the ledger

Match wage and tax expense to the payroll reports (Gusto, ADP, QuickBooks Payroll). Payroll liability accounts should equal what's actually owed — usually they don't.

Phase 4 — Verify and hand over

11. Re-run the before/after comparison

Same reports as step 1. Every material change between "before" and "after" should be explainable in one sentence. If it isn't, you're not done.

12. Document and lock

Write the cleanup memo: what was wrong, what was changed, what needs the client's ongoing attention. Set a closing date with a password so the cleaned period stays clean.

The real question: who should do this work?

Cleanup is systematic, checklist-driven production work — exactly the kind of engagement that shouldn't consume partner or senior hours. Most of the twelve steps above need accuracy and process discipline, not a CPA license; the license belongs on steps 1, 11 and 12, where judgment and client communication live.

That split is how OPS-Automate clients run cleanups: a dedicated QuickBooks-trained accountant works the checklist full-time under daily QA from a success manager, and the firm's CPAs review the before/after and sign the memo. At $950/month flat, a single cleanup engagement often covers the cost of the entire seat — and the same accountant then keeps the books clean going forward with ongoing bookkeeping.