This is version 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 . It is not the current version, and thus it cannot be edited.

Back to current versionRestore this version

CANADIAN TAX REMITTANCE#

This section explains how to produce a summary report with remittance information gathered from the employees' monthly or YTD data that is produced according to 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#

Step 1#

RPREGT

• Produce register for monthly or YTD information.

Step 2#

IDFD

• Set up the form and file definitions.
• This screen specifies the default values to enter on the IDFDV screen.
• The information on this screen is provided with a script; you only need to execute the script in order to load in the most current information for the year.

IDFDV

• Set up the form and file definitions with user information.
• Populate the field variable by performing a look-up and selecting the pay component abbreviation.

RDFD

• Use this screen to report the form and file definition from the IDFD and IDFDV screens.

Step 3 #

RPYEC

• Produce a summary report by employee for the specified 'Form Code' from the IDFDV set up.
• When RPYEC is run, the Process Remittance field should be set to <Y>.
• At the end of the 'Government Registration Total', the remittance information is provided.
• You should use the 'Summary Report Remittance Balance' for remittance to the government
• 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

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

Set Up#

• On IPPR payroll screen, you must indicate that monthly information must be stored in order for RPYEC to process monthly information.
• The set up for the IDFDV screen and all other screens is described in the Canada T4 Process section.

Processing#

• When RPYEC is run, you must answer the prompts for 'Process Remittance' and 'Update Remittance'

• When the Update Remittance field is set to <Yes>, the remittance information is stored in P2K_AM_CUSTOM_TABLES with the Custom Table code set as 'CAN REMITTANCE'

• The amounts are stored in P2K_AM_CUSTOM_VALUES with:
  • CUSTOM_KEY = Government Registration + IDFD form code
  • CUSTOM_SUBKEY = Todate Type + Period + 'As of Date'
  • CUSTOM_DATA = the total remittance amounts for the period

• You may select either form code 'HL$CAN-T4-2005' or 'HL$CAN-TAXATION'. Form code 'HL$CAN-TAXATION' contains all Canadian legislation PC usages for reporting.

RPYEC Report#

• RPYEC will generate a summary report by 'Employee' according to the form code set up. At the end of each government registration, the remittance information is provided.

Sample RPYEC Summary Report#

• You 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.

• You can have multiple government registrations on the IDGR group screen, 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, you can view the remittance on the IMCT screen.
• The information on this screen is maintained internally by RPYEC.
• You can also adjust this screen if the amount is incorrect, or delete the record so that 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#

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

---

Notes #

Click to create a new notes page