QuickBooks Cleanup Checklist for a New Client's Books
No account needed for your first conversions. We never store your bank login.
Short answer: A QuickBooks cleanup runs in a fixed order: scope the damage, fix the chart of accounts, get every bank and card account fully populated and reconciled from the earliest month forward, clear the suspense accounts, then close the year. Doing it in any other order means redoing work. The step most cleanups stall on is populating history, because a bank feed only reaches back about 90 days.
Every bookkeeper who takes on catch up work has inherited the same file. Two years of transactions sat in the bank feed, someone accepted them all with one click, the chart of accounts has four versions of Office Supplies, Undeposited Funds holds five figures, and nothing has been reconciled since the year before last. What follows is the order that works, and why each step has to come where it does.
What is a QuickBooks cleanup?
A QuickBooks cleanup is the process of bringing a neglected company file to a state where the financial statements can be trusted: every bank and card account reconciled to a statement, every transaction categorized to a real account, no duplicates, no orphaned balances in holding accounts, and a balance sheet that ties. It is not the same as catch up bookkeeping, which is entering transactions that were never recorded at all. Most real engagements are both.
What is the first step in cleaning up QuickBooks?
Scope before you touch anything. Run a Balance Sheet and a Profit and Loss for every year in the file, plus a Reconciliation Discrepancy report and an Audit Log review. You are looking for the size of the problem, not fixing it yet. Three numbers tell you almost everything: the balance sitting in Opening Balance Equity, the balance in Undeposited Funds, and the date of the last successful reconciliation on the main operating account.
Then take a backup, or in QuickBooks Online, understand that you cannot take one. That asymmetry matters. Desktop lets you snapshot the file before you start; Online does not, so an Online cleanup should be done in a deliberate order with the Audit Log as your safety net.
The cleanup checklist, in order
- Scope. Balance Sheet and P and L by year, Audit Log, reconciliation history, and the three diagnostic balances above.
- Fix the chart of accounts. Merge duplicates, retire accounts nobody uses, make sure account types are right. Do this before recategorizing anything, or you will recategorize twice.
- Populate every bank and card account in full. Every transaction, from the start date forward, with nothing missing. This is the step that actually takes the time.
- Remove duplicates. Before reconciling, not after.
- Reconcile forward, oldest month first. Never start from the current month.
- Clear the suspense accounts. Undeposited Funds, Opening Balance Equity, Ask My Accountant, Uncategorized Income and Expense.
- Review the balance sheet line by line. Loans, payroll liabilities, sales tax, owner draws.
- Close the period and set a closing password.
Why does step three take so long?
Because the bank feed will not give you the history. A connected feed in QuickBooks pulls roughly the last 90 days of transactions and will not reach further back, regardless of the bank. If your cleanup covers eighteen months, the feed hands you the last three and stays silent about the other fifteen. Nothing is broken, and reconnecting the bank does not help.
The route past it is a file import, which carries no date restriction at all. Download a CSV export from online banking for each range you need, convert it to a QuickBooks Web Connect (.qbo) file, and import that. QuickBooks Desktop has no native CSV transaction import, so for Desktop clients the .qbo is the only file that works. The mechanics are covered in the guide to importing older transactions into QuickBooks, and the converter itself is on the CSV to QBO converter home page.
| Phase | What you are checking | Red flag |
|---|---|---|
| Scope | Opening Balance Equity, Undeposited Funds, last reconcile date | Any balance in Opening Balance Equity older than the setup month |
| Chart of accounts | Duplicate and mistyped accounts | An expense posting to an asset account, or the reverse |
| Populate history | Every month present, no gaps | A gap that starts exactly 90 days ago, which is the feed window |
| Duplicates | Same date, same amount, same payee | A spike in a category the month a feed was connected |
| Reconcile | Beginning balance ties to the prior statement | Beginning balance discrepancy on month one |
| Suspense accounts | Undeposited Funds, Ask My Accountant | Deposits sitting in Undeposited Funds for over a year |
How do I find duplicate transactions in QuickBooks?
Sort the bank register by amount rather than by date. Duplicates line up next to each other immediately, which they never do in date order when one copy came from an import and the other from the feed. Then check the months around any date a bank feed was connected, since overlapping a feed with a file import for the same period is how most duplicates are born.
The structural fix is to prevent them. A converted .qbo file gives every transaction a unique ID, and QuickBooks uses that ID to recognize a transaction it has already imported and skip it. A raw spreadsheet upload has no such ID, so nothing stops the same rows going in twice. Convert, do not upload the CSV directly, and import the oldest range first.
How do I fix uncategorized expenses in QuickBooks?
Filter the P and L for Uncategorized Expense and Ask My Accountant, then work the list by vendor rather than by transaction. Vendors are consistent: once you know that a given payee is always software, you can recategorize every transaction from that payee in one pass with a rule, and the rule keeps working going forward.
What is left after the vendor pass is the genuinely ambiguous spending, usually cards and reimbursements with no documentation attached. That is a conversation with the client, not a guess. If they hand back a shoebox, it is faster to extract the totals and dates from the receipts automatically than to key them in, and it gives you something auditable to attach to each transaction.
How do I clean up Undeposited Funds?
A balance in Undeposited Funds means payments were recorded as received but never grouped into a bank deposit that matches the actual deposit on the statement. Open the account, compare its contents to real deposits on the bank statement, and use Bank Deposit to group the payments exactly as the bank grouped them. If a payment in there has no matching deposit at all, it was either never banked or it was recorded twice, once as a payment and once as a direct deposit in the register.
Why reconcile from the oldest month first?
Because the beginning balance of every reconciliation is the ending balance of the one before it. Reconcile March before January and March's beginning balance is built on transactions you have not verified yet, so a clean March tells you nothing. Start at the earliest month with a statement, tie it exactly, and move forward. Each month then confirms the one before it.
If month one will not tie, the opening balance is usually the culprit rather than the transactions. That has its own fix, covered in opening balance wrong in QuickBooks after import.
Should I start a new QuickBooks file instead of cleaning up?
Rarely, and less often than clients hope. Starting fresh throws away prior year comparatives, breaks the audit trail, orphans payroll history, and means the old file still has to be reconciled if a tax return was ever filed from it. The genuine cases for a new file are a file so corrupted it will not open, a change of entity type, or a Desktop file whose list limits have been exhausted. Everything else is cheaper to clean.
How long does a QuickBooks cleanup take?
Scope it by transaction volume and months, not by gut feel. The two variables that actually drive the hours are how many bank and card accounts need populating and reconciling, and how many months are unreconciled. A single checking account and twelve months is a different engagement from six accounts across two entities and three years. Do the scoping reports before you quote, because the diagnostic balances tell you which one you are looking at.
What reports should I run at the end?
Run the Balance Sheet and check that Opening Balance Equity, Undeposited Funds and Ask My Accountant are all zero, or that any remaining balance is one you can explain in a sentence. Run the P and L year over year and look for categories that jump for no operational reason, since that is where miscategorization hides. Run the reconciliation history and confirm an unbroken chain of reconciled months. Then close the books and set a closing date password so the work does not quietly unwind.
Where cleanups actually fail
Not on the accounting. They fail on data entry: someone tries to type in fifteen months of transactions, runs out of budget in month four, and hands back a file that is half clean, which is worse than one that is uniformly dirty because now nobody knows where the boundary is. Populate the history mechanically before you do any judgment work. Pull each range as a CSV, convert each one, import them oldest first, and only then start categorizing. If you are converting several accounts or a full year at once, the bulk CSV to QBO converter runs them in a single pass, and importing multiple CSV files covers the sequencing. For clients on Desktop, the CSV to QuickBooks Desktop page has the Web Connect import path, which is the only transaction import Desktop offers.