Batch Fill CRA T2200 Forms from Excel

Canadian Employer Declaration of Conditions of Employment

Power PDF Filler lets Canadian employers batch fill T2200 forms for all their employees directly from Excel. Set up your employee data (name, address, employment conditions, expenses), map columns to T2200 fields once, and generate all declarations in seconds. Essential for companies with remote and hybrid workers who claim home office expenses.

What is the CRA T2200 form?

The T2200 (Declaration of Conditions of Employment) is a Canadian tax form that employers complete for employees who need to deduct employment expenses on their personal income tax return. The employer declares the conditions of employment — whether the employee was required to work from home, use a personal vehicle, pay for supplies, or incur other work-related expenses. The employee then uses the T2200 to support their expense claims on Form T777.

Since the shift to remote and hybrid work, T2200 volume has increased significantly. Companies with hundreds of remote workers need to issue hundreds of T2200 forms each tax season. The official fillable PDF is available from canada.ca.

Who needs to batch fill T2200 forms?

Canadian employers with remote/hybrid employees — Any company with employees working from home needs to issue T2200 forms so those employees can claim home office deductions.
HR departments — Processing T2200 requests for the entire workforce during tax season, often hundreds of forms in a short window.
Companies with sales or travel staff — Employees who use personal vehicles or pay for work-related travel, meals, or supplies need T2200 forms from their employer.
Payroll service providers — Processing T2200 forms on behalf of multiple client companies, multiplying the volume.

How to batch fill T2200 forms from Excel

Select your PDF form. Open Power PDF Filler from the Excel ribbon and select the official T2200 fillable PDF (download it from canada.ca if you don't have it). The add-in detects all fillable fields — employer info, employee details, conditions of employment, and expense sections.
Select & map your Excel data. Each row represents one employee. Columns include employee name, address, SIN, employment period, work-from-home details, vehicle use, and expense categories. Map your columns to T2200 fields and save the mapping as a reusable template.
Click "Ready, Go." Power PDF Filler generates one filled T2200 per row. Download individually or as a ZIP file.

What Excel columns do you need?

Excel Column	T2200 Field	Example
employee_name	Employee's name	Marie Tremblay
employee_address	Employee's address	456 Rue Saint-Laurent, Montréal, QC H2Y 2Y3
sin	Social Insurance Number	123 456 789
employment_period	Period of employment	01/01/2025 to 12/31/2025
work_from_home	Required to work from home	Yes
reimburse_expenses	Reimburse for expenses	No
use_vehicle	Required to use personal vehicle	No

Common mistakes to avoid

Using T2200 instead of T2200S. The T2200S is the simplified short form specifically for work-from-home expenses. If your employees only claim home office expenses (no vehicle, travel, or supplies), the T2200S may be more appropriate.
SIN formatting. Use the XXX XXX XXX format with spaces. Excel may treat SINs as numbers and strip leading zeros — format the column as text.
Yes/No fields. The T2200 has many yes/no checkboxes. Use consistent values in your Excel data — 'Yes'/'No' or 'true'/'false'. Inconsistent values will leave checkboxes unfilled.

T2200 — Frequently Asked Questions

Can I batch fill CRA T2200 forms from Excel? ▼

Yes. Set up your employee data in Excel with one row per employee — name, address, employment conditions, and expense details. Map columns to T2200 fields and fill all declarations in one click.

What is the CRA T2200 form used for? ▼

The T2200 (Declaration of Conditions of Employment) is a Canadian form that employers complete for employees who deduct work-from-home or employment expenses on their tax return. The employer declares the conditions of employment.

When do Canadian employers need to issue T2200 forms? ▼

Employers issue T2200 forms when an employee needs to claim employment expenses on their personal tax return. This is common for remote and hybrid workers, salespeople, and employees who use their own vehicle for work.

Can I also fill the T2200S (short form) for remote workers? ▼

Yes. Power PDF Filler works with any fillable PDF including the T2200S (Declaration of Conditions of Employment for Working at Home During COVID-19). Select the fillable PDF from canada.ca and map your fields.

Is my employee data secure when filling T2200 forms? ▼

Yes. In any modern browser such as Chrome or Edge, all processing is client-side — employee data never leaves your machine. Desktop Excel uses secure cloud processing with HTTPS encryption and daily data purging.

Ready to stop filling PDFs manually?

Start your free trial — no credit card required.

Try Free on Microsoft Excel