Import is an advanced feature available in eForms Standard and eForms Enterprise only
Cell A1 must contain “T2200”
Columns and rows containing “NULL” in their first cell will not be imported
| 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 | eForms Enterprise only |
| OKTOEMAILSLIP | Permission granted to email slip | Yes/No | eForms Enterprise only |
| COMPANY.NAME1 | Company associated with slip | Text, 35 | eForms Enterprise only |
| COMPANY.COMPANYTAG | Tag associated with company name | Text, 10 | eForms Enterprise only |
| SLIPTAG | Subset tag | Text, 10 | eForms Enterprise only |
| CUSTOMFIELD | GUID or other unique identifier | Text, 50 | eForms Enterprise only |
| CUSTOMPASSWORD | Password for recipient PDF slip | Text, 20 | eForms Enterprise only |