Submit a ticket

Standard Report - Worker Comp Cost

Updated on Follow
0 out of 0 found this helpful

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.

  

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 transaction.

Will be visible when State is selected under Group By Parameter.

Customer

Customer Name from Transaction.

Will be visible when 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 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 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).

*For “WASHINGTON WORKERS COMP ER” tax, WC Cost is calculated as pay percent of transaction times tax amount present in the check (associated with transaction.)

Formula for WC Cost for “WASHINGTON WORKERS COMP ER” tax:

= Pay Percent Of Transaction * Tax Amount 

See https://support.avionte.com/hc/en-us/articles/211115577-WcCode-Tab-Worker-s-Compensation- to know more on how Avionte calculates 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 client wishes to see in Other Wages.


Have more questions? Submit a request

0 Comments


This space is for article feedback only. To make a request of the Avionté Support Team, please submit a ticket to https://support.avionte.com.