Weekly timesheet template
A timesheet records the hours an hourly employee works each day, which you need to pay them correctly and keep for federal wage rules. This free weekly template takes time in, time out and unpaid breaks, adds up the week, and splits the hours into regular and overtime after 40, with signature lines.
Updated November 2026
What does the template look like?
Type one row per entry. Totals add themselves in Excel. Here it is with sample figures, so you can see how it fills in.
| Day | Date | Time in | Lunch out | Lunch in | Time out | Total hours | Notes |
|---|---|---|---|---|---|---|---|
| Monday | 2026-06-01 | 8:00 AM | 12:00 PM | 12:30 PM | 5:00 PM | 8.5 | |
| Tuesday | 2026-06-02 | 8:00 AM | 12:00 PM | 12:30 PM | 5:30 PM | 9 | |
| Wednesday | 2026-06-03 | 8:00 AM | 12:00 PM | 12:30 PM | 5:00 PM | 8.5 | |
| Thursday | 2026-06-04 | 7:30 AM | 12:00 PM | 12:30 PM | 6:00 PM | 10 | |
| Friday | 2026-06-05 | 8:00 AM | 12:00 PM | 12:30 PM | 4:30 PM | 8 | |
| Total | 44 |
Why do I need timesheets?
For non-exempt employees, federal law requires you to keep records of hours worked each day and week, and pay at least time and a half for hours over 40 in a workweek. If an employee ever disputes their pay, the timesheet is your evidence. Payroll software and time clocks do the same job, as long as the record is accurate.
How is overtime worked out?
Add the hours for the workweek, a fixed seven-day period you choose. Hours up to 40 are regular. Hours over 40 are overtime, paid at 1.5 times the regular rate. Some states add daily overtime or different rules. Our overtime calculator does the math, and the no tax on overtime calculator shows the 2025 to 2028 federal deduction your employees may claim.
How long should I keep timesheets?
The Department of Labor asks for at least two years for time cards and three years for payroll records. For tax purposes the IRS wants employment tax records kept at least four years. Most businesses keep them four years or more.
Sources
General information, not tax advice for your situation.
Do salaried employees need timesheets?
Exempt salaried employees don't need hour records under federal law. Non-exempt salaried employees do, because they're owed overtime.
Can I round time?
Rounding to the nearest 5, 6 or 15 minutes is allowed if it averages out and doesn't always favor the employer.
Are lunch breaks paid?
Breaks of 30 minutes or more, when the employee is fully off duty, can be unpaid. Short breaks of 5 to 20 minutes count as work time.
Tell us what's messy. We'll tell you what it takes.
Tell us what you need and get a fixed price before any work starts. No pressure and no contract.