This report lists either a summary amount or individual employee amounts for the employer's and employee's share of all or selected deductions. This report may also be run in deduction code sequence with sub totaling per deduction table entry.
The log of this report will include a notation for any employee who has a negative Arrears deduction balance (Group 0 Type 0).
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 extra spaces removed from 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 name
-
Employee number
-
Deduction code
-
Deduction description
-
Deduction amount
-
Employer share
-
Eligible earnings
-
Taxable benefits
-
Deduction table code, when applicable
-
Short pay and deduction code descriptions applied when applicable
-
Employee's Birth date
-
Employee's gender
-
Benefit coverage amount for applicable Group 3 Type 5 deductions
Report on Regular / Shadow YTD File
-
Enter 'R' to run the report based on the regular year-to-date file.
-
Enter 'S' to report on the shadow year- to-date file. Running the report on the regular year to date file allows you view all transactions including regular payroll entries, cheque cancellations, year-to-date adjustments, manual cheques and history adjustments.
Running the report based on the shadow year-to-date file gives you access to manual adjustments done between two points in time. This time period is determined by when this shadow file was last deleted and the run time of this report. See the Detailed Adjustments Report for further instructions of the use and maintenance of the shadow file.
When reporting by the year-to-date shadow file is selected, the prompts for a pay period range is bypassed.
Enter Starting Pay Period
-
Enter the starting pay period to be reported.
Enter Ending Pay Period
-
Enter the ending pay period to be reported.
Full or Summary Report
-
Enter 'F' to list individual employee's totals.
-
Enter 'S' to list summary totals for deductions.
When 'F'ull report was selected the following prompt will appear:
Report by Employee or Deduction Code
-
Enter 'E' to produce a report listing each employee and the applicable deductions per employee.
-
Enter 'D' to produce a report in deduction order. The report will list each deduction detailing all employees within the deductions sub totaling by deduction table when applicable.
When 'F'ull report and report by 'E'mployee was selected the following appears:
Report by Employee No or Name
-
Enter 'N' to produce the report sorted by employee name.
-
Enter 'E' to produce the report sorted by employee number.
Report All or Selected Employees
Omit Table Deduction Details
-
Enter 'N' to include table deduction code details. The employee's deduction code details will include the table deduction code used as well as multiple entries when more than one table code was in use for the range of pay periods selected.
-
Enter 'Y' to omit table deduction code details. An employee full deduction amounts will be reported as one entry with no table deduction code reference.
Deduction Codes to Report
-
Accept default to report all deduction codes.
-
Enter up to 25 deduction codes to be reported.
When a Table Deduction code is entered and you have not selected to omit table deduction details:
Enter Deduction Table Start Code [####]
-
Accept default to include reporting of all tables for this deduction.
-
Enter a starting table code for a range of table codes to report for this deduction.
Enter Deduction Table End Code [####]
-
Accept the default when no ending table code is to be used.
-
Enter an ending table code for a range of table codes to report for this deduction.
Report Pay / Adjustment / Manual Cheque / Cheque Cancel
-
Accept default to report on all history record types.
-
Enter the history record types to be reported. More than one history record type can be reported at one time.
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 with this report.
When 'F'ull report and report by 'E'mployee was selected the following prompt appears:
Report Deduction Totals per Employee
-
Enter 'N' to omit the total per employee.
-
Enter 'Y' to include the total employee taken, share and benefit amounts for all deductions per employee. An additional total 'DEDUCTION TOTAL' is also included, which is the employee and employer amounts combined for all deductions per employee.
This report lists the following:
Employee name and number - on a full report
Deduction code and description, deduction table code when applicable
Employer's share, Eligible earnings, Deducted amount, Taxable Benefit Amount
Deduction amount, Employer's share, Eligible earnings, Taxable Benefits
Summary totals per deduction code
When Reporting Table Details was selected the deduction description will display the description from the table deduction database. The summary totals will display the total per table within a deduction as well as the total for the deduction.