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 hours worked and a correct paycheck. Get it 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, the timesheet 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, with the overtime columns and totals already built as formulas. Because hours sit next to leave and attendance, this pairs with your time off policy and your absenteeism policy.
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 describe the same document; Google treats the spellings as equivalent.
It 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 let employers use any accurate timekeeping method, including employees writing their own times.
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, and an attendance sheet to track who is present and to manage absence. If you need to record 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. The groups below are the consensus set that strong timesheets share.
The two elements small businesses most often skip, and most need, are a separate overtime column and a manager approval line. The templates here build both in by default, with the overtime figured per workweek.
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, overtime, totals, and a setup tab already built, free and with no signup. Every template also opens cleanly in Google Sheets. Fill in the hours and the totals calculate themselves.
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 | 8.5 | 0.5 | =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 | 8.0 | 0 | =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 | =SUM | =SUM | =SUM |
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 | 8.5 | 0.5 | 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 | 8.5 | 0 | 8.5 |
| 7 | ... | |||||||
| 8 | 31 | |||||||
| 9 | Monthly Total | =SUM | =SUM | =SUM |
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.
Whichever you choose, the rule that never changes is that overtime is 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. For the difference that decides whether someone earns overtime at all, the exempt vs. non-exempt guide covers the classification tests.
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. A workweek is a fixed, recurring 168-hour period. Pay biweekly or monthly all you like; the overtime math still happens one week at a time. Some states add a daily overtime rule, so confirm your state.
When an employer cannot produce adequate time records, the law shifts the advantage to the employee in a wage dispute, which is why keeping approved timesheets is not just tidy but protective. Many advisors keep everything for three years to cover the longer window. For the discipline side of chronic time problems, the absenteeism policy templates cover the progressive-discipline steps.
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 what the spreadsheets were doing separately: employee profiles hold the roster and rates, a self-service portal lets employees submit and managers approve, e-signature captures the approval, and document storage keeps timesheets and wage records in one retrievable place for the retention period, alongside 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 a record of the hours an employee worked during a pay period, used to calculate pay and to satisfy federal recordkeeping requirements. A typical timesheet lists each day with a time in, time out, and break, and separates regular hours from overtime, totaling the period at the bottom. It usually includes the employee name, the manager, the pay period, and space for both to sign off. Timesheets come in weekly, biweekly, semi-monthly, and monthly formats, and a business picks the one that matches its payroll cycle. The timesheet does three jobs: it captures the hours that drive pay, it creates the approval trail that resolves disputes, and it forms part of the wage record employers are legally required to keep. A good timesheet auto-calculates totals and overtime so payroll is fast and accurate.
What is the difference between a timesheet and an attendance sheet?
A timesheet records hours worked; an attendance sheet records presence and absence. The timesheet answers how many hours someone worked and often on what, which is what drives pay and overtime. The attendance sheet answers whether someone was there and in what status, present, absent, late, or on leave, which is what you use to spot patterns and manage staffing. They overlap but serve different purposes, and a small business gets cleaner records by using each for its job. If you pay hourly workers or owe overtime, you need a timesheet to capture actual clock hours. If you are tracking absence patterns and staffing, an attendance sheet is the better fit. Many businesses use both. For tracking presence rather than hours, a dedicated attendance sheet is the right tool, and this page focuses on the hours side.
What should an employee timesheet include?
A complete timesheet includes identifying fields, hours data, totals, and an approval trail. The identifying fields are the employee name and ID, the manager, the pay period, and the hourly or project rate. The hours data is a time in, time out, and break for each day, with regular and overtime hours kept in separate columns. The totals are the daily and period sums, with overtime figured at one and one-half times the regular rate for hours over forty in a workweek, plus any PTO or paid-leave hours. The approval trail is the employee signature and the manager approval that make the record official. The two elements small businesses most often leave out, and most need, are a separate overtime column and a manager approval line, because the first keeps payroll accurate and the second makes the record defensible if hours are ever disputed.
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. Every template here is already set up this way, with the formulas in place and a separate setup tab, so you can fill it 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 a fixed, recurring period of 168 hours, and it does not change because you pay biweekly or monthly. 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?
Under federal law, timesheets are part of the wage record and must be kept for a set period. The Department of Labor's recordkeeping rules under the Fair Labor Standards Act require payroll records to be preserved for at least three years, and the underlying records used to compute wages, which include time cards and work and time schedules, for at least two years. Electronic records are permitted as long as they can be produced within seventy-two hours of a Department of Labor request. In practice, many advisors recommend keeping everything for three years to cover the longer window and the statute of limitations for wage claims, and some states require longer. The practical takeaway is simple: do not discard approved timesheets at the end of the pay period or the year. Store them somewhere retrievable and hold them for at least the required period, because they are the record 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.