Guide
QuickBooks Online Cleanup Checklist
Most QuickBooks Online files do not break all at once. They drift: a few uncategorized transactions, a reconciliation left unfinished, a journal entry posted to force a balance. Months later the reports stop matching the business.
This is the diagnostic we run before quoting cleanup work. You can run it yourself. It will tell you whether your file needs a genuine rebuild, a focused correction, or nothing more than a change in habit.
Symptoms
Signs the file needs work
None of these prove the file is broken on their own. Two or three together usually mean the reports cannot be relied on for a decision, a lender, or a filing.
- Bank or credit card accounts show an unreconciled difference, or reconciliations stop at some point in the past
- Opening Balance Equity still carries a balance long after setup
- Undeposited Funds keeps growing and never clears to the bank
- Accounts receivable includes invoices that were paid, and accounts payable includes bills that were settled
- The same vendor or customer appears two or three times under slightly different names
- Inventory or item quantities go negative
- The chart of accounts has grown past what anyone can explain, with near-duplicate accounts
- Journal entries exist with no memo, or entries posted directly to a bank or AR/AP control account
- Prior-period figures change between one report run and the next
- The profit and loss looks reasonable but the balance sheet does not
If you would rather not run this yourself, quickbooks cleanup services is the service that covers it.
Order of work
The checklist, in the order it should be run
Sequence matters. Correcting the chart of accounts before the bank feed is reconciled means doing it twice.
01
Fix the period boundary first
Decide the date the clean file starts from and confirm what is closed. Set a closing date with a password so corrected periods cannot drift again.
02
Reconcile cash
Every bank, credit card and line-of-credit account, month by month, against statements. Cash is the anchor: nothing above it can be trusted until it agrees.
03
Clear the clearing accounts
Undeposited Funds, Opening Balance Equity, and any suspense or ask-my-accountant account. Each remaining balance is an unfinished transaction, not a real one.
04
Age receivables and payables honestly
Match open invoices and bills to reality. Write off what is genuinely uncollectible with a documented decision rather than deleting history.
05
Reconcile loans and credit facilities
Split payments between principal and interest against the lender's amortization schedule. This is the single most common source of overstated profit.
06
Rebuild the chart of accounts
Merge duplicates, retire accounts nobody uses, and make the structure match how you actually read the business. Then reclassify history to the new structure.
07
Check payroll and taxes to source
Agree wages, taxes and liabilities to payroll reports and filed returns rather than to what was coded in the file.
08
Review the balance sheet line by line
Every balance should be supportable by a schedule or a statement. If nobody can say what a line represents, it is not finished.
Diagnose
Read the file as it stands. Reconciliation gaps, misposted balances, duplicated accounts, undeposited funds, negative inventory, opening-balance errors.
Document
Write down what is wrong before touching anything, so every later correction has a stated reason and an audit trail.
Correct
Fix systematically, oldest period forward, reconciling as we go rather than forcing balances with plug entries.
Prevent
Tighten the chart of accounts, coding rules and close routine so the same problems do not rebuild over the next year.
Judgement
What to fix, and what to leave alone
Not everything wrong in an old file is worth correcting. The test is whether the error changes a decision, a filing, or a number someone outside the business will read.
Fix anything that affects cash, debt, taxes, or a period that will be reported on. Fix classification errors that distort margin. Leave cosmetic inconsistencies in closed years alone unless a return or a lender package depends on them, and document what was deliberately not touched.
Deleting transactions is almost never the right correction. Reversing and reposting keeps the audit trail intact, which matters if the year is ever examined.
Finished
What a clean file looks like
- Every cash account reconciles to a statement, with no unexplained difference
- Clearing and suspense accounts sit at zero
- Each balance sheet line ties to a schedule someone can produce on request
- Debt agrees to the lender's balance and the interest split is correct
- The chart of accounts is documented and coding follows it consistently
- Prior periods are locked, so the same report run twice gives the same answer
- There is a written record of what was wrong and what was changed
FAQ
Questions we get asked about this
Related
Where to go next
Cleanup
QuickBooks Cleanup Services
QuickBooks cleanup for small businesses: fix miscoded transactions, broken reconciliations, and a distorted chart of accounts so reports can be trusted.
Cleanup
Catch-Up Bookkeeping Services
Catch-up bookkeeping for small businesses that are months or years behind. We rebuild the record, reconcile every account, and get you current.
Monthly close
Monthly Accounting and Month-End Close
Outsourced monthly accounting and month-end close for U.S. small businesses: reconciled accounts, accruals, reviewed statements, and a fixed close date.
Also relevant: QuickBooks Online support.
Next step
Not sure how bad the file actually is?
Send us what you found running this checklist. We will tell you what needs correcting, what does not, and what the work involves.