Run the End-of-Year Exception Report

Generate the End-of-Year Exception Report to review the output and correct any discrepancies in transmitter, employer and employee data. The End-of-Year Exception Report automatically produces both a PDF and an Excel spreadsheet version of the report for all slip types.

Payroll managers and administrators can use the Run End-of-Year Reports task from the Regulatory and Tax Reporting area under Payroll on the Home page to generate the report. You can also run this report using the Submit a Flow task under Payroll in My Client Groups on the Home page.

Prerequisites

Before you run this report, run the Archive End-of-Year Payroll Results process. The information reported in the exception report comes from the end-of-year archive process, with the exception of the employee and employer name and address.

Parameters

Enter these parameters to run the End-of-Year Exception report.

Flow Pattern

Select Run End-of-Year Reports.

Payroll Flow

Enter a payroll flow name.

Note: It’s best practice to name the flow so that you can easily identify the process later. This is helpful while searching so you can determine what you have already run or if you need to rollback any process.

Tax Report Year

Select the four-digit year. The list displays only those years for which the end-of-year archive has been run.

Year End Report

Select the report that you want to validate. Valid values are T4, T4A, RL-1, and RL-2.

Report Type

Select Original. The values you can select are Original, Amended, or Cancelled. The exception report is based on the latest archive.

Format

Select Exception Report.

Transmitter

Select a transmitter, if you want to run the report by a transmitter. If you have selected a transmitter, the list displays only those TRUs that transmit data using this transmitter TRU. The list includes only those TRUs for which the data is archived. However, if you haven’t selected a transmitter, data is processed for all TRUs for which the data is archived.

Tax Reporting Unit

Select a TRU, if you want to run the report by a TRU. The list includes only those TRUs for which the data is archived. However, if you haven’t selected a TRU, report is processed for all TRUs for which the data is archived.

Payroll Relationship Group

Select the payroll relationship group name, if you have defined one. For example, you can create a group to process all employees within a specific province.

Note: Use the Object Groups task under Payroll in My Client Groups on the Home page to define the payroll relationship group before you can select it here.

Province

Select a province, if you want to run the report for a specific province. For RL-1 and RL-2, the field displays only Québec. Also, it’s blank for T4A.

Print Employer Address

This only applies to the T4 and T4A PDF Draft or PDF Final formats. The default value for this field is No.

Print Instructions

This only applies to the PDF Draft or PDF Final format.

Sort Option One

Select Location, Payroll, or Province.

Sort Option Two

Select Location, Payroll, or Province. The options presented to you for selection is dynamically changed depending on your selection in the previous Sort Option parameter.

Sort Option Three

Select Location, Payroll, or Province. The options presented to you for selection is dynamically changed depending on your selection in the previous Sort Option parameter.

Process Configuration Group

Select the process configuration group name, if you have defined one. It is used for logging and reporting purposes.

Note: Use the Payroll Process Configuration task under Payroll in My Client Groups on the Home page to define the process configuration group before you can select it here.

Copyright Message

This only applies to the PDF Draft or PDF Final format of the T4 and T4A slips. This field holds a read-only copyright message. This message isn’t reported on the actual slips.

Results

View the Report Output

Use the View Results icon to view the report output. The End-of-Year Exception Report automatically produces both a PDF and an Excel spreadsheet version of the report for all slip types. If there are exceptions met, the report displays those exception messages. Exceptions are reported for transmitter, employer, and employee data. Before proceeding with the end-of-year processing, you must correct the data as required.

Process Rerun

To archive all data once again, you must first roll back and then rerun the archive. The rerun archive process captures data for the employees excluded in the previous archive process.

Run the exception report to check if the exceptions reported earlier are resolved. If you notice any exceptions, fix them and repeat the process of rollback and rerun of the archive process.