QuickBooks Period Copy for CRA Audit: What Data Is Included and What Is Removed?

 

If you are preparing QuickBooks records for a CRA audit, you may not want to send or work with your entire company file. A QuickBooks Period Copy can create a condensed version of a QuickBooks Desktop company file containing data for a specific date range.

But there is an important point: a Period Copy is not the same thing as a CRA-approved audit file. The Canada Revenue Agency requires businesses to maintain reliable and complete records, supporting documents, and electronic records that can be accessed when requested.

So, a Period Copy can be useful for organizing or reviewing a particular audit period, but you should not assume that everything outside the selected period is safe to discard.

What Is a QuickBooks Period Copy?

A QuickBooks Period Copy is a condensed version of a QuickBooks company file that contains data for a specific period.

In QuickBooks Desktop, the Period Copy process is associated with the Condense Data utility. QuickBooks describes a period copy as a condensed company file containing data for a specific period. The process allows you to define the dates and choose how transactions, inventory, and unused list entries should be handled.

For example, suppose the CRA is reviewing your business records for:

January 1, 2024 through December 31, 2024

Instead of working with a company file containing many years of transactions, you could create a period copy for the relevant date range.

This can make a file easier to review and may reduce unnecessary historical data in the working copy.

However, you should always preserve the original company file and backup before condensing data.

Is a Period Copy the Same as a QuickBooks Backup?

No.

This is one of the most important distinctions to understand.

A normal QuickBooks backup is intended to preserve your company file so it can be restored later. A Period Copy is a condensed version of the company file.

QuickBooks specifically provides a backup before data is removed during the Condense process.

Think about it this way:

 

File	Main Purpose
Original Company File	Complete accounting history
QuickBooks Backup	Preserve the original file
Period Copy	Work with a specific accounting period
Exported Reports/Documents	Provide specific supporting information

For a CRA audit, keeping the original records is particularly important because CRA states that businesses are responsible for protecting their records and making records and supporting documents available when requested.

What Data Can Be Included in a QuickBooks Period Copy?

The exact result depends on the options selected during the Condense process.

A Period Copy is not simply a “copy and paste” of every transaction between two dates. QuickBooks gives you choices about what should be removed and how remaining information should be summarized.

Depending on the version and options available, the process can involve:

• Transactions within the selected period
• Summary journal entries for transactions outside the period
• Inventory transactions
• Accounts
• Customers and Jobs
• Vendors
• Other Names
• Items
• Classes
• Certain list information
• Other company-file information required by the condensed file

QuickBooks also provides options for how transactions should be summarized, including creating one summary journal entry, creating summary journal entries by month, or not creating a summary.

This is why you should never tell a client that a Period Copy always contains exactly the same information as the original file.

The final contents depend on the QuickBooks version and the selections made during the Condense Data process.

What Data Can Be Removed?

This is where extra caution is required.

QuickBooks lists several types of transactions that can be selected for removal during the Condense process. These can include:

• Uncleared or unreconciled bank and credit-card transactions
• Transactions marked “To be printed”
• Invoices and estimates marked “To be sent”
• Estimates
• Sales Orders
• Purchase Orders
• Pending Invoices
• Time and Mileage activities
• Transactions containing unbilled expenses and items

QuickBooks also provides options concerning unused list entries such as accounts, customers and jobs, vendors, other names, items, completed To-Do notes, classes, and unused entries in other lists.

That means you should not assume that creating a Period Copy simply removes transactions before and after the selected dates while leaving everything else untouched.

The Condense wizard gives you additional decisions that can change the resulting file.

How Are Transactions Outside the Audit Period Handled?

One of the key decisions is how transactions outside the selected period are summarized.

QuickBooks provides options such as:

1. Create one summary journal entry.
2. Create a summary journal entry for each month.
3. Do not create a summary.

The choice can affect how much transaction-level detail remains available in the condensed file.

For an audit-related situation, this matters.

If the purpose is simply to provide a clean working copy for a specific period, summarization may be acceptable for that working purpose.

But if someone needs to investigate individual transactions, supporting documents, or the sequence of accounting events, a condensed file may not provide everything that the original file provides.

That is why the original company file should be preserved separately.

What About Inventory?

Inventory requires additional attention.

QuickBooks provides choices for whether inventory transactions should be summarized or kept.

This can matter significantly for businesses with:

• Large inventories
• Frequent purchases and sales
• Inventory adjustments
• Cost-of-goods-sold calculations
• Multiple inventory items
• Historical inventory investigations

If the CRA audit involves inventory, do not create a Period Copy without first understanding how the selected inventory option will affect the information available in the resulting file.

Is a QuickBooks Period Copy Suitable for a CRA Audit?

It can be useful, but it should not automatically be treated as the complete CRA audit record.

This distinction can make your article—and your service—much more credible.

CRA says business records must be reliable and complete, include information needed to meet tax obligations and calculate credits, and be supported by documents.

CRA also explains that electronic records should maintain an audit trail connecting supporting documents to summarized financial accounts. That trail can involve invoices, receipts, payments, inventory records, GST/HST information, e-commerce systems, emails, and other related records.

Therefore, a Period Copy should generally be considered a working or review copy, not a replacement for the complete accounting records.

What Should You Preserve Before Creating a Period Copy?

Before creating a QuickBooks Period Copy for a CRA-related matter, take a conservative approach.

1. Create a complete backup

Preserve the original QuickBooks company file before running Condense Data.

2. Confirm the audit period

Do not guess the dates.

If the CRA request covers a particular fiscal year, GST/HST period, transaction category, or other period, verify exactly what information is being requested.

3. Preserve supporting documents

A QuickBooks file alone may not contain every piece of evidence needed for an audit.

Keep relevant:

• Invoices
• Receipts
• Bank statements
• Credit-card statements
• Payroll records
• GST/HST records
• Purchase documents
• Sales documentation
• Inventory records
• Relevant emails or electronic transaction records

CRA specifically requires supporting records and documents to be maintained and made available when requested.

4. Keep the original file unchanged

Use the Period Copy as a separate working file.

Do not treat it as a replacement for your original accounting history.

5. Review the condensed file

After the process finishes, review the resulting file and reports.

QuickBooks also warns that a Period Copy may not display cash-basis reports correctly.

That is another reason not to assume the condensed file is identical to the original.

How to Create a QuickBooks Period Copy

The exact screens can vary by QuickBooks Desktop version, but the general workflow is:

File → Utilities → Condense Data

Then select the option for removing transactions outside a date range / creating a Period Copy.

Set the required beginning and ending dates, review the available transaction-removal options, decide how transactions should be summarized, review inventory options, review unused list entries, and then begin the Condense process. QuickBooks Community guidance from the QuickBooks team describes this workflow for QuickBooks Desktop.

Before starting, make sure your backup has been successfully created.

Period Copy vs. Full Company File for CRA Review

 

Situation	Better Approach
Reviewing one accounting period	Period Copy may be useful.
Preserving complete business history	Keep the original company file.
Recovering from data problems	Use a full backup.
Investigating individual transactions	The original file may be better.
Reviewing inventory history	Review Period Copy settings carefully.
CRA requests complete supporting records	Preserve original records and documents.
Creating a smaller working file	Period Copy can be useful.

The biggest mistake is assuming that a smaller file automatically means a better audit file.

It does not.

For a CRA review, completeness and traceability are more important than simply reducing file size.

Final Takeaway

A QuickBooks Period Copy for a CRA audit can be a practical way to create a condensed working copy for a specific accounting period. It can help isolate a relevant date range and make certain reviews easier.

However, it should not replace your original QuickBooks company file or supporting documentation.

QuickBooks allows different options for transactions, summaries, inventory, and unused list entries, so the data retained in a Period Copy depends on how the Condense Data process is configured.

For CRA purposes, the safest strategy is:

Back up the original → preserve supporting documents → identify the exact audit period → create a separate Period Copy → review the condensed file → keep the original records available.

That approach gives you the convenience of a focused working file without confusing it with the complete accounting record required for an audit.

Frequently Asked Questions

Can I create a QuickBooks Period Copy for only one year?
Yes, where your QuickBooks Desktop version supports the relevant Period Copy/date-range functionality, you can specify a particular period. The available options can vary by product and version.

Does a Period Copy delete my original QuickBooks company file?
The process is intended to work with a condensed file, but you should always create and preserve a backup before condensing. Never rely on the condensed copy as your only record.

Does a Period Copy contain every transaction from the selected period?
Not necessarily in the same form as the original file. Condense Data provides options for summarizing transactions and handling inventory, so the resulting file can differ from the original.

Can CRA accept a Period Copy as a complete audit record?
You should not assume that. CRA requires reliable and complete records and supporting documentation. Whether a particular file satisfies a CRA request depends on what the CRA has requested and the records involved.

Should I keep the original QuickBooks file after creating a Period Copy?
Absolutely. Keeping the original file and proper backups is the safer approach, especially when the file relates to tax reporting or a potential CRA review.