Relevé 27 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 “R27”
| Column Heading | Description | Type & Size | Comments & Examples |
|---|---|---|---|
| LASTNAME1 | First recipient last name (type 1 & 4) | Text, 30 | Required for type 1 |
| FIRSTNAME1 | First recipient first name (type 1 & 4) | Text, 30 | |
| INITIAL1 | First recipient initial (type 1 & 4) | Text, 1 | |
| FIRSTINDIVIDUAL | Indicate first entity is individual (type 4) | Yes/No | |
| LASTNAME2 | Second recipient last name (type 4) | Text, 30 | |
| FIRSTNAME2 | Second recipient first name (type 4) | Text, 30 | |
| INITIAL2 | Second recipient initial (type 4) | Text, 1 | |
| SECONDINDIVIDUAL | Indicate second entity is individual (type 4) | Yes/No | |
| NAME1 | Recipient name, line 1 (type 2, 3, 4 & 5) | Text, 50 | Required for types 2, 3, 4 & 5 |
| NAME2 | Recipient name, line 2 (type 2, 3, 4 & 5) | Text, 50 | |
| 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, in address | Text, 3 | CAN, USA, etc. |
| TAXYEAR | Year | Text, 1 | 2026 |
| SIN | Social insurance number | Text, 15 | |
| SIN2 | Second recipient’s social insurance number | Text, 15 | |
| RECTYPER27 | Recipient type | Text, 1 | 1-Individual >2-Corporation 3-Partnership 4-Holder of a joint account or co-recipient of payments 5-Consortium |
| NEQR27 | Recipient’s NEQ | Numeric, 10 | |
| NEQ2R27 | Second recipient’s NEQ | Numeric, 10 | |
| REFNO | Recipient’s ID number | Numeric, 10 | |
| REFNO2 | Second recipient’s ID number | Numeric, 10 | |
| PAYMENTS | Contractual payments | Currency | |
| SUBSIDIES | Subsidies | Currency | |
| REPORTCODER27 | Status of slip | Text, 1 | R-Original A-Amended D-Cancelled |
| SERIAL | Relevé No. of paper slip | Numeric, 9 | |
| SERIALORIGINAL | Relevé No. of previously-filed paper slip (user-entered) | Numeric, 9 | |
| SERIALMM | Relevé No. of XML slip | Numeric, 9 | |
| SERIALMMPREVIOUS | Relevé No. of previously-filed XML slip | Numeric, 9 | |
| 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 | 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 |