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
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 overtimeA $256 award allocated across three workweeks adds $2.00 per hour. The two overtime weeks add $6.00 and $2.00 to gross pay.
Worked example · illustrative
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.
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.
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.
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.
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
Join our ever-growing community of satisfied customers today and experience the unparalleled benefits of TimeTrex.
Strength In Numbers
Time To Clock-In
Experience the Ultimate Workforce Solution and Revolutionize Your Business Today
Saving businesses time and money through better workforce management since 2003.
Copyright © 2026 TimeTrex. All Rights Reserved.