Create and maintain the Worker's Compensation Category tables for each state in which your firm is insured for Worker's Compensation.
Clerical tables for Ohio and New York, etc.
Required for Payroll. This viewer is divided into two sections. The upper section consists of the data-entry fields that identify this table, the insurance rate for this category, and the earnings limit (if any). The lower section of the screen lists your firm's Pay Types and the rate at which insurance premiums are calculated.
Referenced in Records: Work Order, Employee
Reference in Journals: Labor, Payroll
Reference in Starters: Compute Payroll
In some states (e.g., Washington), a portion of the worker’s compensation expense (the employee rate) is the responsibility of the employee. SAMPro supports the ability to specify the employee contribution portion (if any) on the worker’s compensation record itself. Since this portion frequently varies by the worker’s compensation category, this functionality accurately assesses the employee’s portion to the employee. Click for additional details.
This enhancement is applicable to a scenario where the WC state from the Job is used to determine the Cost Cat Workers Comp codes to use in the Labor Journal and WO Labor tab. In addition, unique Security-specific WC codes are implemented for each company containing the proper rates, and then added multiple WC codes with the same state to the cost category. Security has been built into this matching process so that it uses the appropriate WC code for the company that the job/labor journal transaction resides in.
Sample Calculation of Workers Comp amounts (per $100) during the Compute PR function. This example is calculated with experience modifier, discount factor & employees WC category rate:
1. Divide Earnings by 100 for 'Per $100' ... $5650.00 / 100 = $56.50
2. Multiply by WC Rate ... $56.50 x .29 = $16.385
3. Apply Experience Modifier ... $16.385 x .89 = $14.58265
4. Apply Discount ... $14.58265 x (1 - .5818) = $6.09846423
5. Round amount to $6.10.
Note: this Help Topic lists the standard configuration of all fields that may be included in this record. If you are using a customized system, the fields displayed on your screen may not exactly match the order or status of the fields described in this Topic.
WC Category Id: (10 character, only . and - special characters)
The compensation category provided by your insurer.
Description: (40 character)
A brief description of the category (e.g., clerical, etc.).
State Id:
This required field specifies the Worker's Comp State record this table is created for. Enter the State Id or double-click to select from a list.
Security Id:
If multiple location security is implemented on your system, this informational field displays the Security Id of the local user that created this record. If multiple location security is not implemented on your system, or if this record was created by a global user, this field will be blank.
Total Rate:
The total of the employer and employee worker’s comp rates. The difference of the Total Rate less the Employee Rate will be the resulting "expense" to be posted to the expense account for W. C.
The rate for this category. WC premiums are also modified by the Experience Modifier and Discount Fields in the Worker's Comp State record. Depending on your state, wages paid for bonus, holiday and vacation time may or may not be liable for insurance premiums. Refer to your accountant or Worker's Compensation Policy Manual for details on rates, limits, and type of pay to be included.
Rate Type:
Select Per $100 (by double-clicking on its radio button or pressing the Spacebar) if premiums are based on each $100 dollars of pay. Select Per Hour if premiums are based on hours worked.
Earnings Limit:
If there is a cap on earnings above which premiums are not assessed, enter its dollar amount. If there is no earnings limit, enter 99,999,999.99 so that all earnings will be included in the calculation of premiums.
Limit by Pay Period:
If the Earning Limit is by Payroll Period, check this box by double-click or pressing the spacebar. If this field is blank, the Earnings Limit will pertain to annual earnings.
Deduction Id:
This field should be used to reference a Deduction record created for use with the employee portion (if applicable) of the worker’s comp. The Deduction should be of Type Miscellaneous, with an appropriate Check Label filled in (e.g., WC), the Amount field blank; typically, the Amount Type is set to hourly. Although the GL Account needs to be completed in the Deduction record, the system will actually credit the GL Debit Account from the Worker’s Comp State record to record the employee’s contributions as an offset to the WC expense.
Important: Do NOT specify this Deduction Id in either the Employee Record Deductions Tab or the Deductions Group record. The software will manage the deduction correctly with it specified in the applicable Workers Comp Category records.
Employee Rate:
Enter the rate for the employee’s portion of the Worker Comp rate. For example, if this is an hour rate, this rate times the hours worked will appear as a miscellaneous deduction on the employee’s paycheck.
Pay Type Id:
Enter a valid Pay Type Id or double-click to select from a list. Note: all your firm's active Pay Types should be included in this table.
First RF Field
This field specifies the Rate Factor at which the insurance premium rate (in the upper portion of the screen) is assessed relative to the employee's regular base pay rate. This field should be left blank if WC insurance should not be assessed on this type of pay.
Second RF Field
The display-only RF: (Rate Factor) field on the right defaults from the Pay Type record, and shows how the employee is actually paid. Consider the following example:
Example 1: WC applied to Hours Worked and Sick Time
Rate: 2.2 Rate Type: Per $100
Earnings Limit: 1,400.00 X Limit by Pay Period
Pay Type Id: RF RF:
regular 1.0 1.0
overtime 1.0 1.5
doubletime 1.0 2.0
bonus 1.0
sick 1.0 1.0
holiday 1.0
vacation 1.0
In the above example, WC premiums are assessed on regular, overtime, doubletime and sick wages at the employee regular (base) rate of pay (1.0), up to a limit of $1,400 per pay period
Example 2: WC applied to Wages Paid for Hours Worked
Rate: 2.2 Rate Type: Per $100
Earnings Limit: 1,400.00 X Limit by Pay Period
Pay Type Id: RF RF:
regular 1.0 1.0
overtime 1.5 1.5
doubletime 2.0 2.0
bonus 1.0
sick 1.0
holiday 1.0
vacation 1.0
In the above example, WC premiums are assessed on regular, overtime, and doubletime wages paid, up to a limit of $1,400 per pay period