Import is an advanced feature available in eForms Standard and eForms Enterprise only
Cell A1 must contain “R1”
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 | |
| SIN | Social insurance number (12) | Text, 9 | |
| PROVEMP | Province of employment (10) | Text, 2 | |
| EMPNUM | Employee number, reference number | Text, 20 | |
| EMPCODE | Employment code (29) | Text, 2 | |
| CPPWEEKS | Weeks eligible for CPP/QPP | Numeric, 4 | 2 digits + 2 decimals: 52.00, 52.5, etc. |
| SLIPSTATUS | Status of slip | Text, 1 | O-Original A-Amended C-Cancelled (R, A or D will be shown on filed Relevé 1s) |
| TAXYEAR | Taxation year | Numeric, 4 | 2025 |
| UNION | Union dues (44) | Currency | |
| CHARITABLE | Charitable donations (46) | Currency | |
| PENSIONNO | RPP/DPSP number (50) | Text, 7 | |
| PENSION | Pension adjustment (52) | Currency | |
| PPIP | PPIP premiums (55, H) | Currency | |
| PPIPEARN | PPIP earnings (56, I) | Currency | |
| CODEBOXOR1 | Code for Box O | Text, 2 | |
| IDNOQ | Recipient Quebec identification number | Numeric,10 | |
| ISBUSINESS | Recipient is business | Yes/No | No |
| INCOMER1 | Employment income (A) | Currency | |
| QPP | QPP contributions (B) | Currency | |
| EI | EI premiums (C) | Currency | |
| RPPR1 | Reg. Pension plan contr. (D) | Currency | |
| TAXR1 | Québec income tax deducted (E) | Currency | |
| UNIONR1 | Union dues (F) | Currency | |
| QPPEARN | QPP pensionable earnings (G) | Currency | Must contain data |
| HEALTHR1 | Private health insurance (J) | Currency | |
| TRAVELR1 | Travel (K) | Currency | |
| OTHERTBR1 | Other taxable benefits (L) | Currency | |
| COMMISSIONS | Employment commissions (M) | Currency | |
| CHARITABLER1 | Charitable donations (N) | Currency | |
| OTHERINC | Other taxable income (O) | Currency | |
| INSURANCE | Multi-employer insurance (P) | Currency | |
| DEFERRED | Deferred salary (Q) | Currency | |
| INDIANINC | Exempt income for an Indian (R) | Currency | |
| TIPS | Tips received (S) | Currency | |
| TIPSALLOCATED | Tips allocated (T) | Currency | |
| PHASEDRETIRE | Phased retirement (U) | Currency | |
| HOUSING | Meals and accommodation (V) | Currency | |
| AUTOR1 | Personal use of auto (W) | Currency | |
| FNOTE1R1 | Footnote #1 | Text, 30 | |
| FNOTE2R1 | Footnote #2 | Text, 30 | |
| FNOTE3R1 | Footnote #3 | Text, 30 | |
| NETPAYOTHERR1 | Other deductions from Net Pay | Currency | For net pay calc. |
| SERIAL | Sequential (Relevé) number of paper slip | Numeric, 9 | |
| SERIALORIGINAL | Sequential (Relevé) number of previously-filed paper slip (user-entered) | Numeric, 9 | |
| SERIALMM | Sequential (Relevé) number of XML slip | Numeric, 9 | |
| SERIALMMPREVIOUS | Sequential (Relevé) number of previously-filed XML slip | Numeric, 9 | |
| TEXTATTOPR1 | Optional text to print at top of slip | Text, 15 |
Generic boxes where ## is two numerals (01 to 04):
| Column Heading | Description | Type, Size | Comments & Examples |
|---|---|---|---|
| XBOX## | Additional Information - Box ##: Box number | Text, 7 | |
| XAMT## | Additional Information - Box ##: Currency data | Currency | |
| XTXT## | Additional Information - Box ##: Character data | Text, 20 | |
| CUSTOMFIELD | GUID or other unique identifier | Text, 50 | eForms Enterprise only |
| CUSTOMPASSWORD | Password for recipient PDF slip | Text, 20 | eForms Enterprise only |