QuickBooks cleanup, step by step
Updated 16 October 2026
A QuickBooks cleanup is a review and correction of a QuickBooks file whose figures no longer match the company's real accounts. The work fixes transactions posted to the wrong account, reconciles accounts that are out of balance, removes duplicates and tidies the chart of accounts. At the end, the financial statements agree with the bank and card statements and can be used again. The worked examples below use round figures, and the figures are an illustration.
How a file drifts out of line
QuickBooks makes a transaction quick to record, and a wrong one just as quick. One error a month goes unnoticed. Twelve months of them change the totals on every report. A cleanup starts by listing the kinds of error in the file.
Five kinds come up in most files. Expenses are posted to the wrong account, or parked in the "Ask My Accountant" account and left there. Bank and card accounts have never been reconciled, or stopped agreeing with the statements months ago. The same transaction appears twice, invoices have been deleted, or a payment sits against the wrong customer. The chart of accounts has too many accounts, or accounts that repeat each other. Customer payments sit in undeposited funds without being matched to a bank deposit.
The figures are an illustration. A company's "Ask My Accountant" account holds $24,600 from 61 transactions over nine months, about 7 a month. None of the 61 appear in the expense lines where they belong. The profit and loss statement overstates profit by $24,600 until each transaction is posted to its proper account.
Signs a file needs a cleanup
The balances on the reports differ from the bank balances. The CPA raised questions about the books at tax time. Reconciliations are months behind. The owner reads a report and doubts it. A loan, a sale or an audit is coming, and the books will be examined by someone outside the company. An owner who cannot say whether a report is accurate has the clearest sign of all.
The figures are an illustration. A lender asks for 24 months of financial statements. The owner's operating account has not been reconciled for 8 of those months. The cleanup reconciles those 8 months first, so the statements the lender receives agree with the bank statements for all 24.
The steps in order
A cleanup runs in a fixed order. First comes a review of the file to scope the problems and the months they cover. Next, every bank and card account is reconciled against its statements. Then the wrong postings and the duplicates are corrected, and the chart of accounts is rebuilt. Open items such as undeposited funds are resolved. The final step is a corrected set of financial statements.
Reconciliation comes early because it shows which transactions are missing or doubled. The corrections that follow then work from a complete list.
The figures are an illustration. The books show $41,250.00 in the operating account at month end. The bank statement shows $38,975.40. The difference is $2,274.60. The review finds a deposit of $1,850.00 entered twice and two bank fees totaling $424.60 that were never recorded. Removing the duplicate and posting the fees brings the two balances together.
Rebuilding the chart of accounts
The chart of accounts is the list of accounts every transaction posts to. Over the years, users add accounts with similar names and stop using others. A rebuilt chart has one account for each kind of income and cost, named so the owner and the CPA can read the reports without a separate list of codes.
The figures are an illustration. A file has 212 accounts, including four versions of "office supplies" and three of "vehicle expense." The cleanup merges repeats and makes unused accounts inactive. The chart ends with 74 active accounts, so 138 accounts, or 65.1%, are merged or made inactive.
Clearing undeposited funds
Undeposited funds is the QuickBooks account where customer payments wait to be recorded as part of a bank deposit. Payments received and never properly deposited in the books pile up there. Until they are cleared, the bank account in the books and the bank statement disagree.
The figures are an illustration. Undeposited funds holds three customer payments of $4,200, $5,100 and $5,500, which total $14,800. The bank statements show all three were deposited months ago. The cleanup matches each payment to its deposit, and the undeposited funds balance falls to zero.
Cleanup and catch-up are different jobs
Catch-up applies to books that are behind. The transactions were never entered, and months of them need recording. Cleanup applies to books that were entered with errors. The records exist and need correcting. Many files need both.
The figures are an illustration. A company's file has 12 months of entries with errors, followed by 5 months with nothing entered. The cleanup corrects the first 12 months. The catch-up records the 5 empty months from bank statements and receipts, on top of the corrected balances.
Owner or professional
An owner with a small file and a few months of drift can sometimes correct it alone. A file with broken reconciliations, a tangled chart of accounts or errors that run past a year needs someone who knows what the correct result looks like. A wrong correction can add new errors to the file. Averan's team includes Certified QuickBooks ProAdvisors, and each cleanup ends with the file set up to stay accurate.
The figures are an illustration. File A has one bank account, 3 months unreconciled and 20 transactions in "Ask My Accountant." File B has four bank and card accounts, 18 months unreconciled and 212 accounts in its chart. The owner of File A can work through it in a weekend. File B goes to a professional.
What this means for an owner
A cleanup corrects a file whose reports disagree with the bank. It runs in order: review, reconcile, correct, rebuild the chart, clear open items, then produce corrected statements. Catch-up records months that were never entered, and many files need both. A file with more than a year of errors or two or more broken accounts goes to a professional.
QuickBooks cleanup with Averan
Averan Advisors reviews a QuickBooks file and returns a written list of what the cleanup will cover. See QuickBooks cleanup for that work, how long a cleanup takes, and bookkeeping and monthly close for keeping the file accurate afterward.
The QuickBooks resources hub covers monthly QuickBooks bookkeeping, cleanup, setup, migration and file repair.
If you want this done for you
What happens next
Reading about it and having it done are different things. Here is exactly what happens if you want the second one.
- The call takes thirty minutesYou describe the business and where the numbers are letting you down. We give you an expert view of your situation, and what we would start with. There is no pitch deck.
- We look at the fileYou give us read access to the books as they are. We come back with what is wrong, what it will take to fix, and whether the answer is bookkeeping, controller work, or something else.
- We send a written scope and a priceIt lists what we do each month, what you get, the date it lands and the fee. We agree it before anything starts, and it does not change unless you agree.
- We take over the books and close the first monthWe set up access and systems and enter the opening balances. The first close lands on the date in the scope, and every one after it does too.