Payroll CSV or XLSX · explicit mapping · calculation aid
W-2 box 12 code TT: qualified overtime workpaper
Turn a payroll register or timesheet export into a per-employee, per-workweek workpaper of qualified overtime compensation: only the FLSA-required half-time premium on hours over 40 in a workweek, at the regular rate (IRS FS-2026-13). Double-time excess, daily and weekend premiums beyond it, contract premiums and overtime-ineligible pay are kept apart and cited; anything the file cannot settle is an exception. One workbook and JSON ZIP use one existing file unlock or credit; the free PDF allowance does not apply.
A calculation aid for your payroll records, not tax, legal or FLSA advice. You decide each employee's FLSA status and what each pay type is; you, the employer, file the W-2. General 40-hour method of 29 USC 207(a) only: not for 7(j) hospital periods, 7(k) public-safety work periods or comp time. UTF-8 comma CSV or .xlsx, 4 MB and 5,000 data rows (about 4,000 with long names or IDs). XLSX: paste values; hours to at most 6 decimals.
Upload only payroll files you may process. The original is discarded; results expire after 1 hour. Keep your own copy.
3. Needs review
Preview: counts, one sample line as read and mapping problems. Every employee's code TT figure, workweek calculation, excluded amount, exception and citation is in the workbook and JSON ZIP. An employee with an unresolved exception has no box 12 figure.