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

mceclip0.png

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.

 

 

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.

 

*If Include Burden Factor = ‘True’, then pulls the worker comp cost based upon the burden (Admin tools >> Burden).

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 

 

 

Articles in this section

Was this article helpful?
0 out of 0 found this helpful
Share