Retroactive Overtime Adjustment Calculator
Standard Formula
Back Pay = Retroactive Rate Difference × 1.5 × Historical OT Hours
Calculates retroactive payroll adjustments when wage increases or union agreements apply retroactively.
How Retroactive Overtime Adjustment Calculator Works?
The Retroactive Overtime Adjustment Calculator works by multiplying the retroactive rate increase by past regular hours at 1.0× and past overtime hours at 1.5×, then adding the 2 amounts.
1Enter the rate increase
Type the raise per hour that applies backward, $2.50 by default.
2Enter overtime hours in the period
Add overtime hours worked since the effective date, 45 by default.
3Enter regular hours in the period
Add regular hours since the effective date, 160 by default.
4Read back pay owed
$400.00 regular adjustment plus $168.75 overtime adjustment returns $568.75.
Retroactive Overtime Adjustment Calculator Formula
The Retroactive Overtime Adjustment Calculator formula is Back Pay = (Rate Increase × Regular Hours) + (Rate Increase × 1.5 × OT Hours).
Regular hours adjustment
Regular Retro = Rate Increase × Regular Hours
Overtime adjustment
OT Retro = Rate Increase × 1.5 × OT Hours
Total back pay
Back Pay = Regular Retro + OT Retro
- Rate Increase
- New rate minus old rate, per hour.
- Regular Hours
- Straight-time hours since the effective date.
- OT Hours
- Overtime hours since the effective date.
Worked example: contract ratified 6 weeks late
Raise = $1.20. Regular Hours = 240. OT Hours = 30.
Back Pay = ($1.20 × 240) + ($1.80 × 30) = $288.00 + $54.00 = $342.00.
Retroactive Overtime Adjustment Calculator Conversion Table
The Retroactive Overtime Adjustment Calculator conversion table shows back pay for 160 regular hours and 45 overtime hours at 7 retroactive raise amounts.
| Retro Raise | OT Rate Increase | Regular Adjustment | Overtime Adjustment | Total Back Pay |
|---|---|---|---|---|
| $0.25 | $0.38 | $40.00 | $16.88 | $56.88 |
| $0.50 | $0.75 | $80.00 | $33.75 | $113.75 |
| $1.00 | $1.50 | $160.00 | $67.50 | $227.50 |
| $1.50 | $2.25 | $240.00 | $101.25 | $341.25 |
| $2.00 | $3.00 | $320.00 | $135.00 | $455.00 |
| $2.50 | $3.75 | $400.00 | $168.75 | $568.75 |
| $4.00 | $6.00 | $640.00 | $270.00 | $910.00 |
What is Retroactive Overtime Adjustment Calculator?
A Retroactive Overtime Adjustment Calculator is a payroll tool that computes back pay when a wage increase applies to past workweeks.
Under 29 CFR § 778.303, a retroactive wage increase raises the regular rate for the weeks it covers. The employer owes the raise on straight hours and 1.5× the raise on overtime hours.
Retroactive raises are common after delayed union contract ratification, minimum wage corrections and pay equity reviews.
What are the uses of Retroactive Overtime Adjustment Calculator?
There are 4 main uses of the Retroactive Overtime Adjustment Calculator.
Union contract settlements
Members compute retro pay back to the contract start date.
Pay corrections
Employers fix rates entered late in payroll.
Pay equity adjustments
HR teams price back pay for equity raises.
Budget accruals
Finance teams accrue retro liability before payment.