Technical Bookkeeping

QuickBooks Online Cleanup: What to Do When a Client's Books Are a Mess

A practical diagnostic checklist and cleanup workflow to turn chaotic general ledgers into audit-ready tax returns.

Cleanup Framework Published: November 13, 2026 • 8 min read • By Credence Global Accounting

Every accounting practice encounters this client: a growing business owner drops off their QuickBooks Online credentials in late February, admitting that "things haven't been reconciled since 2023." A quick glance at the Balance Sheet reveals a \$140,000 balance in Undeposited Funds, negative Accounts Payable, unlinked bank feeds, and opening balance equity balances that make proper tax preparation impossible.

Cleanups can be highly profitable advisory engagements, but without a structured methodology, they quickly turn into time-sink traps that derail your tax season. Here is the proven 6-step diagnostic and remediation order used by Credence's senior bookkeeping team.

The 6 Most Common Disasters in Messy QBO Files

Red Flag Diagnostic Indicators:

1. Undeposited Funds ballooning with stale payments.
2. Negative cash or accounts receivable balances on the Balance Sheet.
3. Opening Balance Equity retaining non-zero balances.
4. Dec 31 bank feed holding hundreds of unaccepted transactions.
5. Payroll liabilities accumulating year after year without clearing.
6. Prior-year retained earnings not tying to prior-year filed tax returns.

The Step-by-Step Cleanup Sequence

Never start by recategorizing expenses. Always follow this strict balance-sheet-first remediation hierarchy:

Step 1: Lock Down Prior-Year Retained Earnings

Before touching a single transaction, compare the beginning Retained Earnings in QBO against the ending Retained Earnings reported on the client's last filed federal tax return (Schedule L, Line 24 or 25). If they do not tie out, someone posted transactions into a closed period. Post an audit adjusting entry to tie out beginning equity and set a closing date password.

Step 2: Clean Up Undeposited Funds / Payments to Deposit

Undeposited Funds usually accumulates because the user recorded customer payments AND subsequently categorized the deposit transaction directly from the bank feed as income. This double-counts revenue. Group the open payments, match them to actual bank deposits, and delete duplicate bank feed sales entries.

Step 3: Reconcile Bank and Credit Card Feeds Chronologically

Reconcile each account month-by-month, starting from the last verified date. Do not skip months. Investigate any reconciliation discrepancy accounts or auto-adjustments immediately. Ensure every ending balance matches the official bank statement down to the penny.

Step 4: Audit Accounts Receivable & Accounts Payable Subledgers

Run AR and AP Aging Detail reports. Look for unapplied credits, duplicate invoices, and negative balances. Write off uncollectible receivables under bad debt expense (with client sign-off) and match historical vendor credits against open bills.

Step 5: Review Payroll Liabilities & Clear Suspense Accounts

Tie out quarterly federal Form 941s and state unemployment returns to the payroll expense and tax liability accounts in QBO. Discrepancies often occur when owners record manual tax payments without applying them to payroll liabilities.

Step 6: Review P&L Deductibility & Generate Working Trial Balance

Scan the Profit & Loss for common misclassifications: capital equipment coded to repairs & maintenance, personal expenses mixed with business travel, and non-deductible entertainment. Produce a clean trial balance for partner sign-off.

Outsource Your Historical Cleanups to Credence

Catch-up cleanups require intense, detailed, multi-hour focus that pulls US staff away from higher-margin advisory. Credence Global Accounting provides white-label historical cleanup teams. We untangle multi-year backlogs inside your QBO or Xero environment, delivering clean workpapers and tie-outs ready for return preparation.

Have a Messy Client File on Your Desk?

Let Credence diagnose and clean it up. Try our complimentary 8-hour evaluation on any messy QBO file.

Test Our Cleanup Team →