QuickBooks Cleanup Checklist (Step-by-Step Guide)
Cleaning up QuickBooks can feel overwhelming — especially if issues have built up over time. Transactions don't match. Payments aren't applied. Accounts don't reconcile cleanly. This checklist breaks the process into simple steps so you can work through your books methodically and fix the most common problems.
When to use this checklist
This checklist is most useful when:
- your reports don't match your bank balance
- you're preparing for taxes
- you're handing books to an accountant
- your QuickBooks file hasn't been reviewed in a while
If things feel "off," this is a good place to start.
QuickBooks cleanup checklist
Work through these steps in order. Each one targets a specific issue that's common in messy QuickBooks files.
1. Review duplicate transactions
Look for transactions recorded more than once
Check bank feeds, compare amounts and dates, and remove duplicates carefully — make sure one valid transaction always remains.
Learn more2. Apply unapplied payments
Find payments that aren't linked to invoices
Run the Unapplied Cash Payment Income report, match each payment to its invoice, and verify customer balances clear.
Learn more3. Clear Undeposited Funds
Make sure payments are properly grouped into deposits
Review the Undeposited Funds account, match payments to bank deposits, and remove incorrect entries.
Learn more4. Fix Opening Balance Equity
Check for leftover setup balances
Review the account, move balances to the correct equity accounts, and confirm Opening Balance Equity is cleared.
Learn more5. Categorize uncategorized transactions
Assign categories to all income and expenses
Review uncategorized entries, assign appropriate accounts, and confirm reports update correctly.
Learn more6. Review account balances
Look for anything unusual:
- negative balances where they shouldn't exist
- accounts that don't match expectations
- inconsistencies across reports
7. Reconcile accounts
Make sure QuickBooks matches your bank:
- reconcile each account
- investigate discrepancies
- resolve unmatched transactions
What this checklist doesn't catch
This checklist covers the most common issues, but it requires manual review. If your file is large or messy, it's easy to miss:
- hidden duplicate transactions
- unapplied payments across multiple customers
- partial or incorrect deposits
- small inconsistencies that add up
Faster way to clean up QuickBooks
Instead of working through everything manually, upload your QuickBooks export and automatically detect all major cleanup issues in one place.
You'll get a full list of problems, the affected transactions, and step-by-step instructions to fix everything. This turns a multi-hour process into a few minutes.
Typical cleanup results
Across a single messy file, common findings include $2,800 in duplicate transactions, $3,200 in unapplied payments, and $5,100 in Undeposited Funds.
- 1Upload your QuickBooks General Ledger CSV.
- 2Review the cleanup plan ordered by severity and impact.
- 3Work through each issue using the step-by-step instructions.
- 4Re-upload after fixes to verify the issues are gone.
Run a full QuickBooks cleanup check in minutes.
Upload your file and get a complete breakdown of what needs to be fixed.
$29 per report. One-time. No subscription.
Related guides
This tool helps you identify and fix common QuickBooks issues. It does not replace professional accounting advice.