This report includes reporting on the employees Federal, Provincial/State, Other and Specific exemption information as defined on the Employees Pay screen.
This report includes an option to generate an export file, ######.CSV, where ###### is the job number. The export file is generated where the logical SRB$OPSWRK is defined. All fields within the export file have any extra spaces removed from the front and back of the fields and all fields are separated by a comma.
The export file includes the following fields:
-
Payroll ID code
-
Employee number
-
Employee name
-
Employee status
-
Tax code
-
Deduction description
-
Exemption name
-
Exemption code, when applicable
-
Exemption amount or setting
-
Extra tax value, only on first entry per employee
Federal / Provincial / Other / Specific / North / Annual / Flags Exemptions
-
Enter to select reporting of all exemption types.
One or more exemption types may be selected to be included on this report.
-
Enter ‘A’ to include all exemptions.
-
Enter 'F' to include the Federal Exemptions.
-
Enter 'P' to include the Provincial Exemptions.
-
Enter 'O' to include the Other Exemptions.
-
Enter 'S' to include the Specific Exemptions.
-
Enter ‘N’ to include the Northern Exemptions.
-
Enter ‘U’ to include the Annual Exemptions.
-
Enter ‘G’ to include the CPP Exemption flags.
Report All or Selected Employees
Report Employees Terminated / On Leave / Both
Sort by Employee Number or Name
-
Enter 'E' to report the employees in employee number order.
-
Enter 'N' to report the employees in employee name order.
Include Generation of CSV Export File
-
Enter 'N' to omit the generation of the export file.
-
Enter 'Y' to include the generation of the export file.
The report lists the following:
-
Employee number and name
-
Employee's income tax deduction code
-
Canadian GROUP 6,7 or 8 (US 9) TYPE 2 deductions
-
Exemption name and code
-
Exemption amount, per database
-
Extra optional income tax as per employee’s individual income tax deduction
-
Employee’s T4 CPP/EI Exempt values, including CPP Exemption Effective date, when selected.
-
Employee’s CPP Exemption Flag value when selected.
-
Employee activity status