QuickBooks Cleanup Checklist: 8 Steps for Accurate Books

September 21, 2026 | Katie Thoma

What does a QuickBooks cleanup involve?

A QuickBooks cleanup reviews and corrects existing bookkeeping records so account balances and reports are supported by statements and other source documents. This eight-step QuickBooks cleanup checklist covers the review process in QuickBooks Online, from gathering records to setting a reliable monthly routine.

The goal is to understand and document the differences. A zero reconciliation difference alone does not prove that every expense category, invoice, or liability is correct.

Use this guide to organize a review and discuss its scope with your bookkeeper. QuickBooks Desktop has different tools and workflows; the software guidance here applies to Online.

Signs you may need a QuickBooks cleanup

Look for patterns that need investigation:

• Bank or credit card reconciliations have unexplained differences.
• A transaction appears more than once, or statement activity is missing.
• Customer invoices still show as unpaid after you received payment.
• Undeposited Funds contains old payments you cannot connect to deposits.
• Uncategorized transactions keep accumulating.
• Loan, credit card, or other balances disagree with supporting records.
• Monthly reports change after you thought a period was finished.

These are clues, not diagnoses. A negative bank balance may reflect timing or an actual overdraft. An Undeposited Funds balance may represent payments still waiting for deposit. Review the detail before deciding an account is wrong.

Cleanup corrects existing records; catch-up bookkeeping fills missing periods. Your business may need both. If transactions are missing for several months, include that work when discussing bookkeeping services.

The QuickBooks cleanup checklist: eight review steps

1. Gather records and agree on the period

Start with the period your reports need to cover and the last reconciliation you can support. Gather bank and credit card statements, loan statements, invoices, bills, receipts, and payment-processor reports. Include accounts you stopped using during the period.

Make a list of missing documents and known issues. For example: “July checking statement is missing” is more useful than “the bank balance looks wrong.” Record any CPA or lender deadline so it can shape the project scope.

Save copies of existing financial reports and reconciliation reports before corrections begin. Agree on who may make changes during the project. If earlier periods were used for filed returns, have your accountant review the proposed treatment of corrections affecting those periods.

2. Review account structure and bank-feed rules

Check whether the chart of accounts has useful, consistent categories. Similar names do not automatically mean two accounts should be merged; they may track different activities or have separate reporting requirements.

Review suggested categories and bank rules before processing more transactions. Intuit's bank-transaction guidance explains that downloaded transactions need review and may be matched to records already in QuickBooks. Treat a suggestion as something to check, not evidence of the correct category.

Write down category questions for the owner or accountant. Guessing just to clear a review queue makes the next report less useful.

3. Reconcile bank and credit card accounts

Compare each account with its statement, beginning with the earliest period in scope. Intuit defines reconciliation in QuickBooks Online as matching the recorded transactions to bank and credit card statements. Add and categorize the period's transactions before starting.

In the reconciliation workflow:

1. Select the account and check its beginning balance.
2. Enter the statement's ending balance and date.
3. Compare transactions with the statement and mark confirmed matches.
4. Investigate any remaining difference before finishing.
5. Save the completed reconciliation report.

If the beginning balance is wrong, stop and investigate the earlier period. Don't add an unexplained adjustment just to reach zero. Ask a bookkeeper to review altered prior reconciliations before undoing them.

4. Trace Undeposited Funds to actual deposits

Intuit's Undeposited Funds explanation describes a holding account for payments that will be grouped into a bank deposit. The grouped amount should correspond to what the bank records.

For each older item, trace the customer payment, deposit record, and statement entry. Check whether money is still awaiting deposit or whether the same receipt was recorded twice. Processor reports may be needed to explain fees and grouped payouts.

The target is an explained balance, not necessarily an empty account. Don't delete payments or deposits simply to reduce the balance. A correction must preserve the relationship between the invoice, payment, and deposit.

5. Investigate duplicates and unclear categories

Compare suspected duplicates using dates, payees, amounts, source documents, and linked records. Two entries with the same amount might be separate legitimate purchases.

Distinguish an unposted bank-feed item from a transaction already recorded in the books. The appropriate correction depends on its status, whether it is reconciled, and which other records it affects. Have a bookkeeper review uncertain corrections before removing recorded transactions.

Then work through uncategorized activity with receipts and business context. Keep an explicit questions list for unresolved items instead of placing everything in a miscellaneous expense category.

6. Review unpaid invoices and bills

Run accounts receivable and accounts payable aging reports: lists of customer invoices and vendor bills still shown as outstanding. Compare them with payment records and owner knowledge.

Investigate paid invoices still appearing as open, unapplied payments, vendor credits, and bills that may have been entered twice. Avoid sending collection reminders or paying old bills solely because they appear on an aging report.

Ask your accountant how to treat genuinely uncollectible balances or prior-period corrections. Writing off an invoice is an accounting decision, not a routine way to make a report shorter.

7. Support the remaining balances and review profit

Review the balance sheet beyond the bank accounts. Compare loans with lender records and payroll-related balances with reports from your payroll provider. Have the accountant review tax-related balances and equity questions where needed.

Check unexplained opening balances against setup or migration records. Don't force Opening Balance Equity to zero without identifying what created it and how it should be treated.

Next, review the profit and loss report month by month. Look for missing revenue, unusual expense changes, and inconsistent categorization. A reconciled bank account cannot tell you whether a purchase belongs in the correct expense category; both reviews matter.

Moxie keeps payroll and year-end records organized for the appropriate provider, but does not run payroll or prepare or file tax returns.

8. Document corrections and protect reviewed periods

Use the QuickBooks Online audit log to investigate recorded changes. Intuit says admin access is required and events are available for two years. Combine that history with statements and saved reports; the log does not replace supporting records.

After review, agree on the appropriate closing date with the person responsible for the books. QuickBooks Online's closing controls can display a warning or require a password for changes on or before that date. A warning-only setting still allows changes.

Keep a correction summary, final reports, and any unresolved questions. Assign responsibility for monthly reconciliations and for approving future changes to reviewed periods.

What determines QuickBooks cleanup cost and timing?

A useful estimate needs more than a count of overdue months. Ask the provider to define the period, accounts, known problems, deliverables, and assumptions before work begins.

The scope depends on transaction volume, missing documents, altered reconciliations, connected payment systems, and whether cleanup also includes catch-up work. Ask how additional issues will be handled and what you need to supply to keep the project moving.

Moxie can discuss your situation through its QuickBooks management service. Confirm the scope, fee, timing, and access arrangements directly; this checklist does not promise a fixed price or turnaround.

DIY review or professional help?

You can begin by collecting records, listing discrepancies, and checking transactions you understand against source documents. Consider professional help when you cannot explain a beginning balance, corrections affect earlier reporting periods, or connected invoices and payments are difficult to untangle.

The decision depends on complexity and confidence, not a universal number of months. Our guide to when to outsource bookkeeping can help you decide who should own the ongoing work.

Frequently Asked Questions

Can a QuickBooks cleanup fix every reporting problem?

Only if the underlying issues are identified and the records needed to resolve them are available. Missing documents or unresolved accounting questions should remain visible in the handoff, with an owner and next step.

Does Undeposited Funds have to be zero?

No. Payments legitimately awaiting deposit can leave a balance. Investigate older items and support the balance with payment and deposit records rather than deleting entries to make it zero.

How long does a QuickBooks cleanup take?

Timing depends on the period, account count, transaction volume, issues found, and document availability. Ask for a timeline after the initial scope discussion and clarify which missing information could delay completion.

What should I receive when the cleanup is finished?

Agree on deliverables before starting. Useful items include completed reconciliation reports, reviewed financial reports, a summary of corrections, outstanding questions, and a clear plan for keeping the next month current.

Start with a clear scope

A good QuickBooks cleanup leaves you with records you can explain and a process you can maintain. Begin with the accounts, dates, and problems you already know, then work through the evidence in order.

Moxie Business Assist is based in Waterloo, Iowa, and supports businesses remotely. Contact Moxie about your QuickBooks file to discuss cleanup, ongoing management, or help understanding the reports you already have.