FLSA regular rate calculator for overtime and code TT
The overtime half is figured on the regular rate: all pay for the week (with nondiscretionary bonuses) divided by hours worked.
Two rates in one week
30 hours at $14 and 15 hours at $16 is $660 for 45 hours. The regular rate is $660 ÷ 45 = $14.67, so the half-time premium for 5 overtime hours is $36.67.
A nondiscretionary bonus
46 hours at $15 plus a $50 attendance bonus is $740. The regular rate is $740 ÷ 46 = $16.09, and the premium for 6 overtime hours is $48.26. Discretionary bonuses, gifts, reimbursements and pay for hours not worked (vacation, holiday, sick) are left out of the regular rate (29 CFR part 778).
Files it reads
A CSV or Excel export with one row per shift, day or week: employee, date (or week ending), hours, and a rate or straight-time pay. Optional columns: pay date, pay code (regular, overtime, double time, vacation, holiday, sick, bonus, reimbursement), bonus or other pay, overtime premium paid and FLSA status. Download the template from the tool to see the layout.
What you get
- Code TT per employee: ½ × the regular rate × hours over 40 in each workweek, added up for the year.
- Workweeks: daily rows grouped into your fixed 7-day workweek, with the year taken from the pay date.
- Checks: premium paid below the FLSA half, coded overtime that doesn't match, duplicates, leave hours, exempt staff, rates below $7.25 and weeks split across years.
- Exports (Pro): code TT CSV, workweek CSV and an Excel workbook.
Your payroll data stays on your computer
Halftally reads your file with JavaScript in this browser tab. Names, hours and pay are never uploaded, and closing the tab clears them.
How it works
- Drop your hours export (CSV or Excel) — or try the sample, or download the template.
- Pick the W-2 year and the day your FLSA workweek starts.
- Read the code TT total and the checks, then print the summary. With Pro, see every employee and download the code TT CSV, the workweek CSV and the Excel workbook.
FAQ
What does Halftally do?
It reads hours from a time-clock or payroll export, groups them into FLSA workweeks, works out each week's regular rate, and totals ½ × regular rate × hours over 40 per employee — the qualified overtime compensation that 2026 Forms W-2 report in box 12 with code TT. It doesn't run payroll and doesn't file anything.
Is my data uploaded?
No. Your file is read by JavaScript in your browser tab and never sent to us or anyone else. Hours aren't stored, so closing the tab clears them. Your settings (year, workweek start, employer name) can be saved in this browser.
Which files can I use?
CSV, tab-separated or Excel with one row per shift, day or week: employee, date (or week ending), hours, and a rate or straight-time pay. Pay code, bonus, pay date and FLSA status are optional. Download the template to see the layout.
What's free?
Importing any number of employees, the company code TT total and every check, plus the first 5 employees itemized on screen and in print (with a footer). Pro itemizes every employee and exports the code TT CSV, the workweek CSV and the Excel workbook.
Is code TT capped at $12,500?
No. Report the full qualified overtime in box 12 code TT. The $12,500 limit ($25,000 joint) and the income phase-out apply only to the employee's deduction on their return (IRS FS-2026-13, Q10).
What isn't covered?
State daily overtime (not qualified), salaried non-exempt and fluctuating-workweek pay, 7(j) hospital and 7(k) public-safety schedules, and spreading a quarterly or annual bonus back over the weeks it covers. Put a bonus in the weeks it was earned, or adjust those weeks with your payroll provider.
Is this tax advice?
No. Halftally applies the method in IRS FS-2026-13 (updated August 6, 2026) and the FLSA regular-rate rules in 29 CFR part 778 to the data you provide. Ask your tax adviser or payroll provider what applies to you.