/
Blended Overtime Calculator

Blended Overtime Calculator

The blended overtime calculator is a tool to assist in calculating an employee’s blended overtime amount.

First, select an employee from the drop down or begin typing in the Employee field and select the employee from the list. Then click ‘Find Employee’.

  • Archived Employees will be excluded from the dropdown list

image-20260129-182223.png

If needing to include archived compensations, mark the ‘Include Archived Compensations?’ checkbox.

image-20260323-160254.png

Next, in the Compensations, click on the down arrow and select the compensation to be included and then click on ‘+ Add Compensation Entry’. Once the Positions are selected, they will appear in the grid below. You are able to select a compensation multiple times to be included in the grid. The Rate that is listed for each Position is determined by the Compensation>Unit Amount. If the Compensation>Pay Unit is set to Hourly, then that is the Rate listed. If the Compensation>Pay Unit is set to Daily, then the Rate is calculated by Unit Amount/Hours in Day.

image-20260323-160406.png
image-20260323-160425.png
image-20260323-154946.png

In the Total Hours fields, enter the appropriate number of hours worked for each Position. Verify the Rate values and update if needed. The Weekly Gross amount will automatically populate. This amount is calculated by the Rate X Total Hours. The Total Hours and Overtime Hours will then be calculated and displayed in the fields below.

image-20260129-185733.png

If needing to clear the Total Hours and Weekly Gross and set the values back to 0.00, click 'Reset'.

image-20260129-191904.png

If needing to delete a row in the grid, click on X = Delete

image-20260323-161034.png

Lastly, click the ‘Calculate Overtime Premium’ option and the following values will populate with the appropriate calculated value - Regular Blended Rate, Straight Pay, Overtime Premium, and the Total Pay.

image-20260129-192359.png

The boxes are calculated as follows:

  • Regular Blended Rate: Total Gross/Total Hours --> $1,231.09 /45 = $27.3575

  • Straight Pay: Total Gross -->$1,126.09 + $45.00 + $60.00 = $1,231.09

  • Overtime Premium: Overtime Premium Rate (0.5 × Regular Blended Rate) X Overtime Hours --> (0.5 × $27.3575) × 5 = $68.39

  • Total Pay: Straight Pay + Overtime Premium-->$1,231.09 + $68.39 = $1,299.49

Using Payroll Payments - Future or Payroll Payments - Current, enter the payment details.