Import is an advanced feature available in eForms Standard and eForms Enterprise only
Cell A1 must contain “R24”
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 | 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. |
| YEAR | Year | Text, 1 | 2025 |
| SIN | Social insurance number | Text, 9 | |
| IDCHILDCARE | Number assigned to payer | Text, 20 | |
| LASTNAMECHILD1 | Surname - child 1 | Text, 30 | |
| FIRSTNAMECHILD1 | First name - child 1 | Text, 30 | |
| DATEOFBIRTH1 | Date of birth - child 1 | Date | Mmm, dd, yyyy |
| DAYSOFCARE1 | Number of days of care - child 1 | Numeric, 3 | |
| WEEKSATCAMP1 | Number of weeks at camp - child 1 | Numeric, 2 | |
| TOTALEXPENSES1 | Total expenses paid - child 1 | Currency | |
| EXPENSESNOTQUALIFY1 | Expenses (no tax credit) - child 1 | Currency | |
| EXPENSESQUALIFY1 | Expenses (with tax credit) - child 1 | Currency | |
| LASTNAMECHILD2 | Surname - child 2 | Text, 30 | |
| FIRSTNAMECHILD2 | First name - child 2 | Text, 30 | |
| DATEOFBIRTH2 | Date of birth - child 2 | Date | Mmm, dd, yyyy |
| DAYSOFCARE2 | Number of days of care - child 2 | Numeric, 3 | |
| WEEKSATCAMP2 | Number of weeks at camp - child 2 | Numeric, 2 | |
| TOTALEXPENSES2 | Total expenses paid - child 2 | Currency | |
| EXPENSESNOTQUALIFY2 | Expenses (no tax credit) - child 2 | Currency | |
| EXPENSESQUALIFY2 | Expenses (with tax credit) - child 2 | Currency | |
| LASTNAMECHILD3 | Surname - child 3 | Text, 30 | |
| FIRSTNAMECHILD3 | First name - child 3 | Text, 30 | |
| DATEOFBIRTH3 | Date of birth - child 3 | Date | Mmm, dd, yyyy |
| DAYSOFCARE3 | Number of days of care - child 3 | Numeric, 3 | |
| WEEKSATCAMP3 | Number of weeks at camp - child 3 | Numeric, 2 | |
| TOTALEXPENSES3 | Total expenses paid - child 3 | Currency | |
| EXPENSESNOTQUALIFY3 | Expenses (no tax credit) - child 3 | Currency | |
| EXPENSESQUALIFY3 | Expenses (with tax credit) - child 3 | Currency | |
| REPORTCODE | 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 | 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 |