Creating a Period Copy of a QuickBooks File for a CRA or IRS Audit
QuickBooks Desktop's Condense Data utility can build a date-limited company file so you hand an auditor only the records they requested, not your entire history.
When a tax authority such as the Canada Revenue Agency (CRA) or the IRS audits a specific year, handing over your complete QuickBooks company file means surrendering far more data than the audit requires. QuickBooks Desktop offers a built-in way to produce a period copy — a standalone company file that contains only the transactions within the auditor’s requested date range, with everything outside that window removed or summarized. The result is a focused deliverable that keeps your full historical books private.
What a Period Copy Actually Is
A period copy is a separate company file built from your existing data but scoped to a chosen date range. Transactions falling inside the range remain intact and detailed. Data outside the range is stripped out or condensed into summary entries so that opening balances for the audited period still foot and tie. Your original, complete company file is not modified — the period copy is an export, not a replacement — and you continue working in your full file as normal.
Producing the Period Copy Through Condense Data
The tool that creates a period copy is the Condense Data utility. In current versions of QuickBooks Desktop Pro, Premier, and Enterprise, the workflow looks like this:
Back up your company file first. Before running any condense operation, create a full backup (File ▸ Back Up Company ▸ Create Local Backup) and store it somewhere safe. The period copy process should never touch your only copy of your live data.
Open the Condense Data utility. From the top menu, choose File ▸ Utilities ▸ Condense Data. The wizard launches and walks you through the available options.
Select the period-copy option. The first screen presents several choices. Rather than picking the standard condense path, choose the option labeled something like “Create a copy of the company file for a specific date range” (exact wording varies slightly by version). This tells QuickBooks to build a new, date-limited file instead of altering your working file.
Enter the audit date range. Specify the beginning and ending dates that match the period under audit — for example, January 1 through December 31 of the tax year in question.
Review how boundary transactions are handled. QuickBooks gives you options for dealing with transactions that fall on or near the edges of the range. The choices you make here directly affect opening balances in the resulting copy, so read each prompt carefully before proceeding.
Choose a save location. Pick a destination folder and a file name that clearly identifies the copy as audit-specific — for instance, including the company name and the date range.
Let QuickBooks build the file. The utility processes your data and produces the standalone period copy. Depending on the size of your original file, this can take several minutes to longer.
Open and verify the copy. Launch the new file in a separate QuickBooks session. Confirm that the date range is correct, that account balances for the audited period are intact, and that the data reconciles to what you expect.
Cautions Before You Hand the File Over
Always work from a backup, and never treat the period copy as a substitute for your full books. Review the deliverable thoroughly before releasing it — check that balances for the audited period reconcile and that no data from outside the range has leaked into the detailed transactions. Pay particular attention to opening balances, since the way the utility handles transactions on the boundary of your specified dates can shift those figures.
Because an audit-ready file must be both correctly scoped and internally consistent, many businesses choose to have a period copy prepared as a professional service. That route creates the date-limited file, verifies it foots and ties to the period’s tax returns, and ensures the complete original books remain untouched. For oversized company files where condensing is also part of the conversation, services that specialize in condensing large QuickBooks Desktop files can address both scope and file size in a single pass.
The Bottom Line
QuickBooks Desktop’s Condense Data utility gives you a practical way to respond to a CRA or IRS audit with only the records the auditor actually needs. The key is choosing the period-copy option — not the standard condense path — entering the correct date range, and verifying the result before it leaves your hands.