Most QuickBooks cleanups go wrong in the first hour. Someone opens the file, spots a miscategorized expense, fixes it, spots another, fixes that one too, and three weekends later the books still don’t tie out.
A cleanup has two halves. First you find out what’s broken, using reports, without touching a single transaction. Then you fix it in a specific order, so nothing you fix today gets undone by something you fix tomorrow.
This guide walks through both halves. It’s written for QuickBooks Online. If you’re still on Desktop, plan to migrate before you clean up.
Part 1: Find what’s broken before you touch anything
Nine reports will show you 80 to 90 percent of what’s wrong with a QuickBooks file. Run them all before you edit anything.
1. Balance Sheet (accrual basis)
This is your main diagnostic tool. Look for:
- Negative balances in asset accounts, such as a checking account below zero that the bank says isn’t
- Accounts that haven’t moved in a year or more
- Opening Balance Equity with anything in it
- Undeposited Funds (called Payments to Deposit in newer files) with old money sitting there
2. Profit & Loss (accrual basis)
Use it to spot patterns, not to fix anything yet. Look for expense categories that swing wildly from month to month, income in odd places, and categories that make no sense for your business.
3. Balance Sheet comparison (this year vs. last year)
This tells you when the problems started. An account that was fine last December and broken by March points you straight to the period that needs attention.
4. Accounts Receivable Aging Summary
Your first real clue. Look for invoices more than 90 days old, customer credits nobody applied, and an AR total that doesn’t match the Balance Sheet. Old “unpaid” invoices are often paid invoices whose payments landed somewhere else.
5. Accounts Payable Aging Summary
The same check for bills. Look for old unpaid bills, vendor credits never applied, and negative vendor balances. A negative balance usually means a bill got paid without the payment being matched to the bill.
6. Reconciliation reports
Check when each bank, credit card and loan account was last reconciled. An account that hasn’t been reconciled in six months is hiding something, even if it looks fine.
7. General Ledger (filtered)
Don’t pull the whole thing. Filter to the accounts that looked wrong on the Balance Sheet, and look for repeated misuse, such as transactions posted straight to equity or to Opening Balance Equity.
8. Chart of Accounts
A structure check. Look for duplicate accounts, accounts with the wrong type (a loan set up as an expense, for example), and accounts nobody can explain.
9. Audit Log
The Audit Log shows who changed what, and when. It tells you how the problems got made: an untrained employee, an app syncing duplicates, or a process with no owner. That’s what you’ll fix last, so the mess doesn’t come back.
Answer four questions before you edit anything
- When did the problems start?
- Which accounts are affected?
- What process or person is causing them?
- Has your CPA already filed returns for any of the affected periods?
The fourth question matters most. Changing a year that’s already been filed can put your books out of step with your tax return. Talk to your CPA before you touch a closed year.
Part 2: The QBO Cleanup steps, in order
You wouldn’t paint a ceiling before you fixed the roof leak that stained it. QuickBooks is the same. Fix the structure first, then the Balance Sheet, then the Profit & Loss.
Step 1: Protect the file and set the scope
Confirm your QuickBooks version. Back up the file. Gather bank, credit card and loan statements for the whole period. Decide exactly which months you’re cleaning up and write it down.
Step 2: Lock down the file structure
Clean up the chart of accounts first: merge duplicates, fix account types, retire accounts you don’t use. Then tidy the customer, vendor, and products and services lists. Every transaction you fix later depends on this structure, so get it right before you move on.
Step 3: Deal with opening balances and equity
Work out what’s in Opening Balance Equity and where it belongs. Separate prior-year problems from current-year ones, and leave closed periods alone unless your CPA agrees.
Step 4: Clean up the Balance Sheet accounts
This is the core of the work. Go in this order:
- Cash accounts: reconcile every bank account, month by month
- Clearing accounts: empty Undeposited Funds (Payments to deposit) by matching each payment to its deposit
- Accounts receivable
- Accounts payable
- Other current assets
- Credit cards, loans and other liabilities: reconcile them to their statements
Step 5: Resolve receivables and payables
Clear stale and duplicate invoices and bills. Apply credits. Fix payments recorded against the wrong customer or vendor. When you’re done, both aging reports should match the Balance Sheet to the penny.
Step 6: Review income and expenses
Now, and only now, fix the Profit & Loss. Recategorize misposted expenses, pull out personal spending, remove duplicates, and fix income recorded in the wrong place.
Step 7: Check payroll, sales tax and special features
Tie payroll liabilities to your payroll provider’s reports. Tie sales tax payable to the returns you’ve filed. If you use inventory or job costing, check those last, since they depend on everything above.
Step 8: Run the reports again
Rerun the nine reports from Part 1. Your Balance Sheet should match your statements. Your Profit & Loss should look like the business you run.
Step 9: Fix the cause
Go back to the Audit Log findings. Change the process, the bank feed rule, the app setting or the training that created the problem. Assign one person to own the books each month. Skip this step and you’ll be doing the cleanup again in a year.
Why this order works
- Structure comes before transactions, so you don’t fix a transaction twice.
- The Balance Sheet comes before the Profit & Loss, because a reconciled Balance Sheet catches most P&L errors on its own.
- You understand the problem before you change anything.
- Prevention gets as much attention as the fix.
Should you do it yourself?
A few months of mess, a simple business and a free weekend: you can do this. Two or three years behind, inventory, payroll, or a tax year already filed: that’s where a DIY cleanup turns into a second job.
If you’d rather hand it off, see our QuickBooks cleanup services in Tucson. Every project starts with a 94-point diagnostic, so you know what’s broken before you pay to fix it.