This page (revision-70) was last changed on 19-Oct-2022 20:29 by Karen Parrott

This page was created on 26-Nov-2021 10:22 by kparrott

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
70 19-Oct-2022 20:29 46 KB Karen Parrott to previous
69 26-Nov-2021 10:22 47 KB Karen Parrott to previous | to last
68 26-Nov-2021 10:22 46 KB Karen Parrott to previous | to last
67 26-Nov-2021 10:22 46 KB Meg McFarland to previous | to last
66 26-Nov-2021 10:22 46 KB Meg McFarland to previous | to last
65 26-Nov-2021 10:22 46 KB Meg McFarland to previous | to last
64 26-Nov-2021 10:22 46 KB Meg McFarland to previous | to last
63 26-Nov-2021 10:22 46 KB Meg McFarland to previous | to last
62 26-Nov-2021 10:22 45 KB kparrott to previous | to last
61 26-Nov-2021 10:22 45 KB kparrott to previous | to last

Page References

Incoming links Outgoing links
CDN T 4 PROCESS
CDN T4 PROCESS

Version management

Difference between version and

At line 9 changed one line
An amendment reason explanation tag has been added at the Summary level for the following form types: T4, T4A, T4A-NR, T4RSP, T4RIF, T4E, T4AP, T4OAS, T1204, PRPP, T5, T5007, T5008, T5013, T5018, T3, NR4, TFSA, RRSP. The tag is not mandatory and is intended allow a filer to provide a brief explanation for the amendments within the file, up to 1309 characters. \\https://www.canada.ca/en/revenue-agency/services/e-services/filing-information-returns-electronically-t4-t5-other-types-returns-overview/filing-information-returns-electronically-t4-t5-other-types-returns-what-you-should-know-before.html#xmlspcs
The High Line RPT4/RPT4W/RPT4AW programs generate the form boxes, as well as the instructions on the reverse side. __Pre-printed forms are not required.__
At line 11 added one line
ADD LOGI BET4 HERE
At line 12 changed 2 lines
!T4 Form
Employer's Guide - Filing T4 Slip and Summary 2017 (RC4120)|https://www.canada.ca/content/dam/cra-arc/migration/cra-arc/E/pub/tg/rc4120/rc4120-17e.pdf
__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.
At line 15 changed 2 lines
For 2017 reporting, T4 (14) Form Layout is used.\\
https://www.canada.ca/content/dam/cra-arc/migration/cra-arc/E/pbg/tf/t4/t4flat-14b.pdf
__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.
At line 18 changed one line
The latest T4 form (14) has no changes in alignment from lat year's form.
!T4 Form
For 2019 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.
At line 23 changed one line
The 2017 T4 Government XML File layout change for this reporting year. An amendment reason explanation tag has been added at the Summary level.
There are no changes for the 2019 T4 Government XML File layout. \\
At line 25 changed 2 lines
Please download CRA 2017 XML Schema from:\\
http://www.cra-arc.gc.ca/esrvc-srvce/rf/hwfl-eng.html
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
At line 28 changed one line
* The IDIF form is configured for the 2017 xml schema format.
The IDIF form is configured for the 2019 xml schema format.
At line 37 added 4 lines
!T4A Form
For 2018 reporting, the T4A(18) 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 \\
At line 31 changed 8 lines
T4A Form
For 2017 reporting, the T4A(17) Form Layout is used. \\
https://www.canada.ca/content/dam/cra-arc/migration/cra-arc/E/pbg/tf/t4a/t4a-17e.pdf \\
https://www.canada.ca/content/dam/cra-arc/migration/cra-arc/E/pub/tg/rc4157/rc4157-17e.pdf
* The latest T4A forms (17) has no changes in alignment from last year’s form.
The latest T4A forms (18) has no changes in alignment from last year’s form.
At line 40 changed one line
The 2017 T4A Government XML File layout change for this reporting year. An amendment reason explanation tag has been added at the Summary level. \\
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 \\
At line 42 changed 2 lines
Please download CRA 2017 XML Schema from: \\
http://www.cra-arc.gc.ca/esrvc-srvce/rf/hwfl-eng.html
The IDIF form is configured for the 2019 xml schema format.
At line 45 removed one line
* The IDIF form is configured for the 2017 xml schema format.
At line 47 changed 3 lines
!T4ANR Form
For 2017 reporting, the T4ANR (16) Form Layout is used. \\
http://www.cra-arc.gc.ca/E/pbg/tf/t4a-nr/t4a-nr-16e.pdf
!T4A-NR Form
For 2018 reporting, the T4A-NR (18) 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
At line 53 changed 2 lines
For 2017 reporting, the NR4 (17) Form Layout is used. \\
https://www.canada.ca/content/dam/cra-arc/migration/cra-arc/E/pbg/tf/nr4/nr4-17e.pdf
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
At line 125 changed one line
!IDFD - Form Code HL$CAN-T4-YYYY (where YYYY is the current reporting year)
!IDFD - Form Code HL$CAN-T4-YYYY \\(YYYY is the current reporting year) \\ \\
At line 136 changed one line
# On the IDFDV form, select last year's Form Code
# Select last year's Form Code
At line 148 changed one line
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 2017 (RC4120)’ prior to setting up IDFDV form.
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 \\
At line 155 changed one line
|Level|Defaults from the IDFD form, displays the Level (Federal, State, Employer, etc.) that is being reported on for forms/media file.
|Level|Defaults in from the IDFD form, displays the Level (Federal, State, Employer, etc.) that is being reported on for forms/media file.
At line 166 changed one line
* Employer’s Guide – Filing T4 Slip and Summary 2017 (RC4120)
* Employer’s Guide – Filing T4 Slip and Summary 2018 (RC4120)
At line 174 removed 135 lines
||Field Identifier||Description||Suggested Field Source||Suggested Variable
|T4-ER-NAME|Employer Name|Data Base Column|DED.ENTITY_NAME
|T4-ER-NAME2|Employer Name Line 2|Data Base Column|DED.ENTITY_NAME, optional
|T4-ER-CAREOF|Employer Name (care of)|Data Base Column|optional
|T4-ER-ADDR1|Employer Address Line 1|Data Base Column|DLN.ADDRESS_LINE_1
|T4-ER-ADDR2|Employer Address Line 2|Data Base Column|DLN.ADDRESS_LINE_2
|T4-ER-ADDR3|Employer City|Data Base Column|DLN.LOCALITY
|T4-ER-ADDR4|Employer Province|Data Base Column|DSP.STATE_PROVINCE_CODE
|T4-ER-ADDR5|Employer Country|Data Base Column|DCO.COUNTRY_CODE
|T4-ER-POSTAL|Employer Postal Code|Data Base Column|DLN.ZIP_POSTAL
|T4-ER-MAG-PROV|Employer Prov for Mag File|Constant|blank
|T4-ER-MAG-CNTRY|Employer Country for Mag File|Constant|blank
|T4-ACCT-NAME|Accounting contact name|Constant|Enter your company data
|T4-ACCT-TEL-AREA|Accounting contact tel area code|Constant|Enter your company data
|T4-ACCT-TEL|Accounting contact telephone|Constant|Enter your company data
|T4-ACCT-TEL-EXT|Accounting contact tel extn|Constant|Enter your company data
|T4-ACCT-LANG|Accounting contact Language|Constant|E
|T4-REGIST-PEN1|Registered pension plan number 1|Constant|Enter your company data
|T4-REGIST-PEN2|Registered pension plan number 2|Constant|Enter your company data
|T4-REGIST-PEN3|Registered pension plan number 3|Constant|Enter your company data
|T4-REGIST-PEN4|Registered pension plan number 4|Constant|Enter your company data
|T4-REGIST-PEN5|Registered pension plan number 5|Constant|Enter your company data
|T4-PROP1-SIN|Proprietor #1 SIN |Constant|Enter your company data
|T4-PROP2-SIN|Proprietor #2 SIN |Constant|Enter your company data
|T4-YOUTH-IND|Youth Hires Program Indicator|Constant|1
|T4-EE-NAME1|Employee Surname|Data Base Column|EID.LAST_NAME
|T4-EE-NAME2|Employee First Name|Data Base Column|EID.FIRST_NAME
|T4-EE-NAME3|Employee Middle Initial|Data Base Column|EID.MIDDLE_NAME
|T4-EE-ADDR1|Employee Address Line 1|Constant|EPS.ADDRESS_LINE_1
|T4-EE-ADDR2|Employee Address Line 2|Constant|EPS.ADDRESS_LINE_2
|T4-EE-ADDR3|Employee City|Constant|EPS.LOCALITY
|T4-EE-ADDR4|Employee Province|Constant |DSP.STATE_PROVINCE_CODE
|T4-EE-ADDR5|Employee Country|Constant|DCP.COUNTRY_CODE
|T4-EE-POSTAL|Employee Postal Code|Constant|EPS.ZIP_POSTAL
|T4-EE-MAG-PROV|Employee Prov for Mag File|Constant|blank
|T4-EE-MAG-CNTRY|Employee Country for Mag File|Constant|blank
|T4-BOX-SIN|Social Insurance Number|Data Base Column|EID.GOVERNMENT_CODE
|T4-EE-DISTR|Print Distribution on T4 form|Constant|blank or 1\\If 1, print employee distribution
|T4-EE-DESTIN|Print Pay Destination|Constant|blank or 1\\If 1, the employee destination is concatenated to employee distribution for printing purposes
|T4-EE-DISTR1|Employee Distribution 1|Data Base Column|PPA.PAYROLL_CODE
|T4-EE-DISTR2|Employee Distribution 2|Data Base Column|EID.PERSON_CODE
|T4-BOX-14|Employment Income|Element|T4-BOX-14
|T4-BOX-16|Employee's CPP contribution|Element|T4-BOX-16
|T4-BOX-16-ER|Employer's CPP contribution|Element|T4-BOX-16-ER
|T4-BOX-17|Employee's QPP contribution|Element|T4-BOX-17
|T4-BOX-17-ER|Employer's QPP contribution|Element|T4-BOX-17-ER
|T4-BOX-18|Employee's EI Premiums|Element|T4-BOX-18
|T4-BOX-18-ER|Employer's EI Premiums|Element|T4-BOX-18-ER
|T4-BOX-20|RPP contributions|Element|T4-BOX-20
|T4-BOX-22|Federal Income Tax deducted|Element|T4-BOX-22
|T4-BOX-24|EI Insurable Earnings|Element|T4-BOX-24
|T4-BOX-24-PRT|EI Insurable Earnings Printed|Not specified|Information only, do not set up this identifier
|T4-BOX-26-CPP|CPP Pensionable Earnings|Element|T4-BOX-26-CPP
|T4-BOX-26-QPP|QPP Pensionable Earnings|Element|T4-BOX-26-QPP
|T4-BOX-26-EXCEPT|CPP/QPP Excepted Earnings|Element|T4-BOX-26-EXCEPT
|T4-BOX-26-OTHER|CPP/QPP Other Earnings|Element|T4-BOX-26-OTHER
|T4-BOX-26-PRT|CPP/QPP Earnings Printed|Not specified|Information only, do not set up this identifier
|T4-BOX-28-CPP-PRT|CPP Exempt Indicator|Not specified|Information only, do not set up this identifier
|T4-BOX-28-QPP-PRT|QPP Exempt Indicator |Not specified|Information only, do not set up this identifier
|T4-BOX-28-EI-PRT|EI Exempt Indicator|Not specified|Information only, do not set up this identifier
|T4-BOX-28-PPIP-PRT|PPIP Exempt Indicator|Not specified |Information only, do not set up this identifier
|T4-BOX-29-PRT|Employment Code|Not specified|Information only, do not set up this identifier
|T4-BOX-44|Union Dues|Element|T4-BOX-44
|T4-BOX-44-PRT|Union Dues Printed|Not specified |Information only, do not set up this identifier
|T4-BOX-46|Charitable Donations|Element|T4-BOX-46
|T4-BOX-50-REG1|RPP Registration Number 1|Data Base Column|constant, must be numeric
|T4-BOX-50-REG2|RPP Registration Number 2|Data Base Column|constant, must be numeric
|T4-BOX-50-REG3|RPP Registration Number 3|Data Base Column|constant, must be numeric
|T4-BOX-50-REG4|RPP Registration Number 4|Data Base Column|constant, must be numeric
|T4-BOX-50-REG5|RPP Registration Number 5|Data Base Column|constant, must be numeric
|T4-BOX-50-RPP1|RPP Amount 1|Element|T4-BOX-50-RPP1
|T4-BOX-50-RPP2|RPP Amount 2|Element|T4-BOX-50-RPP2
|T4-BOX-50-RPP3|RPP Amount 3|Element|T4-BOX-50-RPP3
|T4-BOX-50-RPP4|RPP Amount 4|Element|T4-BOX-50-RPP4
|T4-BOX-50-RPP5|RPP Amount 5|Element|T4-BOX-50-RPP5
|T4-BOX-50-PRT|RPP or DPSP Plan Number Printed|Not specified|Information only, do not set up this identifier
|T4-BOX-52|Pension Adjustment|Element|T4-BOX-52
|T4-BOX-55|PPIP Employee Premium|Element|T4-BOX-55
|T4-BOX-55-ER|PPIP Employer Premium|Element|T4-BOX-55-ER
|T4-BOX-56|PPIP Insurable Earnings|Element|T4-BOX-56
|OTHER-30|Housing, Board and Lodging|PC or Element|T4-BOX-OTH-30
|OTHER-31|Special work site|PC or Element|T4-BOX-OTH-31
|OTHER-32|Travel in prescribed zone|PC or Element|T4-BOX-OTH-32
|OTHER-33|Medical travel|PC or Element|T4-BOX-OTH-33
|OTHER-34|Personal use of employer auto|PC or Element|T4-BOX-OTH-34
|OTHER-35|Reasonable KM allowance|PC or Element |T4-BOX-OTH-35
|OTHER-36|Interest free loan|PC or Element|T4-BOX-OTH-36
|OTHER-37|Home relocation loan deduction|PC or Element|T4-BOX-OTH-37
|OTHER-38|Stock option benefits|PC or Element|T4-BOX-OTH-38
|OTHER-39|Stock option 110(1)(d)|PC or Element|T4-BOX-OTH-39
|OTHER-40|Other Taxable benefits|PC or Element|T4-BOX-OTH-40
|OTHER-41|Stock option 110(1)(d.1)|PC or Element|T4-BOX-OTH-41
|OTHER-42|Employment Commissions|PC or Element|T4-BOX-OTH-42
|OTHER-53|Deferred stock option benefits|PC or Element|T4-BOX-OTH-53
|OTHER-70|Officer expense allowance|PC or Element|T4-BOX-OTH-70
|OTHER-71|Status Indian employee|PC or Element|T4-BOX-OTH-71
|OTHER-72|Section 122.3 income|PC or Element|T4-BOX-OTH-72
|OTHER-73|Number of days outside Canada|PC or Element|T4-BOX-OTH-73
|OTHER-74|Pre 1990 Past Serv-Contributor|PC or Element|T4-BOX-OTH-74
|OTHER-75|Pre 1990 Past Serv-Not Contributor|PC or Element|T4-BOX-OTH-75
|OTHER-77|Workers Compensation repaid|PC or Element|T4-BOX-OTH-77
|OTHER-78|Fishers Gross earnings|PC or Element|T4-BOX-OTH-78
|OTHER-79|Fishers Net partnership amt|PC or Element|T4-BOX-OTH-79
|OTHER-80|Fishers Shareperson amt|PC or Element |T4-BOX-OTH-80
|OTHER-81|Placement Agency Earnings|PC or Element|T4-BOX-OTH-81
|OTHER-82|Drivers Earnings|PC or Element|T4-BOX-OTH-82
|OTHER-83|Barbers Earnings|PC or Element|T4-BOX-OTH-83
|OTHER-84|Public Transit Pass|PC or Element|T4-BOX-OTH-84
|OTHER-85|EE prem private health plan|PC or Element|T4-BOX-OTH-85
|OTHER-86|Security Options selections|PC or Element|T4-BOX-OTH-86
|OTHER-87|Emergency services volunteer exempt amount|PC or Element|T4-BOX-OTH-87
|OTHER-88|Indian (exempt income)|PC or Element|T4-BOX-OTH-88
|OTHER-97|Stock option benefit-before Feb 28, 2000|PC or Element|T4-BOX-OTH-97
|OTHER-98|Stock dedn 110(1)(d)-before Feb 28, 2000|PC or Element|T4-BOX-OTH-98
|OTHER-99|Stock dedn 110(1)(d.1)-before Feb 28, 2000|PC or Element|T4-BOX-OTH-99
|SUB-REF-ID|Submission Reference ID|Constant|Unique number for each filing
IDIF is set up to use GVT Run Number for Submission Reference ID as default, if users want to override the GVT Run Number, then enter the value in this IDFDV Identifier and manually change the IDIF set up for the <sbmt_ref_id> tag to pick up the Variable Name from IDFDV Identifier with this SUB-REF-ID sequence
|FILE-TYPE-CODE|Transmitter Type Code|Constant|Constant '904' for T4
|FILE-DATA-TYPE|Data Type Code|Constant|1
|FILE-TRAN-NUM|Transmitter number|Constant|MM999999
|FILE-TRAN-TYPE|Transmitter type indicator|Constant|1
|FILE-TRAN-NAME1|Transmitter Name - line 1|Constant|Enter your company data
|FILE-TRAN-NAME2|Transmitter Name - line 2|Constant|Enter your company data
|FILE-TRAN-ADDR1|Transmitter Address - line 1|Constant|Enter your company data
|FILE-TRAN-ADDR2|Transmitter Address - line 2|Constant|Enter your company data
|FILE-TRAN-CITY|Transmitter City|Constant|Enter your company data
|FILE-TRAN-PROV|Transmitter Province|Constant|Enter your company data
|FILE-TRAN-COUNTRY|Transmitter Country|Constant|Enter your company data
|FILE-TRAN-POSTAL|Transmitter Postal Code|Constant|Enter your company data
|FILE-CONT-NAME|Technical contact name|Constant|Enter your company data
|FILE-CONT-TEL-AREA|Technical contact tel area code|Constant|111
|FILE-CONT-TEL|Technical contact telephone|Constant|2223333
|FILE-CONT-TEL-EXT|Technical contact tel extn|Constant|1234
|FILE-CONT-LANG|Technical contact Language|Constant|E
|FILE-CONT-EMAIL|Contact E-mail address|Constant|Enter your company data
At line 180 added one line
[{InsertPage page='IDFDV_FORM_DEFINTIONS'}]
At line 182 added 2 lines
At line 374 changed one line
*Users can print a specific Province, or all Provinces. If all Provinces are to be printed, the Print Program will print a T4 form for each province that an employee has worked in.
* Users can print a specific Province, or all Provinces. If all Provinces are to be printed, the Print Program will print a T4 form for each province that an employee has worked in.
At line 376 changed one line
*If an employee is paid by multiple government registrations, then multiple T4 slips are produced, by government registration number, for the employee.
* If an employee is paid by multiple government registrations, then multiple T4 slips are produced, by government registration number, for the employee.
At line 378 changed one line
*T4 slips are printed in alphabetical order by the employee's Surname, First Name, within a government registration number.
* T4 slips are printed in alphabetical order by the employee's Surname, First Name, within a government registration number.
At line 380 changed one line
*The font size for printing T4 slips is the standard 10 or 12 character per inch font, character mode.
* The font size for printing T4 slips is the standard 10 or 12 character per inch font, character mode.
At line 382 changed one line
*Negative (credit) amounts are never allowed for T4 reporting. If negative amounts are encountered, an exception message is printed and users must resolve the negative amount(s) and re-run the process.
* Negative (credit) amounts are never allowed for T4 reporting. If negative amounts are encountered, an exception message is printed and users must resolve the negative amount(s) and re-run the process.
At line 384 changed one line
*If there is no amount to be printed in a Box on the T4 form, the Box is left as BLANK. A zero amount or 'NIL' is __NOT__ allowed.
* If there is no amount to be printed in a Box on the T4 form, the Box is left as BLANK. A zero amount or 'NIL' is __NOT__ allowed.
At line 386 changed one line
*Users can sort inactive and active employees separately for mailing purposes.
* Users can sort inactive and active employees separately for mailing purposes.
** If the Employment Status is A (Active) then the employee is considered active, otherwise the employee is considered inactive.
At line 388 changed one line
*If the Employment Status is A (Active) then the employee is considered active, otherwise the employee is considered inactive.
* The T4 slip has an "Other Information" area to report up to 6 footnote codes and amounts for each form.
At line 390 removed 2 lines
*The T4 slip has an "Other Information" area to report up to 6 footnote codes and amounts for each form.
At line 396 changed one line
*If an employee works in more than one province, then one T4 slip is produced for each province for the employee. The "Other Information" area T4 slips are also generated by Province.
* If an employee works in more than one province, then one T4 slip is produced for each province for the employee. The "Other Information" area T4 slips are also generated by Province.
At line 398 changed one line
*The T4 Magnetic Media File also includes the subsequent T4 record(s) with the Other Information area in the same manner as the T4 slip. Consequently, an employee can have multiple "110" code records. The Box 14 reporting for the additional code "110" records will also contain $1.00.
* The T4 Magnetic Media File also includes the subsequent T4 record(s) with the Other Information area in the same manner as the T4 slip. Consequently, an employee can have multiple "110" code records. The Box 14 reporting for the additional code "110" records will also contain $1.00.
At line 400 changed one line
*The alphanumeric fields are left justified with no space between each character, such as JOHN DOE, not J O H N D O E.
* The alphanumeric fields are left justified with no space between each character, such as JOHN DOE, not J O H N D O E.
At line 402 changed one line
*The numeric fields are lined up with the decimal.
* The numeric fields are lined up with the decimal.
At line 404 changed one line
*T4 grand totals are generated for all T4 forms as Execution Run Log Exception Messages to balance to the RPYEC Summary report
* T4 grand totals are generated for all T4 forms as Execution Run Log Exception Messages to balance to the RPYEC Summary report
At line 409 removed 3 lines
!RPYEC - Cdn Year End Summary Report - Selection Criteria
This report extracts information from YTD records 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 tables.
At line 413 removed 4 lines
* This report is used to balance to the Year-To-Date Register (RPREGT)
* Users must check the exception messages from this Summary Report and correct any exceptions
* Generate the T4 File in the federal format
* Generate the XML file to populate the T4 Print Programs to print the T4 Forms for all processed employees
At line 418 changed 22 lines
! RPYEC Report Parameters
||Field||Desciption
|Form Code|Mandatory. Form Code that is defined on the IDFDV form.\\NOTE: Always use current year form code. DO NOT use a prior year form code as the Identifiers may be obsolete. \\For 2017-2018 reporting, the current year form code contains the Store Option field to store the Employer Addresses, Employee Addresses and Amounts in the government remittance tables, which can be viewed on the IPGR or IPGH forms.
|Period Type|Enter the Year for Annual Reporting
|Period End Date|Enter the Year Ending Date
|As of Date|The start date of the reporting period
|Govt Form Option|Mandatory. Defines the type of form to be run. Options are: \\* 01: New Forms only \\* 02: All normal forms \\* 03: Duplicte forms \\* 04: Amended forms \\* 05: Rejected forms \\* 06: Cancelled forms
|Retain Amend/Reject Forms|Should the original forms be retained when issuing an amended or replacement form that was rejected by the Government?
|Sort Level By|Mandatory. How should the employees be grouped for sorting?
|Sort People By|Mandatory. How should the employees on the report be sorted?
|Sort Active/Inactive|Mandatory. Should the employees on the report be sorted by their status?
|Combine Fed Regist|Should all the selected Federal Registrations reporting be combined? \\If a Province code is defined in the report filters, users can combine the Fed Registration Numbers with the Prov Registration Numbers so that employees are grouped together for the same Prov Registration Numbers.
|Directory Name|The name of the directory where the government Magnetic Media file will be stored.
|File Name|The name of the government Magnetic Media file
|Trace Level|Users should always run RPYEC with the Trace Level set to Exceptions Only for all employees.\\ \\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.
|Regist/Set Up Audit|Option 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 Employee Detail|Option to print the report with employee’s detailed information
|Trial Print Only|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.
|Create Trace File|To generate trace files. One file is for dynamic SQL Select statement, the other is a comma delimited spreadsheet to display all trace messages.
|Create Data Dump|When set to Yes, the RPYEC process will generate data dump files with a .csv extension for the Federal information. Users can open these data dump files in Excel for debugging and balancing purposes.
|Process Remittance|To generate monthly remittances
|Update Remittance|To update monthly remittances
[{InsertPage page='RPYEC'}]
At line 441 removed 75 lines
!RPYEC Report Filters
||Field||Desciption
|Entity|To define and report on a specific Entity
|Federal Regist Set|To define and report on a specific Federal Registration Set (on IDGV)
|Federal Regist Number|Employer Identification Number (on IDGV)
|People List|This field limits the process to the people in the defined list.
|Person|Person Code of employee you are testing with
|Prov Regist Set|To define and report on a specific Provincial Registration Set (on IDGV). Not required for Annual reporting.
|Prov Regist Numbers|To define and report on a specific Province Registration Number.
__Notes for RPYEC__
* 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 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.
* Alternately, users can go directly to IPGH (Government Header) inquiry form by employee
* 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, RPYEC 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.
!!Canadian Government Reporting - RPGRC
This is the Government Payroll Reporting for Canada. This process reads the Government Reporting table information generated by the RPYEC process. \\ \\
A Summary Total Report, by government registration, or by employee detail, for a selected Form Code, as defined on IDFDV, is generated. \\ \\
Users should run the [RPGRC] process to generate the:
* Internal xml files for the Form Print programs, such as RPT4 and RPT4W/RPT4AW, to print the T4 and T4A forms
* Magnetic Media xml file to submit to the government. The government requires users to validate the government xml file according to the downloaded government xml schema, using a validating parser prior to submitting it to the government.
Each RPGRC run generates one GVT Run (Government Run Number). All employees processed by the RPGRC run belong to this GVT Run Number. \\ \\
After RPGRC is run, users can go into the IPGR form to view the details by 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 RPGRC runs for different sets of employees. This generates multiple GVT Run Numbers. \\ \\
At the end of each run, the RPGRC process removes any GVT Run Number that does not have GVT Headers associated with it. \\ \\
Once the government xml file is generated, it is ready for an xml parser validation prior to sending the file to the government.
!RPGRC Report Parameters
||Field||Description
|Form Code|Mandatory. Form Code that is defined on the IDFDV form.\\NOTE: Always use current year form code. DO NOT use a prior year form code as the Identifiers may be obsolete. \\ \\For 2017-2018 reporting, the current year form code contains the Store Option field to store the Employer Addresses, Employee Addresses and Amounts in the government remittance tables, which can be viewed on the IPGR or IPGH forms.
|Govt Interface Format|Enter HL$CAN-T4-YYYY\\This Interface Format is defined on the IDIF form and is provided in our software
|Period Type|Enter the Year for Annual Reporting
|Period End Date|Enter the Year Ending Date
|As of Date|The start date of the reporting period
|Govt Form Option|Mandatory. Defines the type of form to be run. Options are: \\* 01: New Forms only \\* 02: All normal forms \\* 03: Duplicte forms \\* 04: Amended forms \\* 05: Rejected forms \\* 06: Cancelled forms
|Sort Level By|Mandatory. How should the employees be grouped for sorting?
|Sort People By|Mandatory. How should the employees on the report be sorted?
|Sort Active/Inactive|Mandatory. Should the employees on the report be sorted by their status?
|Directory Name|The name of the directory where the government Magnetic Media file will be stored.
|File Name|The name of the government Magnetic Media file
|Trace Level|Users should always run RPYEC with the Trace Level set to Exceptions Only for all employees. \\ \\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.
|Print Employee Detail|Option to print the report with employee’s detailed information
|Trial Print Only|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.
|Create File|To generate trace files. One file is for dynamic SQL Select statement, the other is a comma delimited spreadsheet to display all trace messages.
!RPGRC Report Filters
||Field||Description
|GVT Run Number|Enter the GVT Run Number from the RPYEC run
|Entity|To define and report on a specific Entity
|Federal Regist Set|To define and report on a specific Federal Registration Set (on IDGV)
|Federal Regist Number|Employer Identification Number (on IDGV)
|People List|This field limits the process to the people in the defined list.
|Person|Person Code of employee you are testing with
|Prov Regist Set|To define and report on a specific Provincial Registration Set (on IDGV). Not required for Annual reporting.
|Prov Regist Numbers|To define and report on a specific Province Registration Number.
After the [RPGRC] process is run, the government xml file is generated and is ready for an xml parser validation prior to sending to the government. The internal xml file is generated for printing of the T4s by the RPT4 process.
At line 288 added 2 lines
__New for 2018: The High Line RPT4/RPT4W/RPT4AW programs generate the form boxes, as well as the instructions on the reverse side. Pre-printed forms are not required.__\\
At line 521 changed 2 lines
* This report completes and prints the T4 forms, as well as the T4 Media file, based on the parameter selections
* Produces the T4 Forms
* This function generates and prints the T4 forms, as well as the T4 Media file, based on the parameter selections
At line 528 changed one line
All T4 Form Print programs are aligned with the government forms in the PDF format. Users can adjust the parameters for the Top Margin and the Between Form Space when generating the PDF file. Once the PDF file is generated, users will not need to adjust the Page Set up when printing. \\ \\
At line 531 removed one line
%%warning IMPORTANT: When printing from the pdf file, users must set the Page Sizing and Handling to “Actual Size” to print on the pre-printed government forms to avoid re-sizing of the form.%%
At line 534 changed one line
!RPT4 Report Parameters __* Oracle Report Only * __
!RPT4 Report Parameters __* Oracle Report Only * __ \\
__2018 is the last year end Oracle Reports are supported.__
At line 574 changed one line
|GVT Run (WW Only)|Mandatory (when running Windward report only). Defines the GVT Run number to extract data from and produce the T4 form.
|GVT Run|Mandatory. Defines the GVT Run number to extract data from and produce the T4 form.
At line 356 added one line
New for 2018: The RPT4/RPT4W/RPT4AW programs generate the form boxes, as well as the instructions on the reverse side. Pre-printed forms are not required. \\
At line 587 changed one line
The RPT4/RPT4W Program Print Format is based on the Government published T4 (15) Form. High Line recommends using the same form version as the RPT4/RPT4W program. \\ \\
The RPT4/RPT4W Program Print Format is based on the Government published T4 (18) Form. \\ \\
At line 589 removed 2 lines
If you are using other versions of the T4 form, such as T4(14), please test the RPT4/RPT4W form layout prior to printing. If the RPT4/RPT4W program does not align with the form, users should re-order the form from the government so it is the same version that the RPT4/RPT4W process is programmed for. \\ \\
This page (revision-70) was last changed on 19-Oct-2022 20:29 by Karen ParrottTop