Here’s a secret that will save you hours of work: You can find most of the problems that need fixing in a QuickBooks cleanup without opening a single transaction. All you need to do is review the right reports in the right order.

Below are the essential reports you need to check, along with why each one matters and what problems it will help you find.

Balance Sheet (Accrual Basis)

This is the single most important report for diagnosing QuickBooks problems.

Why start with the Balance Sheet?

The Balance Sheet is like a health checkup for your entire QuickBooks file. Here’s why it’s so powerful:

• It builds up over time and shows everything from day one, so historical problems show up here
• It exposes structural problems, posting errors, and process failures immediately
• If the Balance Sheet is wrong, everything else in QuickBooks is wrong too

What problems does it reveal?

• Negative balances in asset accounts (like cash, accounts receivable, or inventory)
• Accounts that shouldn’t have balances sitting in them (like Undeposited Funds or clearing accounts)
• Old or mysterious equity balances that don’t make sense
• Payroll liabilities, loan balances, or sales tax payable that look wrong
• Accounts that haven’t changed in years (which usually means they’re abandoned or being used incorrectly)

The test: You should be able to “tell the story” of the business just by looking at the Balance Sheet. If you can’t, there’s a problem that needs fixing.

Profit & Loss (Accrual Basis)

Use this report to spot patterns, not to fix details yet.

How the Profit & Loss helps with QuickBooks cleanup

This report helps you identify two main issues:

• Problems with how transactions are categorized
• Problems with when income and expenses are being recorded

What issues does it reveal?

• Income or expense categories that are unusually high or unusually low
• Expense accounts that have credits in them, or income accounts that have debits (both are red flags)
• Missing Cost of Goods Sold
• Income spikes caused by bank deposits being recorded directly to income accounts (without creating invoices first)
• Payroll costs or contractor payments showing up in the wrong section

Important: You’re not fixing the Profit & Loss yet. You’re just learning how transactions are being recorded so you understand what’s broken.

Balance Sheet Comparison (This Year vs Last Year)

This is your “what changed?” report.

Why it matters for QuickBooks cleanup

This comparison report helps you:

• Figure out when the problems started
• Identify which accounts are actively being misused right now

What problems does it uncover?

• Sudden increases in Accounts Receivable, Accounts Payable, or Undeposited Funds
• New equity accounts that appeared in the middle of the year (a major red flag)
• Loan balances that are growing without any corresponding loan activity
• Accounts that used to be reconciled but suddenly stopped

This report helps you determine whether the cleanup needs to go back years or just fix recent months.

Accounts Receivable Aging Summary (Your First QuickBooks Cleanup Clue)

This is a high-risk report that often reveals major problems. If you or the business owner are reviewing this report several times each month it will show you quickly if you need to fix some things.

Why it’s critical for QuickBooks cleanup

Problems with Accounts Receivable mess up two important things:

• Your income statements (making it look like you made more or less money than you actually did)
• Your cash flow (making it unclear who actually owes you money)

Many QuickBooks files have Accounts Receivable balances that aren’t even real.

What does this report reveal?

• Old invoices that should have been closed out a long time ago
• Credit balances on customer accounts (which means the customer overpaid or a payment was applied twice)
• Customers showing balances but no recent activity
• Accounts Receivable totals that don’t match what’s on the Balance Sheet

The bottom line: If the AR aging doesn’t make sense, your revenue numbers are probably wrong.

Accounts Payable Aging Summary

Use this report to check if expenses and liabilities are accurate.

Why it’s important

Accounts Payable errors are extremely common, especially when:

• Bills are skipped and expenses are entered directly
• The same bill gets entered twice

Vendor balances often contain old or invalid items that should have been cleaned up years ago.

What does this report reveal?

• Old unpaid bills that shouldn’t exist anymore
• Vendor credits that were never applied to bills
• Negative vendor balances (which usually means a payment was applied twice or to the wrong vendor)
• Accounts Payable totals that don’t match the Balance Sheet

This report helps you figure out whether your expenses and liabilities are overstated (making it look like you owe more money than you actually do).

Reconciliation Reports (or Reconciliation Status)

You’re checking whether reconciliations exist, not fixing them yet.

Why experienced bookkeepers always check this

Here’s the truth:

• Reconciled accounts are way more trustworthy than unreconciled accounts
• Unreconciled accounts almost always mean there are deeper problems in the file

What does this reveal?

• Accounts that have never been reconciled
• Reconciliations that stopped months or even years ago
• Large unexplained differences between QuickBooks and the bank
• Bank accounts with balances that don’t even come close to reality

Key point: Almost every QuickBooks cleanup starts with knowing which accounts are reconciled and which ones aren’t.

General Ledger (Filtered, Not Full Detail)

Use this report selectively, not line-by-line.

Why QuickBooks ProAdvisors use the General Ledger

The General Ledger helps you identify patterns in how accounts are being misused. You’re looking for repeated mistakes, not individual transactions.

What does it reveal?

• Equity accounts being used over and over instead of income or expense accounts
• Opening Balance Equity getting hit with transactions after the initial setup (a major red flag)
• Journal entries being used to “force” account balances to match
• Transactions posted directly to Accounts Receivable or Accounts Payable accounts (bypassing the invoice and bill system)

At this stage, you’re using pattern recognition, not hunting through transactions one by one yet.

Chart of Accounts

This is a structural diagnostic tool.

Why it matters for QuickBooks cleanup

A messy Chart of Accounts guarantees messy reports. It’s that simple.

What does it reveal?

• Duplicate or redundant accounts
• Too many income and expense accounts (making reports confusing and hard to read)
• Accounts with misleading names or the wrong account type
• Accounts set up as the wrong type (like an expense account set up as an asset)

Important: Many cleanup problems start with a poorly designed Chart of Accounts. If the structure is wrong from the beginning, everything built on top of it will be wrong too.

Audit Log (QuickBooks Online)

Use this to understand user behavior and how problems are being created.

Why it’s useful

The Audit Log shows you how the problems are happening, not just what the problems are.

What does it reveal?

• Deleted or altered transactions
• The same transactions being edited over and over by non-accounting users
• Bulk changes that explain sudden shifts in account balances

This report helps you figure out whether the problem is:

• A training issue (people don’t know how to use QuickBooks correctly)
• An access issue (too many people have permission to make changes)
• A process issue (there are no procedures in place to prevent mistakes)

The Key to Successful QuickBooks Cleanup

Here’s what experienced bookkeepers know: You should be able to identify 80-90% of the problems in a QuickBooks file just by reviewing these reports.

Before you start touching any transactions, you should be able to answer these four questions:

• What is wrong?
• Where is it wrong?
• How far back does it go?
• Is this a structural problem, a procedural problem, or a transactional problem?

Only after you’ve diagnosed the problems using these reports should you begin the actual cleanup work.