CANADIAN TAX REMITTANCE#
PURPOSE:
To produce a summary report with remittance information gathered from employees’ monthly or YTD data that is produced according to user-defined selection criteria. STEPS:
The following procedure follows the same steps for producing T4 forms. On the summary report, the remittance information is provided. Please also read PR_can_T4_Process_2005.doc for T4 processing.
1) RPREGT produce register for monthly or YTD information
2) IDFD set up form and file definitions this screen specifies for users the default values to enter on the IDFDV screen the information on this screen is provided with a script by High Line, the user only needs to execute the script in order to load in the most current information for the year
IDFDV set up 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
3) RPYEC produce summary report by employee for the specified ‘Form Code’ from IDFDV set up when RPYEC is run, the user should enter ‘Y’ to ‘Process Remittance?’ at the end of the ‘Government Registration Total’, the remittance information is provided the user 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.
4) IMCT the user can view the remittance information with table code ‘CAN REMITTANCE’ the IMCT remittance total is a cumulative total for the period processed, therefore, the user only needs 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, the user 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 PR_T4_Process_2005.doc document
PROCESSING
When RPYEC is run, the user must answer the prompts for ‘Process Remittance’ and ‘Update Remittance’
When ‘Update Remittance’ = ‘Yes’, the remittance information is stored in P2K_AM_CUSTOM_TABLES with CUSTOM_TABLE_CODE = ‘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
The user 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:
The user 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.
The user 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, the user can view the remittance on the IMCT screen.
The information on this screen is maintained internally by RPYEC
The user 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, the user can double click on the data area to view the information using ‘Notepad’.
5) IMCT SCREEN IN ‘NOTEPAD’
The user can double click on IMCT screen ‘Data’ area, in order to view the remittance information using ‘Notepad’.