T4 & Relevé 1 Headings

FIRST TOPIC  BACK  PREVIOUS TOPIC  NEXT TOPIC

eForms Standard & Enterprise Only

 

Cell A1 (import from Excel) or the first data element (import from CSV) must contain "T4"

 

Use this table to import Relevé 1 data with T4 data, see bottom of this table for Relevé 1 specific fields

 

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

 

SIN

Social insurance number (12)

Text, 9

 

PROVEMP

Province of employment (10)

Text, 2

"QC" forces creation of Relevé 1

EMPNUM

Employee number, reference number

Text, 20

 

EMPCODE

Employment code (29)

Text, 2

 

CPPWEEKS

Weeks eligible for CPP

Numeric, 4

2 digits + 2 decimals: 52.00, 52.5, etc.

SLIPSTATUS

Status of slip

Text, 1

O - Original,

A - Amended or

C - Cancelled

(R, A or D will be shown on filed Relevé 1s)

TAXYEAR

Taxation year

Numeric, 4

2023

INCOME

Employment income (14)

Currency

 

CPP

CPP contributions (16)

Currency

 

QPP

QPP contributions (17, B)

Currency

 

CPP2

CPP2 contributions (16A)

Currency

2024 and later

QPP2

QPP2 contributions (17A)

Currency

2024 and later

EI

EI premiums (18, C)

Currency

 

RPP

Reg. Pension plan contr. (20)

Currency

 

TAX

Federal income tax deducted (22)

Currency

 

EIEARN

EI insurable earnings (24)

Currency

EIEARN & CPPEARN will default to 0.00 if no data is imported; marked as overridden fields on the T4 and will not be recalculated as Box 14 is modified.

CPPEARN

CPP pensionable earnings (26)

Currency

CPPEXEMPT

CPP exempt (28)

Yes/No

No

EIEXEMPT

EI exempt (28)

Yes/No

No

PPIPEXEMPT

PPIP exempt (28)

Yes/No

No

NOCPPADJUST

Do not adjust CPP

Yes/No

No

NOEIADJUST

Do not adjust EI

Yes/No

No

NOPPIPADJUST

Do not adjust PPIP

Yes/No

No

UNION

Union dues (44)

Currency

 

DENTALBENEFITS

Employer-offered dental benefits (45)

Text, 1

 

CHARITABLE

Charitable donations (46)

Currency

 

PENSIONNO

RPP/DPSP number (50)

Text, 7

 

PENSION

Pension adjustment (52)

Currency

 

PPIP

PPIP premiums (55, H)

Currency

 

PPIPEARN

PPIP earnings (56, I)

Currency

 

Generic boxes where # is one numeral (1 to 6):

OTHERCODE#

Other information - Box # code

Text, 2

 

OTHERAMT#

Other information - Box # amount

Currency

 

NETPAYOTHER

Other deductions from Net Pay

Currency

For net pay calc.

TEXTATTOP

Optional text to print at top of slip

Text, 15

 

EMAILADDRESS

Recipient email address

Text, 255

eForms Enterprise only

One email address, or two separated by a semi-colon

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

ADDITIONAL HEADINGS FOR Relevé 1 FIELDS

 

 

CODEBOXOR1

Code for Box O

Text, 2

 

IDNOQ

Recipient Quebec identification number

Numeric,10

 

ISBUSINESS

Recipient is business

Yes/No

No

INCOMER1

Employment income (A)

Currency

 

 

Box B: See QPP in T4 section above

 

 

 

Box C: See EI in T4 section above

 

 

RPPR1

Reg. Pension plan contr. (D)

Currency

 

TAXR1

Québec income tax deducted (E)

Currency

 

UNIONR1

Union dues (F)

Currency

 

QPPEARN

QPP pensionable earnings (G)

Currency

Must contain data

 

Box H: See PPIP in T4 section above

 

 

 

Box I: See PPIP in T4 section above

 

 

HEALTHR1

Private health insurance (J)

Currency

 

TRAVELR1

Travel (K)

Currency

 

OTHERTBR1

Other taxable benefits (L)

Currency

 

COMMISSIONS

Employment commissions (M)

Currency

 

CHARITABLER1

Charitable donations (N)

Currency

 

OTHERINC

Other taxable income (O)

Currency

 

INSURANCE

Multi-employer insurance (P)

Currency

 

DEFERRED

Deferred salary (Q)

Currency

 

INDIANINC

Exempt income for an Indian (R)

Currency

 

TIPS

Tips received (S)

Currency

 

TIPSALLOCATED

Tips allocated (T)

Currency

 

PHASEDRETIRE

Phased retirement (U)

Currency

 

HOUSING

Meals and accommodation (V)

Currency

 

AUTOR1

Personal use of auto (W)

Currency

 

FNOTE1R1

Footnote #1

Text, 30

 

FNOTE2R1

Footnote #2

Text, 30

 

FNOTE3R1

Footnote #3

Text, 30

 

NETPAYOTHERR1

Other deductions from Net Pay

Currency

For net pay calc.

SERIAL

Sequential (Relevé) number of paper slip

Numeric, 9

 

SERIALORIGINAL

Sequential (Relevé) number of previously-filed paper slip (user-entered)

Numeric, 9

 

SERIALMM

Sequential (Relevé) number of XML slip

Numeric, 9

 

SERIALMMPREVIOUS

Sequential (Relevé) number of previously-filed XML slip

Numeric, 9

 

TEXTATTOPR1

Optional text to print at top of slip

Text, 15

 

Generic boxes where ## is two numerals (01 to 04):

XBOX##

Additional Information - Box ##: Box number

Text, 7

 

XAMT##

Additional Information - Box ##: Currency data

Currency

 

XTXT##

Additional Information - Box ##: Character data

Text, 20

 

CUSTOMFIELD

GUID or other unique identifier

Text, 50

eForms Enterprise only

CUSTOMPASSWORD

Password for recipient PDF slip

Text, 20

eForms Enterprise only