11 min read
How to Clean Up QuickBooks Online: The Complete Checklist
The complete QuickBooks Online cleanup checklist — reconciliations, chart of accounts, Undeposited Funds, AR/AP, and the balance sheet review, in the order a pro works.
QuickBooks Online is powerful, which also means it’s easy to make a mess in. Bank feeds get matched to the wrong things, Undeposited Funds quietly fills up, and the chart of accounts sprouts duplicates. This is the complete checklist for getting a QBO file back to clean — in the order a seasoned accountant actually works.
Work top-down from the balance sheet
The balance sheet is your checklist. Errors hide and compound there, and getting it right is what makes the profit & loss trustworthy. Do it one period at a time so the work stays reviewable. This is the same philosophy behind the general messy-books cleanup — here it’s applied specifically to QBO.
1. Reconcile every bank and credit card account
In QBO, use the Reconcile tool and match each account to its statement to the penny — credit cards included. If the beginning balance is already wrong, fix that before anything else; a bad starting point poisons every reconciliation after it.
2. Fix and merge the chart of accounts
Merge duplicates (in QBO, give one account the exact name of another), make each account the correct type, and remove one-off categories. Full detail lives in how to clean up your chart of accounts.
3. Clear Undeposited Funds and unapplied payments
Open Undeposited Funds and match anything older than a few days to a real bank deposit. This is where QBO files most often duplicate income. The step-by-step is in clearing unapplied payments & undeposited funds.
4. Resolve AR and AP aging
Review both aging reports for paid-but-open invoices, negatives, and phantom bills. See how to clean up AR / AP aging for the details.
5. Review the balance sheet and P&L
True up payroll liabilities, tie loan balances to statements, then read the balance sheet line by line. Does every number make sense? Run the reports monthly and compare periods so anomalies jump out.
If you can’t trust the balance sheet, you can’t trust anything else in QuickBooks.
Clean books shouldn’t require heroics.
🧹Clean Books is AI-native accounting built by a 30-year accountant — designed so the cleanup you just did stays done. Plain-English bank rules, reconciliations that don’t fight you, and reports that actually look like reports — not to mention the most amazing transaction search on the planet.
Sign in or Sign UpFrequently asked questions
How do I clean up QuickBooks Online?
Work top-down from the balance sheet. Reconcile every bank and credit card account to its statement, fix and merge the chart of accounts, clear out Undeposited Funds and unapplied payments, resolve stale AR and AP, true up payroll liabilities and loans, then review the balance sheet and profit & loss line by line. Do it one period at a time so the work stays reviewable.
How do I clean up Undeposited Funds in QuickBooks Online?
Open the Undeposited Funds account and look for payments sitting there longer than a few days. Each one should be matched to an actual bank deposit. If the deposit was already recorded straight to income, you likely have duplicated revenue — remove the duplicate and apply the original payment to the deposit instead.
How do I fix the chart of accounts in QuickBooks Online?
Merge duplicate accounts, make each account the correct type, and remove one-off categories nobody uses. In QBO you merge accounts by giving one the exact name of another. A lean, correctly typed chart of accounts is what makes your reports readable and accurate.
How long does it take to clean up QuickBooks Online?
A single clean year with good bank feeds can take a few focused days. Multiple years with payroll, inventory, or commingled personal spending can take weeks. Reconciling the bank accounts first is the fastest way to see how deep the cleanup goes.
Want a pro to handle the QBO cleanup? Browse the Clean Accountants and Bookkeepers Directory.