Most small business owners don't open QuickBooks Online expecting to be confused by their own numbers. It happens gradually. A few transactions get categorized to "Ask My Accountant" and never revisited. A bank feed goes unreconciled for three months because there wasn't time. A bookkeeper leaves, and nobody picks up where they stopped. By the time someone finally looks closely, the P&L doesn't make sense and the balance sheet has numbers nobody can explain.

This is normal, and it's fixable. A QuickBooks Online cleanup isn't about starting over. It's about working backward through the file methodically until every account tells the truth again. Below is the checklist I actually use with clients, in the order I use it.

Why a Cleanup Matters Before You Do Anything Else

Every decision that comes out of your books — pricing, hiring, loan applications, tax filings — is only as good as the data behind it. A business owner looking at an inflated profit figure because expenses were miscategorized will make different decisions than one looking at the real number. Lenders and tax authorities also don't accept "the books were a mess" as an explanation later.

Cleanup work also isn't optional once you've gone more than a quarter without reconciling. Errors compound. A duplicate transaction in month two shows up as a wrong balance in month eight, and by month twelve you're reconciling against numbers that were never right to begin with.

Step 1: Set a Cleanup Start Date

Decide how far back you're going. If the last reliable reconciliation was eight months ago, that's your starting line. Don't try to fix everything since the company was founded unless the file has never been touched — that's a different project with a different scope.

Pull the last bank statement you're confident matches QuickBooks. Everything from that date forward is in scope.

Step 2: Reconcile Every Bank and Credit Card Account

This is the backbone of the whole cleanup. Go month by month, account by account, and reconcile against the actual statements — not against what QuickBooks thinks the ending balance should be.

  • Match every transaction the bank shows against what's recorded in QBO.
  • Flag anything in QuickBooks that doesn't appear on the statement (often a duplicate or a manually entered transaction that never cleared).
  • Flag anything on the statement missing from QuickBooks entirely.

If a reconciliation won't balance, don't force it with a journal entry to "plug" the difference. Find the actual error. A recurring source: someone connected a bank feed and also manually entered the same transactions from receipts, creating duplicates that quietly overstate expenses.

Step 3: Clear Out the Uncategorized and "Ask My Accountant" Buckets

Open the Chart of Accounts and look at Uncategorized Income, Uncategorized Expense, and Ask My Accountant. These accounts exist as a holding pen, not a resting place. If they carry a balance for months, your P&L is understating or overstating real activity in categories that matter.

Go through each transaction and assign it to where it actually belongs — advertising, software subscriptions, professional fees, whatever fits. If you genuinely can't tell what a transaction was for, that's worth a five-minute look at the receipt or a message to whoever made the purchase, rather than a guess.

Step 4: Review the Chart of Accounts Itself

A cluttered chart of accounts is one of the most common reasons QuickBooks files become unreadable over time. I regularly see files with three different "Office Supplies" accounts created because someone typed a new name instead of selecting the existing one from the dropdown.

  • Merge duplicate accounts (QBO allows this — rename one to match the other exactly, and it merges automatically).
  • Deactivate accounts with zero activity that aren't structurally needed.
  • Make sure accounts are mapped to the right type — an equipment purchase sitting under Expenses instead of Fixed Assets will distort both your P&L and your balance sheet.

Keep the chart of accounts only as detailed as you'll actually use. Twelve types of "miscellaneous" categories help no one.

Step 5: Check Accounts Receivable and Accounts Payable

Open the AR aging and AP aging reports. Look for:

  • Invoices marked open that were actually paid months ago (common when a payment was recorded as a deposit instead of applied to the invoice).
  • Bills sitting in AP that were already paid from the bank feed directly, creating a phantom liability.
  • Customer or vendor balances that are clearly wrong — a negative balance where there shouldn't be one is almost always a sign a payment was applied incorrectly.

These errors matter because AP and AR balances feed straight into your balance sheet and your cash flow picture. A business that thinks it's owed money it already collected is going to make a bad decision somewhere down the line.

Step 6: Verify Sales Tax or VAT Accounts

If you're collecting sales tax (US), GST/HST (Canada), VAT (UK or EU), or GST (Australia), check that the liability account matches what you've actually filed and remitted. This is one of the more consequential things to get right in a cleanup, since a mismatch here isn't just a bookkeeping inconvenience — it can mean under- or over-reporting to a tax authority.

Compare the sales tax liability balance in QuickBooks against your actual filed returns for the period. If they don't match, trace back to find whether a transaction was taxed incorrectly, a filing was recorded twice, or a payment was never logged against the liability.

Step 7: Confirm Payroll Is Posting Correctly

If payroll runs through QuickBooks Online (or through Gusto, ADP, or another provider feeding into QBO), check that the payroll journal entries are hitting the right accounts — wages, payroll taxes, benefits — and that the numbers tie out to what actually left the bank account each pay period. Payroll errors are quiet but expensive; they tend to sit unnoticed until year-end reporting forces the issue.

Step 8: Run the Three Core Reports and Read Them Like a Skeptic

Once the above steps are done, pull the Profit & Loss, Balance Sheet, and Statement of Cash Flows for the cleanup period. Read them the way an outside lender or tax preparer would — not the way you hope they'll read.

  • Does the P&L show a profit margin that's plausible for the business, or does something look inflated or oddly negative?
  • Does the balance sheet balance, literally (assets = liabilities + equity)?
  • Is there a large balance in Opening Balance Equity? That account should be at or near zero once a file is clean — a large balance there is usually a sign of an incomplete setup or an unresolved migration issue.

If something still looks wrong at this stage, it's usually traceable to one of the earlier steps being incomplete rather than a new problem.

Step 9: Lock the Period

Once everything ties out, set a closing date in QuickBooks Online (Settings > Advanced > Accounting) for the period you just cleaned up, ideally with a password. This stops anyone — including a future version of you, in a hurry — from editing a transaction that's already been reconciled and reported on.

Keeping It From Happening Again

A cleanup fixes the past. What keeps books clean going forward is a monthly reconciliation habit, a chart of accounts nobody adds to without checking first, and a fixed closing date every month. Most businesses that end up needing a major cleanup didn't have a bad bookkeeper — they had no consistent process at all.

If your QuickBooks file has drifted to the point where you don't trust the numbers on screen, that's worth fixing before it costs you a loan application, a tax filing, or a decision made on bad information. Get in touch and I'll take a look at what shape your books are actually in.