QuickBooks Cleanup Checklist: How to Clean Up QuickBooks Online Step by Step

Last updated August 2026.

A QuickBooks cleanup is the process of correcting a company file so the reports can be trusted: fixing the chart of accounts, categorizing what was left uncategorized, clearing out opening balance equity and undeposited funds, importing any history the bank feed never pulled in, and then reconciling every account for every month in order. Most files that need one have the same handful of problems, and they have to be fixed in sequence. Categorizing before the opening balances are right just means categorizing twice.

What is a QuickBooks cleanup?

A cleanup fixes a file where the bookkeeping was done, but done wrong. Transactions were coded to the wrong account, the same expense got entered twice through both the bank feed and a manual entry, personal spending sits in business expenses, and nothing has been reconciled in months. The balance sheet stops making sense, the profit and loss swings for no reason, and the CPA sends the file back.

That is different from catch up bookkeeping, where the transactions were simply never entered. In practice most engagements are both at once, and both start from the same place: every bank and credit card statement for the period, converted into rows you can actually work with. If you are scoping a job that covers a year or more, the bookkeeping cleanup and catch up workflow page covers how to get the whole backlog into a spreadsheet before you touch the file.

The QuickBooks cleanup checklist

Work these in order. The sequence matters more than the individual steps, because several of them will silently undo each other if you run them out of order.

1. Confirm the cleanup period. Find the last correctly filed tax return and the last month that was genuinely reconciled. That date is your starting line. Anything before it should be left alone unless you plan to amend a return.
2. Close the books through that date. Set a closing date with a password in Accounts and Settings so nobody, including you, changes a period that already tied to a filed return.
3. Gather every statement. Pull each month of every checking account, savings account, credit card, loan, and payment processor for the whole cleanup period. Get all pages, not just the summary page.
4. Review the chart of accounts. Merge duplicates, make inactive the accounts nobody uses, and check that the account types are right. A liability sitting under expenses will throw off both the balance sheet and the return.
5. Fix the opening balances. Tie the first day of the cleanup period to the last filed return. This is the step people skip, and every month after it inherits the error.
6. Import the missing history. Pull in whatever the bank feed did not reach, because a fresh feed connection typically brings only about 90 days.
7. Clear the uncategorized accounts. Work the uncategorized income, uncategorized expense, and uncategorized asset accounts down to zero, using the statement descriptions rather than guesswork.
8. Separate personal from business. Reclass owner spending to draws or distributions instead of leaving it in expenses.
9. Empty opening balance equity. Anything left in that account is an unexplained difference, not a real equity balance.
10. Clear undeposited funds. Match received payments to the deposits that actually hit the bank, rather than letting them stack up indefinitely.
11. Look for duplicates. Sort by amount and by date. Duplicates usually come from a manual entry plus a matched bank feed transaction for the same payment.
12. Split loans and payroll. Break loan payments into principal and interest, and make sure payroll liabilities agree with the 941s and state returns that were actually filed.
13. Reconcile every account, every month, in order. Do not skip ahead. A month that does not tie means something upstream is still wrong.
14. Read the finished reports. Run the profit and loss by month and look for spikes. Check the balance sheet for negative asset balances, stale liabilities, and accounts receivable that should have been written off.

Cleaning up the chart of accounts

Start here because everything else codes into it. The usual damage is duplication: three accounts that all mean office supplies, a vendor accidentally created as an account, and expense accounts nobody can map to a line on the tax return. Merge the duplicates rather than deleting them so the historical transactions follow the merge. Make unused accounts inactive instead of deleting them, which keeps prior year reports intact.

The test for whether the chart of accounts is finished is simple: can you point at each account and say which line of the tax return it feeds? If not, it needs consolidating. Twenty accounts you can defend beat eighty you cannot.

Opening balance equity and undeposited funds

These two accounts are where QuickBooks quietly parks anything it could not resolve, and a balance in either one is a symptom rather than a number. Opening balance equity fills up when accounts are created with a starting balance, when a conversion from another system leaves a gap, or when a reconciliation is forced. It should end at zero, with the amounts moved to retained earnings, owner equity, or wherever they actually belong. Our explainer on what opening balance equity is in QuickBooks covers where the balance comes from and how to clear it properly.

Undeposited funds holds payments that were recorded as received but never grouped into a deposit that matches the bank. A growing balance means the bank deposit was entered separately, so the income is now counted twice. The fix is to match each received payment to the actual deposit, which is covered in what undeposited funds means in QuickBooks.

Getting the missing history into QuickBooks

This is where most cleanups stall. Connecting a bank feed to a new account in QuickBooks Online typically pulls only about 90 days of history, and the exact window depends on the bank. If the cleanup covers 18 or 24 months, the feed will not bring the older period in no matter how many times you reconnect it.

The dependable route is to import the history yourself. Convert the statement PDFs into a QuickBooks ready CSV with date, description, and amount columns, or into a QBO file so the transactions land in the bank feed review queue exactly as a live feed would deliver them. The QuickBooks bank statement converter handles both formats, and importing old bank transactions into QuickBooks Online walks the screens. Convert the whole period in one batch rather than a month at a time, because a single combined sheet is the only way to spot the gaps before you import.

One check before importing anything: confirm the closing balance of each month equals the opening balance of the next. If the chain breaks, a statement is missing, and finding that now costs minutes instead of a re-reconciliation later.

Reconciling every month in order

Reconciliation is what proves the cleanup worked. Go account by account, month by month, oldest first, and match the ending balance in QuickBooks to the ending balance on the statement. Do not move forward from a month that does not tie.

The most common blocker is a beginning balance that does not match, which usually traces back to a transaction that was edited or deleted after a prior reconciliation. Fixing a beginning balance discrepancy in QuickBooks is its own process and needs to happen before the current month will close. If the file balance simply disagrees with the bank at large, the reasons a QuickBooks balance differs from the bank narrows it down quickly.

How do I clean up QuickBooks Online?

Set a closing date through the last filed return, fix the chart of accounts, correct the opening balances, then import any history the bank feed missed. From there, categorize the uncategorized accounts down to zero, reclass personal spending to owner draws, clear opening balance equity and undeposited funds, remove duplicates, and reconcile every account for every month in date order. Finish by reviewing the profit and loss by month and the balance sheet for anything that still looks wrong.

Bulk categorization is where the hours go, so use the tools built for it. Sorting by description groups recurring vendors together, and bank rules handle the ones that repeat every month. The guide on categorizing bank transactions in QuickBooks Online covers rules and batch actions, and recording owner draws and contributions covers the personal spending that always turns up.

How long does a QuickBooks cleanup take?

Budget roughly two to six weeks per year of history. A file twelve months behind with moderately messy books commonly finishes in four to eight weeks, and twenty four months of badly neglected records can run twelve to twenty weeks. Transaction volume and the number of accounts drive the estimate far more than the calendar span does. A single checking account with forty transactions a month is a different job from three accounts, two cards, and a payment processor.

How much does a QuickBooks cleanup cost?

US bookkeeping practices generally price cleanup by month of backlog rather than by the hour. Benchmarks published during 2026 tend to cluster around 150 to 300 dollars per month behind for simple books, 300 to 600 dollars for medium complexity, and 600 to 1,200 dollars or more where payroll, inventory, or multiple entities are involved. Those ranges assume roughly 50 to 150 transactions a month for a single entity, and files with payroll or multiple entities commonly run 30 to 50 percent higher. Treat them as a sanity check on a quote, not a price list.

Can I clean up QuickBooks myself?

Yes, if the file is a year or less behind, has one or two accounts, and the errors are mostly categorization. The checklist above is the whole job in that case. Bring in a professional when there are unfiled returns, payroll liabilities that do not agree with the filed forms, inventory, multiple entities, or a prior year that was already reported from numbers you now know were wrong. Those situations involve tax positions, not just data entry, and the cost of getting them wrong is larger than the fee.

Whoever does the work, the same rule applies afterward: a cleanup only holds if the habits change. Reconcile monthly, keep the closing date password set, and get expense documentation captured as it happens rather than at year end. Firms that keep receipts read and categorized automatically as they come in tend not to need a second cleanup, because the gap between the transaction and its documentation never opens.

QuickBooks cleanup vs catch up bookkeeping

A cleanup corrects entries that exist. Catch up creates entries that were never made. The QuickBooks work differs at the front end, since catch up is mostly importing and categorizing while cleanup is mostly correcting and reclassing, but both converge on the same finish line: every account reconciled to the statement for every month in the period. Scope them separately when you quote, because a file that needs both is not the same job as a file that needs one. The cleanup and catch up bookkeeping page compares the two side by side and covers converting the statement backlog that either one runs on.