Employee tracking sheet
A pay-period worksheet for regular rate, overtime hours, overtime rate, statement reference, and method notes.
Template pack
Download a free overtime record sheet for Excel or Google Sheets. Keep your estimates and the pay records behind them in one place. Email us about the planned paid pack.
Not affiliated with the IRS, Treasury, Department of Labor, payroll providers, or tax software vendors. For educational and tracking purposes only.

A blank CSV sheet for your workweek dates, regular rates, overtime hours, estimated premiums, and pay-statement references. It opens in Excel or Google Sheets. No account or email is required.
Keep different workweeks and rates on separate rows. This sheet does not calculate a tax deduction or replace payroll reporting. Use the calculator to download a record containing your current estimate.
The items below describe the planned pack for recordkeeping and tax-preparer review. It is not available for instant download or online purchase. Email us about availability. The pack does not file taxes or replace your payroll system.
A pay-period worksheet for regular rate, overtime hours, overtime rate, statement reference, and method notes.
Planned Excel and Google Sheets layouts for a local copy or a shared worksheet.
A review list for 2025 reporting variations, employer statements, portal screenshots, and questions to ask payroll.
A one-page summary of estimated qualified overtime compensation, caps, phase-out warning, source documents, and open issues.

The pack is useful when records are scattered across pay statements, payroll portals, and year-end forms.
It is also useful for employers who need a consistent internal checklist before responding to employee or preparer questions.
Official sources
Source baseline checked 2026-09-08
Defines qualified overtime compensation, FLSA overtime eligibility, deduction limits, reporting rules, and taxpayer requirements.
View official sourceSummarizes the deduction cap, MAGI phase-out thresholds, Social Security number rule, and 2025 reporting note.
View official sourceProvides 2025 methods for individuals estimating qualified overtime compensation when separate reporting is not available.
View official sourceExplains 2026 Form W-2 reporting, including Box 12 code TT for qualified overtime compensation.
View official sourceExplains the FLSA overtime baseline for covered, nonexempt employees working over 40 hours in a workweek.
View official source