How to Clean Up QuickBooks Online: Step-by-Step Ledger Cleanup & Cost Guide

QuickBooks cleanup diagnostic: DIY vs. ProAdvisor catch-up sprint

Use this comparison to decide whether the file is a manageable owner task or a project that needs experienced bookkeeping support. A cleanup is complete only when the underlying activity is supported and key accounts reconcile; a prettier Profit and Loss report alone is not proof.

Step 1: Audit the Chart of Accounts and deactivate duplicates

Start by exporting or reviewing the Chart of Accounts and the current Balance Sheet and Profit and Loss reports. Look for duplicate names, accounts created for one-off purchases, vague buckets such as “Ask My Accountant,” and accounts with balances that do not match their purpose. Compare names and account types before deciding two accounts are duplicates; a bank account and an expense account with similar names are not interchangeable.

In QuickBooks Online, merge truly duplicate accounts only when they have the same account type and detail type and the history should be combined. Merging is generally irreversible, so confirm the target account, review the transactions that will be combined, and save a copy of the current reports first. If an account is simply no longer needed, make it inactive instead of deleting historical activity. Do not merge accounts with different tax treatment or reporting intent merely to shorten the list.

• Identify which accounts are active, used for reporting, or connected to a bank feed.
• Confirm account and detail types before merging; retain the preferred account name and number.
• Deactivate unused accounts only after checking that they have no unresolved balance or pending feed activity.
• Document any reclassification so the CPA can understand changes to prior-period reports.

Step 2: Clear Undeposited Funds (Payments to Deposit)

Undeposited Funds—called Payments to Deposit in some QuickBooks Online views—is a temporary clearing account. It holds customer payments recorded in Receive Payment until they are grouped into a bank deposit. Its balance should normally represent receipts not yet included in a deposit, not a permanent parking place for old activity.

Open the account register or run a detail report for Undeposited Funds, then inspect each old item. Match the payment to the customer invoice and the actual bank deposit. If several customer receipts arrived together as one net bank deposit, use the Bank Deposit workflow to select the individual receipts and record the processor fee separately where applicable. If the payment was already deposited directly to income or a bank account, determine whether the original entry or the duplicate should be corrected; do not create another deposit simply to make the clearing account zero.

After resolving supported items, compare the account balance with payments genuinely in transit at the cleanup date. Preserve a list of remaining items and their expected deposit dates. An unexplained zero is not a good outcome if it was achieved by deleting, voiding, or re-dating valid receipts.

• Trace each receipt to an invoice, sales receipt, processor payout, or bank statement.
• Group receipts into the real deposit when multiple payments settled together.
• Record fees, refunds, and chargebacks distinctly rather than netting them into sales.
• Investigate old credits with the customer or source records before writing them off.

Step 3: Reconcile Accounts Receivable (A/R) and aging balances

Run the Accounts Receivable Aging Summary and detail reports as of the cleanup date. Review old open invoices, unapplied customer payments, credit memos, and negative customer balances. An invoice may remain open because the payment was recorded as a bank deposit instead of being applied through Receive Payment; conversely, a payment can be applied to the wrong invoice or customer.

Trace aged balances to invoices, receipts, remittance advice, and customer correspondence. Apply payments only when the customer and invoice match. For a legitimate write-off, follow the company’s approval policy and use the appropriate write-off account so the adjustment is visible. Do not delete invoices just because they are old, and do not post a journal entry directly to A/R without the customer detail needed to keep the subledger and general ledger aligned.

Compare the A/R aging total with the A/R control account on the Balance Sheet at the same date. If they differ, investigate journal entries, opening-balance adjustments, or transactions posted without customer names. A cleanup should provide a short list of unresolved disputes and unapplied credits rather than burying them in a catch-all account.

Step 4: Reconcile Stripe, PayPal, and Shopify payment feeds

Payment processors usually settle transactions in batches and pay out net of processing fees, refunds, chargebacks, reserves, and timing differences. The payout in the bank is therefore not necessarily equal to gross sales in QuickBooks. Posting only the net payout as sales can understate revenue and hide fees; recording both gross sales and the payout as income can double-count revenue.

Choose a consistent workflow for each channel. Use a supported integration or a summarized sales-receipt process, then reconcile the processor clearing account from gross receipts through fees, refunds, disputes, and transfers to the bank. For Shopify, separate sales tax collected and shipping where the accounting setup requires it. For PayPal and Stripe, account for fees and refunds and tie the payout batch—not just an individual sale—to the bank statement.

At minimum, compare processor settlement reports with the books for the same dates and investigate payout timing around month-end. Keep source reports with the reconciliation so a reviewer can reproduce how the gross activity became the net bank deposit. If there are high order volumes, multiple currencies, or inventory/COGS dependencies, agree on the data source and accounting method with the CPA before bulk corrections.

• Reconcile gross sales, refunds, fees, chargebacks, and net payouts as separate components.
• Use a processor clearing account to track amounts awaiting settlement.
• Match each payout batch to the bank deposit and settlement report.
• Review cutoff timing, sales tax, currency conversion, and duplicate integration imports.

Step 5: Match bank feeds and reconcile to zero balance variance

A bank feed match suggests two records may represent the same transaction; it is not a substitute for reconciling the account to a monthly statement. Before reconciling, obtain complete bank and credit-card statements and confirm the opening balance. Then work one account and statement period at a time, matching existing entries where appropriate and adding new feed transactions only after checking the payee, date, amount, and business purpose.

The target is a completed reconciliation with a $0 difference between QuickBooks and the statement—not a forced journal entry. If the beginning balance is wrong, review prior reconciliations for changed, deleted, or added transactions. If a current statement does not reconcile, inspect duplicates, transfers recorded on only one side, outstanding checks, deposits in transit, and date/amount mismatches. Never use an adjustment to conceal a discrepancy without identifying and documenting its cause.

When all relevant accounts are reconciled through the agreed cut-off date, rerun the Balance Sheet and Profit and Loss. Compare unusual movements to source documents and preserve the reconciliations, adjustment rationale, and open-item schedule. This gives the owner and CPA a clear audit trail for the cleanup.

Section 6: Real-world QuickBooks cleanup costs—hourly rates vs. CPA flat fees

Cleanup cost depends on transaction volume, number of accounts and sales channels, how many months are behind, and whether statements and source reports are available. For a scoped 12-month catch-up with organized records, a practical planning range is 15–30 hours. At $35–$50 per hour, that is typically $525–$1,500 in specialist time. Messy files, missing records, payroll or inventory issues, and CPA review can add hours.

Some CPA firms quote flat fees or require a monthly accounting engagement, often with minimums that may land around $3,000–$5,000 for a larger cleanup or retainer arrangement. Compare the actual scope, deliverables, and included review rather than rate alone: a CPA may be needed for tax positions, financial statement assurance, or filing advice, while a bookkeeper can handle transaction-level cleanup and reconciliation within an agreed policy. Confirm who will review adjustments and whether the quote includes ongoing monthly bookkeeping.

Ask for a written scope before work begins: months covered, accounts and channels included, statement availability, treatment of prior-period corrections, target reports, and how exceptions will be escalated. With hourly work, agree on a check-in point and authorization before the estimated hours are exceeded.

Before-and-after close checklist

A good cleanup ends with a repeatable close, not just corrected historical entries. Keep the cut-off date and final reports together with the evidence used to support the changes. Ask the bookkeeper to explain material adjustments in plain language and list anything that could not be verified.

• Bank and credit-card reconciliations completed to statement dates with $0 difference.
• Undeposited Funds and processor clearing accounts supported by in-transit or settlement items.
• A/R aging reviewed and tied to the A/R control balance, with old disputes documented.
• Revenue, fees, refunds, chargebacks, and sales tax classified consistently by channel.
• Duplicate and obsolete accounts merged or deactivated only after review.
• Final Balance Sheet and Profit and Loss reviewed for unusual balances and period-over-period swings.
• CPA handoff includes reconciliations, source reports, adjustment notes, and unresolved questions.

Frequently asked questions

Related services