Most QuickBooks files do not arrive broken. They arrive drifted - a few months of bank feed matches accepted without looking, a Suspense account quietly absorbing anything awkward, and an opening balance nobody has reconciled since the file was created.
The mistake in cleaning one up is starting at the top of the chart of accounts and working down. You end up recategorising transactions that a later reconciliation proves should not exist. Work in dependency order instead: prove cash first, then explain what cash tells you.
Here is the order we use, and why each step sits where it does.
Before you touch anything
1. Take a backup and agree the scope period
Agree in writing which periods are in scope and which are closed. If a prior year has been filed, you are not reopening it without the filer's agreement - you are reconciling forward from it.
For QuickBooks Online, export a full General Ledger to Excel for the scope period before your first edit. QBO has no true point-in-time restore, so that export is your only way back to the starting position.
2. Check the closing date and who can override it
If no closing date is set, someone has probably been posting into filed periods. Set one at the last filed period end, with a password. Then check the Audit Log for edits dated before it - that tells you whether your comparatives can be trusted at all.
Prove the cash
3. Reconcile every bank and card account, oldest first
Nothing downstream is trustworthy until cash is. Work oldest period forward - a difference in month one cascades, and fixing it often resolves three later months at once.
4. Hunt the reconciliation discrepancies report
This is the single most useful report in a cleanup. It lists transactions changed or deleted after they were reconciled - the usual reason a previously clean reconciliation no longer balances. Each line is either a genuine correction or someone editing history.
5. Clear Undeposited Funds
The classic symptom: payments received and recorded, but never grouped into a deposit matching the bank. Revenue looks right, cash does not, and the balance grows quietly for years. Anything in Undeposited Funds older than a few weeks is almost certainly a duplicate or an unmatched deposit.
6. Reconcile the opening balance
If the file was converted or migrated, check the Opening Balance Equity account. It should be zero once setup is complete. A balance sitting there means the migration was never finished, and every ratio from that file is wrong by that amount.
Explain what cash revealed
7. Empty the Suspense and Ask My Accountant accounts
Every item here is a decision somebody deferred. Clear them individually with documentation, not a single journal to one account. A one-line journal clearing eighteen months of Suspense is how the next person inherits the same problem.
8. Review Accounts Receivable and Payable ageing for the impossible
Look for credit balances in AR and debit balances in AP. Both usually mean a payment applied to the wrong invoice, or an invoice entered twice and paid once. Also check for invoices older than the business's actual collection cycle - those are often already written off in reality but not in the ledger.
9. Find the duplicates
Sort the expense register by amount and scan for pairs. The common causes are a bank feed transaction accepted alongside a manually entered bill, and a bill paid through both Pay Bills and a direct expense entry. Both overstate costs and understate profit.
10. Check the chart of accounts for drift
Two accounts for the same thing, personal expenses mixed into business categories, and balance sheet items posted to P&L accounts. Merge duplicates rather than deleting them - deleting detaches history.
Before you hand it back
11. Run comparatives and ask whether they make sense
Pull a two-year monthly Profit and Loss. You are not looking for precision, you are looking for shapes: a month with no payroll, revenue that doubles for one period and returns, an expense category that stops dead. Each anomaly is either a real business event or an error, and the owner can tell you which in about five minutes.
12. Document what you changed and what you could not
The deliverable is not just a clean file. It is a short memo: what was wrong, what you corrected, what assumptions you made, and what remains unresolved pending information. That memo is what lets the next preparer trust your work - and it is what protects you if a figure is later questioned.
The judgment call most checklists skip
At some point in most cleanups you find a period so unreliable that correcting it transaction by transaction costs more than it is worth. The honest options are to reconstruct from source documents, or to agree a clean cut-off, document the position, and reconcile forward from there.
That is a conversation with the client, not a decision to make silently in the file. Reconstructing nine months of mangled data at an hourly rate, without asking first, is how cleanup projects end badly for both sides.
We run this checklist on QuickBooks Online and Zoho Books files as a fixed-fee review, with the workpapers shared before anything goes back to your client. If you have a file you would rather not hand a junior in January, see QuickBooks and offshore accounting or email us.