The WCB Cross Payroll Report allows reporting of employees from one or up to ten live payrolls based on either a WCB deduction or selected pay codes within a pay periods range. The intent of this report is to report the total WCB earnings capped by the total assessable maximum and the resulting assessment amount per employee. When a WCB deduction is used on the payrolls, the WCB earnings will be based on the deduction eligible earnings and the report will reflect any differences between the annual calculation and the deduction amounts taken.
The report includes a detailed or summary option. The detailed report includes a breakdown by payroll of the amounts and the summary report compresses the totals for all payrolls per employee.
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
-
Total earnings
-
Total eligible
-
Assessable amount
-
Deduction
-
Assessment
-
Assessment difference
Enter Assessable Maximum $
-
Enter the current maximum assessable earnings to be report.
Enter Assessment Factor
-
Enter the assessment percentage assigned to your organization.
Select by Deduction or Earnings
-
Enter 'D' to run the report for selected WCB deduction codes.
-
Enter 'E' to run the report based on pay codes, when no WCB deduction is in use.
WCB Cross Payroll Selection (by Deduction)
-
Enter one or multiple payroll ID's along with the pay periods and WCB deductions.
WCB Cross Payroll Selection (by Earnings)
-
Enter one or multiple payroll ID's along with the pay periods, excluded earnings list, along with the taxable benefits to be included (Alberta) if appropriate.
Summary or Detail Report
-
Enter 'S' to produce the summary report.
-
Enter 'D' to produce the detailed report.
Sort by Employee Name or Number
-
Enter 'E' to sort the employee report by employee number.
-
Enter 'N' to sort the employee report by employee name.
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
-
Employee Name
-
Pay ID
-
Total Earnings
-
Total Eligible
-
Assessable
-
Eligible-Assessable difference
-
Deduction
-
Assessment,
-
Deduction-Assessment Difference