T2200 Data Import Headings
Import is available in eForms Standard and eForms Enterprise only
(these headings are also used in the import files for AvanTax Filing Services)
QuickHelps Video - Import data from Excel (CSV & XLSX)
Columns and rows containing “NULL” in their first cell will not be imported.
Unused columns can be left empty in the template without impacting the import.
Cell A1 MUST contain “T2200”
IMPORTANT NOTICE - Name, Address, and Data characters accepted by CRA
| Column Heading | Description | Type & Size | Comments & Examples |
|---|---|---|---|
| LASTNAME | Recipient last name | Text, 30 | Required |
| FIRSTNAME | Recipient first name | Text, 30 | |
| INITIAL | Recipient initial | Text, 1 | |
| ADDRESS1 | Address line 1 (Home address) | Text, 50 | |
| ADDRESS2 | Address line 2 (Business address) | Text, 50 | |
| CITY | City | Text, 6 | |
| PROV | Province code | Text, 2 | |
| POSTAL | Postal code (including space) | Text, 10 | |
| COUNTRY | Country, in address | Text, 3 | CAN, USA, etc. |
| SIN | Social insurance number | Numeric, 9 | SIN is not required and is not printed but can be used by eForms Enterprise as a password on individual recipient PDFs |
| TAXYEAR | Taxation year | Numeric, 4 | 2026 |
| EMPNUM | Employee number | Text, 20 | |
| JOBTITLE | Job title & brief description of duties | Text, 100 | |
| Q1FROM | Q. 1, “From date” | Date | Mmm. dd, yyyy (Apr. 1, 2026) |
| Q1TO | Q. 1, “To date” | Date | Mmm. dd, yyyy (Apr. 1, 2026) |
| Q1BREAK | Q. 1, “Break in employment” | Text, 60 | |
| Q2AYES | Q. 2, “Commission,” Yes | Text, 1 | ”X” = Checked |
| Q2ANO | Q. 2, “Commission,” No | Text, 1 | ”X” = Checked |
| Q2COMMISSION | Q. 2, “Commissions” | Currency | |
| Q2TYPEOFSALES | Q. 2, “Type of goods or contracts” | Text, 75 | |
| Q2BYES | Q. 2, “Bus. development acc’t,” Yes | Text, 1 | ”X” = Checked |
| Q2BNO | Q. 2, “Bus. development acc’t,” No | Text, 1 | ”X” = Checked |
| Q2CYES | Q. 2, “Commission incl. T4,” Yes | Text, 1 | ”X” = Checked |
| Q2CNO | Q. 2, “Commission incl. T4,” No | Text, 1 | ”X” = Checked |
| Q3AYES | Q. 3, “Rent an office,” Yes | Text, 1 | ”X” = Checked |
| Q3ANO | Q. 3, “Rent an office,” No | Text, 1 | ”X” = Checked |
| Q3BYES | Q. 3, “Pay substitute,” Yes | Text, 1 | ”X” = Checked |
| Q3BNO | Q. 3, “Pay substitute,” No | Text, 1 | ”X” = Checked |
| Q3CYES | Q. 3, “Pay supplies”, Yes | Text, 1 | ”X” = Checked |
| Q3CNO | Q. 3, “Pay supplies”, No | Text, 1 | ”X” = Checked |
| Q3DYES | Q. 3, “Pay cell phone,” Yes | Text, 1 | ”X” = Checked |
| Q3DNO | Q. 3, “Pay cell phone,” No | Text, 1 | ”X” = Checked |
| Q4AYES | Q. 4, “Req’d to use home,” Yes | Text, 1 | ”X” = Checked |
| Q4ANO | Q. 4, “Req’d to use home,” No | Text, 1 | ”X” = Checked |
| Q4BYES | Q. 4, “Worked over 50% from home,” Yes | Text, 1 | ”X” = Checked |
| Q4BNO | Q. 4, “Worked over 50% from home,” No | Text, 1 | ”X” = Checked |
| Q4CYES | Q. 4, “In person meetings,” Yes | Text, 1 | ”X” = Checked |
| Q4CNO | Q. 4, “In person meetings,” No | Text, 1 | ”X” = Checked |
| Q5YES | Q. 5, “Reimbursed for Q3 and Q4,” Yes | Text, 1 | ”X” = Checked |
| Q5NO | Q. 5, “Reimbursed for Q3 and Q4,” No | Text, 1 | ”X” = Checked |
| Q5AMT1 | Q. 5, “Expense Amount,” Line 1 | Currency | |
| Q5TYPE1 | Q. 5, “Expense Type,” Line 1 | Text, 75 | |
| Q5INCLUDED1YES | Q. 5, “Expense, Incl. T4,” Line 1, Yes | Text, 1 | ”X” = Checked |
| Q5INCLUDED1NO | Q. 5, “Expense, Incl. T4,” Line 1, No | Text, 1 | ”X” = Checked |
| Q5AMT2 | Q. 5, “Expense Amount,” Line 2 | Currency | |
| Q5TYPE2 | Q. 5, “Expense Type,” Line 2 | Text, 75 | |
| Q5INCLUDED2YES | Q. 5, “Expense, Incl. T4,” Line 2, Yes | Text, 1 | ”X” = Checked |
| Q5INCLUDED2NO | Q. 5, “Expense, Incl. T4,” Line 2, No | Text, 1 | ”X” = Checked |
| Q5AMT3 | Q. 5, “Expense Amount,” Line 3 | Currency | |
| Q5TYPE3 | Q. 5, “Expense Type,” Line 3 | Text, 75 | |
| Q5INCLUDED3YES | Q. 5, “Expense, Incl. T4,” Line 3, Yes | Text, 1 | ”X” = Checked |
| Q5INCLUDED3NO | Q. 5, “Expense, Incl. T4,” Line 3, No | Text, 1 | ”X” = Checked |
| Q6YES | Q. 6, “Area of travel,” Yes | Text, 1 | ”X” = Checked |
| Q6NO | Q. 6, “Area of travel,” No | Text, 1 | ”X” = Checked |
| Q6AREA | Q. 6, “Area of travel” | Text, 75 | |
| Q7YES | Q. 7, “Consecutive hours,” Yes | Text, 1 | ”X” = Checked |
| Q7NO | Q. 7, “Consecutive hours,” No | Text, 1 | ”X” = Checked |
| Q7HOWFREQUENTLY | Q. 7, “How Frequently” | Text, 75 | |
| Q8AYES | Q. 8, “Vehicle allowance,” Yes | Text, 1 | ”X” = Checked |
| Q8ANO | Q. 8, “Vehicle allowance,” No | Text, 1 | ”X” = Checked |
| Q8AMTFIXED | Q. 8, “Fixed allowance amount” | Currency | |
| Q8PERKMRATE | Q. 8, “Per km rate” | Currency | |
| Q8AMTFORKM | Q. 8, “km amount received” | Currency | |
| Q8AMTONT4 | Q. 8, “Amount reported on T4” | Currency | |
| Q9AYES | Q. 9, “Company vehicle,” Yes | Text, 1 | ”X” = Checked |
| Q9ANO | Q. 9, “Company vehicle,” No | Text, 1 | ”X” = Checked |
| Q9BYES | Q. 9, “Expense,” Yes | Text, 1 | ”X” = Checked |
| Q9BNO | Q. 9, “Expense,” No | Text, 1 | ”X” = Checked |
| Q9AMT1 | Q. 9, “Expense Amount,” Line 1 | Currency | |
| Q9TYPE1 | Q. 9, “Expense Type,” Line 1 | Text, 75 | |
| Q9AMT2 | Q. 9, “Expense Amount,” Line 2 | Currency | |
| Q9TYPE2 | Q. 9, “Expense Type,” Line 2 | Text, 75 | |
| Q9AMT3 | Q. 9, “Expense Amount,” Line 3 | Currency | |
| Q9TYPE3 | Q. 9, “Expense Type,” Line 3 | Text, 75 | |
| Q10YES | Q. 10, “Other expenses,” Yes | Text, 1 | ”X” = Checked |
| Q10NO | Q. 10, “Other expenses,” No | Text, 1 | ”X” = Checked |
| Q10AMT1 | Q. 10, “Expense Amount,” Line 1 | Currency | |
| Q10TYPE1 | Q. 10, “Expense Type,” Line 1 | Text, 75 | |
| Q10INCLUDED1YES | Q. 10, “Expense, Incl. T4,” Line 1, Yes | Text, 1 | ”X” = Checked |
| Q10INCLUDED1NO | Q. 10, “Expense, Incl. T4,” Line 1, No | Text, 1 | ”X” = Checked |
| Q10AMT2 | Q. 10, “Expense Amount,” Line 2 | Currency | |
| Q10TYPE2 | Q. 10, “Expense Type,” Line 2 | Text, 75 | |
| Q10INCLUDED2YES | Q. 10, “Expense, Incl. T4,” Line 2, Yes | Text, 1 | ”X” = Checked |
| Q10INCLUDED2NO | Q. 10, “Expense, Incl. T4,” Line 2, No | Text, 1 | ”X” = Checked |
| Q10AMT3 | Q. 10, “Expense Amount,” Line 3 | Currency | |
| Q10TYPE3 | Q. 10, “Expense Type,” Line 3 | Text, 75 | |
| Q10INCLUDED3YES | Q. 10, “Expense, Incl. T4,” Line 3, Yes | Text, 1 | ”X” = Checked |
| Q10INCLUDED3NO | Q. 10, “Expense, Incl. T4,” Line 3, No | Text, 1 | ”X” = Checked |
| Q11YES | Q. 11, “Other expenses,” Yes | Text, 1 | ”X” = Checked |
| Q11NO | Q. 11, “Other expenses,” No | Text, 1 | ”X” = Checked |
| Q11TYPEOTHER | Q. 11 “Other expense description” | Text, 75 | |
| Q12AYES | Q. 12, “Tradesperson,” Yes | Text, 1 | ”X” = Checked |
| Q12ANO | Q. 12, “Tradesperson,” No | Text, 1 | ”X” = Checked |
| Q12BYES | Q. 12, “Purchase tools,” Yes | Text, 1 | ”X” = Checked |
| Q12BNO | Q. 12, “Purchase tools,” No | Text, 1 | ”X” = Checked |
| Q12CYES | Q. 12, “Satisfy,” Yes | Text, 1 | ”X” = Checked |
| Q12CNO | Q. 12, “Satisfy,” No | Text, 1 | ”X” = Checked |
| Q13AYES | Q. 13, “Apprentice,” Yes | Text, 1 | ”X” = Checked |
| Q13ANO | Q. 13, “Apprentice,” No | Text, 1 | ”X” = Checked |
| Q13BYES | Q. 13, “Designation,” Yes | Text, 1 | ”X” = Checked |
| Q13BNO | Q. 13, “Designation,” No | Text, 1 | ”X” = Checked |
| Q13CYES | Q. 13, “Purchase Tools,” Yes | Text, 1 | ”X” = Checked |
| Q13CNO | Q. 13, “Purchase Tools,” No | Text, 1 | ”X” = Checked |
| Q13DYES | Q. 13, “Satisfy,” Yes | Text, 1 | ”X” = Checked |
| Q13DNO | Q. 13, “Satisfy,” No | Text, 1 | ”X” = Checked |
| Q14AYES | Q. 14, “Forestry,” Yes | Text, 1 | ”X” = Checked |
| Q14ANO | Q. 14, “Forestry,” No | Text, 1 | ”X” = Checked |
| Q14BYES | Q. 14, “Provide Saw,” Yes | Text, 1 | ”X” = Checked |
| Q14BNO | Q. 14, “Provide Saw,” No | Text, 1 | ”X” = Checked |
| EMAILADDRESS | Recipient email address; one email address, or two separated by a semi-colon | Text, 255 | AvanTax eForms Enterprise & AvanTax Filing Services |
| OKTOEMAILSLIP | Permission granted to email slip | Yes/No | AvanTax eForms Enterprise & AvanTax Filing Services |
| COMPANY.NAME1 | Company associated with slip | Text, 35 | AvanTax eForms Enterprise & AvanTax Filing Services |
| COMPANY.COMPANYTAG | Tag associated with company name | Text, 10 | AvanTax eForms Enterprise & AvanTax Filing Services |
| SLIPTAG | Subset tag | Text, 10 | AvanTax eForms Enterprise & AvanTax Filing Services |
| CUSTOMFIELD | GUID or other unique identifier | Text, 50 | AvanTax eForms Enterprise & AvanTax Filing Services |
| CUSTOMPASSWORD | Password for recipient PDF slip | Text, 20 | AvanTax eForms Enterprise & AvanTax Filing Services |