This report lists the employee's earnings and employee deduction amounts only for a range of pay periods selected. The earnings and deductions are reported vertically with the pay periods listed horizontally across the page. Reporting of the employer share of deduction amounts is optional.
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
-
Pay cycle code
-
Employee status
-
Row type, Header, Earnings, Deduction or Employer Share
-
Pay or Deduction code
-
Description
-
Pay period, earnings or deduction amount
-
Total for row
Enter Starting Pay Period
-
Enter the starting pay period to be reported.
Enter Ending Pay Period
-
Enter the ending pay period to be reported.
Detailed or Summary Report
-
Enter 'D' to generate a detailed report. All history entries per pay period are listed separately. Each entry will indicate the record type.
-
Enter 'S' to generate a summary report. All history entries for a specific pay period are compressed into one entry.
Report by Employee or Cycle
-
Enter 'E' to select employees by employee number.
-
Enter ‘C’ to select employees by pay cycle code.
Report All or Selected Employees
Enter the Pay Cycle Codes for Employee Selection
-
Enter one or a list of pay cycle codes ((one at a time). Employees with one of these pay cycle codes on their master or first function line will be selected for reporting.
Report Employees Terminated / On Leave / Both
Report Employer Share of Deductions
-
Enter 'N' to omit the employer share of deduction amounts.
-
Enter 'Y' to include the employer share of deduction amounts on the report.
The employer amount per deduction will be listed following the employee's net pay. Only deductions that contain an employer share amount for the range of pay periods defined will be listed.
Omit Employees with no history for Range Selected
-
Enter 'Y' to omit reporting employees with no history records for the range of pay periods selected.
-
Enter 'N' to report all employees even if an employee has no balances to report.
Sort by Employee Number or Employee Name
-
Enter 'E' to generate the report in employee number order.
-
Enter 'N' to generate the report 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 listing includes:
The employees’ number, name, pay cycle code and employment status
Vertical headings include pay period record type, pay period and pay period ending date
For detail reports the pay record type is included:
-
P = Payroll Run
-
A = Adjustment
-
C = Cheque Cancellation
-
M = Manual Cheque
Earnings and employee deduction amount listed vertically including the gross pay, total deductions and net pay. Each pay period history record listed vertically across the page
Totals per earnings and deductions listed as the last column for each employee
Grand totals for report including the total number of employees reported