Most people who contact me about a cleanup have the same question: how bad is it, and what will it take to fix it?
The honest answer is that I don’t know until I look at the file. But I can explain what the process involves so you have a realistic picture before we start.
What “cleanup” means
A cleanup is the process of making your QuickBooks file agree with reality. That means:
- Every bank account and credit card reconciles against the corresponding statements
- Every transaction is categorized to the right account
- There are no duplicate entries, unresolved undeposited funds, or stale journal entries sitting open
- The P&L shows the actual profit or loss for each period
- The balance sheet shows real, accurate balances, with no negative equity and no accounts that should be zero but aren’t
If your file has never been formally reconciled, or if it has been maintained inconsistently, most of these will be off. The cleanup is the work of going through each one and fixing it.
The typical steps
1. Review the file as-is
Before touching anything, I take a full picture of what’s there. I look at:
- How many unreconciled months there are, per account
- How many uncategorized transactions
- Whether there are duplicate accounts or a chart of accounts that has grown organically without structure
- Any obvious mispostings, such as income posted to expense accounts or payments posted to the wrong vendor
This is the diagnostic stage. It tells me roughly how long the cleanup will take and where the biggest problems are.
2. Fix the chart of accounts
If the chart of accounts has grown messy, with duplicate accounts, accounts used for the wrong purpose, or income and expense accounts mixed up, I correct the structure first. Moving transactions to the right account later is much harder if the accounts themselves are wrong.
3. Clear duplicates and stale entries
Duplicate transactions and stale journal entries (entries recorded without a corresponding real-world event) create phantom balances. I find these by comparing the ledger to source documents such as bank statements, invoices, and payment confirmations, and remove the ones that shouldn’t be there.
4. Categorize uncategorized transactions
Every uncategorized transaction is a gap in your P&L. I go through them systematically, matching each one to the right expense or income category based on the payee, description, and amount. For larger files this is the most time-consuming part of the cleanup. When I can’t tell what a transaction was for, I ask you.
5. Reconcile account by account
Starting from the earliest affected period, I reconcile each bank account and credit card against its statement. This involves matching each ledger entry to its statement line and clearing it. Anything that doesn’t match, such as missing entries, wrong amounts, or transactions in the wrong period, gets investigated and corrected.
6. Ask you about what the records can’t show
Some answers aren’t in the file. Which expense belongs to which project or job, which deposit paid which invoice, what an unclear transaction was for: only you know that. I’ll send you questions as I go, and the cleanup can only be as complete as the answers I get.
7. Review the financial statements
Once reconciliation is complete, I review the P&L and balance sheet for anything that still looks wrong. A large expense in an unusual category, a balance that should be zero, a period where income looks implausibly high or low. These often indicate one more error to trace.
8. Stand behind every change
Every change I make in QuickBooks Online is traceable, and I can walk you through any of it. That matters for your accountant or tax preparer, who’ll need to understand what happened to each period.
How long does all of this take? It depends on the size of the file, how many years are behind, and how many accounts are involved. I give a realistic estimate after reviewing the file, not before. If you aren’t sure how messy your books are, the first step is to book an intro call and we can take a look together.