Overview of End-of-Year Exception Report

Before you generate the year-end slips, ensure that the slips don't contain any errors or missing information. Generate the End-of-Year Exception Report to review and correct any errors or discrepancies in transmitter, employer and employee data. This report facilitates year-end reconciliation.

Use the report to respond to government reports identifying discrepancies in Canada Pension Plan, Quebec Pension Plan, Employment Insurance, Quebec Parental Insurance Plan amounts reported in the year-end slips or other government reports.

Note: Not all exceptions displayed on the reports are errors. Some exceptions are informational only.

Run this report after you process the Archive End-of-Year process. All of the data displayed on the report comes from the archived data, with the exception of the name and address of the employee and the employer. The End-of-Year Exception Report automatically produces both a PDF and an Excel spreadsheet version of the report for all slip types.

These sections list the exception messages reported in the End-of-Year Exception Report for transmitter, employer and employee information.

T4 Exceptions

Here's a list of the T4 exception messages.

Transmitter Exceptions

The Transmitter Name is missing on the T4 Interface Rules.
The Transmitter Name on the T4 Interface Rules contains more than 60 characters and will be reported as per the specific report requirements.
The Transmitter City is missing on the T4 Interface Rules.
The Transmitter Province is missing on the T4 Interface Rules.
The Transmitter Postal Code is missing on the T4 Interface Rules.
The Transmitter Contact Name is missing on the T4 Interface Rules.
The Transmitter Contact Name on the T4 Interface Rules contains more than 22 characters and will be truncated on the electronic interface file.
The Transmitter Contact Area Code is missing on the T4 Interface Rules.
The Transmitter Contact Phone Number is missing on the T4 Interface Rules.
The Language of Communication Indicator is missing on the T4 Interface Rules.

Employer Exceptions

The Legal Reporting Unit Registered Name contains more than 30 characters and will be reported as per the specific report requirements.
The Employer Account Number is missing or is invalid on the Legal Entity Registration Information.
The Employer Account Number on the Legal Entity Registration Information contains more than 15 characters and will be truncated on the electronic interface file.
The Proprietor 1 Social Insurance Number is invalid on the T4 Interface Rules.
The Proprietor 2 Social Insurance Number is invalid on the T4 Interface Rules.
The Contact Name for this Return is missing on the T4 Interface Rules.
The Contact Name for this Return on the T4 Interface Rules contains more than 22 characters and will be truncated on the electronic interface file.
The Contact Area Code is missing on the T4 Interface Rules.
The Contact Phone Number is missing on the T4 Interface Rules.

Employee Exceptions

The First Name of the employee is missing on the person record.
The Last Name of the employee on the person record contains more than 20 characters and will be truncated on the electronic interface file.
The Primary Address Line 1 of the employee is missing on the person record.
The Primary Address Line 1 of the employee on the person record contains more than 30 characters and will be reported as per the specific report requirements.
The Social Insurance Number of the employee is missing on the person record.
The Social Insurance Number of the employee has expired on the person record. The Expiration Date of the Social Insurance Number is <SIN EXP DATE>.
One or more negative balances exist for the employee.
No box balance values exist for the employee.
The employee is designated as CPP Exempt on the employee's tax calculation card.
The employee is designated as EI Exempt on the employee's tax calculation card.
The employee has CPP deductions over the annual limit.
The employee has EI deductions over the annual limit.
The employee turned 18 years of age during the reporting year. The Date of Birth on the person record is <DOB>.
The employee turned 70 years of age during the reporting year. The Date of Birth on the person record is <DOB>.
The employee was hired during the reporting year. The Hire Date on the person record is <HD>.
The employee was terminated during the reporting year. The Termination Date on the employee's work relationship record is <TD>.
The employee has worked in multiple provinces during the reporting year, as reported on the calculation card of the employee.
The employee has a CPP Election Date of <date> on the employee's tax calculation card.
The employee has a CPP Revocation Date of <date> on the employee's tax calculation card.
The expected and actual CPP deductions don't match. <calc table>
The expected and actual EI deductions don't match. <calc table>
The employee had taxable benefits without any other remuneration in one or more payroll runs.
The Employment Code configured for Box 29 is not valid.
The Dental Access or Coverage Code value of <CODE> for Box 45 is not valid.
The Dental Access or Coverage Code for Box 45 is missing.

T4A Exceptions

Here's a list of the T4A exception messages.

Transmitter Exceptions

The Transmitter Name is missing on the T4A Interface Rules.
The Transmitter Name on the T4A Interface Rules contains more than 60 characters and will be reported as per the specific report requirements.
The Transmitter City is missing on the T4A Interface Rules.
The Transmitter Province is missing on the T4A Interface Rules.
The Transmitter Postal Code is missing on the T4A Interface Rules.
The Transmitter Contact Name is missing on the T4A Interface Rules.
The Transmitter Contact Name on the T4A Interface Rules contains more than 22 characters and will be truncated on the electronic interface file.
The Transmitter Contact Area Code is missing on the T4A Interface Rules.
The Transmitter Contact Phone Number is missing on the T4A Interface Rules.
The Language of Communication Indicator is missing on the T4A Interface Rules.

Employer Exceptions

The Legal Reporting Unit Registered Name contains more than 30 characters and will be reported as per the specific report requirements.
The Employer Account Number is missing or is invalid on the Legal Entity Registration Information.
The Employer Account Number on the Legal Entity Registration Information contains more than 15 characters and will be truncated on the electronic interface file.
The Proprietor 1 Social Insurance Number is invalid on the T4A Interface Rules.
The Proprietor 2 Social Insurance Number is invalid on the T4A Interface Rules.
The Contact Name for this Return is missing on the T4A Interface Rules.
The Contact Name for this Return on the T4A Interface Rules contains more than 22 characters and will be truncated on the electronic interface file.
The Contact Area Code is missing on the T4A Interface Rules.
The Contact Phone Number is missing on the T4A Interface Rules.

Employee Exceptions

The First Name of the recipient is missing on the person record.
The Last Name of the recipient on the person record contains more than 20 characters and will be truncated on the electronic interface file.
The Primary Address Line 1 of the recipient is missing on the person record.
The Dental Access or Coverage Code value of <CODE> for Box 015 is not valid.
The Dental Access or Coverage Code for Box 015 is missinge.

Note: This message is only displayed when there is an amount reported in T4A Box 016.
The Primary Address Line 1 of the recipient on the person record contains more than 30 characters and will be reported as per the specific report requirements.
The Social Insurance Number of the recipient is missing on the person record.
The Social Insurance Number of the recipient has expired on the person record. The Expiration Date of the Social Insurance Number is <SIN EXP DATE>.
One or more negative balances exist for the recipient.
No box balance values exist for the recipient.

RL-1 Exceptions

Here's a list of the RL-1 exception messages.

Transmitter Exceptions

The Transmitter Name is missing on the RL-1 Interface Rules.
The Transmitter Name on the RL-1 Interface Rules contains more than 30 characters and will be reported as per the specific report requirements.
The Source of RL Slips Used is missing on the RL-1 Interface Rules.
The Transmitter Address Line 1 is missing on the RL-1 Interface Rules.
The Transmitter City is missing on the RL-1 Interface Rules.
The Transmitter Province is missing on the RL-1 Interface Rules.
The Transmitter Postal Code is missing on the RL-1 Interface Rules.
The Computer Resource Person Name is missing on the RL-1 Interface Rules.
The Computer Resource Person Area Code is missing on the RL-1 Interface Rules.
The Computer Resource Person Phone Number is missing on the RL-1 Interface Rules.
The Computer Resource Person Language is missing on the RL-1 Interface Rules.
The Accounting Resource Person Name is missing on the RL-1 Interface Rules.
The Accounting Resource Person Area Code is missing on the RL-1 Interface Rules.
The Accounting Resource Person Phone Number is missing on the RL-1 Interface Rules.
The Accounting Resource Person Language is missing on the RL-1 Interface Rules.
The Starting RL-1 Slip Number is missing on the RL-1 Interface Rules.
The Ending RL-1 Slip Number is missing on the RL-1 Interface Rules.

Employer Exceptions

The Legal Reporting Unit Registered Name contains more than 60 characters and will be reported as per the specific report requirements.
The Legal Reporting Unit Alternate Registered Name contains more than 60 characters and will be reported as per the specific report requirements.
The Payroll Statutory Unit Registered Name contains more than 60 characters and will be reported as per the specific report requirements.
The Payroll Statutory Unit Alternate Registered Name contains more than 60 characters and will be reported as per the specific report requirements.
The Quebec Identification Number is missing or is invalid on the Legal Entity or the Legal Reporting Unit Registration Information.

Employee Exceptions

The First Name of the employee is missing on the person record.
The Last Name of the employee on the person record contains more than 30 characters and will be truncated on the electronic interface file.
The Primary Address Line 1 of the employee is missing on the person record.
The Primary Address Line 1 of the employee on the person record contains more than 30 characters and will be reported as per the specific report requirements.
The Social Insurance Number of the employee is missing on the person record.
The Social Insurance Number of the employee has expired on the person record. The Expiration Date of the Social Insurance Number is <SIN EXP DATE>.
One or more negative balances exist for the employee.
No box balance values exist for the employee.
The employee is designated as QPP Exempt on the employee's tax calculation card.
The employee is designated as QPIP Exempt on the employee's tax calculation card.
The employee has QPP deductions over the annual limit.
The employee has QPIP deductions over the annual limit.
The employee turned 18 years of age during the reporting year. The Date of Birth on the person record is <DOB>.
The employee was hired during the reporting year. The Hire Date on the person record is <HD>.
The employee was terminated during the reporting year. The Termination Date on the employee's work relationship record is <TD>.
The employee has worked in multiple provinces during the reporting year, as reported on the calculation card of the employee.
The expected and actual QPP deductions don't match. <calc table>
The expected and actual QPIP deductions don't match. <calc table>
The employee had taxable benefits without any other remuneration in one or more payroll runs.

RL-2 Exceptions

Here's a list of the RL-2 exception messages.

Transmitter Exceptions

The Transmitter Name is missing on the RL-2 Interface Rules.
The Transmitter Name on the RL-2 Interface Rules contains more than 30 characters and will be reported as per the specific report requirements.
The Source of RL Slips Used is missing on the RL-2 Interface Rules.
The Transmitter Address Line 1 is missing on the RL-2 Interface Rules.
The Transmitter City is missing on the RL-2 Interface Rules.
The Transmitter Province is missing on the RL-2 Interface Rules.
The Transmitter Postal Code is missing on the RL-2 Interface Rules.
The Computer Resource Person Name is missing on the RL-2 Interface Rules.
The Computer Resource Person Area Code is missing on the RL-2 Interface Rules.
The Computer Resource Person Phone Number is missing on the RL-2 Interface Rules.
The Computer Resource Person Language is missing on the RL-2 Interface Rules.
The Accounting Resource Person Name is missing on the RL-2 Interface Rules.
The Accounting Resource Person Area Code is missing on the RL-2 Interface Rules.
The Accounting Resource Person Phone Number is missing on the RL-2 Interface Rules.
The Accounting Resource Person Language is missing on the RL-2 Interface Rules.
The Starting RL-2 Slip Number is missing on the RL-2 Interface Rules.
The Ending RL-2 Slip Number is missing on the RL-2 Interface Rules.

Employer Exceptions

The Legal Reporting Unit Registered Name contains more than 60 characters and will be reported as per the specific report requirements.
The Legal Reporting Unit Alternate Registered Name contains more than 60 characters and will be reported as per the specific report requirements.
The Payroll Statutory Unit Registered Name contains more than 60 characters and will be reported as per the specific report requirements.
The Payroll Statutory Unit Alternate Registered Name contains more than 60 characters and will be reported as per the specific report requirements.
The Quebec Identification Number is missing or is invalid on the Legal Entity or the Legal Reporting Unit Registration Information.

Employee Exceptions

The First Name of the employee is missing on the person record.
The Last Name of the employee on the person record contains more than 30 characters, may be truncated, and will be reported as per the specific report requirements. This message is informational only, and will cause any failures.
The Primary Address Line 1 of the employee is missing on the person record.
The Primary Address Line 1 of the employee on the person record contains more than 30 characters and will be reported as per the specific report requirements.
The Social Insurance Number of the employee is missing on the person record.
The Social Insurance Number of the employee has expired on the person record. The Expiration Date of the Social Insurance Number is <SIN EXP DATE>.
One or more negative balances exist for the employee.
No box balance values exist for the employee.
The RL-2 Source of Income is missing on the RL-2 Interface Rules.