Tie-out tool / Worksheet template (CSV)
Code TT reconciliation worksheet template
A free spreadsheet template with one row per employee workweek. It computes hours over 40, the Code TT amount and the difference to the overtime the register paid.
Opens in Excel, Google Sheets, Numbers or LibreOffice. No sign-up. The file contains formulas, so the spreadsheet may ask before opening it.
Columns
| Column | What goes in it | Formula |
|---|---|---|
employee | Name or ID | |
workweek_start, workweek_end | The fixed 7-day workweek, not the pay period | |
pay_date | Payday for the period in which the workweek ends; keep only 2026 paydays | |
hourly_rate | The one hourly rate for that week | |
hours_worked | Hours actually worked; leave out holiday, vacation and sick hours | |
hours_over_40 | =MAX(0,F2-40) | |
code_tt | Qualified overtime for the workweek | =ROUND(G2*0.5*E2,2) |
register_overtime_pay | Overtime the register paid for that week | |
difference | =I2-H2 | |
reason_for_difference | Half-time only, double time, holiday hours, daily overtime, split period |
The three example rows
| Week | Hours worked | Register overtime | Code TT | Difference |
|---|---|---|---|---|
| $20 an hour, 50 hours, time-and-a-half | 50 | $300.00 | $100.00 | $200.00 |
| $20 an hour, 36 worked + 8 holiday, 4 hours paid as overtime | 36 | $120.00 | $0.00 | $120.00 |
| $24 an hour, 50 hours, overtime paid at double time | 50 | $480.00 | $120.00 | $360.00 |
The formula is the IRS one: hours worked over 40 in the workweek x one-half x the regular rate. (IRS FS-2026-13, Q12) It fits hourly staff on one rate. For a bonus, a salary or two rates, the rate column must hold the regular rate for that week.
When a template is too slow
A year for ten employees is about 520 rows to type. The tie-out tool builds the same worksheet from a timesheet CSV in the browser, cuts the year by payday and names the reason for each difference.
Use it freely
The template may be shared, changed and used with clients without asking. A link back to this page is welcome.
Do the whole year from a file
Drop a timesheet CSV, paste the register overtime totals, and get a worksheet per employee with the reason for every difference.
Open the tie-out toolRuns in your browser. Payroll data is never uploaded.
Questions
Is the template free to use with clients?
Yes. It can be shared, changed and used commercially.
Does the template handle double time?
Yes for Code TT, because the formula uses hours over 40 and half the rate whatever multiple was paid. The register column then shows a larger difference.
Sources
- IRS Fact Sheet FS-2026-13, qualified overtime questions and answers (August 2026)
- 29 CFR 778.104, each workweek stands alone
Fetched 2026-11-10. Regulation text was checked against the federal annual edition; links open the current online version.
Updated 2026-11-10. Tickfoot is an information tool, not tax, legal or professional advice.