CANADIAN TAX REMITTANCE#

This section explains how to produce a summary report with remittance information generated from the employees' monthly or YTD data according to the user-defined selection criteria.

The following procedure follows the same steps for producing T4 forms. On the summary report, the remittance information is provided. Please also read the Canada T4 Process section.

Steps#

• Produce the Monthly or YTD register.
  
  

Step 2
IDFD

• Set up the Form Code and the Government File Definitions.
• This form defines the default values for users to enter on IDFDV.
• The information on this form is provided by High Line using a script. Users only need to execute the script to load the most current information

IDFDV

• Set up the Form and File Definitions with your user information.
• Populate the field variable by looking up and selecting the Pay Component abbreviation.

RDFD

• Print the Form and File Definitions from IDFD and IDFDV.
  
  

Step 3
RPYEC

• Extracts information from YTD according the to Form Code on IDFDV
• Produce the Summary Total Report, by government registration or by employee detail.
• When RPYEC is run, the "Process Remittance" field should be set to Yes.
• At the end of the 'Government Registration Total', the remittance information is provided.
• Users must verify the Summary Total balances to the YTD Register report.
• Users should check the exception messages from the Summary Report and correct any exceptions.
• Users should use the 'Summary Report Remittance Balance' to remit to the government
• Stores results by GVT Run Number for each employee in the Government Reporting tables in the database.
• In 'Remit Update' mode, the remittance information is stored by 'Government Registration', 'To-date Type' and 'Period' in P2K_AM_CUSTOM_TABLES and P2K_AM_CUSTOM_DATA.
  
  

Step 4
IMCT

• Users can view the remittance information with the table code 'CAN REMITTANCE'
• The IMCT remittance total is a cumulative total for the period processed, therefore, users only need to look at the most recent record for the period to view the total remittance amounts for that period.
  
  

Set Up#

• On the Define Payrolls form IPPR, users must define that the monthly information must be stored in order for RPYEC to process the monthly information.
• The set up for the IDFDV form, and all other forms, is described in the Canada T4 Process section.

Processing#

• When RPYEC is run, users must define the 'Process Remittance' and 'Update Remittance' fields.

• When the "Update Remittance" field is set to Yes, the remittance information is stored in the P2K_AM_CUSTOM_TABLES with the Custom Table Code set to 'CAN REMITTANCE'
• The amounts are stored in P2K_AM_CUSTOM_VALUES with:
  • CUSTOM_KEY: Government Registration + IDFDV Form Code
  • CUSTOM_SUBKEY: Todate Type + Period + 'As of Date'
  • CUSTOM_DATA: The total remittance amounts for the period

• Users can select either Form Code 'HL$CAN-T4-2017' or 'HL$CAN-TAXATION'. Form code 'HL$CAN-TAXATION' contains all Canadian Legislation PC usages for reporting.

RPYEC Report#

• RPYEC extracts information from the YTD records according to the Form Code on IDFDV and produces a Summary Total Report by Government Registration. At the end of each government registration, the remittance information is provided.
• This process also stores the results by GVT Run Number for each employee in the Government Reporting tables.
  
  

Sample RPYEC Summary Report#

• Users will use the summary report to review the remittance balance line to remit the appropriate amounts to the government according to each government registration on the report.
• There can be multiple government registrations on the IDGR group form, if employees belong to a group that has a different Government Registration. In this case, the summary report and remittance information are generated for each government registration.

IMCT Screen#

• After RPYEC remittance is run in Update mode, users can view the remittance information on the IMCT form.
• The information on this form is generated by RPYEC.
• Users can adjust the information on this form if an amount is incorrect, or delete a record so RPYEC can generate the remittance amounts again.
• In order to align the remittance amounts in the data window, you can double click on the data area to view the information using Notepad.

IMCT Screen in Notepad#

• Users can double click on IMCT form Data area, in order to view the remittance information using Notepad.

Notes #