T2202 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 “T2202”
IMPORTANT NOTICE - Name, Address, and Data characters accepted by CRA
| Column Heading | Description | Type & Size | Comments & Examples |
|---|---|---|---|
| LASTNAME | Recipient last name | Text, 50 | Required |
| FIRSTNAME | Recipient first name | Text, 50 | |
| 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. |
| SLIPSTATUS | Status of slip | Text, 1 | O-Original A-Amended C-Cancelled |
| SIN | Student’s Social Insurance Number | Numeric, 9 | |
| PROGRAMNAME | Name of program of study | Text, 50 | |
| TAXYEAR | Taxation year | Numeric, 4 | 2026 |
| FLYINGSCHOOLCOURSETYPE | Flying school course type. NOTE: The value for “School Type Code” is not imported but is entered manually on the summary, from which it is reported on each T2202 form. | Text, 1 | 1 - Private pilot’s license 2 - Commercial pilot’s licence 3 - Civil flying instructor rating 4 - Helicopter category rating 5 - Instrument rating 6 - Other |
| STUDENTNUMBER | Student number | Text, 15 | |
| FROMYEAR1 | From: Year, line 1 | Numeric, 4 | |
| FROMMONTH1 | From: Month, line 1 | Numeric, 2 | 1 to 12 |
| TOYEAR1 | To: Year, line 1 | Numeric, 4 | 2026 |
| TOMONTH1 | To: Month, line 1 | Numeric, 2 | 1 to 12 |
| TUITIONFEES1 | Eligible tuition fees, line 1 | Currency | |
| PARTTIMEMONTHS1 | Number of months for: Part-time, line 1 | Numeric, 2 | 1 to 12 |
| FULLTIMEMONTHS1 | Number of months for: Full-time, line 1 | Numeric, 2 | 1 to 12 |
| FROMYEAR2 | From: Year, line 2 | Numeric, 4 | 2026 |
| FROMMONTH2 | From: Month, line 2 | Numeric, 2 | 1 to 12 |
| TOYEAR2 | To: Year, line 2 | Numeric, 4 | 2026 |
| TOMONTH2 | To: Month, line 2 | Numeric, 2 | 1 to 12 |
| TUITIONFEES2 | Eligible tuition fees, line 2 | Currency | |
| PARTTIMEMONTHS2 | Number of months for: Part-time, line 2 | Numeric, 2 | 1 to 12 |
| FULLTIMEMONTHS2 | Number of months for: Full-time, line 2 | Numeric, 2 | 1 to 12 |
| FROMYEAR3 | From: Year, line 3 | Numeric, 4 | 2026 |
| FROMMONTH3 | From: Month, line 3 | Numeric, 2 | 1 to 12 |
| TOYEAR3 | To: Year, line 3 | Numeric, 4 | 2026 |
| TOMONTH3 | To: Month, line 3 | Numeric, 2 | 1 to 12 |
| TUITIONFEES3 | Eligible tuition fees, line 3 | Currency | |
| PARTTIMEMONTHS3 | Number of months for: Part-time, line 3 | Numeric, 2 | 1 to 12 |
| FULLTIMEMONTHS3 | Number of months for: Full-time, line 3 | Numeric, 2 | 1 to 12 |
| FROMYEAR4 | From: Year, line 4 | Numeric, 4 | 2026 |
| FROMMONTH4 | From: Month, line 4 | Numeric, 2 | 1 to 12 |
| TOYEAR4 | To: Year, line 4 | Numeric, 4 | 2026 |
| TOMONTH4 | To: Month, line 4 | Numeric, 2 | 1 to 12 |
| TUITIONFEES4 | Eligible tuition fees, line 4 | Currency | |
| PARTTIMEMONTHS4 | Number of months for: Part-time, line 4 | Numeric, 2 | 1 to 12 |
| FULLTIMEMONTHS4 | Number of months for: Full-time, line 4 | Numeric, 2 | 1 to 12 |
| 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 |