Free Employee Timesheet Templates
Free employee timesheet templates for small business: weekly, biweekly, semi-monthly, monthly, and contractor. Excel with overtime formulas. No signup.
Employee Timesheet Templates
Six free employee timesheet templates for small business: weekly, biweekly, semi-monthly, monthly, a contractor version, and a blank printable. Download as Excel with overtime formulas and approval fields built in. No signup.
An employee timesheet records the hours worked in a pay period, and it is the document that stands between those hours and a correct paycheck. This page gives you six free templates and the federal overtime and recordkeeping rules behind them. If another founder asked me which HR record to get right first, I would point to this one.
Get the timesheet right and payroll is fast and accurate; get it wrong, or lose it, and you have both a payroll problem and a compliance gap. For a small business, it is often the only wage record you keep, which makes the format you choose and how you store it matter more than they seem.
These six templates cover the range: weekly, biweekly, semi-monthly, and monthly versions for each payroll cycle, a contractor version that doubles as an invoice basis, and a blank printable for manual entry. Each downloads as an Excel file, free and without an email, and all but the blank come with the totals already built as formulas.
What an Employee Timesheet Is
An employee timesheet is a record of the hours an employee worked during a pay period, used to calculate pay and to satisfy federal recordkeeping rules. It lists each day with a time in, time out, and break, separates regular from overtime hours, and totals the period. Timesheet, time sheet, and staff timesheet all describe the same document, and nothing about the format changes with the spelling.
A timesheet is an employer-side record, filled in by the employee or a manager and approved before payroll runs. Beyond driving pay, it does two jobs: it creates the approval trail that settles hours disputes, and it forms part of the wage record the Fair Labor Standards Act requires. The Department of Labor recordkeeping rules care about what the record shows, not how you capture it.
Time Card vs. Timesheet
A time card and a timesheet are the same record in almost every small business. The term time card comes from the paper card a worker punched into a mechanical clock, and the federal rules still use it: the recordkeeping regulation names time cards among the records used to compute wages. A timesheet is that same data on a sheet or a spreadsheet.
The one distinction worth keeping is granularity. A time card usually holds one worker and one period of punch times, typically on a printable weekly or biweekly grid. A timesheet more often carries task or project detail next to the hours. Every template here works either way, and the blank printable is the closest thing to a classic punch card.
Timesheet vs. Attendance Sheet
A timesheet and an attendance sheet are often confused, but they answer different questions. A timesheet records hours worked, and often the tasks those hours went to, which is what drives pay and overtime.
An attendance sheet records presence and absence, whether someone showed up and in what status, which is what you use for staffing and to spot patterns. Knowing which one a task needs keeps a small business from making one sheet do both jobs badly.
| Timesheet | Attendance sheet | |
|---|---|---|
| Records | Hours worked and tasks | Presence and absence status |
| Answers | How many hours, on what? | Was the person here? |
| Unit | Clock-in and clock-out times | A status code per day |
| Best for | Hourly pay, overtime, billing | Staffing, absence patterns, discipline |
| Drives | Payroll and overtime | Attendance policy and discipline |
The practical rule: use a timesheet to capture the hours that drive pay. When what you need is presence and absence status rather than hours, a dedicated attendance sheet is the right document; this page covers the hours side.
What to Include
A complete timesheet covers four groups: identifying fields, hours data, totals and pay, and an approval trail. Here is what belongs in each one.
The two elements small businesses most often skip, and most need, are a separate overtime column and a manager approval line. The weekly, semi-monthly, and monthly templates build both in, with the overtime figured per workweek.
Timesheet Categories and Tracking Time by Project
Timesheet categories are the buckets each hour gets sorted into, and they decide what the sheet can tell you later. Every timesheet needs pay categories, because payroll depends on them. Work categories are optional, and worth adding only when you plan to use the answer for job costing, client billing, or planning capacity.
| Category type | Examples | Why it earns a column |
|---|---|---|
| Pay categories | Regular, overtime, double time, PTO, holiday, sick, unpaid break | They drive gross pay and keep overtime separate from regular hours |
| Work categories | Project, job number, client, task, cost code | They let you cost a job, bill a client, or see where the week actually went |
| Billing status | Billable, non-billable, internal | The split consultants and agencies need before they can invoice |
| Location or shift | Site, department, shift, travel time | Field and multi-site teams need it for job costing and travel pay questions |
| Approval status | Submitted, approved, corrected | The trail that makes the record defensible when hours are disputed |
To track time by project or job, use the contractor sheet as a work log: keep the project or task column, add a client or job number beside it, and mark each line billable or not. The same file then works as a project time tracking spreadsheet, so whoever does the collecting has one file to chase instead of two.
Task-level tracking only survives if the categories stay few and obvious. A consultant splitting time across six clients will keep it up for years. A five-person shop with forty task codes will abandon it inside a month. Start with the pay categories, add project detail only where a real decision depends on it, and drop the rest.
Which Template Should You Use?
Match the template to your payroll cycle and worker type. Weekly for the simplest overtime math, biweekly for the most common US cycle, semi-monthly or monthly for salaried staff, the contractor version for freelance work, and the blank for manual entry.
6 Free Employee Timesheet Templates
Download all six as a single Excel set or grab individual templates. Each downloads as an Excel file with the time columns and totals already built, free and with no signup. Every template also opens cleanly in Google Sheets. Fill in the hours on any formula sheet and the totals calculate themselves.
Open the file in Google Sheets and it becomes an online timesheet people can fill in from anywhere; Sheets and Excel both print it or save it to PDF. For a paper version instead of a Word or Excel file, print the blank sheet and fill it in by hand, remembering that the formulas stay behind in the spreadsheet.
Template 1: Weekly Timesheet
Seven days with time in, time out, break, and separate regular and overtime columns that total automatically. The cleanest fit for hourly pay and weekly overtime.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Day | Date | Time In | Time Out | Break (min) | Regular Hrs | Overtime Hrs | Total Hrs |
| 2 | Monday | 8:00 AM | 5:00 PM | 30 | 8.5 | 0 | =F2+G2 | |
| 3 | Tuesday | 8:00 AM | 5:30 PM | 30 | 9.0 | 0 | =F3+G3 | |
| 4 | Wednesday | 8:00 AM | 5:00 PM | 30 | 8.5 | 0 | =F4+G4 | |
| 5 | Thursday | 8:00 AM | 5:00 PM | 30 | 8.5 | 0 | =F5+G5 | |
| 6 | Friday | 8:00 AM | 4:30 PM | 30 | 5.5 | 2.5 | =F6+G6 | |
| 7 | Saturday | 0 | 0 | =F7+G7 | ||||
| 8 | Sunday | 0 | 0 | =F8+G8 | ||||
| 9 | Weekly Total | =SUM(F2:F8) | =SUM(G2:G8) | =SUM(H2:H8) |
Template 2: Biweekly Timesheet
Two weekly grids on separate tabs with a combined pay-period total, keeping each workweek separate so overtime is still figured per week. For the every-two-weeks cycle.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Day | Date | Time In | Time Out | Break | Total Hrs |
| 2 | Monday | 8:00 AM | 5:00 PM | 30 | 8.5 | |
| 3 | Tuesday | 8:00 AM | 5:00 PM | 30 | 8.5 | |
| 4 | Wednesday | 8:00 AM | 5:00 PM | 30 | 8.5 | |
| 5 | Thursday | 8:00 AM | 5:00 PM | 30 | 8.5 | |
| 6 | Friday | 8:00 AM | 5:00 PM | 30 | 8.5 | |
| 7 | Saturday | 0 | ||||
| 8 | Sunday | 0 | ||||
| 9 | Week 1 Total | =SUM(F2:F8) |
Template 3: Semi-Monthly Timesheet
A pay period running the 1st to the 15th and 16th to month end, with regular, overtime, and PTO columns. For the twice-a-month cycle that splits calendar weeks.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Date | Time In | Time Out | Break (min) | Regular Hrs | Overtime Hrs | PTO Hrs | Total Hrs |
| 2 | 1st | 8:00 AM | 5:00 PM | 30 | 8.5 | 0 | 0 | 8.5 |
| 3 | 2nd | 8:00 AM | 5:00 PM | 30 | 8.5 | 0 | 0 | 8.5 |
| 4 | 3rd | 8:00 AM | 5:00 PM | 30 | 8.5 | 0 | 0 | 8.5 |
| 5 | 4th | 0 | 0 | 8 | 8 | |||
| 6 | 5th | 8:00 AM | 5:00 PM | 30 | 8.5 | 0 | 0 | 8.5 |
| 7 | ... | |||||||
| 8 | 15th | 8:00 AM | 5:00 PM | 30 | 8.5 | 0 | 0 | 8.5 |
| 9 | Period Total (1-15) | =SUM(E2:E8) | =SUM(F2:F8) | =SUM(G2:G8) | =SUM(H2:H8) |
Template 4: Monthly Timesheet
A full-month day-by-day grid with regular and overtime totals, for monthly payroll or salaried staff, with a note that overtime is still figured per workweek.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Date | Day | Time In | Time Out | Break (min) | Regular Hrs | Overtime Hrs | Total Hrs |
| 2 | 1 | Mon | 8:00 AM | 5:00 PM | 30 | 8.5 | 0 | 8.5 |
| 3 | 2 | Tue | 8:00 AM | 5:00 PM | 30 | 8.5 | 0 | 8.5 |
| 4 | 3 | Wed | 8:00 AM | 5:30 PM | 30 | 9.0 | 0 | 9.0 |
| 5 | 4 | Thu | 8:00 AM | 5:00 PM | 30 | 8.5 | 0 | 8.5 |
| 6 | 5 | Fri | 8:00 AM | 5:00 PM | 30 | 5.5 | 3.0 | 8.5 |
| 7 | ... | |||||||
| 8 | 31 | |||||||
| 9 | Monthly Total | =SUM(F2:F8) | =SUM(G2:G8) | =SUM(H2:H8) |
Template 5: Contractor Timesheet
Date, project or task, start and end, hours, rate, and an auto-calculated amount, so the sheet doubles as an hours record and an invoice basis for independent contractors.
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Date | Project / Task | Start | End | Hours | Rate | Amount |
| 2 | Discovery call | 9:00 AM | 10:00 AM | 1.0 | 75.00 | =E2*F2 | |
| 3 | Design mockups | 10:30 AM | 1:00 PM | 2.5 | 75.00 | =E3*F3 | |
| 4 | Revisions | 2:00 PM | 4:30 PM | 2.5 | 75.00 | =E4*F4 | |
| 5 | |||||||
| 6 | |||||||
| 7 | |||||||
| 8 | Total | =SUM(E2:E7) | =SUM(G2:G7) |
Template 6: Blank Printable Timesheet
A blank grid with name, date, time in and out, break, and totals, plus a signature line. Print it and fill it in by hand when a formula sheet is more than you need.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Date | Day | Time In | Time Out | Break | Total Hrs |
| 2 | ||||||
| 3 | ||||||
| 4 | ||||||
| 5 | ||||||
| 6 | ||||||
| 7 | ||||||
| 8 | ||||||
| 9 | ||||||
| 10 | ||||||
| 11 |
Choosing a Pay Period
The pay period you run determines which timesheet fits, and each has tradeoffs. Weekly is simplest for overtime; biweekly is the most common US cycle; semi-monthly suits salaried staff but splits calendar weeks; monthly is easiest to administer for small salaried teams. Here is how they compare.
According to the Bureau of Labor Statistics Current Employment Statistics survey (February 2023), 43.0 percent of private establishments pay biweekly, ahead of weekly at 27.0 percent, semi-monthly at 19.8 percent, and monthly at 10.3 percent.
Matching the sheet to your own pay cycle is the whole decision, because the time in, time out, break, and hours columns are the same in every pay-period version. Whichever cycle you pick, overtime is still figured per workweek. A semi-monthly or monthly period will split workweeks across pay periods, so track hours by week underneath the pay period, then sum.
How to Fill Out the Timesheet
Filling out a timesheet takes a minute a day once it is set up. Here is the sequence the templates are built around.
Overtime and FLSA Recordkeeping
Two federal rules sit underneath every timesheet: how overtime is calculated, and how long you keep the record. Getting either wrong is a common and expensive small-business mistake, and both are simple once you know them.
Overtime is owed to non-exempt employees at one and one-half times their regular rate for hours worked over forty in a workweek, and it is calculated per workweek, not per pay period. Pay biweekly or monthly all you like; the overtime math still happens one week at a time.
A workweek is a fixed, regularly recurring period of 168 hours, seven consecutive 24-hour periods, and it need not start on a Monday or line up with the calendar week. Some states add a daily overtime rule on top, so confirm your state.
Whether overtime is owed at all turns on classification. The Department of Labor's white-collar exemption tests run on salary level and actual duties. The Department's fact sheet on those tests says plainly that job titles do not determine exempt status, so a salaried assistant manager can still be non-exempt and owed overtime.
When an employer's time records are inaccurate or inadequate, Anderson v. Mt. Clemens Pottery (1946) lets an employee who proves unpaid work carry the burden by showing its amount and extent as a matter of just and reasonable inference. The burden then shifts to the employer to produce evidence of the precise hours worked or to rebut the inference.
In plain terms, when your records fall short, an employee's reasonable estimate of unpaid hours can stand unless you can disprove it, so approved timesheets are worth holding on to. Keeping every sheet for three years covers the longer retention window and the FLSA's statute of limitations, which allows two years to sue over unpaid minimum wages or overtime and three for a willful violation.
Timesheets for a Small Business
A large company runs time tracking through software and a payroll team. A small business has an owner or a manager collecting sheets directly, between everything else, and pays the price when hours are wrong or a record goes missing. The framework is the same at any size; a small business just needs it simple, per-workweek accurate, and retained.
The single most valuable habit is collecting an approved timesheet every period, in one consistent format, and holding onto it. A signed, retained record is what turns a payroll question into a two-minute lookup instead of an argument.
From Spreadsheet to HR Software
A spreadsheet timesheet is the right tool for a small team, and these templates work on their own. The strain shows up when hours, approvals, and record retention live in scattered files, when chasing sheets every period eats a manager's time, and when a lost record becomes a real liability.
When that point arrives, FirstHR centralizes the records around the timesheets: employee profiles hold the roster with each person's FLSA status and standard hours, and document storage keeps approved timesheets and wage records in one retrievable place for the retention period. In their own self-service portal, each employee e-signs the acknowledgments for the employee handbook and time-off policy.
FirstHR is an onboarding and HR platform, not a payroll processor: it does not run payroll, calculate wages, or replace a dedicated time clock, so pair it with your payroll provider and, for wage questions, a professional advisor. Applicant tracking is coming soon to FirstHR.
Frequently Asked Questions
What is an employee timesheet?
An employee timesheet is the employer's record of how many hours a worker put in during one pay period. Each day gets a row with the start time, end time, and break; regular hours and overtime go in separate columns; and the period total sits at the bottom. The header carries the employee's name, the manager, and the pay period, with room for both of them to sign. Layouts come weekly, biweekly, semi-monthly, or monthly, and a business chooses the one that fits its payroll cycle. In practice the sheet does three jobs at once: it captures the hours that pay is calculated from, it leaves an approval trail that settles disputes, and it serves as part of the wage record federal recordkeeping rules require you to keep. A well-built timesheet totals the hours and overtime automatically, which keeps payroll quick and accurate.
What is the difference between a timesheet and an attendance sheet?
A timesheet measures time worked, while an attendance sheet records whether each person was there. The timesheet tells you how many hours someone put in, and often which tasks those hours went to, so it is the record that pay and overtime are calculated from. The attendance sheet logs a status for each day, such as present, absent, late, or on leave, which helps you spot absence patterns and plan staffing. The two overlap, yet each has its own job, and a small business keeps cleaner records when it does not ask one sheet to do both. If you pay hourly workers or owe overtime, you need a timesheet that captures actual clock hours. If your concern is absences and coverage, an attendance sheet fits better, and plenty of businesses keep both. This page deals with the hours side; presence and absence status belongs on a dedicated attendance sheet.
What should an employee timesheet include?
A complete timesheet has four parts. First come the details that identify it: the employee's name and ID, the manager, the pay period, and the hourly or project rate. Next is the daily hours data, meaning a start time, an end time, and a break for every day worked, with regular and overtime hours in their own columns. Then come the totals: a sum for each day and for the period, any PTO or paid-leave hours, and overtime at one and one-half times the regular rate for every hour beyond forty in a workweek. Last is the approval trail, an employee signature plus a manager's sign-off, which makes the record official. Small businesses most often leave out the separate overtime column and the manager approval line, yet those two matter most: one keeps payroll accurate, and the other lets you defend the record if anyone disputes the hours.
How do I create a timesheet in Excel?
The fastest way is to start from a template rather than a blank grid. Download one of the Excel timesheets on this page and the columns, formulas, and totals are already built. If you build your own, put the day and date in the first columns, then time in, time out, and break, then columns for regular hours, overtime hours, and a daily total. To calculate hours worked, subtract time in from time out and the break, formatting the cells as time or using a formula that converts to decimal hours. Use SUM to total the period at the bottom, and a separate overtime column so hours over forty in a week are captured on their own. Add employee and manager signature lines. The weekly and monthly templates here are already set up this way, with the formulas in place and a separate setup tab, so you can fill one in immediately.
How is overtime calculated on a timesheet?
Under the Fair Labor Standards Act, non-exempt employees earn overtime at one and one-half times their regular rate for hours worked over forty in a single workweek. The critical detail is that overtime is calculated per workweek, not per pay period. A workweek is any fixed block of 168 hours that repeats every seven days, and paying biweekly or monthly does not change it. So if an employee works forty-five hours one week and thirty-five the next, they are owed five hours of overtime for the first week, even though the two-week total is eighty hours. This is why timesheets should keep each workweek separate, and why the biweekly template on this page uses a tab per week. Some states also require daily overtime, for example over eight hours in a day, so check your state rule. Salaried exempt employees generally do not earn overtime, but classification follows the actual duties and salary tests, not the job title.
How long do employers have to keep timesheets?
Federal law treats timesheets as part of the wage record, so they have to be kept for a set period. The Department of Labor's rules under the Fair Labor Standards Act require at least three years for payroll records and at least two for the records wages are computed from, time cards and work and time schedules among them. Copies on microfilm or in automated data processing memory are acceptable, provided they stay legible and can be viewed on request. If the records sit at a central recordkeeping office rather than at the worksite, an inspector must have them within seventy-two hours of notice. Holding everything for three years is the simplest policy: it satisfies the longer period and lines up with the federal statute of limitations, which gives employees three years to sue over a willful violation. Some states require longer; New York, for example, sets six years for payroll records. So do not throw out approved timesheets when a pay period or year closes. File them where you can find them and keep them at least as long as required, because they are the evidence you rely on in a wage dispute or audit. This is general information, not legal advice.
Can employees fill out their own timesheets?
Yes, and it is common and fully compliant. The Department of Labor allows any timekeeping method as long as it is complete and accurate, including having employees write their own times on the record. The key is a review-and-approval step: the employee records their hours, and a manager reviews and signs off before payroll runs. This is exactly what the signature and approval lines on these templates are for. Self-reported timesheets work well for small teams and salaried or trusted staff, while businesses with hourly shift workers sometimes prefer a clock-in method to reduce disputes. Whichever you use, the employer, not the employee, is responsible for keeping accurate records, so the manager approval step matters. Build the habit of reviewing each sheet against the schedule before approving, and the self-reported timesheet is both simple and defensible.
Do I need timesheets for salaried employees?
It depends on whether they are exempt or non-exempt. Non-exempt salaried employees are still owed overtime, so you must track their hours, and a timesheet is the practical way to do it. Exempt salaried employees, those who meet the FLSA duties and salary tests, do not earn overtime, so you are not legally required to track their exact hours for pay purposes. Many businesses still have exempt staff submit a simple timesheet or attendance record for PTO tracking, project costing, or client billing, which is why the monthly template on this page works for salaried staff. The important thing is not to assume a salary makes someone exempt. Classification depends on the actual duties and the salary level, not the title or the fact that someone is paid a salary. If a salaried employee is actually non-exempt, you owe them overtime and you need their hours. This is general information, not legal advice.