How to Archive a Client's QuickBooks Online File When You Offboard Them

Offboarding a client is mostly routine until you get to the books. When an engagement ends, your access to that client's QuickBooks Online company usually ends with it, either because the client removes you as the accountant user or because they cancel the subscription to stop paying for software they no longer use. Everything you worked on inside that file, and everything that documented it, stops being something you can reach. The clean version of an offboarding pulls a complete archive out first, while you still have access, and hands it to the client as part of your final deliverable.

Three ways an engagement ends, one shared problem

Clients leave for different reasons, and each closes off the file a little differently.

• The client is winding down. They file final returns, close operations, and cancel QuickBooks because there is nothing left to run. (Our pull-list for a closing client covers this scenario item by item.)
• The client moves on. They switch firms, bring the bookkeeping in-house, or simply go quiet, and at some point your accountant access is removed.
• The client sells. The buyer takes over the entity, stands up their own file or a different platform, and the old company gets cancelled once the transition finishes.

In all three the live company that held years of your work becomes unreachable, and on someone else's schedule rather than yours. Once the client cancels, Intuit keeps the company in read-only mode for 12 months and then deletes it permanently. If you were removed as the accountant user before the cancellation, you lost your view of the file even sooner.

The exposure runs to you, not only the client

The reason this belongs on your offboarding checklist is that the request for old records rarely arrives while you still have access. It arrives a year or two later. A former client calls because their new accountant has a question about how a prior period was handled. An examiner opens the final return. A lender doing diligence on a sale wants the workpapers behind a number. A dispute surfaces and a lawyer wants to know who changed an entry and when.

By the time any of that lands, the QuickBooks company may already be gone. The IRS generally expects business records to be kept for three years, and up to six or seven in cases involving substantial underreporting or certain losses, with employment tax records carrying their own four-year window and no limit at all where a return was fraudulent or never filed. Those windows outlast the read-only year by a wide margin, and they usually outlast the engagement. A complete archive protects the client, who still owes those records to the tax authority, and it protects you, because it lets you answer a later question from a document instead of from memory.

What a clean offboarding archive contains

A final deliverable that actually covers the retention period is more than a folder of report PDFs. At minimum it should include:

1. The full general ledger for the company's entire history, not just the final fiscal year.
2. Each year's core financials, meaning profit and loss, balance sheet, and trial balance, in both cash and accrual basis where the client ever reported on a basis different from how the books were kept.
3. Every attachment, under its original filename, indexed to the transaction it supports so the link survives outside QuickBooks.
4. The audit log, which records who changed what and when.
5. Payroll reports, if the client ran payroll, since those back the employment-tax window.

Where the built-in exports fall short for a final deliverable

You can assemble much of this from QuickBooks' own tools, but the gaps matter more when you are signing off on the result and handing it over. Intuit's Export Data feature leaves several record types out, including attachments, estimates, purchase orders, customer statements, and recurring templates, and it will not export a profit and loss report to CSV. The bulk receipt export does give you the files, but Intuit's documentation says they come out separated from the transactions they were attached to, so the client ends up with a pile of documents and no record of which entry each one supports. The audit log is worse: it exports only as CSV, 150 rows at a time, and Intuit retains it for just two years, so the history you would most want in a dispute may already be truncated before you ever pull it. There is more on the linkage problem in our guide to what happens to your data when you cancel.

For your own day-to-day, a partial export is fine because the live company still resolves the gaps. As a client's final work product, a folder of unlinked receipts and a two-year audit log is a gap you will be the one explaining later.

Delivering it as a professional work product

Treat the archive the way you would treat any deliverable that leaves your firm. Lead with a short cover memo: what the archive contains, the period it covers, the basis of each report set, and the date it was pulled. Include verification counts so the client (and anyone who reviews it after them) can trust it: the number of attachments captured against the number in the file, the general ledger tied to the trial balance, and a sample of receipts opened to confirm they match the entries they document. That verification step is the difference between handing over files and handing over something you would stand behind. Keeping a copy of the same archive in your own workpapers, per your retention policy, closes the loop on your side.

Retention duties are yours to define

How long you personally have to retain client records, versus what you hand back and let the client keep, is not a question QuickBooks or the IRS answers for you. It comes from your engagement letter and your state board's rules, and both vary. The practical posture is to check your engagement letter's retention and offboarding language and your board's requirements before you decide what to keep and for how long; this is an operational note, not legal advice. Our guide on how long to keep business records after closing covers the underlying tax windows the client is on the hook for.

If building that archive by hand across years of a client's books is not how you want to spend the last billable hours of an engagement, that is the archive we build for you: the full ledger, every report in cash and accrual, every attachment still linked to its transaction, the audit log, and payroll reports where they apply, verified against the live company and delivered as a single file with a cover summary you can pass straight to the client. It runs off a free accountant-user seat, so you can order it before the client's read-only window closes and hand it over as the last item on the offboarding checklist.