Free worksheet

W-2 box 12 code TT, rebuilt workweek by workweek

For employers and bookkeepers whose payroll may not work out qualified overtime, or only partly: QuickBooks Desktop payroll in some setups, spreadsheets or after-the-fact payroll. Load your pay lines and get the amount for each employee, with the regular rate and hours behind every week.

This worksheet needs JavaScript. It runs entirely in your browser.

How the amount is worked out

  1. Workweeks. Lines are grouped into your fixed workweek. Each week stands alone; hours are never averaged across weeks (FS-2026-13, Q13).
  2. Hours worked. Regular and overtime hours count. Holiday, vacation, sick and other paid time off do not, so 36 hours worked plus an 8-hour holiday gives no overtime.
  3. Regular rate. Pay for the week, divided by hours worked. It includes shift differentials, nondiscretionary bonuses and commissions, and any tip credit. It leaves out overtime premiums for hours over 8 a day, 40 a week or normal hours (at any multiplier), weekend and holiday premiums of 1.5× or more, discretionary bonuses, gifts, reimbursements and pay for time not worked (29 USC 207(e)).
  4. Code TT for the week. Hours over 40 × ½ × regular rate. If you pay double time, or overtime under a state daily rule, only the half the FLSA requires counts (FS-2026-13, Q16). Code TT is overtime paid: if less premium was paid than required, the week shows what was paid and the rest is listed as owed (FS-2026-13, Q10 and Q21).
  5. Bonuses for longer periods are spread back over the weeks they cover. The extra half-rate they create for the overtime weeks is owed to the employee; it counts as code TT once it has been paid, so tick the box above only if you paid it.
  6. Rounding. Rates are kept unrounded; each week is rounded to the cent, and totals add the rounded weeks.
  7. Incomplete totals. An employee with a skipped line, a bonus that could not be spread, underpaid overtime or a year-end week without a pay date is marked incomplete in the totals and in the download.

What it does not do

Step-by-step explanation with worked examples: how to calculate code TT.

Sources: IRS Fact Sheet FS-2026-13 (August 2026), DOL Fact Sheet #56A, regular rate, 29 CFR part 778.