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.
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.
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.
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.