
Set up and pay overtime based on different hourly rates
by Intuit•14• Updated 3 months ago
Learn how to set up overtime rates for your employees paid two different hourly rates in QuickBooks Online Payroll and QuickBooks Desktop Payroll.
If you pay your employees different hourly rates, you can set up these rates in your payroll account. You can also choose which rate to use to calculate overtime and double overtime based on different hourly rates. We'll show you how.
Step 1: Determine your overtime situation
You can pay overtime to your employees based on their highest regular hourly rate. Some businesses are required to follow union contracts that have more complicated methods. You may be required to calculate overtime based on each hourly rate separately, or use a base rate (blended overtime rate).
Here's the formula to get the base rate (blend two hourly rates):
(Overtime Regular Hours x Regular Pay Rate) + (Overtime Hourly 2 Hours x Hourly 2 Rate)
/
(Overtime Regular Hours) + (Overtime Hourly 2 Hours)
= Base Rate
For example, suppose John worked the following hours last week:
Regular Pay Rate ($12): Regular hrs — 28, Overtime hrs. — 8
Hourly2 Rate ($10): Regular hrs — 12, Overtime hrs. — 2
The blended rate to enter for OT and Double OT Base Rate is $11.60: (8 x $12) + (2 x $10) / (8 + 2) = $11.60
For this Base Rate, gross wages are $630.00: (28 x $12) + (12 x $10) + (10 x $11.60 x 1.5) = $630.00
Step 2: Set up overtime based on your situation
Select your product below.
Note: Not sure which payroll service you have? Here's how to find your payroll service. |
Scenario 1: Pay overtime based on the highest hourly rate for your employee
For a better experience, open this article in QuickBooks Online. Launch side-by-side view
Great news! There’s nothing extra you need to do. QuickBooks Online Payroll automatically calculates overtime based on the highest hourly rate.
You’ll add an overtime payroll item to your employee profile or paycheck just below the hourly payroll item with the highest hourly rate.
Scenario 2: Pay overtime based on each hourly rate separately
For a better experience, open this article in QuickBooks Online. Launch side-by-side view
You’ll have to manually calculate overtime for each lower hourly rate and set up other earnings items for overtime. You’ll add the dollar amounts on the other earnings items on paychecks.
You’ll add an overtime payroll item to your employee profile or paycheck just below each hourly payroll item. Add the overtime rates for each item.
Scenario 3: Pay overtime based on the blended base rate
For a better experience, open this article in QuickBooks Online. Launch side-by-side view
You’ll change the overtime base rate on the employee’s paycheck when you create payroll.
- Go to Payroll, then Employees.
- Select Run Payroll.
- Select employees to pay. Then enter their pay details.
- Select Actions ⋮ then Edit paycheck.
- Edit the Overtime Pay and Double Overtime Pay rate in the Rate column.
- Select Save.
- Select Preview payroll then Submit payroll.
- Select Close.
You’ll add an overtime payroll item with the base rate you calculated in Step 1 to your employee profile or paycheck.
You must sign in to vote.
Sign in now for personalized help
See articles customized for your product and join our large community of QuickBooks users.
Find the right fit for your business
![[object Object]](https://digitalasset.intuit.com/content/dam/intuit/sbsegcs/en_us/quickbooks-online/images/SDR-qbo-rightrail.png)
Choose from plans and features to fit your business needs with QuickBooks Online.
More like this
- Pay an employee different hourly ratesby QuickBooks
- Add overtime pay to an employeeby QuickBooks
- Map QuickBooks payroll items in QuickBooks Timeby QuickBooks
- Set up and track Alabama overtime exemptionby QuickBooks