The QBO Cleanup Checklist That Catches What Reconciliation Doesn't

You finished the transaction cleanup. Reconciliations are done. The bank balances tie out. You run the financials and something is off.

Maybe retained earnings doesn't match the prior tax return. Maybe there's a negative liability sitting in payroll that nobody flagged. Maybe a credit card account reconciles to zero but the statement says otherwise because someone recorded payments from the bank feed instead of matching them to the card.

This is where QuickBooks Online (QBO) cleanup projects stall. Not during the work, but at the end, when you're trying to close the file and hand it off. I wrote a detailed 12-point QC checklist covering the specific checks — this post is about why the sequence of those checks matters.

The Pattern

Most bookkeepers work through cleanup in the order that feels logical: categorize transactions, reconcile bank accounts, move on. The problem is that cleanup done without a structured QC pass will always leave gaps, because certain issues only become visible in relation to other accounts.

Here's a common scenario. A client's QBO file had two years of unreconciled accounts. The bookkeeper categorized everything, reconciled all bank and credit card accounts, and the balances tied. Project looked done. But when the balance sheet was reviewed against the prior year tax return, owner's equity was off by $14,000. Loan payments had been categorized entirely as expenses instead of split between principal and interest. Every month's reconciliation still worked because the cash side was correct. The error lived on the balance sheet, and nobody caught it because QC was just "do the reconciliations match."

Others show up constantly: undeposited funds with a balance that should be zero, A/P aging that doesn't match the balance sheet because someone used journal entries instead of entering bills, or 1099 vendors recorded without tax ID tracking. The file looks "clean" but isn't ready for year-end.

What a Structured QC Sequence Looks Like

The fix isn't working harder during cleanup. It's running QC in a specific order that forces these issues to surface before you call the project done.

1. Verify opening balances tie to the prior tax return or last known good starting point. If they don't match at the start, nothing downstream will be right.
2. Confirm all balance sheet accounts reconcile — not just bank and credit cards. Loans, payroll liabilities, sales tax payable, undeposited funds. If it has a balance, verify it against a source document. Reconciliation discrepancies are the most common issue at this step.
3. Review A/R and A/P aging reports separately from the balance sheet totals. Journal entries posted directly to receivables or payables will make the balance sheet look fine while the aging is a mess.
4. Run a vendor list filtered by 1099 status and check for missing tax IDs. This is a compliance check, not a bookkeeping check, and it gets skipped constantly.
5. Compare the P&L to the prior period and flag anything structurally different. A category that was $40,000 last year and $2,000 this year probably has transactions hiding elsewhere in the chart of accounts.
6. Check retained earnings. If it doesn't match prior year net income rolled forward, something was posted to equity that shouldn't have been.

This sequence works because each step builds on the one before it. You're not confirming that individual accounts are correct in isolation. You're confirming that the file tells a coherent financial story from the balance sheet through the income statement.

The Takeaway

Build your QC checklist in dependency order, not task order. This QC pass is the final stage of the full cleanup process — and it only works if the earlier steps (COA rebuild, categorization, reconciliation) were done in the right sequence. Scope the project properly before you start, then use this dependency-order QC to verify the results. Most QC checklists are flat — they check whether things were done, not whether the results are internally consistent. A structured sequence catches the problems that only exist in the relationship between accounts, which is exactly what your CPA or your client's tax preparer will find if you don't.

This is part of why I built LedgerClean. It runs these cross-account checks automatically across your QBO exports and flags the issues that only show up when you look at the file as a whole — balance sheet vs. P&L, aging vs. GL, opening balances vs. prior returns. If you're spending time at the end of every cleanup chasing down why the numbers don't tie, try a free diagnostic scan and see what it catches.