Standard Report - Worker Comp Cost

Required Setup

For the Other Wages, the client needs to set up the pay codes’ “CalculateWorkerCompCost” property to True to include those pay codes which the client wishes to see in Other Wages.

Special Logic

1. The page is separated per Supplier
2. There are two Summary Boxes; Supplier Total and Report Total.
   
   1. Total shows Total wages and total hours for different types of Pay codes(Reg, OT, DT and others), Total Gross Wages , Total WC Wage and Total WC Cost details for Supplier.
   2. Report Total shows Total wages and total hours for different types of Pay codes(Reg, OT, DT and others), Total Gross Wages , Total WC Wage and Total WC Cost details for whole report.

Report Description

Shows worker comp costs by branch. This report allows you to determine the total cost of WC claims for an entire branch along with additional wage information.

Parameters

Parameter Name	Options	Description
Date Type	Accounting Period Date, Check Date	Transaction’s Accounting Period or Check Date.
Group By	Branch, State, Customer, Order Type, WC Code, Employee
Start Date
End Date
Branch	All available branches	Transaction’s Branch
Roll Up To Parent Customer	True/False	Roll data up to the Parent if true else display under individual customer.
Include WA Worker Comp Tax	True/False

Report Fields

Field Name	Description
Branch	Transaction Branch. Will be visible when Branch is selected under Group By Parameter.
State	Name of the State associated with the transaction. Will be visible when State is selected under Group By Parameter.
Customer	Customer Name from Transaction. Will be visible when the Customer is selected under Group By Parameter.
Order Type	Order type from Transaction. Will be visible when Order type is selected under Group By Parameter.
Wc Code	Worker comp code from Transaction Will be visible when Wc Code is selected under Group By Parameter.
Employee	Employee Name from Transaction Will be visible when Employee Name is selected under Group By Parameter.
Emp ID	Employee ID
SSN	Employee's SSN
Department	Department Name of the Customer. Will be visible when the Customer is selected under Group By Parameter.
Reg. Hours	Total Hours of Reg Transactions
OT Hours	Total Hours of OT Transactions
DT Hours	Total Hours of DT Transactions
Other Hours	Total Hours of Transactions that is not Reg, OT, DT and has “CalculateWorkerCompCost” property set to True and IsDeduction set to False.
Reg Wages	Item Pay from transaction having Pay Code = “Reg”. Depends Upon Group By parameter. Pulls the sum of Item Pay for “Reg” Pay Code based upon the Group By parameter selected.
OT Wages	Item Pay from transaction having Pay Code = “OT”. Depends Upon Group By parameter. Pulls the sum of Item Pay for “OT” Pay Code based upon the Group By parameter selected.
DT Wages	Item Pay from transaction having Pay Code = “DT”. Depends Upon Group By parameter. Pulls the sum of Item Pay for “DT” Pay Code based upon the Group By parameter selected.
Other Wages	Sum of Item Pay of transaction not present in Reg, OT, DT pay code and has “CalculateWorkerCompCost” property set to True and IsDeduction set to False. Depends Upon Group By parameter. Pulls the sum of Other Wages based upon the Group By parameter selected.
WC Rate	Worker Comp Percent from the transaction.  Will be visible when WC Code is selected under Group By Parameter.
Gross Wages	Total Taxable/Gross wages
WC Wage	Worker Comp Wage from the transaction. The system calculates Worker Comp Wages based on the processing method defined on each Wc Code Setup. details here Depends Upon Group By parameter. Pulls the sum of Worker Comp Wage based upon the Group By parameter selected.
WC Cost	Worker Comp Cost from the transaction. Depends upon Include Burden Factor and Group By parameter. Pulls the sum of Worker Comp Cost based upon the Group By parameter selected. (Will also include the WA Worker Comp if the Include WA Worker Comp Tax parameter is selected True) *If Include Burden Factor = ‘True’, then pulls the worker comp cost based upon the burden (Admin tools >> Burden). Workers Comp Code Tab
WA WC ER	*For “WASHINGTON WORKERS COMP ER” tax ,The Tax amount calculated as pay percent of transaction times tax amount present in the check (associated with the transaction) for the Employer Formula for WC Cost for “WASHINGTON WORKERS COMP ER” tax: = Pay Percent Of Transaction * Tax Amount
WA WC EE	*For “WASHINGTON WORKERS COMP EE” tax ,The Tax amount calculated as pay percent of transaction times tax amount present in the check (associated with the transaction) for the Employee Formula for WC Cost for “WASHINGTON WORKERS COMP EE” tax: = Pay Percent Of Transaction * Tax Amount