← Back to Blog
Client ManagementMarch 28, 20269 min read

Taking Over a Client's QBO File From a Previous Bookkeeper: A Step-by-Step Playbook

You just got the login credentials. You're staring at a new client's QuickBooks Online file for the first time, and within thirty seconds, your stomach is doing that thing it does when you realize the previous bookkeeper left a disaster behind.

I've been here more times than I can count. During my five years as a lead bookkeeper at Intuit QuickBooks Live, I regularly inherited files from other bookkeepers — some who left voluntarily, some who were let go, and some who just disappeared. Every time, I learned something new about how to take over a QBO file without losing my mind.

This is the playbook I wish someone had handed me on day one.

The Reality of a Client Takeover

Let's acknowledge what this feels like. You've landed a new client — exciting. They chose you because they're unhappy with their current situation — also exciting. But now you're looking at someone else's work, and you have to figure out what's right, what's wrong, what's intentional, and what's accidental. You don't have context for any of it.

The file might be a disaster. Or it might actually be fine and the client just wanted a personality change. You don't know yet. Resist the urge to start "fixing" things before you understand what you're looking at.

Step 1: Don't Panic and Don't Touch Anything Yet

I know this sounds obvious, but I've watched bookkeepers (including early-career me) open a new client file, see a problem, and immediately start editing transactions. That is the worst thing you can do on day one.

First, back up the file. In QBO, go to Settings > Back up company. Download a copy of the data as it exists right now, before you've touched anything. This is your insurance policy. If something goes sideways during cleanup, you can show exactly what the file looked like when you received it.

Second, set a closing date. Go to Settings > Account and settings > Advanced > Accounting and set a closing date on the last completed period. If the previous bookkeeper finished through December 2025, lock December 31, 2025. Set a password only you know. This prevents anyone from modifying historical transactions while you assess.

These two steps take less than five minutes. Do them first, every time, no exceptions.

Step 2: Run Your Diagnostic

Now you can start looking around — but do it systematically, not randomly.

Start with the Balance Sheet. Run a Balance Sheet set to "All Dates." This is your single most informative report. Are any bank balances negative? (Missing or duplicated transactions.) Do AR and AP make sense? Is there anything in Uncategorized Asset or Ask My Accountant? Is there an Opening Balance Equity account with a balance? (Someone set up accounts incorrectly.)

Check for the big red flags. Negative bank balances, large uncategorized balances, unreconciled accounts, a bloated chart of accounts, and AR/AP balances that don't match reality. I've written about the full diagnostic process in detail. If any of these are present, you're looking at a cleanup project, not just a bookkeeper transition.

Check reconciliation status. Go to each bank and credit card account and look at the last reconciled date. Are they current? Months behind? Never reconciled at all? This tells you more about the previous bookkeeper's work quality than almost anything else.

Document everything as you go. I keep a running list of every issue, question, and red flag. You'll need it for the client conversation.

Step 3: Communicate With the Client

Before you fix anything, you need information. This is where bookkeepers skip ahead, and it always comes back to bite them.

What did the previous bookkeeper handle? Full-service bookkeeping or just reconciliation? Payroll? Sales tax? Financial statements? The answers tell you what was maintained and what was neglected.

What integrations are in use? Payroll system, POS, invoicing tool, expense tracker? You need to know every app feeding data into QBO because those connections might be creating transactions you don't understand yet.

Any pending deadlines? Sales tax due next month? Quarterly payroll taxes? 1099s? An upcoming tax return? Deadlines drive priorities. If sales tax is due in three weeks and the books are a mess, that filing comes first.

Why did they leave the previous bookkeeper? If the client left over poor communication, be proactive about yours. If the work was bad, they need to understand cleanup takes time and money. This context helps you price and scope the engagement.

Step 4: Document What You Find

As you dig deeper, keep a running list organized into three categories:

Issues found: Specific problems. "Checking account unreconciled since March 2025." "$12,400 in Uncategorized Expense." "Chart of accounts has 147 accounts, many unused." Be specific, include dollar amounts.

Questions for the client: Things you can't figure out from the file alone. "What is the recurring $2,500 payment to Smith LLC?" "Is the PayPal account still active?" Batch these into one organized email rather than peppering the client with individual questions.

Decisions to make: Judgment calls you'll make with the client or their CPA. "Consolidate the three supplies accounts?" "The previous bookkeeper used cash basis — does the client need accrual?" "Old loan account with a small balance — write off or investigate?"

This document becomes your project roadmap. Without it, you'll forget things and waste time re-investigating issues you already identified.

Step 5: Decide on the Scope — Cleanup or Fresh Start?

This is the big strategic decision.

Option A: Cleanup (fix the mess). Go back through historical periods, fix miscategorized transactions, reconcile accounts, rebuild the COA. More work, more cost, but the client gets accurate historical financials. This is right when they need prior-period data for taxes, loans, or decisions — or when the mess is under 12 months old. Here's my full 12-step cleanup process if you go this route.

Option B: Fresh start. Draw a line — everything before a certain date stays as-is, and you start maintaining correctly going forward. Faster, cheaper, but historical financials stay inaccurate. Makes sense when the file is so far gone that cleanup costs more than the client will pay, or when the CPA already filed taxes using their own numbers.

Sometimes the answer is a hybrid: clean up the current fiscal year, leave prior years alone. There's no universal right answer — it depends on the client's needs, budget, and what they'll use the data for. But make this decision deliberately, not by accident.

Step 6: Set Expectations

This conversation determines whether the engagement goes smoothly or becomes a nightmare.

Give a realistic timeline. Don't underquote to win the client. If cleanup takes 20 hours, say 20 hours. If you say 8 and it takes 20, you either eat the extra time or go back for more money and damage trust. I'd rather slightly overestimate and come in under. Takeover files almost always run high; if you don't have a system for converting findings into hours yet, the category-by-category framework is what I use.

Explain what cleanup means. Most clients think you'll click a button and everything's fixed. Take five minutes: "We need to go through transactions from [date range], categorize everything correctly, reconcile your accounts, and clean up structural issues. This is detailed work and it takes time."

Be honest about cost. Cleanup is not ongoing monthly bookkeeping, and it shouldn't be priced the same. I charge cleanup as a separate project — not bundled into the monthly rate. The client needs to understand it's a one-time investment to get their books right.

Put everything in writing. A scope document or engagement letter that spells out what's included, what's not, estimated timeline, and price. Verbal agreements about scope are how bookkeepers end up doing twice the work for half the pay.

The Emotional Side: Don't Badmouth the Previous Bookkeeper

No matter how bad the file is, do not trash-talk the previous bookkeeper to the client.

I know it's tempting. You're staring at 18 months of unreconciled accounts, $40,000 in Uncategorized Expense, and a chart of accounts with entries like "Misc 2" and "Old Stuff Don't Use." You want to say "whoever did your books before had no idea what they were doing."

Don't. You don't know the full story — maybe the previous bookkeeper was doing their best with a client who wouldn't provide information. Maybe the client caused most of these problems by making unauthorized changes. And badmouthing the previous bookkeeper makes the client wonder what you'll say about them if this relationship ends.

Focus forward. "I've identified some areas where the books need attention, and I've put together a plan to get everything cleaned up." Professional, solution-oriented. That's the energy.

How to Handle the "We've Never Reconciled" Revelation

This comes up more often than you'd think. You ask about reconciliation, the client says, "I think the previous bookkeeper did that... maybe?" Translation: never reconciled.

Check QBO for reconciliation history — look for the "R" flag on transactions in the account register. If nothing is marked, you're starting from scratch.

For 6-12 months of data, you can usually reconcile from the beginning — start with the first statement and work forward. Tedious but doable. For years of unreconciled data, consider a fresh-start reconciliation: pick a recent statement date, verify the QBO balance matches, make adjustments to align, and reconcile forward from there. I covered the full reconciliation discrepancy process in a separate post if you need help with the mechanics.

Whatever you decide, explain the tradeoff to the client. "We can reconcile everything back to 2022, but it adds X hours. Or we start fresh from this month. Here's the cost difference." Let them choose.

When to Walk Away

Not every file is worth saving, and not every client is worth the trouble.

Walk away if cleanup would cost more than re-entering the data from scratch — and the client won't pay for re-entry. Sometimes a fresh QBO file is the right answer.

Walk away if the client won't participate. Every cleanup requires client input — answering questions about transactions, providing statements, explaining payments. An unresponsive client means a stalled project and you'll be blamed.

Walk away if you see signs of fraud. Deliberately falsified books need a forensic accountant, not a bookkeeper. Protect yourself.

Walk away if the client pushes back on every recommendation. If they won't let you fix the chart of accounts or refuse to let you reconcile, you're going to do a lot of work for someone who won't let you do it right.

Walking away feels hard, especially when you need the income. But a bad client who eats 40 hours at a discounted rate is worse for your business than no client at all.

Your Post-Takeover Quality Check

After you've cleaned up the file — whether full historical cleanup or fresh start — you need a structured QC pass before you deliver it back to the client. This is the step most bookkeepers skip, and it's the step that separates professional work from "good enough."

Does the Balance Sheet balance? Do all bank and credit card accounts reconcile to their statements? Is the P&L reasonable for the business type? Any remaining balances in Uncategorized Income, Uncategorized Expense, or Ask My Accountant? Is AR clean? Is AP accurate? Are payroll liabilities cleared?

I built LedgerClean to run this kind of diagnostic automatically — upload your client's QBO exports and it scans across all 8 issue categories, giving you a health score and prioritized findings. Use it at the start of a takeover to scope the damage, and again after cleanup to verify you haven't missed anything. Free to try.

Taking over a client's books from a previous bookkeeper is stressful. There's no shortcut around that. But with a structured approach — back up, diagnose, communicate, document, scope, set expectations — it becomes manageable. You've got this.

LC

Written by the Founder

IRS Enrolled Agent and former Intuit QBO Live Lead Bookkeeper with 7+ years managing cleanup engagements. Built LedgerClean from real cleanup methodology, not theoretical best practices.

Try LedgerClean free — 14-day Solo trial, no credit card required to start.

Start Free Trial

Get cleanup tips in your inbox

Practical guides for bookkeepers. No spam, unsubscribe anytime.

Subscribe on Substack

Related posts