Before you start: two safety rules
- Note today's numbers first, total income, expenses, and every balance sheet account. You want to know what your fixes changed.
- Never edit closed, filed years without a plan, changes to years already on a tax return create mismatches; corrections for closed years belong in journal entries dated in the current period, or in an amended-return conversation.
The checklist
1. Hunt duplicate transactions
The most common QuickBooks disease, usually from bank feed double-imports or manual entries colliding with feed entries. Sort each account's register by amount and scan for pairs on nearby dates. Fix the source too: if entries were made manually and the feed added them again, the workflow needs to change, not just the data.
2. Empty the 'For Review' backlog
Everything sitting in the bank feed queue gets categorized or matched, oldest first, building bank rules as patterns emerge. Match to existing invoices and bills where they exist; 'Add' creates duplicates when a matching entry is already in the register.
3. Clear Uncategorized and 'Ask My Accountant'
Uncategorized Income, Uncategorized Expense, and Ask My Accountant are holding pens, not categories. Every dollar in them moves to a real account. Can't identify a charge? Park it on a dated list to resolve in batches, don't let ten mysteries stall a thousand knowns.
4. Fix Undeposited Funds
If this account holds more than a few days of receipts, payments were recorded but never 'deposited' in QuickBooks, meaning income may be double-counted or deposits unmatched. Match each stuck payment to its real bank deposit. (Detailed walkthrough: How to Fix Undeposited Funds in QuickBooks Online .)
5. Scrub AR and AP aging
Run both aging reports. Invoices customers actually paid, bills you actually settled, and ancient balances nobody will ever collect get resolved, matched, credited, or written off. Ghost receivables overstate income; ghost payables overstate obligations; both make the reports lie.
6. Reconcile every account, every month
The heart of the cleanup. Bank accounts, credit cards, and loans each get reconciled monthly against statements, oldest month first. Discrepancies mean duplicates, missing entries, or amount errors, find them now, while the month is isolated. If reconciliations have never been done and won't balance, this is the checkpoint where DIY projects most often (and correctly) become professional ones.
7. True up loan balances
Every loan and line of credit in QuickBooks should match the lender's statement to the dollar. The classic error: payments booked entirely as expense instead of split between principal and interest, leaving loan balances frozen in time.
8. Tie payroll to filings
Payroll expense and liability accounts must match what your payroll provider actually filed, quarterly 941 totals, W-2 totals. Mismatches here mean the P&L is wrong, the filings are wrong, or both, and this is the one area where errors carry government penalties. Escalate mismatches you can't explain.
9. Read the balance sheet for fiction
Negative loan balances, negative payroll liabilities, an Opening Balance Equity balance, asset accounts nobody recognizes, each is a thread; pull it. A balance sheet that can't be explained line by line isn't done. (Common causes decoded: Why Your QuickBooks Balance Sheet Is Wrong (and How to Fix It) .)
10. Review the chart of accounts
Merge duplicate categories ('Fuel', 'Gas', 'Gasoline'), deactivate the unused, and make sure the structure reflects how you actually operate, direct costs as COGS, overhead as expenses, so gross margin means something.
11. Re-run the comparison
Compare P&L and balance sheet against the numbers you noted at the start. Big swings should have explanations you can say out loud. If income changed materially for a filed year, your tax preparer needs to know.
12. Lock it and build the habit
Set a close date with a password so cleaned periods stay clean, then install the routine that prevents round two: feeds reviewed weekly, reconciliations monthly, a real close date. Cleanups that end without a system get repurchased within eighteen months.
When to stop DIY-ing this
Honest triggers, from someone who cleans these files for a living: reconciliations that won't balance across multiple accounts, payroll that doesn't tie to filings, multiple unfiled years, or a balance sheet you can't narrate. Those files are past checklist territory, get a diagnostic and a fixed-fee quote instead of donating three more weekends. Cleanup & Catch-Up Bookkeeping Services