Import is an advanced feature available in eForms Standard and eForms Enterprise only
Cell A1 must contain “T4E”
Columns and rows containing “NULL” in their first cell will not be imported
| Column Heading | Description | Type, Size | Comments & Examples |
|---|---|---|---|
| LASTNAME | Employee last name | Text, 30 | Required |
| FIRSTNAME | Employee first name | Text, 30 | |
| INITIAL | Employee initial | Text, 1 | |
| ADDRESS1 | Address line 1 | Text, 50 | |
| ADDRESS2 | Address line 2 | Text, 50 | |
| CITY | City | Text, 28 | |
| PROV | Province code | Text, 2 | |
| POSTAL | Postal code (including space) | Text, 10 | |
| COUNTRY | Country code | Text, 3 | |
| YEAR | Year | Numeric, 4 | 2025 |
| SLIPSTATUS | Status of slip | Text, 1 | O-Original A-Amended C-Cancelled |
| SIN | Social insurance number (12) | Numeric, 9 | |
| RECIPIENTNO | Recipient’s number | Text, 20 | |
| REPAYMENTRATE | T4E repayment rate; percentage (7) | Numeric, 3 | |
| TOTALBENEFITS | Total benefits paid (14) | Currency | |
| REGULAROTHERBENEFITS | Regular benefits paid included in Box 14 (15) | Currency | |
| EMPLOYMENTSUPPORT | Employment benefits and support measures included in Box 14 (17) | Currency | |
| TAXABLETUITION | Taxable tuition assistance (20) | Currency | |
| NONTAXABLETUITION | Non-taxable tuition assistance (21) | Currency | |
| INCOMETAX | T4E income tax deducted (22) | Currency | |
| QUEBECINCOMETAX | T4E Québec income tax deducted (23) | Currency | |
| OTHERCODE1 | Other information Box 1 | Numeric, 2 | |
| OTHERAMT1 | Other information Amount 1 | Currency | |
| OTHERCODE2 | Other information Box 2 | Numeric, 2 | |
| OTHERAMT2 | Other information Amount 2 | Currency | |
| OTHERCODE3 | Other information Box 3 | Numeric, 2 | |
| OTHERAMT3 | Other information Amount 3 | Currency | |
| OTHERCODE4 | Other information Box 4 | Numeric, 2 | |
| OTHERAMT4 | Other information Amount 4 | Currency | |
| OTHERCODE5 | Other information Box 5 | Numeric, 2 | |
| OTHERAMT5 | Other information Amount 5 | Currency | |
| OTHERCODE6 | Other information Box 6 | Numeric, 2 | |
| OTHERAMT6 | Other information Amount 6 | Currency | |
| TEXTATTOP | Optional text to print at top of slip | Text, 15 | |
| 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 |