For Small Business
How to Clean Up QuickBooks: Find and Fix Common Errors
To clean up QuickBooks, work through the high-impact problem areas in order: reconcile every bank and credit card account, clear out the Undeposited Funds account, resolve Opening Balance Equity, remove duplicate transactions, categorize anything uncategorized, and review aged receivables and payables. Fixing these restores accurate financials.
- 6 — highest-impact cleanup areas
- $0 — where Opening Balance Equity should end up
- Monthly — reconciliation keeps books clean
1. Reconcile every account
Unreconciled accounts are the root of most QuickBooks problems. Reconcile each bank and credit card account to its statement so your books match reality. Anything that won't clear points to a duplicate, a missing transaction, or a miscoded entry.
2. Clear out Undeposited Funds
Undeposited Funds is a holding account for payments received but not yet deposited. When old payments pile up there, it usually means deposits were recorded twice or never matched to a bank deposit. Match each payment to an actual deposit to empty it.
3. Fix Opening Balance Equity
Opening Balance Equity should be zero once setup is complete. A lingering balance means opening balances were entered without an offset. Reclassify those amounts to the correct equity or asset accounts so the account zeroes out.
4. Find and remove duplicates
- Duplicate bills or vendor payments from manual entry plus a bank feed.
- Duplicate deposits from recording income twice.
- Duplicate invoices sent to the same customer.
5. Categorize uncategorized transactions
Uncategorized income and expenses distort your profit and your tax deductions. Review the Uncategorized accounts and assign each transaction to the right category, adding vendor and customer names where they're missing.
6. Review A/R and A/P aging
Stale receivables overstate the cash you'll actually collect; old payables may already be paid. Write off or collect invoices past 90 days, and apply any unapplied payments and credits sitting on customer or vendor accounts.
Note: Doing this by hand takes hours. QB Assistant scans all of these areas at once, scores them, and shows you the exact transactions to fix.
Frequently Asked Questions
Why is my Undeposited Funds account so high?
It usually means payments were recorded as received but never matched to an actual bank deposit, or deposits were entered twice. Match each payment in Undeposited Funds to a real bank deposit to clear it.
What is Opening Balance Equity and why isn't it zero?
Opening Balance Equity is a temporary account QuickBooks uses during setup. A non-zero balance means opening balances were entered without a proper offset; reclassify them to the correct accounts so it returns to zero.
How do I find duplicate transactions in QuickBooks?
Review bank-feed matches against manually entered bills and deposits, sort registers by amount and date to spot repeats, and check for the same invoice or payment entered twice. QB Assistant detects likely duplicates automatically.
How long does it take to clean up QuickBooks?
Manually, a year of messy books can take many hours across several sessions. An automated scan identifies the issues in minutes so your cleanup time goes to fixing, not finding.
Related Guides
Sources & References
- QuickBooks Online help documentation
- Standard bookkeeping cleanup practices
This article is general information, not legal, tax, or accounting advice.