CDN T 4 PROCESS
Back to current versionRestore this version

CANADIAN T4 PROCESS#

This process allows organizations to report to the Canadian government, from the employees' YTD information, according to the government defined requirements and to generate the Magnetic Media files for this reporting.

Current Year End Changes#

New for 2018
The High Line RPT4W and RPT4AW programs generate the form boxes, as well as the instructions on the reverse side. Pre-printed forms are no longer required.

The Canadian Government does not require employees to provide consent. As such, employees do not have to give consent in order to get their T4 forms online.

New BET4 self service form! Displays a pdf copy of an employee's T4. This function is more performant than the RET4 function, as it the windward report server is not utilized.

RET4 is still available for organizations who prefer to use it.

The Electronic Consent logic has been removed, which means the employees do not have to give consent in order to get their T4/Releve 1 forms online. Organizations can now print the forms for selected employees using the new report parameter 'Status Type' and other existing report filters.

Code 37 - Employee home relocation loan deduction
For 2018 and subsequent taxation years, the employee home relocation loan deduction has been eliminated. This change was announced in the 2017 federal budget.

Elimination of Code 70 - Municipal officer's expense allowance
For 2019 and subsequent taxation years, non-accountable allowances paid to members of legislative assemblies and certain municipal officers will be fully included in their income. The use of code 70 will therefore no longer be needed.

Code 128 - Veteran's benefits eligible for pension splitting
Enter amounts received in the year for a retirement income security benefit paid to the individual under Part 2 of the Veterans Well-being Act. Also, report the amount in box 016.

Employer's Guide - Filing the T4 Slip and Summary
https://www.canada.ca/content/dam/cra-arc/formspubs/pub/rc4120/rc4120-18e.pdf

T4 Form#

For 2018 reporting, T4 (18) Form Layout is used.
https://www.canada.ca/en/revenue-agency/services/forms-publications/forms/t4.html https://www.canada.ca/content/dam/cra-arc/formspubs/pub/rc4120/rc4120-18e.pdf

The latest T4 form (18) has no changes in alignment from lat year's form.

T4 Government XML File#

There are no changes for the 2018 T4 Government XML File layout.

Please download CRA 2018 XML Schema from:
https://www.canada.ca/en/revenue-agency/services/e-services/filing-information-returns-electronically-t4-t5-other-types-returns-overview/upcoming-year-t619/t4.html

The IDIF form is configured for the 2018 xml schema format.

T4A Form#

For 2018 reporting, the T4A(17) Form Layout is used.
https://www.canada.ca/content/dam/cra-arc/formspubs/pbg/t4a/t4a-18e.pdf
https://www.canada.ca/en/revenue-agency/services/forms-publications/publications/rc4157.html

The latest T4A forms (18) has no changes in alignment from last year's form.

T4A Government XML File#

Please download CRA 2018 XML Schema from:
https://www.canada.ca/en/revenue-agency/services/e-services/filing-information-returns-electronically-t4-t5-other-types-returns-overview/upcoming-year-t619/t4a.html

The IDIF form is configured for the 2018 xml schema format.

T4A-NR Form#

For 2018 reporting, the T4A-NR (16) Form Layout is used.
https://www.canada.ca/content/dam/cra-arc/formspubs/pbg/t4a-nr/t4a-nr-18e.pdf https://www.canada.ca/content/dam/cra-arc/formspubs/pub/rc4445/rc4445-18e.pdf

NR4 Form#

For 2018 reporting, the NR4 (17) Form Layout is used.
https://www.canada.ca/content/dam/cra-arc/formspubs/pbg/nr4sum/nr4-sum-18e.pdf

Government Reporting Procedures#

Government Reporting Sequence#

The following steps outline the sequence to produce the Government Reports and Files, and to print the Forms:

RPREGT

IDFD

IDFDV

RDFD

IDIF

RDIF

RPYEC

IPGR

IPGH

RPGRC

Form Print

RMEX

UPGRUNDO

IDFD Form Definition#

IDFD - Form Code HL$CAN-T4-YYYY
#

(YYYY is the current reporting year)

The IDFD form provides on-line help and updates to the definition of T4s. This form defines the default values for users to enter on the IDFDV form.

High Line provides seed data scripts to our clients with the Year End software release to load in the IDFD Form Code SEED_IDFD_HL$CAN_T4_YYYY.sql.

IDFDV - Copy Last Year's Definition to Current Year#

After the HL$CAN-T4-YYYY information has been loaded, users can copy the 'IDFDV Variable' definition from last year to the current year by using the "Copy" button on the IDFDV form as follows:
  1. Select last year's Form Code
  2. Press the "Copy Form Definition" button
  3. The Copying dialog box is displayed. Enter the current year Form Code
  4. Set the "Copy Definition with Variables" toggle to ON. This will copy the variables set up from the previous year to the current year for the same Field Identifier name.

T4 Form Definition Variables#

The Variable Definition (IDFDV) form is used to enter the variable data needed to complete the printing of T4's, for both the printed T4s and the Magnetic Media files. On this form, users define where, in their particular set up, each required field of data will be retrieved from.

Example: Users can reference pay components, elements, database items, etc. For more information regarding the possible sources, refer the Field Descriptions table below.

Users should only work with the 'Field Source' and 'Field Variable' columns. The Derivation Expression field can be used by advanced users or under the guidance of a High Line consultant.

Please refer to Revenue Canada for a clearer and more in depth description of the appropriate method to complete your forms. Users should read the following Form Descriptions and refer to the 'Employer's Guide - Filing T4 Slip and Summary 2018 (RC4120)' prior to setting up IDFDV form.
https://www.canada.ca/content/dam/cra-arc/formspubs/pub/rc4120/rc4120-18e.pdf

IDFDV Field Descriptions#

FieldDesciption
IdentiferThis value defaults in from the IDFD form and shows the relevant box on the T4 form or stored on the file.
Seq #Defines the sequence number of the Identifier
DescriptionThis value defaults in from the IDFD form and displays the corresponding T4 Form Box description form or stored on the file.
LevelDefaults in from the IDFD form, displays the Level (Federal, State, Employer, etc.) that is being reported on for forms/media file.
O/R PromptDisplays the user-defined text (prompt) to print on the Summary Reports. These user-defined terms are not all used on the T4 forms but are all used on the summary reports.
SourceDefines the source of the variable data to report on the T4 from. The Source defines the Field Variables that will be available. Options are:
* Constant: Input a character string, such as the company name. Manual data entry
* Database column: Choose from a list of Data Base fields available
* Statistic: Choose from a list of Statistics from IDSC
* Pay Component: Choose from a list of Pay Components from IPPC
* Element: Choose from a list of Elements from IPPE
* IDGV Variable: Choose from a list of User Defined fields defined for the Government Registration (IDGV) form
Field VariableDefines the relevant value for the record from the LOV previously defined in the Source field.
Field UsageThis value defaults in from the IDFD form and defines where this record will be used. Options are: Form only, File only or Form and File.
TextDefaults in from the IDFD form, help/explanation text for the field.
Derivation ExpressionUsed to format the information so that it is presented as required.
Example: Users can show all of the information in upper case. This is where a string formula would be defined.

IDFDV T4 Form Code Identifiers#

IDFD FORM: HL$CAN-T4-YYYY - supplied by system IDFD FORM TYPE: CDN T4 Definition - defines the T4 definition is used

This section is curently being updated.

There is no page called 'IDFDV_Form_Definitions_CDN T4'. Would you like to create it?

Report T4 Form Definitions Variables - RDFD#

Generates a list of the T4 Form and File Definitions defined on the IDFDV form.

Special Notes for T4 Boxes#

Exclude EEs
Users can exclude certain employees from T4 reporting by setting up the EXCLUDE-EE Identifier on the IDFDV form.

If the value of the EXCLUDE-EE Identifier is set to Yes, the employee is by-passed.
Example: If a user does not want to report employees whose assignment title is "Election Worker" or "Self Employed", then:
For the EXCLUDE-EE Identifier, set up the following:

NOTE: Use UPPER(~) to convert an alphanumeric field to compare all upper case letters.

If a user has a complex situation to exclude an employee, a STAT CODE can be used to indicate the employee should be excluded.

Example: An employee is excluded when they work in certain groups, or with certain hours. Users can keep track of this by setting the STAT CODE value to 1.00.
Then on IDFDV, set up the following for the EXCLUDE-EE Identifier:


Primary and Mailing Addresses#

Employer Address
If a user wants to use the Employer Primary Address, the user does not need to set up the 1220 - 1270 Identifiers. Leave these Identifiers blank and the system will use the Primary Address as the default.

If a user wants to use the Employer Mailing Address, the user needs to define the following Identifiers:

Seq #Field IdentifierDescriptionField Variable
1220T4-ER-ADDR1Employee Address Line 1MAIL
1230T4-ER-ADDR2Employee Address Line 2Blank
1240T4-ER-ADDR3Employee CityBlank
1250T4-ER-ADDR4Employee ProvinceBlank or constant NAME
1260T4-ER-ADDR5Employee CountryBlank or constant NAME
1270T4-ER-POSTALEmployee Postal CodeBLANK
1280T4-ER-MAG-PROVEmployee Prov for Mag FileBlank
1290T4-ER-MAG-CNTRYEmployee Country for Mag FileBlank

Employee Address
If a user wants to use the Employee Primary Address, the user does not need to set up the 2100 - 2170 Identifiers. Leave these Identifiers blank and the system will use the Primary Address as the default.

If a user wants to use the Employee Mailing Address, the user needs to set up the following Identifiers:

Seq #Field IdentifierDescriptionField Variable
2100T4-EE-ADDR1Employee Address Line 1MAIL
2110T4-EE-ADDR2Employee Address Line 2Blank
2120T4-EE-ADDR3Employee CityBlank
2130T4-EE-ADDR4Employee ProvinceBlank or constant NAME
2140T4-EE-ADDR5Employee CountryBlank or constant NAME
2150T4-EE-POSTALEmployee Postal CodeBLANK
2160T4-EE-MAG-PROVEmployee Prov for Mag FileBlank
2170T4-EE-MAG-CNTRYEmployee Country for Mag FileBlank

T4 Processing#

Generate GVT Run for T4#

RPYEC - CANADIAN PAYROLL YEAR END SUMMARY#

This report extracts information from YTD according to the Form Code on IDFDV and produces the Summary Total Report by government registration.
This process also stores the results by GVT Run Number for each employee in the Government Reporting table.

RPYEC Report Parameters & Filters#

Report Parameters

FieldDescription
Form CodeMandatory. Enter the current year Form Code, defined on IDFDV.
NOTE: Always use current year form code, such as HL$CAN-T4-20YY.
DO NOT use a prior year form code as the Identifiers may be obsolete.
LOV available
Period TypeMandatory. Enter the Period Type, such as Month or Year. LOV available
Period End DateMandatory. Enter the end date of the reporting period. LOV Available
As of DateMandatory. Enter the start date of the reporting period. LOV Available
Govt Form OptionMandatory. Defines the type of form to be run. Options are:
* 01: New forms only
* 02: All normal forms
* 03: Duplicate forms
* 04: Amended forms
* 05: Rejected forms
* 06: Cancelled forms.
Govt Form Option LOV available
Retain Amend/Reject FormOptional. Should the original forms be retained when issuing an amended or replacement form that was rejected by the Government?
Yes/No LOV
Sort Level ByMandatory. How should the employees be grouped for sorting?
Sort Level By LOV available
Sort People ByMandatory. How should the employees on the report be sorted?
Sort People By LOV available
Sort by Active/InactiveOptional. Should the employees on the report be sorted by their status?
Sort By LOV available
Combine Fed RegistOptional. Should all the selected Federal Registrations reporting be combined?
If a Province code is defined in the report filters, users can combine the Federal Registration Numbers with the Provincial Registration Numbers so that employees are grouped together for the same Provincial Registration Numbers.
Yes/No LOV
Directory Name
File Name
Trace LevelOptional. Defines the level of detail to be printed on the report. Users should always run RPYEC with the Trace Level set to 'Exceptions Only' for all employees, unless required for tracing or debugging.

If there is problem in RPYEC and a user needs to determine which employee has the problem, the user should run RPYEC with the Trace Level set to Program Trace. This will print a list of processed employees to determine which employee has the problem.

When the Trace Level is set to Program Trace, the Select Statements for Federal, State and Local levels are also written as Trace messages. Users can review the select statements by running RMEX for the RPYEC Execution ID.

After determining which employee has the problem, users should run RPYEC for one employee with the Trace Level set to Utility Trace to determine the problem in detail. Trace Level LOV available.
Regist/Set Up AuditOptional. Defines whether to print exceptions that may exist from set up. Options are:
* 00 Do not print, run
* 01: Print, do not run
* 02: Print and run
* 03: Excp and run.
Print and Run LOV available
Print Employee DetailOptional. Defines whether to print the report with employee’s detailed information.
Yes/No LOV available
Trial Print OnlyOptional. Defines if the Print Stage field on the IPGH form will be updated when the T4s are printed.
When set to Yes, the field will not be updated. When set to No, the Print Stage will be changed to Forms Printed.
Yes/No LOV
Create Trace File
Create Data Dump
Process RemittanceOptional. To generate monthly remittances.
Yes/No LOV
Update RemittanceOptional. To update monthly remittances.
Yes/No LOV
User CommentOptional. Users can enter text that will print on the header of the report.

Report Filters

FieldDescription
EntityOptional. To define and report on a specific Entity.
LOV available
Federal Regist SetOptional. To define and report on a specific Federal Registration Set, defined on IDGV.
LOV available
Federal Regist NumberOptional. Defines the Employer Identification Number, defined on IDGV.
LOV available
People ListOptional. To define and report on the people in the defined list.
LOV available
PersonOptional. Enter the Person Code of the employee you are testing with.
LOV available
Select ProvinceOptional. To define and report on a specific Province.
LOV available
Province Regist SetOptional. To define and report on a specific Provincial Registration Set, defined on IDGV. Not required for Annual reporting.
LOV available
Prov Regist NumberOptional. To define and report on a specific Province Registration Number.
LOV available

RPYEC Notes

  • The RPYEC process produces a Summary Total Report by Government Registrations. Users must balance this report to the RPREGT report.
  • Each RPYEC run generates one Government Run Number (GVT Run).
  • All employees processed by the RPYEC run belong to this GVT Run Number. At end of RPYEC, the Government Reporting Statistics are printed with the generated GVT Run Number. After RPYEC is run, users can go into the IPGR (Government Run) form to view the details by the GVT Run number.
  • On the IPGR form, the employee’s detail government reporting information can be viewed. Alternately, users can go directly to the IPGH (Government Header) form by employee to view this information.
  • Users can process many RPYEC runs for different sets of employees. This generates multiple GVT Run numbers. Users can run one RPGRC (Government Reporting) run to pick up all GVT Runs to generate one Print Form file for printing and one government interface file.
  • Employee’s Government Header information are re-generated by subsequent RPYEC runs if the Government Header has not been filed to the government. The same IPGH information is removed automatically when a new IPGH is re-generated.
  • At the end of each run, the RPYEC process removes any GVT Run Number that does not have GVT Header associated with it.
  • Users can run the RPYEC process concurrently for different sets of employees.
  • At the beginning of the RPYEC run, the Execution Run Log is stamped with the Execution Start Date. At the end of RPYEC run, the Execution End Date is stamped.
  • For concurrent RPYEC runs that have not been finished with the Execution End Date, any other concurrent RPYEC runs will not remove the GVT Run Number, even if there are no GVT Headers.

Form Print Selection Criteria#

T4 Printing and Balancing#

New for 2018: The High Line RPT4W and RPT4AW programs generate the form boxes, as well as the instructions on the reverse side. Pre-printed forms are not required.

Once the year-to-date information is correct, run the RPT4W report to print the T4 Forms.

The PDF file is generated in the working directory of your P2K path.

Write down the Execution ID of the T4 Print Program report and run RMEX to obtain a grand total report.

RPT4W Report Parameters #

FieldDescription
Print T4 CopyDefines if the Employer or Employee copy will be printed. Options are:
*01: Employer Copy. Prints 2 employees on one page. Use as the Employer Copy to send to government or keep for reference.
*02: Employee Copy. Prints 1 employee 2 times on 1 page. Use as the Employee Copy to distribute to the employees
Duplicate/AmendedOptional. Defines the text to print on the T4 form to indicate if it is a 'Duplicate' or an 'Amended' copy.
Include Back InformationWhen set to YES, the report will print the information from the back of the T4.
Trial Print onlyDefines if the Print Stage field on the IPGH form will be updated when the T4s are printed.
When set to Yes, the field will not be updated.
When set to No, the Print Stage will be changed to Forms Printed.
Optional.
Exception LevelDefines the level of detail on the exception report. Users should always run with 'Exception Only' unless for needed for tracing

RPT4W Report Filters#

FieldDescription
GVT RunMandatory. Defines the GVT Run number to extract data from and produce the T4 form.
PersonOptional. Person code of the employee being tested with. If a Person Code is not defined, all the employees in the xml file will be printed.
People ListOptional. A people list may be used to indicate specific employees that are to be processed.
Status TypeOptional. Allows organizations to print forms for a defined Status Type. Options are:
* Active
* Cobra
* Inactive
* Leave
*Pending
*Retired
*Survivor
* Terminated
*Unpaid Leave

Execution Report

Processing#

RPT4W Form Print Processing#

New for 2018: The RPT4W and RPT4AW programs generate the form boxes, as well as the instructions on the reverse side. Pre-printed forms are not required.

The RPT4W Program Print Format is based on the Government published T4 (18) Form.

Form Printing#

When printing T4 forms, users are required to print the Employer Copy and Employee Copy of the T4s.

Duplicate Copies#

If an employee loses their T4 Form, organizations can issue a duplicate copy of the T4 form.

To issue Duplicate Copies:
1. Go to the IPGH form for the employee and highlight the form to be duplicated.

2. Run RPGRC with the "GVT Form Option" set to "Duplicate forms" and the "Trial Print Only" set to Yes

3. Run RPT4W to print the duplicate forms

Amended Copies#

If a user discovers erroneous box information on the T4 form and needs to revise the Box information, users should either correct the employee amounts or modify the IDFDV set up and then re-run the RPYEC, RPGRC and RPT4W processes. This produces the Amended T4 form. To issue Amended copies:

1. Update the employee's YTD information through payroll. 2. Check the IDFDV set up and revise the box information, if necessary 3. Go to the IPGH form for the employee. Locate the form to be amended

4. Run RPGRC with the GVT Form Option set to Amended Forms

5. Run RPT4W to print the Amended forms.

UPGRUNDO - Undo GVT Run#

The UPGRUNDO process allows users to undo a GVT Run number by employee. This process should be used to undo an erroneous GVT Run due to set up issues or to remove any archived GVT information.

UPGRUNDO Selection Criteria#

FieldDescription
GVT Run NumberMandatory. Users must enter at least one GVT Run Number
Person CodeEnter one or more Person Codes. The selected Person codes within the GVT Run Numbers are processed. Optional.
Trace LevelUsers should always run this process with this field set to Exceptions Only unless required for tracing purposes.
TrialWhen set to ON, allows users to review the report for verification prior to running the undo process.

In non-trial mode, UPGRUNDO removes GVT Headers and GVT Run for the qualified GVT Run.
Optional.

T4 Slip Print Distribution#

On the T4 Form, the last line in the Address Box is used to print the user defined distribution information for users to dsitribute the T4 forms to the employees. Users must set up the following identifiers:

Field IdentifierField VariableSuggested Field Variable
T4-EE-DISTRConstantBlank or 1
T4-EE-DESTINConstantBlank or 1
T4-EE-DISTR1 DED.ENTITY_CODE
T4-EE-DISTR2 EID.PERSON_CODE

If T4-EE-DISTR = 1 (not null), the distribution will be printed below the employee address for distribution purposes, and the distribution will be visible outside the window envelope. Otherwise, the distribution will not be printed.

If T4-EE-DESTIN = 1, the employee's pay destination will be printed along with T4-EE-DISTR1 and T4-EE-DISTR2 fields.

Therefore, the logic for printing the distribution on the T4 form is:
If T4-EE-DISTR = 1, the distribution information is printed from:

T4 Statement of Remuneration#

Box Descriptions#

Users should read the following Form Descriptions and refer to "Employers' Guide - Filing the T4 Slips and Summary Forms" RC4120(E) Rev. 18" prior to setting up the IDFDV form.

Box - Year
From user defined Calendar Year YYYY

Box - Employer's Name and Address
Derived from the IDFDV form

Seq #Field IdentifierDescriptionField Variable
1220T4-ER-ADDR1Employer Address Line 1MAIL
1230T4-ER-ADDR2Employer Address Line 2Blank
1240T4-ER-ADDR3Employer CityBlank
1250T4-ER-ADDR4Employer ProvinceBlank or NAME
1260T4-ER-ADDR5Employer CountryBlank or NAME
1270T4-ER-POSTALEmployer Postal Code Blank
1280T4-ER-MAG-PROVEmployer Prov for Mag FileBlank
1290T4-ER-MAG-CNTRYEmployer Country for Mag FileBlank

Box 54 - Business Number
The Business Number is derived automatically according to employee's YTD federal government registration number from IDGV or the employee's Group IDGR form. When users are printing the 'Employee Copy', Box 54 is not printed.

Box 10 - Province of Employment
The Province of Employment is derived automatically according to employee's YTD information

Box 12 - Employee's Social Insurance Number
Derived from the IDFDV form

Seq #Field IdentifierSuggested Field Variable
2200 T4-BOX-SINEID.GOVERNMENT_CODE

Box - Employee's name
Derived from the IDFDV form

Seq #Field IdentifierSuggested Field Variable
2000 T4-EE-NAME1EID.LAST_NAME
2030 T4-EE-NAME2EID.FIRST_NAME
2040 T4-EE-NAME3EID.MIDDLE_NAME

Box - Employee's address
Derived from the IDFDV form

Seq #Field IdentifierDescriptionField Variable
2100T4-EE-ADDR1Employee Address Line 1Blank or MAIL
2110T4-EE-ADDR2Employee Address Line 2Blank
2120T4-EE-ADDR3Employee City Blank
2130T4-EE-ADDR4Employee ProvinceBlank or NAME
2140T4-EE-ADDR5Employee CountryBlank or NAME
2150T4-EE-POSTALEmployee Postal Code Blank
2160T4-EE-MAG-PROVEmployee Prov for Mag FileBlank
2170T4-EE-MAG-CNTRYEmployee Country for Mag FileBlank

Box - Last line of Employee Address
Derived from the IDFDV form The last line in the Address Box is used to print the user defined distribution information for users to distribute the T4 forms to employees.

Seq #Field IdentifierField VariableSuggested Field Variable
2210 T4-EE-DISTRConstantBlank or 1
2215 T4-EE-DESTINConstantBlank or 1
2220 T4-EE-DISTR1 DED.ENTITY_CODE
2230 T4-EE-DISTR2 EID.PERSON_CODE

Therefore, the logic for printing the distribution on the T4 form is:
If T4-EE-DISTR = 1, the distribution information is printed from:

Box 14 - Employment Income
Derived from the IDFDV form

Seq #Field IdentifierSuggested Field Variable
3000 T4-BOX-14T4-BOX-14
This is the taxable earnings applicable for federal income tax withheld

Box 16 - Employee's CPP Contributions
Derived from the IDFDV form

Seq #Field IdentifierSuggested Field Variable
3010 T4-BOX-16T4-BOX-16

Box 17 - Employee's QPP contributions
Derived from the IDFDV form

Seq #Field IdentifierSuggested Field Variable
3030 T4-BOX-17T4-BOX-17

Box 18 - Employee's EI Premiums
Derived from the IDFDV form

Seq #Field IdentifierSuggested Field Variable (Element)
3040 T4-BOX-18T4-BOX-18

Box 20 - RPP Contributions
Derived from the IDFDV form

Seq #Field IdentifierSuggested Field Variable (Element)
3060 T4-BOX-20T4-BOX-20

Box 22 - Income Tax Deducted
Derived from the IDFDV form

Seq #Field IdentifierSuggested Field Variable (Element)
3070 T4-BOX-22T4-BOX-22

Box 24 - EI Insurable Earnings
Derived from the IDFDV form

Seq #Field IdentifierSuggested Field Variable (Element)
3080 T4-BOX-24T4-BOX-24
  1. There are no insurable earnings. Example: If Box 24 = 0, then Box 24 = blank.
  2. Insurable earnings are the same as the employment income in Box 14. Example: If Box 24 = Box 14, then Box 24 = blank.
  3. Insurable earnings are over the EI maximum earnings for the year, from IPCT, Tax Rate Code '011001', EI Annual Maximum Earnings.
Example: If Box 24 >= EI maximum earnings, then Box 24 = Blank. Users should verify the reported EI Insurable Earnings are correct according to the government specifications.

Box 26 - CPP/QPP Pensionable Earnings
For all provinces except Quebec:

Seq #Field IdentifierSuggested Field Variable (Element)
3090 T4-BOX-26-CPPT4-BOX-26-CPP

For Quebec only:
Seq #Field IdentifierSuggested Field Variable (Element)
3100 T4-BOX-26-QPPT4-BOX-26-QPP

For all provinces and Quebec:
Seq #Field IdentifierSuggested Field Variable (Element)
3110 T4-BOX-26-EXCEPTT4-BOX-26-EXCEPT
3120 T4-BOX-26-OTHERT4-BOX-26-OTHER
Example: if Box 26 >= CPP/QPP maximum earnings, then Box 26 = Blank Users should verify the reported CPP/QPP Pensionable Earnings are correct according to the government specifications.

Box 28 - Exempt (CPP-QPP and EI and PPIP)

Seq #Field Identifier
3130 T4-BOX-28-CPP-PRT
3140 T4-BOX-28-QPP-PRT
3150 T4-BOX-28-EI-PRT
3155 T4-BOX-28-PPIP-PRT


Box 29 - Employment Code
Report the appropriate code if one of the following situations applies:

11Placement agency - self employed
12Driver of taxi or other passenger-carrying vehicle
13Barber or hairdresser
14Withdrawal from a prescribed salary deferral arrangement plan
15Seasonal Agriculture Workers Program
16Detached employee - social security agreement
Seq #Field Identifier
3160 T4-BOX-29-PRTThis is used for the XML file only


Box 44 - Union Dues
Derived from the IDFDV form and the IDUN form, T4 UNION DUES field

Seq #Field IdentifierSuggested Field Variable (Element)
3180 T4-BOX-44T4-BOX-44

Box 46 - Charitable Donations
Derived from the IDFDV form

Seq #Field IdentifierSuggested Field Variable (Element)
3190 T4-BOX-46T4-BOX-46


Box 50 - RPP or DPSP Registration Number
Derived from the IDFDV form

Seq #Field IdentifierSuggested Field VariableSuggested Field Variable (Element)
3200 T4-BOX-50-REG1Constant
3210 T4-BOX-50-REG2Constant
3220 T4-BOX-50-REG3Constant
3230 T4-BOX-50-REG4Constant
3240 T4-BOX-50-REG5Constant
3205 T4-BOX-50-RPP1 T4-BOX-50-RPP1
3215 T4-BOX-50-RPP2 T4-BOX-50-RPP2
3225 T4-BOX-50-RPP3 T4-BOX-50-RPP3
3235 T4-BOX-50-RPP4 T4-BOX-50-RPP4
3245 T4-BOX-50-RPP5 T4-BOX-50-RPP5

Box 52 - Pension Adjustment
Derived from the IDFDV form

Seq #Field IdentifierSuggested Field Variable
3260 T4-BOX-52T4-BOX-52

Box 55 - Employee's PPIP Premiums
Derived from the IDFDV form

Seq #Field IdentifierSuggested Field Variable
3270 T4-BOX-55T4-BOX-55

Box 56 - PPIP Insurable Earnings
Derived from the IDFDV form

Seq #Field IdentifierSuggested Field Variable
3290 T4-BOX-56T4-BOX-56

Box - Other Information
Derived from the IDFDV form

Seq #Field IdentifierSuggested Field Variable
4nnnOTHER-nnT4-BOX-OTH-nn

Magnetic Media File - Government XML file#

IDIF - T4 Government XML File layout#

The government XML file layouts are provided by the government on their web site each year. High Line uses the IDIF form to define the government file as specified, in an xml format.

High Line delivers the IDIF form layout using Seed data along with the Year End release. Users do not need to modify this form

Users must run the RPYEC and RPGRC processes to generate the Magnetic Media file in the government XML file format. Please refer to the 'Government Reporting Procedures, Sequence' section that describes how the process is run.

Validating the Govt XML File#

IMPORTANT: The government requires users to validate the government XML file according to the downloaded government XML schema, using a validating parser prior to sending the file to the government. A validating parser tool from any third party will perform the following checks on the government XML file generated by RPGRC:
  1. Verify the government XML file is properly created according to the XML syntax rules, such as the file is well formed, no missing xml tags, etc.
  2. Verify the government XML file conforms to the schema downloaded from the government web site.

Validating parser software is NOT provided by High Line. Organizations can use any third party validating parser tool.

High Line uses the XML SPY Home edition tool to validate the T4 and T4A xml files.

Electronic T4 Print Program#

NEW for 2018:

The Canadian Government does not require employees to provide consent. As such, employees do not have to give consent in order to get their T4 forms online and the Electronic Consent logic has been removed.

Organizations can now print the forms for selected employees using the new report parameter 'Status Type' and other existing report filters.

New BET4 self service form! Displays a pdf copy of an employee's T4. This function is more performant than the RET4 function, as the windward report server is not utilized.
BET4 reports the current year T4 only.

RET4 is still available for organizations who prefer to use it. On RET4, employees define the year they want to print and launch the report to generate their T4. The output is in a pdf format.

Organizations can control the years the T4 forms are available for employees to print, by setting the EE_T4_GVT_RUN Preference on the IMST form.

Setup/Implementation#

Users must set up the EE_T4_GVT_RUN Preference with the values of the Gvt Run Numbers that contain the information for the employee's T4s (from the RPYEC run) on the IMST form, 'Preference' tab. The GVT Run numbers must be entered with comma separators and no spaces, such as 1234,3333,4567).


Notes #

Click to create a new notes page