US Nondiscretionary Bonus Overtime True-Up Workbook

Calculate the overtime premium on a later bonus

Use this Excel workbook when payroll has determined that a bonus belongs in the federal regular rate and has already paid straight time and the original overtime correctly. Bring one employee’s award amount, its earning workweeks, actual hours worked and approved bonus allocation. The workbook ties the allocation back to the award before showing the total additional gross overtime.

Excel worksheet

Reconcile one award

Enter the award and up to 53 workweeks on the True-Up tab. Use Worked Example to see the inputs and formulas before starting.

Download the Excel workbook (.xlsx)

Illustrative result

$8.00 added overtime

A $256 award allocated across three workweeks adds $2.00 per hour. The two overtime weeks add $6.00 and $2.00 to gross pay.

Build and review the workweek allocation

  1. Confirm that the award belongs in the regular rate. Check the plan terms and how the award was promised and earned. The label on a payment does not decide whether it qualifies for exclusion. See U.S. Department of Labor guidance on bonuses.
  2. Allocate the award to its earning workweeks. Use identifiable weekly earnings where possible. If that is impossible, document a reasonable and equitable basis. Equal dollars per week or equal dollars per hour may be appropriate if the facts support that basis. See 29 CFR § 778.209.
  3. Enter all workweeks in order. Use actual hours worked, including overtime hours. Include weeks with zero overtime. Enter zero only when confirmed. Record the allocation in cents and resolve any difference from the award. A missing or duplicate workweek, unknown hours or dollars assigned to a zero-hour week blocks the total in this workbook.
  4. Review the adjustment before posting. Tie each premium to its workweek and check whether an adjustment was already paid. Keep the worksheet, approved allocation basis and supporting time and payroll records together in your restricted payroll system. See the federal recordkeeping guidance for required records.

Worked example · illustrative

A bonus spread over 128 actual hours

Payroll has documented that equal dollars per hour is reasonable for this $256 award. Divide $256 by 128 hours to allocate $2.00 per hour. Each statutory overtime hour adds another $1.00, or half that increase.

Week 1
40 worked hours
$80 allocation
$0.00 premium
Week 2
46 worked hours
$92 allocation
$6.00 premium
Week 3
42 worked hours
$84 allocation
$2.00 premium

The three rows total $256 in allocated bonus and $8.00 in additional overtime. Week 1 still belongs in the reconciliation because it earned part of the award.

If the facts instead supported equal dollars per week, putting the extra cent in week 2 would allocate $85.33, $85.34 and $85.33. The overtime premiums would be $0.00, $5.57 and $2.03, for $7.60. Choose the allocation from the award evidence before comparing premiums.

Method and limits

For each week, divide its bonus allocation in USD by all hours actually worked to get the increase in USD per hour. Under this standard federal model, overtime hours equal hours above 40 in a workweek. Multiply the increase by 0.5 and by that week’s overtime hours. The workbook keeps the calculated hourly rate at full precision, rounds each weekly premium to cents, and sums the weekly amounts. A valid week with zero work and zero allocation has no hourly increase to calculate and contributes $0.00.

When does the worksheet need a different review?

Use qualified review if the original overtime was missing or incorrect, the award spans more than 53 workweeks, or special federal, state or local overtime rules apply. A qualifying percentage-of-total-earnings bonus may already include the overtime premium under 29 CFR § 778.210. The workbook does not decide inclusion, correct withholding, or calculate net pay. Check the applicable jurisdiction through the state labor office directory.

Preparing the hours first? See TimeTrex Time & Attendance.

Disclaimer: This resource estimates the incremental overtime premium for one includable bonus under the standard U.S. federal 40-hour workweek. It assumes straight time and original overtime were paid correctly and does not determine bonus eligibility, state or local requirements, special federal rules, taxes or net pay. Verify all inputs, results and assumptions against appropriate records and obtain qualified advice before relying on them. To the fullest extent permitted by applicable law, this resource is provided “as is” without warranties of accuracy, completeness or fitness for a particular purpose, and TimeTrex and its affiliates disclaim liability for losses, damages, costs or claims arising from its use, inability to use, or reliance on it, including errors or omissions. Nothing in this disclaimer excludes or limits liability or rights that cannot lawfully be excluded or limited.

Share the Bonus Overtime True-Up Workbook

Facebook
X
LinkedIn
Email
WhatsApp
Print
Three weekly timesheets, a bonus award and a calculator.

Disclaimer: The content provided on this webpage is for informational purposes only and is not intended to be a substitute for professional advice. While we strive to ensure the accuracy and timeliness of the information presented here, the details may change over time or vary in different jurisdictions. Therefore, we do not guarantee the completeness, reliability, or absolute accuracy of this information. The information on this page should not be used as a basis for making legal, financial, or any other key decisions. We strongly advise consulting with a qualified professional or expert in the relevant field for specific advice, guidance, or services. By using this webpage, you acknowledge that the information is offered “as is” and that we are not liable for any errors, omissions, or inaccuracies in the content, nor for any actions taken based on the information provided. We shall not be held liable for any direct, indirect, incidental, consequential, or punitive damages arising out of your access to, use of, or reliance on any content on this page.

Trusted By

Trusted by 3.4M+ Employees: 23 Years of Service Across Startups to Fortune 500 Enterprises

Join our ever-growing community of satisfied customers today and experience the unparalleled benefits of TimeTrex.

Logo for H&R Block
Hilton Hotels and Resorts logo
HP computers logo
Oracle logo black and white
PWC brand logo
Texas A&M University logo
Mcdonald's brand logo
New York Stock Exchange Logo black and white
Walmart brand logo
London Drugs logo black and white

Strength In Numbers

Join The Companies Already Benefiting From TimeTrex

Users
0
Companies
0
Years
0

Time To Clock-In

Start your 30-day free trial!

Experience the Ultimate Workforce Solution and Revolutionize Your Business Today

TimeTrex Mobile App Hand