Canadian Payroll History Audit (R77703)
To ensure that the system records the correct amounts on the tax and year-end reports, you should run the Canadian Payroll History Audit Report (R77703) each month and before you process year-end reports. You should correct any variances that appear on this report before you print tax or year-end reports.
The Canadian Payroll History Audit Report compares detail history information with summary history information and produces an exception report listing any inconsistencies between the summary and detail history information. This report does not make any corrections to the summary or detail tables.
The Canadian Payroll History Audit Report verifies that tax type CA exists for every employee that has a record for any of the following tax types in the F0713 table: CB, CC, CD, CE, CF, CG, or CH.
If an employee does not have tax type CA, the year-end workfile will be invalid. Therefore, it is very important that you run the Canadian Payroll History Audit Report and correct any errors before you generate the year-end workfile.
You use the processing options to specify whether this report compares basic history information, pay check history information, or both.
If you choose to compare basic history information, the report compares the information in these tables:
Summary Tables |
Detail Tables |
|---|---|
F0713 |
F0716 |
F06145 |
F0719 |
F06146 |
F0618 and F0719 |
F06176 |
F0716 |
If you choose to compare pay check history information, the report compares the information in these tables:
Summary Tables |
Detail Tables |
|---|---|
F06156 |
F0716 |
F06156 |
F0618 |
F06156 |
F0719 |
Refer to UDC 77/ER for a list of error codes that might appear on the report.