T4A 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.
Cell A1 MUST contain “T4A”| 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 | |
| RECBN | Recipient Business No. (13) | Text, 15 | |
| RECIPIENTNO | Recipient’s number (14) | Text, 20 | |
| CORPNAME1 | Recipient corporation name line 1 | Text, 50 | |
| CORPNAME2 | Recipient corporation name line 2 | Text, 50 | |
| T4ADENTALCODE | Payer-offered dental benefits (15) | Text, 1 | |
| SUPER | Pension or superannuation (16) | Currency | |
| LUMPSUM | Lump-sum payments (18) | Currency | |
| SELF | Self-employed commissions (20) | Currency | |
| TAX | Income tax deducted (22) | Currency | |
| ANNUITIES | Annuities (24) | Currency | |
| RETIRING | Eligible retiring allowances (26) | Currency | |
| RETIRINGNON | Non-eligible retiring allowances (27) | Currency | |
| OTHER | Other income (28) | Currency | |
| PATRONAGE | Patronage allocations (30) | Currency | |
| PAST | RPP contributions (past service)(32) | Currency | |
| PENSION | Pension adjustment (34) | Currency | |
| PENSIONNO | Pension plan reg. number (36) | Text, 7 | |
| RESPACCUM | RESP accum. income payments (40) | Currency | |
| RESPED | RESP educational assist. pay’ts (42) | Currency | |
| CHARITABLE | Charitable donations (46) | Currency | |
| FEES | Fees for services (48) | Currency | |
| RESPPAYMENTSOTHER | RESP accumulated income payments to other (122) | Currency | |
| RECIPIENTPAIDHEALTHPLANS | Recipient paid premiums for private health services plans (135) | Currency | |
| LABOURADJUSTMENTBENEFITS | Labour adjustment benefits act and appropriation act (150) | Currency | |
| SUBPQUALIFIED | SUBP qualified under the Income Tax Act (152) | Currency | |
| CASHAWARD | Cash award or prize from payer (154) | Currency | |
| BANKRUPTCY | Bankruptcy settlement (156) | Currency | |
| UNREGPEN | Unregistered pension plan (109) | Currency | |
| SIPENSION | Status Indian-pension or superannuation (146) | Currency | |
| LUMPSUMACC | Lump-sum pymt. accrued to 12/31/71 (110) | Currency | |
| LUMPSUMSI | Status Indian - Lump-sum payments (148) | Currency | |
| LUMPSUMRPP | Lump-sum payments (RPP-not eligible) (108) | Currency | |
| LUMPSUMDPSP | Lump-sum payments (DPSP-not eligible) (180) | Currency | |
| LUMPSUMNONRES | Lump-sum pymt. (non-resident services) (102) | Currency | |
| LUMPSUMUNREG | Lump-sum pymt. (unreg’d pension ben.) (190) | Currency | |
| LUMPSUMNOTRANS | Lump-sum pymt. (no trans.) (158) | Currency | |
| DPSPANNUITY | Instalment or annuity pymt. under DPSP (115) | Currency | |
| IAACANNUITY | IAAC annuity (111) | Currency | |
| RETIRINGSI | Status Indian-eligible retiring allowance (142) | Currency | |
| RETIRINGNONSI | Status Indian-non-elig. retiring allowance (143) | Currency | |
| OTHERSI | Status Indian - other income (144) | Currency | |
| OTHERDPSP | Instalment / annuity under revoked DPSP (115) | Currency | |
| BOARDSITE | Board and lodging at special work sites (124) | Currency | |
| MEDTRAVEL | Medical travel (116) | Currency | |
| LOANBENEFIT | Loan benefit under subsection 80.4(2) (117) | Currency | |
| RESEARCH | Research Grants (104) | Currency | |
| SCHOLARSHIP | Scholarships, fellowships, or bursaries (105) | Currency | |
| WAGELOSS | Income from wage loss plans (107) | Currency | |
| DEATHBENEFIT | Death benefits (106) | Currency | |
| MEDBENEFIT | Medical Premium benefit (118) | Currency | |
| DISABILITY | Disability benefits (125) | Currency | |
| GROUPTERMLIFE | Group Term Life Insurance Benefit (119) | Currency | |
| VETERANSBENEFIT | Veteran’s benefits (127) | Currency | |
| APPRENTICESHIPINCENTIVE | Apprenticeship Incentive Grant (130) | Currency | |
| TAXDEFPATDIVIDENDS | Tax deferred patronage dividends (129) | Currency | |
| RPPPRE1990 | RPP (pre-1990 past service) (126) | Currency | |
| REGISTEREDDISABILITY | Registered disability savings plan (131) | Currency | |
| WAGEEARNERPROTECTION | Wage earner protection program (132) | Currency | |
| VARIABLEPENSION | Variable pension benefits (133) | Currency | |
| TFSATAXAMOUNT | TFSA taxable amount | Currency | |
| PARENTSMURDEREDCHILDRENGRANT | Federal support for parents of missing or murdered children (136) | Currency | |
| NONCONTRIBUTORRPPPASTSERVICE | Non contributor RPP past service pre-19990 contributions (162) | Currency | |
| PRPPPAYMENTSTAXABLE | PRPP payments from taxable income (194) | Currency | |
| PRPPPAYMENTSEXEMPT | PRPP payments from exempt income (195) | Currency | |
| SASKPENSIONPLANSPOUSALCONTRIBUTORIND | Saskatchewan Pension Plan spousal contributor indicator | Text, 1 | |
| SASKPENSIONPLANSPOUSALCONTRIBUTORSIN | Saskatchewan Pension Plan contributor SIN | 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 |