Free Weekly Timesheet Template for Small Business
Free weekly timesheet templates for small business: single and multiple employees, with breaks, daily, and time log. Excel with overtime formulas.
Weekly Timesheet Templates
Six free weekly timesheet templates for small business: single employee, multiple employees, with breaks, daily, a time log, and a biweekly bridge. Download as Excel with formulas and totals built in, and the FLSA workweek field on the single-employee and team sheets. No signup.
A weekly timesheet is the simplest way to turn hours worked into a correct paycheck, and the templates below are built to be filled in on Friday and run through payroll the same day. If another founder asked me which payroll record to get right first, I would point to this one, because it is the page you pull out when anyone questions their hours.
There are six here, and they cover more than just the standard weekly grid: a single-employee sheet, a multiple-employee team sheet, a version with lunch and break columns, a daily sheet for field crews, a time log for activity tracking, and a biweekly bridge. Each downloads as an Excel file, free and without an email, with the formulas and totals built in.
The weekly rhythm is what makes the format work: overtime is owed for hours over forty in a workweek, so a sheet that covers exactly one week makes the overtime math obvious. For a small business without a payroll department, that clarity matters. The single-employee and team sheets also come with the timekeeping fields required by the Fair Labor Standards Act (FLSA) already in place.
What a Weekly Timesheet Is
A weekly timesheet is a record of the hours an employee worked over a single week, used to calculate pay and to meet federal recordkeeping rules. It lists each day with a time in, time out, and break, separates regular from overtime hours, and totals the week.
Weekly timesheet and weekly time sheet are two spellings of the same document, and a weekly time card template is that same record again, named after the card a punch clock used to stamp.
The weekly format is popular for a practical reason: federal overtime is counted one workweek at a time, so a sheet that matches the workweek shows at a glance when someone passes forty hours. It is an employer-side record, filled in by the employee and approved by a manager before payroll runs, and it forms part of the wage record the Fair Labor Standards Act requires employers to keep.
Which Template Should You Use?
Match the template to your team and how they report hours. If you are unsure, start with the single-employee sheet; each of the other five fits one situation, from a whole team on one page to a biweekly pay cycle.
6 Free Weekly 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, and the single-employee, team, and daily sheets add an overtime column and a setup tab. Every template also opens cleanly in Google Sheets, so you can copy it and share a live version with your team.
Template 1: Weekly Timesheet, Single Employee
The default: a seven-day grid for one hourly employee with time in and out, break, separate regular and overtime columns, a weekly total, and signature and approval lines.
| 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:00 PM | 30 | 8.5 | 0 | =F3+G3 | |
| 4 | Wednesday | 8:00 AM | 5:30 PM | 30 | 9.0 | 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: Weekly Timesheet, Multiple Employees
One row per employee across the week, with regular, overtime, rate, and total pay per person and a team total. For a manager tracking a small team on one sheet.
| A | B | C | D | E | F | G | H | I | J | K | L | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Employee Name | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Regular | Overtime | Rate | Total Pay |
| 2 | Jordan Blake | 8.5 | 8.5 | 8.5 | 8.5 | 8 | 0 | 0 | 40 | 2 | 20 | =I2*K2+J2*K2*1.5 |
| 3 | Sam Rivera | 8 | 8 | 8 | 8 | 8 | 0 | 0 | 40 | 0 | 18 | =I3*K3+J3*K3*1.5 |
| 4 | Taylor Kim | 8 | 8 | 8 | 8 | 4 | 0 | 0 | 36 | 0 | 19 | =I4*K4+J4*K4*1.5 |
| 5 | ||||||||||||
| 6 | ||||||||||||
| 7 | ||||||||||||
| 8 | Team Total | =SUM(I2:I7) | =SUM(J2:J7) | =SUM(L2:L7) |
Template 3: Weekly Timesheet with Breaks
Explicit lunch-out and lunch-in columns with an unpaid meal deduction and a paid short-break column, so break rules are applied correctly. For retail, hospitality, and shift work.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Day | Time In | Lunch Out | Lunch In | Time Out | Unpaid Meal (min) | Paid Break (min) | Total Hrs |
| 2 | Monday | 8:00 AM | 12:00 PM | 12:30 PM | 5:00 PM | 30 | 15 | 8.5 |
| 3 | Tuesday | 8:00 AM | 12:00 PM | 12:30 PM | 5:00 PM | 30 | 15 | 8.5 |
| 4 | Wednesday | 8:00 AM | 12:00 PM | 12:30 PM | 5:00 PM | 30 | 15 | 8.5 |
| 5 | Thursday | 8:00 AM | 12:00 PM | 12:30 PM | 5:00 PM | 30 | 15 | 8.5 |
| 6 | Friday | 8:00 AM | 12:00 PM | 12:30 PM | 4:30 PM | 30 | 15 | 8.0 |
| 7 | Saturday | 0 | ||||||
| 8 | Sunday | 0 | ||||||
| 9 | Weekly Total | =SUM(H2:H8) |
Template 4: Daily Timesheet
A single-day sheet broken out by task or job site, with time in and out, overtime, and notes. For construction and field crews submitting hours at the end of each day.
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Task / Job Site | Time In | Time Out | Break (min) | Regular Hrs | Overtime Hrs | Notes |
| 2 | Site A framing | 7:00 AM | 11:00 AM | 0 | 4.0 | 0 | |
| 3 | Site A framing | 11:30 AM | 3:30 PM | 0 | 4.0 | 0 | After lunch |
| 4 | Site B punch list | 3:45 PM | 5:15 PM | 0 | 1.5 | 0 | |
| 5 | |||||||
| 6 | |||||||
| 7 | Daily Total | =SUM(E2:E6) | =SUM(F2:F6) |
If your crews report daily, the daily sheet is the source record, but the workweek is still the payroll unit. Total each week on its own, since federal overtime is owed on hours over forty in the week rather than on one long day. Keep the signed daily sheets after they roll into the weekly total, because they are part of the underlying records used to compute wages.
The daily sheet above is deliberately generic. Billable work split by client, a whole crew initialing one card, and trades logged against cost codes and job sites each want their own daily layout. On federally funded construction under the Davis-Bacon Act, those daily field sheets are also the documentation behind the weekly certified payroll, which contractors can submit on the optional Department of Labor (DOL) Form WH-347.
Template 5: Time Log Sheet
A chronological log of activities by time, with task, start, end, duration, project, and priority. For freelance billing and project costing. This is a different document from a payroll timesheet.
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Date | Task / Activity | Start | End | Duration (hrs) | Project / Client | Priority |
| 2 | Client kickoff call | 9:00 AM | 9:45 AM | 0.75 | Acme | H | |
| 3 | Draft proposal | 10:00 AM | 12:00 PM | 2.0 | Acme | H | |
| 4 | Email and admin | 1:00 PM | 1:30 PM | 0.5 | Internal | L | |
| 5 | Design review | 2:00 PM | 3:30 PM | 1.5 | Beta Co | M | |
| 6 | |||||||
| 7 | |||||||
| 8 | Total | =SUM(E2:E7) |
Template 6: Biweekly Timesheet
Two weekly grids on separate tabs with a combined pay-period total, keeping each workweek separate so overtime stays correct. For the every-two-weeks payroll cycle. Biweekly is the most common US pay frequency: according to the Bureau of Labor Statistics Current Employment Statistics survey (February 2023), 43.0 percent of private establishments pay every two weeks and 27.0 percent pay weekly.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Day | 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 | Week 1 Total | =SUM(E2:E6) |
The FLSA-Required Fields
Parts of a weekly timesheet are not optional: federal recordkeeping rules call for them. The Fair Labor Standards Act requires employers to record specific information for each non-exempt worker, meaning each employee entitled to overtime, and a good timesheet builds those fields in rather than leaving them out. The four groups below combine the required fields with the approval trail that makes the record defensible.
How to Create a Timesheet
Creating a weekly timesheet comes down to five steps: set up the header, log each day, split regular from overtime hours, total the week, and get it signed. Building one from scratch takes a few minutes, but starting from one of the templates above takes seconds. The steps below are the sequence the templates are built around, whether you use them or build your own.
Printing the Weekly Timesheet
A printable weekly timesheet earns its place when the crew writes hours by hand and the office types them up later, or when you want a signed paper copy in the file. Clear the sample times first so the grid comes out empty, then print one sheet per employee for the week.
In Excel, open File, then Print, and set the scaling to fit the sheet on one page. To keep a PDF instead, open File, then Save As, and choose PDF as the file type. In Google Sheets, open File, then Download, and pick PDF. Whichever route you take, keep the signature and approval lines on the printed page, since that is what turns the sheet into a record.
Breaks, Meals, and Paid Time
Breaks are where a lot of small businesses get timesheets wrong, because the rule is not intuitive. A short break is paid; a real meal is not. Getting this backward either shorts employees on pay or overpays them, and the first creates real liability.
The practical rule for the timesheet: include short rest breaks in hours worked, and deduct only genuine meal periods where the employee is completely off duty. If someone eats at their desk and keeps answering the phone, that meal is not bona fide and must be paid. The weekly timesheet with breaks handles this with separate columns for the unpaid meal and the paid short break.
Weekly Timesheets Without HR
A large company runs time tracking through software and a payroll team that knows the rules. A small business has an owner or a manager collecting weekly sheets and running payroll themselves, which is where honest mistakes on overtime, breaks, and retention happen.
The templates here are built for exactly that situation. They are simple enough to use every week, and the single-employee and team sheets come with the compliance fields already in place, so the record is correct without a specialist.
The habit that pays off most comes after approval: file every signed, approved sheet in the same place and hold onto it. A weekly record you can actually produce is what turns a payroll question into a quick lookup instead of a dispute.
FLSA Compliance and Recordkeeping
Two federal rules sit underneath every weekly timesheet: how overtime is figured, and how long you keep the record. Both are simple once you know them, and both are common small-business mistakes when you do not.
Overtime is owed to non-exempt employees at one and one-half times the regular rate for hours worked over forty in a workweek. It is figured per workweek, not per pay period, and the Department of Labor does not permit averaging hours across two or more weeks. The weekly timesheet makes this natural, since the week is the unit.
Retention, the second rule, applies to timesheets because they are the underlying records used to compute wages.
Because timesheets are wage records, keeping them protects you. Under the Supreme Court decision in Anderson v. Mt. Clemens Pottery Co. (1946), when an employer keeps inadequate time records, an employee can prove unpaid hours by just and reasonable inference, meaning a reasonable estimate backed by evidence. The burden then shifts to the employer to show the precise hours worked or that the estimate is unreasonable.
Common Timesheet Mistakes
Most timesheet problems come down to five recurring mistakes. Each has a simple fix, and the fixes for the first three are built into how the templates are structured.
From Spreadsheet to HR Software
A weekly spreadsheet is the right tool for a small team, and these templates work on their own. The strain shows up when chasing sheets every Friday eats a manager's time, when approvals live in email, and when a lost record becomes a liability in a wage dispute.
When that point arrives, FirstHR gives the paperwork around the weekly sheets one home. Employee profiles keep the roster along with each person's FLSA status and standard hours, document storage holds approved timesheets and wage records where you can retrieve them for the whole retention period, and employees e-sign their handbook and time-off policy acknowledgments in the self-service portal.
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 a weekly timesheet?
A weekly timesheet is one employee's hours for a single workweek, written down so the business can calculate pay correctly and satisfy federal recordkeeping rules. Every day of the week gets a row with a start time, an end time, and any break, and the sheet keeps regular hours apart from overtime before adding up the week. Most versions also name the employee and the manager, note the day and time the workweek begins, and leave room for both of them to sign. Whether you spell it weekly timesheet or weekly time sheet, it is the same document. The weekly layout is popular because overtime is counted per workweek: once hours pass forty in a single week, the extra hours are overtime, so a one-week sheet shows them at a glance. A good weekly timesheet totals the regular, overtime, and overall hours for you, which keeps payroll fast and accurate.
What is the difference between a timesheet and a time log sheet?
A timesheet totals the hours an employee worked in a period so you can run payroll. A time log sheet records what time was spent on, activity by activity, in chronological order. The timesheet answers how many hours to pay for; the time log answers where the time went. A weekly timesheet has one row per day and columns for time in, time out, and totals. A time log has one row per activity with a task description, a start and end, a duration, and often a project or client. Freelancers and contractors use time logs to bill clients and cost projects, and volunteer coordinators use them to track contributed hours. This page includes both: use the weekly timesheet for payroll, and the time log sheet when you need to record activities rather than total hours for pay. They look similar but serve different purposes.
What should a weekly timesheet include?
A complete weekly timesheet includes the fields federal recordkeeping expects plus an approval trail. The identifying fields are the employee name and ID, the company and manager, and the day and time the workweek begins, which the Fair Labor Standards Act specifically calls for. The hours fields are a time in and time out for each day, the hours worked each day, and the total hours for the workweek. The pay fields are the regular hourly rate, the overtime hours and earnings, and the total pay for the week. The approval trail is the employee signature and the manager approval with dates. The two elements small businesses most often leave out, and most need, are the day and time the workweek begins and the manager approval line. The first is a required recordkeeping field, and the second is what makes the timesheet a defensible record if hours are ever disputed.
How do I create a weekly timesheet in Excel?
The fastest way is to start from a template rather than a blank grid. Download one of the Excel weekly timesheets on this page and the columns, formulas, and totals are already built. If you build your own, put the days of the week in the first column, 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; format the cells as time or convert to decimal hours. Use a SUM formula to total the week at the bottom, and keep overtime in its own column so hours over forty are captured separately. Add the employee name, the day and time the workweek begins, the hourly rate, and signature lines. The single-employee weekly 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 and copy it to Google Sheets if you prefer.
Are short breaks paid on a timesheet?
Yes, short breaks are generally paid. The Department of Labor's hours-worked rules treat short rest periods, usually those of twenty minutes or less, as working time, so a ten or fifteen minute coffee break belongs in paid hours and is not subtracted on the timesheet. Meal periods are handled differently. A bona fide meal, typically thirty minutes or longer with the employee completely relieved of duty, is not work time, so it goes unpaid and comes off the day's hours. On the timesheet, that means leaving short rest breaks inside hours worked and deducting only real meal periods. A lunch eaten at the desk while the employee keeps working does not count as bona fide and has to be paid. On this page, the weekly timesheet with breaks gives the unpaid lunch and the paid rest break their own columns, which keeps the calculation right. This is general information, not legal advice.
How is overtime shown on a weekly timesheet?
Overtime belongs in its own column, separate from regular hours, and is owed for hours worked over forty in the workweek at one and one-half times the regular rate. The reason a weekly timesheet keeps overtime separate is that the weekly total is exactly the number overtime depends on: any hours over forty in that week are overtime. So if an employee works forty-five hours in the week, forty go in the regular column and five in the overtime column, and the five are paid at 1.5 times the rate. Some states also require daily overtime; California, for example, requires it for hours over eight in a single day. That is why the templates give you a clear hours breakdown, so you can apply your state rule on top of the federal one. Keeping the overtime column separate on the sheet means payroll can see at a glance what is owed at the premium rate without recalculating.
How long do I have to keep weekly timesheets?
Keep weekly timesheets for at least two years, and three years is the safer habit, because federal law treats them as part of the wage record. The Department of Labor's recordkeeping rules under the Fair Labor Standards Act set two minimums: at least three years for payroll records, and at least two years for the records wages are calculated from, a group that covers time cards as well as work and time schedules. No particular format is required, so storing timesheets electronically works, but if they sit at a central office instead of the worksite, you have seventy-two hours after the Department of Labor gives notice to make them available. Holding everything for three years covers the longer period and also the federal deadline for wage claims, which is two years, or three for a willful violation, and some states require even longer. So do not throw away approved weekly timesheets when a week, a pay period, or a year ends. File them where you can retrieve them and keep 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.
Is weekly or biweekly better for a small business?
Both are common, and the better fit depends on your workforce and your cash flow. In the US, biweekly comes out on top: the Bureau of Labor Statistics Current Employment Statistics survey (February 2023) found about 43 percent of private establishments paying every two weeks and about 27 percent paying weekly. Hourly and shift workers often like weekly pay because their earnings arrive sooner, and it keeps overtime simple, since each sheet is exactly one workweek. Biweekly cuts the number of payroll runs in half, which saves administrative time, but each pay period then holds two workweeks, so overtime still has to be calculated week by week inside the period, never on the eighty-hour total. Plenty of small businesses pay hourly teams weekly at first and move to biweekly as they grow, to lighten the payroll workload. You can run either cycle from this page: there is a weekly template and a biweekly one, and the biweekly file keeps each workweek on its own tab so overtime stays correct.
Make HR the easy part of running your business
Onboarding, e-signatures, training and core HR in one place. Up and running in 5ย minutes.
- 7-day free trial
- No credit card required
- Cancel anytime
