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.
Cell A1 MUST contain “T2200”| 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 | 2025 |
| 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, 2025) |
| Q1TO | Q. 1, “To date” | Date | Mmm. dd, yyyy (Apr. 1, 2025) |
| 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 |