QuickBooks Cleanup Checklist — Free Printable & Spreadsheet
Work through a practical QuickBooks cleanup checklist with evidence to collect, saved checkboxes, a free spreadsheet download, and a print-friendly version.
By CleanUp for QuickBooks · Updated
Start with the period you are cleaning up
Choose the statement period or year you need to review. Save starting reports and resolve one account or issue at a time. The checklist is a working aid for business owners and bookkeepers; the steps that apply depend on the business and the records available.
The download is a CSV spreadsheet you can open in Excel or Sheets. Use the status, owner, and notes columns for a handoff. Do not put private financial information into a shared copy unless everyone with access is authorized to see it.
Your cleanup checklist
Progress stays in this browser. No account or email needed. Mark an item complete only after you have the supporting evidence.
0 of 9 steps complete
Record the period and cash/accrual basis. Keep an untouched export so you can compare changes.
Keep as evidence: Dated Balance Sheet, Profit & Loss, bank statements, and reconciliation reports for the same period.
Open the related guide →Identify the source of a difference before changing an opening balance or moving equity.
Keep as evidence: Statement balance at the QuickBooks start date and supporting opening entries.
Open the related guide →Two identical amounts can be real purchases. Confirm the same economic event was recorded twice before removing anything.
Keep as evidence: Transaction number, date, amount, payee, receipt, and bank-feed match.
Open the related guide →Separate pending bank-feed items from entries already posted to your books. Record why each account was selected.
Keep as evidence: Account detail for Uncategorized Income, Expense, and Asset, plus supporting documents.
Open the related guide →Check unapplied payments and payment dates. A customer prepayment can legitimately appear on a cash-basis report.
Keep as evidence: Open Invoices report, customer payment record, and related invoice.
Open the related guide →Group payments to the actual deposit total. Investigate deposits already recorded before creating another one.
Keep as evidence: Undeposited Funds detail, deposit slips, processor settlement reports, and bank deposits.
Open the related guide →Explain the difference with actual transactions. List unresolved differences for your bookkeeper instead of forcing an adjustment.
Keep as evidence: Statement ending date/balance and completed reconciliation report.
Open the related guide →Confirm old balances, transfers, owner activity, and unusual amounts. A General Ledger scan does not cover every account-specific check.
Keep as evidence: A/R and A/P aging, loan statements, payroll liabilities, and supporting schedules where applicable.
Open the related guide →Use the same period and reporting basis as your starting reports. Have your accountant review items affecting closed periods or tax filings.
Keep as evidence: Before/after reports, explanation of each correction, and unresolved items with an owner.
Open the related guide →
When is cleanup complete?
Every change should have a reason and supporting evidence. A tidy dashboard or an empty Uncategorized account is not enough: reconcile accounts, explain unresolved balances, and preserve before-and-after reports. Your accountant should review matters involving closed periods, tax treatment, payroll liabilities, or equity.
Our scanner helps assemble a shortlist from a supported ledger export. It does not replace this entire checklist or establish that the books are ready to file.
Continue your cleanup
Sources and further help
QuickBooks menus vary by plan and interface. Use in-app search if a menu label differs. These sources support the workflows; synthetic examples illustrate the checks.
Need a list of entries to review?
Scan a supported General Ledger CSV for possible cleanup issues. See the preview free; the detailed report is $29 one-time. You review and make any changes in QuickBooks.
No QuickBooks connection. Findings are review prompts, not a complete accounting review.