This provides reporting of deductions codes from one or up to ten live payrolls. This report allows the definition of separate pay period ranges as well as deduction codes to be reported, per payroll selected.
The report includes a detail or summary deduction option as well as a detailed or summary employee option. The detailed employee option includes a complete breakdown of all deductions for all selected payrolls per employee. The employee summary option reports the employee deduction amounts compressed for all payrolls. The deduction summary only option allows reporting of deduction totals omitting the employee details. The deduction code description per payroll is included as deduction code values may vary from payroll to payroll.
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. The export file is a comma separated file with one record per deduction per employee. The export file containing the following fields:
The export file includes the following fields:
-
Payroll ID code
-
Employee number
-
Employee name
-
Deduction code
-
Deduction description
-
Employer share (when not omitted)
-
Eligible earnings (when not omitted)
-
Employee's deduction amount
-
Taxable benefit amount (when not omitted)
This process includes the option to maintain multiple sets of stored prompts.
Name the prompt sets by defining a title up to 10 characters, with a 30-character description.
On the first prompt click the Report Defaults icon to select an existing set of prompt values. You can delete prompt sets or change the description from the Report Default icon.
Report Employees or Deduction Summary Only
-
Enter 'E' to produce the employee deduction report. This option includes all employees as well as the summary totals.
-
Enter 'S' to produce just the summary deduction totals.
-
Enter one or multiple payroll ID's along with the pay periods, deductions and Shadow YTD History files selected (when applicable) per payroll to be reported.
* Enter the pay period followed by a '0' to only report the main pay and omit special pay periods. For example enter 2020070 to only include 202007 reporting details.
Report Pay / Adjustment / Manual Cheque / Cheque Cancel
-
Enter the history record type to report on to report all history types.
More than one history type can be reported on at one time. The record types selected will display below the prompt as each type is selected. The report heading also reflects the history types selected for that report.
Report Employee Deductions Detail or Summary
-
Enter 'S' to produce the employee summary report with employee deductions compress for multiple payrolls.
-
Enter 'D' to report the employee deduction details for multiple payrolls.
Omit Printing Eligible Earnings
-
Enter 'N' to include the reporting of the eligible earnings.
-
Enter 'Y' to omit the reporting of eligible earnings. You may want to suppress the eligible earnings for a report that is for outside your office.
Sort by Employee Number or Employee Name
-
Enter 'E' to sort the employee report by employee number.
-
Enter 'N' to sort the employee report by employee name.
Omit Printing Employer Share
-
Enter 'N' to include the reporting of the employer share.
-
Enter 'Y' to omit the reporting of employer share.
Omit Printing Eligible Earnings
-
Enter 'N' to include the reporting of the eligible earnings.
-
Enter 'Y' to omit the reporting of eligible earnings. You may want to suppress the eligible earnings for a report that is for outside your office.
Omit Printing Taxable Benefits
-
Enter 'N' to include the reporting of the taxable benefits.
-
Enter 'Y' to omit the reporting of taxable benefits.
Double Space Report
-
Enter 'Y' to include a blank line between employees.
-
Enter 'N' to omit the blank line between employees.
When EMPLOYEE DEDUCTION REPORT was selected, the following prompts appears:
Report Only Employees with Multiple Payrolls
-
Enter 'N' to include all employee detail.
-
Enter 'Y' to only include those employees with values on multiple payrolls. When this option is selected the deduction, summary is omitted.
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.
When INCLUDE CSV EXPORT FILE was selected the following prompt appears:
Omit Omitted Columns From CSV Export
-
Enter 'N' to include the columns that have been selected for omission in the export file.
-
Enter 'Y' to omit the columns selected for omission from the export file.
The report lists the following:
-
Employee detail:
-
Employee name and Human Resources employee number
-
Deduction code and description
-
Payroll ID, when employee detail was selected
-
Employer share, employee's deduction amount, eligible earnings and taxable benefit amount per deduction code. Employee totals are suppressed when only one entry was printed
Deduction summary:
-
The payroll ID code a payroll description
-
The deduction code and deduction code description per payroll
-
The employer share and employee deduction amount
-
The total employee and employer amount
-
The total eligible earnings and taxable benefits
-
A total for the deduction code for all payrolls
-
A summary of select payroll ID's, pay period ranges and deduction codes