My 12-Point QBO Cleanup Quality Control Checklist (Run This Before You Deliver)

There's a moment at the end of every QuickBooks Online cleanup where you lean back, look at the numbers, and think "okay, that looks right." The bank accounts reconcile. The P&L makes sense. The Balance Sheet isn't screaming at you. You're tempted to mark it done, send the deliverable, and move on.

Don't. That moment — the gap between "this looks done" and "I've verified this is done" — is where quality control lives, and it's the difference between a good cleanup and a great one.

I run a formal 12-point QC process on every single cleanup I deliver. It takes about 30 minutes. It catches things I would have missed at least a third of the time. And it has saved me from the single most embarrassing scenario in our line of work.

The Embarrassment Scenario

Picture this: you deliver "clean" books to a client. They forward your file to their CPA at tax time. The CPA opens it up and within 20 minutes finds a $15,000 discrepancy on the Balance Sheet. Maybe it's stale Undeposited Funds. Maybe it's an Opening Balance Equity account that never got cleared. Maybe there are negative bank balances that don't make sense.

The CPA sends the client an email: "There are some issues with your books. Can you check with your bookkeeper?"

That email is a credibility killer. It doesn't matter that you spent 40 hours untangling three years of chaos. It doesn't matter that the file is 95% perfect. The CPA found a problem, and now the client is wondering whether they got what they paid for.

A formal QC process prevents this. Not by making your cleanup work better — you already know how to do the work. It prevents it by making sure you check the work. Systematically. Every time. The same way, in the same order.

Why a Checklist, Not Just "Looking Things Over"

When you "look things over," you check what's top of mind. You check whatever you worked on most recently. You check what went wrong last time. But you don't check the things sitting quietly in the background, waiting to embarrass you.

A checklist forces you to check everything, every time. Same reason pilots run a pre-flight checklist after 10,000 flights — not because they forgot how to fly, but because the human brain is unreliable at remembering routine checks under time pressure. And at the end of a cleanup, you're always under some kind of time pressure.

I've written separately about running QC in dependency order — why the sequence of checks matters. This article is the detailed checklist itself: the specific 12 points I verify before any file leaves my hands.

Point 1: Reconciliation Verification

This is the foundation. If the reconciliations aren't right, nothing else matters.

Go to every bank account and every credit card account. Check that each one is reconciled through the most recent statement date. Check that beginning and ending balances match the actual bank statements. If you're cleaning up multiple years, verify this for each year.

What I'm looking for:

No unreconciled transactions in periods that should be fully reconciled. If you reconciled through December 31 but there are October transactions still unreconciled, something went wrong.

Reconciliation discrepancies of $0.00. If QBO shows any discrepancy, even $0.01, dig into it. Small discrepancies are usually a sign of a bigger issue — a duplicated transaction, a deleted entry.

Statement balance matches. Pull the actual bank statements and compare. Don't just trust QBO's reconciliation status. I've seen files where someone force-reconciled with an adjustment, and QBO shows it as reconciled even though the numbers are wrong.

This single checkpoint catches more post-delivery issues than any other.

Point 2: Balance Sheet Sanity Check

Pull the Balance Sheet as of the cleanup end date. Scan it systematically — you're looking for things that don't make sense on their face.

Negative bank account balances. A bank account should never show negative on the Balance Sheet. If it does, there's a reconciliation error, a missing deposit, or transactions posted to the wrong account. This is the first thing a CPA notices.

Stale Undeposited Funds. Check the balance. If it's not $0, drill into it. Old payments sitting here mean deposits were received but never matched to a bank deposit. A large balance is a red flag that needs resolution before delivery.

Accounts Receivable and Accounts Payable aging. Run the aging reports. Look for entries that are absurdly old — invoices from three years ago still showing as open. These are almost always invoices that were paid but the payment wasn't applied, or invoices that should have been written off.

Loan and liability balances. Do they roughly match what the client actually owes? A loan showing $0 when the client is still making payments? A loan showing $50,000 that was paid off two years ago? These need attention.

The Balance Sheet sanity check isn't about auditing every number. It's about catching the things that will jump out to anyone reviewing the file.

Point 3: P&L Category Review

Pull the Profit & Loss for the full cleanup period. Scan every category for miscategorized items that made it through the cleanup — because they always do.

Common catches at this stage:

Office supplies in Cost of Goods Sold. Happens when bank rules are wrong or Amazon purchases get auto-categorized. A $200 desk chair in COGS throws off gross margin.

Owner draws in regular expense categories. Owner's personal expenses categorized as business expenses. This is a tax issue a CPA will flag immediately. Look for categories with unusually large amounts, then drill in.

Meals and entertainment miscategorized. These have specific tax treatment (50% deductible in most cases). I often find meal expenses buried in "Office Supplies" or "Miscellaneous."

Revenue in expense categories (or vice versa). A refund coded as revenue. A client payment coded as an expense. In files with a lot of transactions, this happens more than you'd think.

I don't review every individual transaction. I scan for unusual amounts — categories way higher or lower than expected — and drill into those. If "Office Supplies" shows $14,000 for a consulting business, something is miscategorized.

Point 4: Uncategorized Account Check

The easiest check on the list and one of the most important. Three accounts should always be $0 when you deliver:

Run a Transaction Detail report for each. If there's anything in them, recategorize before delivery. No exceptions. Delivering a cleanup with transactions in "Ask My Accountant" is like a mechanic returning your car with the check engine light still on. It tells the client (and their CPA) the job isn't done.

This takes two minutes. I've caught leftover transactions on probably 20% of my cleanups during QC. Transactions I legitimately forgot to go back to. The checklist caught what my memory didn't.

Point 5: Payroll Liability Verification

If the client runs payroll, this is critical. Payroll liabilities need to match actual obligations.

Payroll liabilities balance. Pull the Balance Sheet and look at all payroll-related liability accounts. Are old balances accumulating? If the client uses a payroll service that handles tax payments, these should be clearing each pay period. If they're accumulating, there's a recording issue.

Payroll expense reasonableness. Compare total payroll expense on the P&L to what the payroll service reports. They should be in the same ballpark. If your P&L shows $120,000 but the payroll service reports $98,000, there's a categorization or duplication problem.

Duplicate entries. The most common payroll issue in cleanup files. The payroll service syncs transactions and the bank feed pulls in the same ones. Everything is doubled. Compare the number of payroll entries in QBO to the number of actual payroll runs.

Payroll is what CPAs notice instantly because the numbers directly affect tax returns.

Points 6-12: The Rest of the Checklist

Point 6: Sales Tax Review. Verify sales tax liability accounts match what's actually owed. Confirm payments to taxing authorities are recorded correctly.

Point 7: Vendor and 1099 Cleanup. Check that 1099-eligible vendors are flagged correctly and payments categorized to the right accounts. Saves a massive headache at year-end.

Point 8: Closing Date Set. Lock down the cleanup period in QBO (Settings > Advanced > Accounting > Close the books). Set a password only you know. If you skip this, the cleanup you spent weeks on can be undone in five minutes by someone who doesn't know what they're doing.

Point 9: Bank Rules Cleaned Up. Review existing rules. Delete incorrect or outdated ones. Set up rules for recurring transactions. Good bank rules are the first line of defense against the file getting messy again.

Point 10: Opening Balance Equity Cleared. This account should be $0 in a clean file. If there's a balance, journal entries used for opening balances were never closed out properly.

Point 11: Year-Over-Year Comparison. If the cleanup covers multiple years, pull a comparative P&L. A category that went from $2,000 in Year 1 to $45,000 in Year 2 deserves a second look.

Point 12: Final Report Package Prepared. Generate the deliverables: Balance Sheet, P&L, AR/AP aging summaries, reconciliation summaries. Review each report one more time as a package before sending. This is your final eyes-on-it moment.

What QC Does to Your Deliverable

Without QC, your deliverable is a set of books you believe is clean because you worked through the cleanup process. It's probably 90-95% right.

With QC, your deliverable is a set of books you've verified is clean through a systematic process. The reconciliations match actual bank statements. The Balance Sheet is defensible. The P&L categories are accurate. The dumping-ground accounts are empty. Payroll ties out. The closing date is set. And you have a report package that tells a clear financial story.

That's the difference between a CPA who finds issues and a CPA who says "this is clean, let's do the return." It's also the difference in what you can charge. When you deliver a QC'd file with a professional report package, you're not competing with the bookkeeper on Fiverr who'll "fix your QuickBooks" for $200.

Make QC Non-Negotiable

I run this checklist on every cleanup, without exception. Even small ones. Even when I'm confident the file is clean. Especially when I'm in a hurry — because that's when I'm most likely to miss something.

The 30 minutes it takes is the highest-value 30 minutes in the entire cleanup. It's not where you do the work — it's where you verify the work. And it's what lets you deliver with confidence instead of hope.

Automate the First Pass

Many of the checks in this QC process — reconciliation gaps, uncategorized transactions, balance sheet anomalies, COA issues, duplicate detection — are the same things LedgerClean scans for automatically. I use it at the start of a project to scope the cleanup, and I use it again at the end as a first-pass QC tool before running my manual checklist. Upload the client's updated QBO exports after cleanup and see if the health score reflects the work you did. If issues remain, you catch them before the CPA does. Free to try.