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 "R1"

 

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

 

EMPNUM

Employee number, reference number

Text, 20

 

EMPCODE

Employment code (29)

Text, 2

 

CPPWEEKS

Weeks eligible for CPP/QPP

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

2024

UNION

Union dues (44)

Currency

 

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

 

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

 

QPP

QPP contributions (B)

Currency

 

EI

EI premiums (C)

Currency

 

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

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