QuickBooks Cleanup Checklist for a New Client

A QuickBooks cleanup for a new client means auditing the chart of accounts, gathering every bank and credit card statement, importing the missing history, reconciling each account month by month to its printed closing balance, clearing Undeposited Funds and Opening Balance Equity, fixing uncategorized transactions, and reviewing the AR and AP aging before you certify the numbers.

Last updated July 2026.

Before you touch anything: scope the mess

Don't start categorizing on day one. Run a Profit and Loss and a Balance Sheet for the period in question and read them like a stranger would. Where are the numbers obviously wrong? A negative bank balance, an Opening Balance Equity that never zeroed out, an Accounts Receivable full of invoices from clients who paid two years ago. That five-minute scan tells you how deep the hole is and lets you quote the work honestly.

Then confirm one thing that decides your whole approach: does the bank feed have history, or does it start ninety days ago? On a fresh connection QuickBooks commonly pulls only about the last 90 days (it varies by bank), so a client who needs last year cleaned up has a gap the feed will never fill. That gap is filled by uploading statements, which is the backbone of the workflow below.

1. Review the chart of accounts first

Messy books almost always start with a messy chart of accounts. Before you reconcile a single transaction, clean the structure the transactions will land in, or you'll re-categorize everything twice.

• Merge duplicate accounts (the classic "Office Supplies" and "Office Supply" pair, or three different "Owner Draw" accounts).
• Confirm every account has the correct type and detail type. A loan sitting in an income account will wreck the Balance Sheet and the tax return.
• Make accounts you'll never use inactive so staff can't post to them.
• Check that the bank and credit card accounts match real, open accounts the client actually holds. Catch-up clients often have a closed account still linked and a live one missing.

Do this now. Renaming and merging accounts after you've categorized a year of activity is how a two-hour job becomes a two-day one.

2. Gather every statement, then import the missing history

This is the step that makes or breaks a catch-up. Ask the client for every bank and credit card statement, as PDFs downloaded from online banking rather than phone photos, for the full cleanup period. Line them up and check the sequence: statement 3's opening balance should equal statement 2's closing balance. Find the missing month now, not in reconciliation.

Because the feed won't reach back far enough, the fast repeatable path is to convert each PDF statement to a .qbo Web Connect file and upload it. QuickBooks Online's Upload from file accepts QBO, QFX and CSV (not PDF), capped at 350 KB and 1,000 lines per file, so you work one statement month at a time. A QBO converter turns each PDF into a bank-identified file that lands in For Review like feed data, with no column mapping. For the full process on a client who's a year behind, see converting a year of statements for catch-up bookkeeping, and for doing this without the client's login, importing client bank statements into QuickBooks Online.

Import oldest first, one file per month, naming files so a human can sort them (ClientName_Checking_2025-01.qbo). Date order keeps the running balance meaningful and lets you back out the last month if one goes wrong.

3. Reconcile each account month by month

Reconciliation is where cleanup becomes real. A file isn't clean because the transactions are categorized; it's clean because every account ties to the bank. Work one account, one month at a time, oldest first.

• Set the statement ending date and enter the closing balance printed on the paper statement.
• Match and clear transactions until the difference reads zero. Don't force it with a reconciliation adjustment. A forced adjustment is a bug you're hiding, not fixing.
• If a month won't tie, stop and find the cause: a duplicate from an overlapping feed pull, a missing deposit, a transaction posted to the wrong account.
• Only move to the next month once the current one ties.

Because you already checked each imported month against its statement's closing balance during upload, most of these reconciliations become a confirmation rather than an investigation. That's the point of tying balances as you go. This is the same discipline that keeps a monthly close on rails; if the client will stay on with you, set up the recurring version described in the QuickBooks month-end close routine.

4. Clear Undeposited Funds and Opening Balance Equity

These two accounts are where messy books hide their sins. Check both on every cleanup.

Undeposited Funds. This should be near zero most of the time. A large stale balance means payments were received into Undeposited Funds and never matched to an actual bank deposit, so income may be double-counted. Work through the balance, group payments into the deposits that actually hit the bank, and clear the account.

Opening Balance Equity. This temporary account should be zero in a clean file. A lingering balance usually traces to a bank account opened with a hard-coded opening balance instead of real transaction history, which is exactly what statement imports let you avoid. Reclassify what's left to Retained Earnings or the correct equity account once you've confirmed where it came from, and never leave a plug sitting there.

5. Fix uncategorized transactions and set bank rules

Now the volume work. Sort the register or run a report on the Uncategorized Income, Uncategorized Expense, and Uncategorized Asset accounts, plus anything dumped into Ask My Accountant. Categorize from the top down, and as you recognize a recurring vendor, build a bank rule so the next fifty instances categorize themselves.

• Set rules for the obvious repeaters first: merchant processor fees, software subscriptions, recurring vendors, payroll runs.
• Keep an owner-questions list as you go. Some transactions genuinely need the client to tell you what they were; don't guess on those.
• Watch for personal spending run through the business account, a near-universal feature of small-business cleanups.

Catch-up clients rarely stop at the bank feed. The same folder usually holds a stack of receipts and vendor bills, and rather than key them line by line you can pull the receipts into expense-tracking software and bring the detail in behind the statement totals. The statements give you the money movement; the receipts give you the substantiation a return or an audit will ask for.

6. Review AR and AP aging

Open the Accounts Receivable Aging and Accounts Payable Aging summaries and read the oldest columns. This is where cleanups surface real money.

• AR: invoices marked open that were actually paid (the payment got recorded as a deposit instead of applied to the invoice, so income double-counts and the customer looks delinquent). Apply the payments, and write off what's genuinely uncollectible with the client's sign-off.
• AP: bills showing unpaid that were paid outside QuickBooks, or paid by a check entered as an expense. Clean up the duplicates so the client isn't told they owe vendors they already paid.
• Confirm the AR and AP totals on the Balance Sheet match the aging reports. If they don't, something was posted with a date or account that breaks the tie.

7. Check sales tax and payroll clearing

Two areas that quietly rot if nobody watches them.

Sales tax: confirm the Sales Tax Liability report agrees with what was actually filed and paid. Payments recorded as ordinary expenses instead of through the sales tax center overstate expenses and understate the liability.

Payroll clearing and liabilities: if the client runs payroll, tie the payroll clearing account back to zero and confirm payroll tax liabilities match the amounts actually remitted. A stubborn clearing balance almost always means a paycheck or tax payment was recorded twice, once from the bank feed and once from the payroll system.

8. Final review and lock the period

Rerun the Profit and Loss and Balance Sheet you started with. Do the numbers make sense for this business now? Is Opening Balance Equity zero? Do the bank and credit card balances match the last statements? Write a short cleanup memo listing what you changed, what you assumed, and the questions still open with the client.

Then set a closing date with a password so nobody, including a future you, edits a reconciled period by accident. Hand the client the memo and the open-questions list. This clean starting point is what every future close builds on. For the recurring statement-to-books mechanics your monthly process leans on, see the bank statement to QuickBooks workflow for accountants and the step-by-step for importing a bank statement into QuickBooks Online.

Frequently asked questions

Where do I start with a messy QuickBooks file?

Start with the reports, not the transactions. Run a Profit and Loss and a Balance Sheet, note what's obviously wrong, then clean the chart of accounts before anything else. After that, gather every bank statement and import the missing history so you have complete data to reconcile against. Categorizing first just means redoing it.

How long does a QuickBooks cleanup take?

It depends on volume and how far behind the client is, but the biggest variable is how you get transactions in. Keying or reformatting CSVs by hand stretches a year-long cleanup into days. Converting each PDF statement to a .qbo and importing month by month, tying to each closing balance as you go, turns most of the reconciliation into a confirmation and cuts the job substantially.

Why is my Opening Balance Equity not zero?

Because an account was set up with a hard-coded opening balance instead of real transaction history, or an adjustment was plugged there and never reclassified. In a clean file the balance is zero. Trace where the amount came from, move it to Retained Earnings or the correct account, and going forward build accounts from imported statement history so no plug is needed.

Can I clean up a client's books without their bank login?

Yes, and you should prefer to. A firm can't connect a client's bank feed anyway, so ask for PDF statements from online banking and convert each one to a .qbo Web Connect file to upload. That gives you complete history for the whole cleanup period, not just the roughly 90 days a fresh feed connection tends to pull.

How do I import bank history older than 90 days into QuickBooks?

By uploading it manually, which is Intuit's own advice for older history. The bank feed only reaches back so far, so download the older statements as PDFs, convert each to a .qbo file, and upload one month at a time through Upload from file. Each file must be 350 KB or less and under 1,000 lines, which one statement month fits comfortably.