DIY QuickBooks cleanup: the checklist, in the order that actually works
Most DIY cleanups fail for one reason: people start with categorization because it's the visible mess, then reconciliation changes the underlying transactions and they do the work twice. The order below exists so every step builds on verified data.
-
1. Reconcile every bank and credit card account first
Month by month, oldest gap first, against the real statements. This is the ground truth everything else depends on. If a month won't balance, find the missing or duplicated transaction now - do not use an adjusting entry to force it and move on; that buries the error.
-
2. Hunt duplicates while you reconcile
Reconciliation surfaces them naturally: a month that's off by exactly one transaction's amount usually has that transaction twice. Also check for double-imported bank feeds after any bank connection was re-linked.
-
3. Clear Undeposited Funds
A big Undeposited Funds balance means payments were recorded but never matched to deposits - so income may be double-counted (once as a payment, once as a deposit). Match each stuck payment to its real bank deposit.
-
4. Empty the parking accounts
"Uncategorized Expense," "Uncategorized Income," "Ask My Accountant" - every entry gets a real category. Work by vendor: sort the account by payee and categorize in batches, then set bank rules so the same vendor books correctly going forward.
-
5. Review categorization patterns, not just totals
Run the P&L by month and scan for anomalies: a category that doubles one month, personal-looking expenses in business accounts, owner draws booked as expenses, loan payments booked entirely as interest. Fix the pattern and the bank rule that caused it.
-
6. Check AR and AP aging for ghosts
Invoices you know were paid but still show open, bills paid outside QBO still showing due. These distort your income (accrual) and make reports useless for decisions.
-
7. Close the books
When a period is clean, set a closing date with a password in QBO. This is what prevents the next cleanup - nothing can silently change history anymore.
When DIY stops making sense
A rule of thumb from practitioners: under ~6 months behind with under 100 transactions a month is a realistic weekend-sized DIY project. A year or more behind, multiple accounts, payroll in the mix - that's the $2,000-$6,000 quote territory, and professionals quote high because they can't scope a file they haven't seen. Check your own number with our free cleanup cost estimator.
Either way, the first step is the same: know exactly what's wrong before anyone (including you) spends hours fixing it. BooksAudit reads your QBO/Xero export and returns that diagnosis as a report. Request a free diagnostic.
This guide is general information, not accounting, tax, or financial advice.