This report lists payroll history for a specified range of periods. This report is a summary report that provides a listing of each of the pay periods for each employee. The report displays on a single line for each pay period. It identifies the regular and other earnings, the statutory deductions and a compressed total for all non-statutory deductions. The report produces a total for each employee and a grand total for the report for each of the fields listed. This report can be useful in balancing federal deductions and earnings for T4 purposes.
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 Period
-
Date
-
History type
-
Total hours
-
Total gross earnings
-
Total taxable gross
-
Federal tax
-
Provincial / State tax (Canada/US)
-
CPP / Medical
-
EI / Fica
-
Total other deductions
-
Total deductions
-
Net Pay
-
Insurable earning (Canada)]
Enter Start Period
-
Enter the starting pay period of the range to report on.
Enter End Period
-
Enter the ending period of the range.
Sort by Employee Number or Employee Name
-
Enter 'E' to produce the report in employee number order.
-
Enter 'N' to produce the report in employee name order.
Report All or Selected Employees
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
-
Pay period and date
-
Pay type - P payroll processing
-
M manual cheque
-
A YTD adjustment
-
C cheque cancellation
-
-
Hours
-
Gross
-
Taxable gross
-
Federal tax, Provincial tax, CPP, EI -(CANADA)
-
Federal tax, State tax, Medicare, FICA - (US)
-
Other deductions
-
Total deductions
-
Net pay
-
EI Insurable earnings - (CANADA)