Import is an advanced feature available in eForms Standard and eForms Enterprise only
Cell A1 must contain “T4A”
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 | |
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 | 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 |