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.

1. Inspect your export