Client Closing Their Business: What to Pull from QuickBooks Online Before Access Ends

The question comes up in the QuickBooks Community in almost these words: my client is closing their business and cancelling QuickBooks, what should I pull before the file goes away? It is a good instinct to ask before the access ends, because some of what you want is already shrinking while the file sits there, and the rest disappears once the read-only window runs out. This is the pull-list, ordered by what expires first rather than by what is easiest to click.

Two clocks are running

Your client is subject to two separate deadlines, and they do not line up. The first is Intuit's. When the client cancels a paid subscription, QuickBooks keeps the company in read-only mode for 12 months and then deletes it permanently. The second is the tax authority's. The final return the client files starts a retention window that runs three years at a minimum, and up to six or seven in cases of substantial underreporting or certain loss claims, with employment tax records held four years and no limit where a return was fraudulent or never filed. The IRS also publishes a checklist of the steps for closing a business, including final returns, that is worth walking your client through separately.

The gap between twelve months and seven years is the whole reason to pull a complete copy now. Everything below has to come out before the read-only clock runs, and one item has to come out even sooner.

1. The audit log, first

(There is a dedicated walkthrough of exporting the audit log if you want the click-by-click version, a broader guide to offboarding a client cleanly, and a case for making this a standard disengagement step.)

Start with the audit log, because it is the one record that is degrading while you wait. The log exports only as CSV, 150 rows at a time, and Intuit retains it for just two years. That two-year cap runs regardless of the read-only window, so on a company with any real history the older entries are already gone, and they keep falling off the back edge every day. The 150-row export limit makes a busy log slow to pull in full, which is another reason not to leave it for the end of the wind-down. This is the record you will want if anyone ever questions who touched an entry and when, so capture what remains before it truncates further.

2. Attachments, with their linkage rebuilt

Attachments are next because the way QuickBooks exports them creates work that has to be done while the file is still open. The bulk receipt export gives you the files, but Intuit's documentation says they come out separated from the transactions they were attached to, so you get a folder of documents with no record of which bill, invoice, or expense each one supports. On companies with many attachments, users on Intuit's forums also report that batch exports hit size limits and fail, so you may be exporting in pieces. Rebuilding the link, an index that maps each file to its transaction with date, amount, payee, and account, only works while you can still open the transactions to see what each file was for. Once the company is deleted, a folder of loose receipts is just a folder of loose receipts. Our guide on exporting attachments linked to transactions covers the index in detail.

3. The general ledger, full history, both bases

Pull the complete general ledger for the entire life of the company, not just the final fiscal year, and pull it in both cash and accrual basis if the client ever reported on a basis different from how the books were kept. The GL is the spine that ties every other document back to a number, and it is what an examiner reconstructs from. Note that QuickBooks' Export Data feature omits several record types and will not send a profit and loss report to CSV, so plan to export reports individually rather than assuming one Export to Excel produces the full set.

4. Per-year financials and trial balance

For each fiscal year the company operated, pull the profit and loss, the balance sheet, and the trial balance, again in both bases where it applies. The trial balance is your reconciliation anchor: tie the ledger to it so you can prove the archive is complete rather than merely present. Year-by-year statements are also what the client's future accountant, buyer, or lender will actually ask to see.

5. AR and AP aging as of the close date

Run the accounts receivable and accounts payable aging reports dated to the close, and keep them with the financials. These fix the client's open receivables and payables at the moment operations stopped, which matters for final collections, for writing off genuine bad debt, and for any dispute about what was owed at the end.

6. Payroll returns, if the client ran QuickBooks Payroll

If the client processed payroll inside QuickBooks, pull the filed payroll returns and year-end forms along with the payroll detail behind them. Employment tax records sit on their own four-year window, and closing payroll accounts is one of the steps on the IRS closing-a-business checklist, so this set has to survive the cancellation intact.

7. Master lists

Finally, export the master lists: the chart of accounts, customers, vendors, employees, products and services, and any recurring templates the client relied on. These give whoever picks up the entity, or the client themselves, the reference data that gives the numbers context. They are quick to pull, which is exactly why they get forgotten under deadline.

Handoff etiquette

Two copies of this archive should exist when you are done. The client gets their copy, because the retention obligation on the final return is theirs, and you keep a copy in your engagement workpapers per your firm's retention policy. How long you hold that copy, and what you are required to retain versus what you simply hand back, comes from your engagement letter and your state board's rules rather than from QuickBooks; check both before you decide, and treat this as an operational note rather than legal advice. For the underlying tax windows the client is responsible for, our guide on how long to keep business records after closing breaks them down by situation.

If pulling all seven of these cleanly, verifying them against the live file, and rebuilding the attachment linkage by hand is more than you want to take on inside a closing client's read-only window, that is the archive we build for you: every item on this list captured under a free accountant-user seat, checked against the live books, and delivered as a single download with a cover summary you can pass to the client. The order of operations is the same whether you do it or we do it, so the first move either way is to pull the audit log before it shrinks any further.