Free template
A free timesheet template, from a company that would rather you stopped using one.
We sell software that writes timecards from GPS, so handing out a blank timesheet is a slightly odd thing for us to do. But most crews are using one today, plenty of them are using a bad one, and a good template costs us nothing. No email required.
Weekly timesheet
Seven days, start and end times, unpaid meal, drive time as its own column, and job or site. Total hours calculate themselves.
Best for: Any crew, any state.
Download CSVWeekly timesheet - California overtime
The same sheet, plus straight / overtime / double-time columns computed per day under Labor Code 510(a), and the weekly promotion worked out at the bottom so daily overtime is not counted twice.
Best for: Anyone with California employees.
Download CSVCSV, so it opens in Excel, Google Sheets, Numbers or LibreOffice with the formulas intact. In Google Sheets, use File → Import → Replace spreadsheet so the formulas are read as formulas.
Three things most templates get wrong
Days labelled Monday to Sunday
Ours say Day 1 to Day 7, because your workweek starts whenever you say it starts. It matters more than it sounds: California's seventh-consecutive-day premium is keyed to the employer's own workweek, which is the holding in Mendoza v. Nordstrom. A sheet that assumes Sunday teaches people the wrong rule.
Drive time folded into the job
It gets its own column here. Travel between the shop and a site is hours worked, it is the single loudest grievance field workers have, and burying it in the job total is how an argument starts. More on why that matters to the crew.
A rounding column
There is not one, deliberately. Plenty of templates round the daily total to the nearest quarter hour. 29 CFR 785.48(b) permits rounding punch times, not a day's total - and five days of 8h05m rounded down is 25 minutes a week that someone worked and nobody paid for.
What a spreadsheet cannot fix
The template is only as good as what goes into it, and what goes into it is usually somebody's recollection of a Tuesday. That is fine right up until the hours are questioned - by an employee, an auditor or a lawyer - at which point a sheet filled in on Friday afternoon is evidence of what someone remembered rather than of what happened.
That is the part we sell, and it is the only part worth paying for. Everything above is free and always will be.
Common questions
Do I have to give you my email?+
No. The files are linked directly and there is no form in front of them. Gating a timesheet template behind an email address in exchange for something anyone can build in a spreadsheet felt like a poor first impression.
Will these open in Google Sheets?+
Yes. They are CSV, so Excel, Google Sheets, Numbers and LibreOffice all open them and the formulas work in each. In Google Sheets use File then Import and choose Replace spreadsheet, so the formulas are read as formulas rather than text.
Why is drive time a separate column?+
Because it is separately payable and it is the loudest thing field workers argue about. Travel between the shop and a job site, or between jobs, is hours worked under both federal law and California's. Folding it into the job hides it from everyone, including you.
Why does the template tell me not to round?+
29 CFR 785.48(b) permits rounding punch times to the nearest few minutes. It does not permit rounding a day's total, which is a different practice with different error behaviour, and in California Camp v. Home Depot held that an employer who can capture exact time must pay all of it. Rounding a daily total is also where money quietly goes missing - five days of 8h05m rounded to 8h00m is 25 unpaid minutes a week.
Does the California version handle everything?+
No, and it says so on the sheet. It does the daily 8 and 12 hour thresholds and the weekly promotion. It does not do the seventh-consecutive-day premium, the split-shift premium, or any meal or rest period premium under Labor Code 226.7 - those need more than a column of arithmetic. The free calculator handles the seventh day; nothing we publish prices a 226.7 premium, because that needs a bonus table.
Is a spreadsheet good enough?+
For a couple of people on one site, honestly yes, and we would rather you used this than bought something you do not need. It stops being good enough when someone has to remember what time they left a job three days ago, because at that point the sheet is a record of memory rather than of work - which is the thing that does not hold up when it is questioned.
Want the overtime worked out for you? The free calculator runs the same engine as our payroll exports, and every rule behind it is published with its statute. Punchless is not a law firm and this is not legal advice.