Most messy books don't start messy. They drift. A bank feed gets connected and transactions are accepted without checking. A busy season means three months go unrecorded. Someone new takes over and codes things differently. By the time anyone notices, the numbers can't be trusted.

Here are the seven signs I see most often, what each one means, and what fixing it involves.

1. Your QuickBooks bank balance doesn't match your bank statement

This is the clearest sign of all. If the balance in QuickBooks for your checking account doesn't match your bank statement for the same date, something is missing, duplicated or wrong.

The usual causes are bank feed transactions added twice, payments recorded in the wrong account, or a past reconciliation that was undone or edited.

2. Money is sitting in Uncategorized Income or Uncategorized Expense

QuickBooks uses these accounts when a transaction is accepted without a category. A few items waiting to be reviewed is normal. Thousands of dollars sitting there for months is not.

Those transactions are missing from your real income and expense lines, so your profit and loss statement is wrong.

3. Ask My Accountant has become a dumping ground

Ask My Accountant is meant to hold the occasional transaction you genuinely aren't sure about. When it holds months of activity, it's a sign that nobody has had time to review the books properly.

4. Customers show as owing money they already paid

If your accounts receivable report shows large balances you know have been paid, payments were probably recorded without being applied to the invoices. In one cleanup I worked on, 224 sales invoices had been posted to receivables instead of the bank. That created an $84K balance that didn't exist.

5. Duplicate suppliers, customers or transactions

The same supplier entered three different ways splits your spending across three names. Duplicate transactions inflate your expenses. In another cleanup, QuickBooks held 822 supplier names against a real list of 282.

6. Months with nothing recorded

Gaps happen when the person doing the books leaves, or when the business gets too busy. Missing months mean missing income and expenses, and they make the next tax filing much harder.

7. Your accountant or lender asked for clean books

If your accountant has sent the file back, or a bank has asked for financial statements you can't produce with confidence, you need a cleanup.

What does a QuickBooks cleanup involve?

A proper cleanup is done month by month, starting with the oldest problem month:

  1. Review the file. List every issue before changing anything.
  2. Reconcile each account. Match every bank, credit card and loan account to its statement, one month at a time.
  3. Recode and correct. Move transactions to the right accounts, merge duplicates and apply payments to invoices.
  4. Clear the holding accounts. Empty Uncategorized Income, Uncategorized Expense and Ask My Accountant.
  5. Document every change. Post correcting entries with a clear description, so your accountant can follow them.
  6. Review the reports. Check the profit and loss statement and balance sheet before handing over.

Can you clean up QuickBooks yourself?

If the problem is small, such as a few months of uncategorized transactions in one account, you can often fix it yourself with your bank statements and some patience.

If the problems run across several accounts or more than a few months, a bookkeeper will usually find the root cause faster. That's especially true if earlier reconciliations were wrong.

How long does a cleanup take?

It depends on how many months and accounts are involved and how complete your records are. A cleanup of up to three months for two accounts can take about a week. A full-year rebuild takes around three weeks.