Below is a step-by-step guide for a QuickBooks Cleanup on your company file that are a complete mess.

The key to success is doing things in the right order. Start with the basics, protect your file, fix structural problems, clean up the Balance Sheet first, then move to the Profit & Loss statement, and finally check your reports and set up controls to prevent future problems.

This guide focuses on what to fix and when, not exactly how to do each task. Why? Because there could be many different ways to fix the same problem. For example, I can think of at least 5 different ways to fix an Undeposited Funds issue.

Protect and Assess Before Touching Anything

Purpose: Don’t make a bad situation worse. You need to understand what you’re dealing with before you start changing things.

Here’s what to do:

• Figure out which version of QuickBooks you’re using and what type of file it is
• Create backup copies and make sure you have access to bank statements, receipts, and other important documents
• Decide which time period you’re cleaning up and what reports you need at the end
• Look for obvious warning signs like negative account balances, weird equity accounts, or bank accounts that haven’t been reconciled

Why start here: QuickBooks Cleanup is like detective work. You have to understand what’s broken before you can fix it.

Lock Down the File Structure

Purpose: Stop new problems from happening while you’re fixing the old ones.

Here’s what to check:

• Review your chart of accounts—look for too many accounts, duplicate accounts, or accounts being used incorrectly
• Find accounts that are being misused (for example, income accounts being used like holding accounts)
• Check your customer list, vendor list, and products/services list for structural problems

Why do this now: If the structure is wrong, everything else will be wrong too. Fixing transactions before you fix the structure just means you’ll have to redo your work later.

Address Opening Balances and Equity

Purpose: Make sure you’re starting from a solid foundation.

Here’s what to review:

• Look at Opening Balance Equity and other “plug” equity accounts that QuickBooks creates automatically
• Figure out which problems are from previous years versus the current year
• Decide what you should and shouldn’t change based on which accounting periods are already closed

Why tackle this early: Equity problems mess up everything else. If your equity accounts are wrong, you won’t be able to trust any of your other reports?

Clean Up Balance Sheet Accounts (Top Priority)

Purpose: Make sure your Balance Sheet is accurate before you start fixing income and expenses.

Work through your Balance Sheet accounts in this order:

1. Bank accounts and credit card accounts
2. Undeposited Funds and other clearing accounts
3. Accounts Receivable (money customers owe you)
4. Accounts Payable (money you owe vendors)
5. Other current assets and liabilities
6. Loans, payroll liabilities, and sales tax payable

Why clean up the Balance Sheet before the Profit & Loss: The Balance Sheet builds up over time and shows you everything from day one. Mistakes here will make your Profit & Loss cleanup pointless.

Resolve Accounts Receivable and Accounts Payable

Purpose: Get rid of fake balances that make it look like customers owe you money (or you owe vendors money) when they don’t.

Here’s what to fix:

• Find old invoices and bills that should have been closed out, duplicate entries, or invalid open balances
• Fix payments and credits that were applied to the wrong customer or vendor
• Make sure customer and vendor balances actually make sense

Why fix this now: Accounts Receivable and Accounts Payable affect both your Balance Sheet and your income, so they need to be correct before you start reviewing revenue and expenses.

Review Income and Expense Activity

Purpose: Make sure transactions are accurate and put in the right categories.

Here’s what to look for:

• Transactions that are in the wrong category
• Personal expenses, duplicate transactions, or non-business activity
• Income that was recorded incorrectly (like bank deposits coded directly to an income account without creating an invoice)

Why wait until after the Balance Sheet is clean? Once your cash accounts, Accounts Receivable, and Accounts Payable are correct, you can review your income and expenses with confidence.

Evaluate Payroll, Sales Tax, and Special Modules

Purpose: Fix high-risk areas that have tax and legal consequences.

Here’s what to review:

• Payroll liabilities and payroll clearing accounts
• Sales tax payable and make sure it matches what you filed with the state
• Inventory or job costing (if your business uses these features)

Why save this for later: These areas depend on the earlier corrections you made. They also often need to be checked against outside systems, tax filings, or government reports.

Final Reporting Review and Reasonableness Checks

Purpose: Make sure the cleanup actually worked.

Here’s what to do:

• Review your Balance Sheet and Profit & Loss to make sure the numbers make sense
• Compare trends across different time periods
• Make sure your reports match what you expected and what your bank statements and other documents show

Why do this last: This step is about double-checking your work, not finding new problems. If you did the earlier steps in the right order, you shouldn’t find many issues here.

Implement Controls to Prevent Another QuickBooks Cleanup

Purpose: Make sure the mess doesn’t happen again.

Here’s what to set up:

• Figure out what process failures caused the problems in the first place
• Recommend changes to procedures or how the QuickBooks file is set up
• Train on the QuickBooks workflows so that there’s an understanding of how money flows in QuickBooks.
• Make it clear who is responsible for keeping the books accurate going forward

Why this matters: Cleaning up QuickBooks without teaching people better habits or putting controls in place just means you’ll be back doing the same cleanup again next year.

Core Reasons Behind This Order

• Fix the structure before you fix individual transactions
• Clean up the Balance Sheet before the Profit & Loss
• Understand the problems before you start correcting them
• Prevention is just as important as correction