This page (revision-28) was last changed on 26-Nov-2021 10:22 by mmcfarland

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

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
28 26-Nov-2021 10:22 4 KB mmcfarland to previous
27 26-Nov-2021 10:22 5 KB mmcfarland to previous | to last
26 26-Nov-2021 10:22 4 KB kparrott to previous | to last
25 26-Nov-2021 10:22 4 KB kparrott to previous | to last
24 26-Nov-2021 10:22 4 KB jmyers to previous | to last
23 26-Nov-2021 10:22 4 KB jmyers to previous | to last
22 26-Nov-2021 10:22 4 KB jmyers to previous | to last
21 26-Nov-2021 10:22 4 KB jmyers to previous | to last

Page References

Incoming links Outgoing links
CDN TAX REMITTANCE
CDN TAX REMITTANCE

Version management

Difference between version and

At line 5 changed one line
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. \\
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.
At line 7 changed one line
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|CDN T4 PROCESS] section.
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|CDN T4 PROCESS 2010] section.
At line 9 changed one line
%%information [RPYEC] and the tax remittance process will report for the province of Quebec, if [IDFDV] is set up.\\In order to report Quebec taxation, [RPYEC] should be run as follows:\\ \\Period Type = ‘Month’\\Province = ‘Quebec’\\Govt Form Option = ‘All normal forms’%%
!!Steps
!Step 1
[RPREGT]
*Produce register for monthly or YTD information.
At line 11 changed 3 lines
__RPREGT__\\
* Produce the Monthly or YTD register.
* For the "Provide Totals By" parameter, select "Fed Regist Number" \\ \\
!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.
At line 20 added 3 lines
[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.
At line 16 changed 4 lines
__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 with the Year End software \\ \\
[RDFD]
*Use this screen to report the form and file definition from the [IDFD] and [IDFDV] screens.
At line 21 changed 3 lines
__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. \\ \\
!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].
At line 25 changed 2 lines
__RDFD__\\
* Print the Form and File Definitions from [IDFD] and [IDFDV]. \\ \\
!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.
At line 28 removed 16 lines
__RPYEC__\\
* Means "Report Payroll Year End Canada"
* Extracts information from YTD information according to the 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 '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]. \\ \\
__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. \\ \\
At line 45 changed 2 lines
* On the Define Payrolls form [IPPR], users must define 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|CDN T4 PROCESS] section.
*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|CDN T4 PROCESS 2010] section.
At line 49 changed 6 lines
* 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|CUSTOM_TABLE_CODE] set to 'CAN REMITTANCE'
* The amounts are stored in [P2K_AM_CUSTOM_VALUES] table 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
*When [RPYEC] is run, you must answer the prompts for 'Process Remittance' and 'Update Remittance'.
[CDN TAX REMITTANCE_01.JPG]
At line 56 changed one line
*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.
*When the Update Remittance field is set to <Yes>, the remittance information is stored in [P2K_AM_CUSTOM_TABLES] with the [Custom Table code|CUSTOM_TABLE_CODE] set as 'CAN REMITTANCE'
At line 50 added 4 lines
*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
At line 55 added 5 lines
*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.
At line 61 changed 3 lines
\\
*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.
*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.
At line 65 changed 5 lines
!IMCT Form
*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, users can double click on the data area to view the information using Notepad.
*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.
At line 71 changed 2 lines
!IMCT Form in Notepad
*Users can double click on IMCT form Data area, in order to view the remittance 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.
This page (revision-28) was last changed on 26-Nov-2021 10:22 by mmcfarlandTop