Understanding the Canadian Payroll History Audit Report

To ensure that the system records the correct amounts on the tax and year-end reports, you must run the Canadian Payroll History Audit Report (R77703) each month and before you process year-end reports. You must 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 that lists the inconsistencies (if any) between the summary and detail history information. This report does not make any corrections to the summary or detail tables.

Important:

The Canadian Payroll History Audit Report verifies that tax type CA exists for every
                employee who has a record for any of these tax types in the Tax History table
                (F0713): 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, before you generate the year-end workfile, it is important to run the
                Canadian Payroll History Audit Report and correct any errors.

To specify whether this report compares basic history information, pay cheque history information, or both, you use the processing options.

Here is a description of the tables that the system compares if you select to compare basic history information in the report:

Summary Tables	Detail Tables
Tax History (F0713)	Pay Check History Tax Ledger - Canadian DB (F0716)
Calendar Month DBA Summary History (F06145)	DBA Transaction Detail History (F0719)
Employee Transaction History Summary (F06146)	Employee Transaction History (F0618) and DBA Transaction Detail History (F0719)
Unemployment Insurance History (F06176)	Pay Check History Tax Ledger - Canadian DB (F0716)

If you want to compare pay cheque history information, the report compares the information in these tables:

Summary Tables	Detail Tables
Pay Check History Summary (F06156)	Pay Check History Tax Ledger - Canadian DB (F0716)
Pay Check History Summary (F06156)	Employee Transaction History (F0618)
Pay Check History Summary (F06156)	DBA Transaction Detail History (F0719)

For a list of error codes that can appear on the report, see the user-defined code (UDC) table 77/ER.