Free timesheet templates
Download our free daily, weekly, and monthly timesheet templates to track employee hours, overtime, vacation days, and more.
Timesheet templates are for tracking employee time. Each template is printable but optimized for Excel. If your business needs a timesheet template with employee hours, overtime, vacation days, and even lunch breaks all included, this is a great solution.
If you’re tired of tracking time by hand, QuickBooks Time is a cloud-based time tracking solution that you can try for free for two weeks. QuickBooks Time tracking is always accurate and makes compliance even easier.
Daily timesheet templates
The daily timesheet includes space for overtime hours, vacation time, lunch breaks, and more. It’s ideal for hourly temporary, part-time, or full-time workers who track time at one or more job sites and submit time daily. Download a template for workers each day for your time tracking and payroll records.
Weekly timesheet templates
The weekly timesheet includes space for overtime hours, vacation time, lunch breaks, and more. It’s ideal for hourly and salaried, full- and part-time employees who need to track time and submit timesheets for payroll weekly. The weekly timesheet has a line for every day of the week, ideal for workers who track time for one shift per day. Download a template for each worker, each week, for your time tracking and payroll records.
Monthly timesheet templates
The monthly timesheet includes space for overtime hours, vacation time, lunch breaks, and more. Hourly and salaried employees, either full- or part-time, who need to track time and submit timesheets for payroll monthly, can use the monthly timesheet. The monthly timesheet has space for 31 time entries, ideal for workers who track time for one shift per day. Download a template for each worker, each month, for your time tracking and payroll records.
Industry-specific timesheet templates
New construction templates
Download this PDF template to track time for construction workers. This weekly timesheet includes space for the worker’s name and ID number (if applicable), the worker’s trade classification, and their manager’s name. The template also includes space for the company name, location or project, job or activity, and the worker’s pay rate and hours worked. This template does not calculate the worker’s deductions, withholdings, or net wages paid. The template has enough space for seven entries (one per day) or many entries per day. Finally, PDFs are read-only. Print the template for the best results.
New volunteer templates
Download this PDF template to track time for volunteers. This weekly timesheet includes space for the volunteer’s name, their supervisor’s name, the organization’s name, and the event or program they’re working for. Use this template to record the hours and overtime your volunteers work. This template doesn’t include space for sick, holiday, or vacation hours. This template has enough space for seven entries (one per day) or many entries per day. Finally, PDFs are read-only. Print the template for the best results.
New hospitality templates
Download this PDF template to track time for hospitality workers. This weekly template includes space for the worker’s name, plus their job or shift, pay rate, regular and overtime hours worked, and the worker’s site name or location. This template does not include calculations for the worker’s deductions, withholdings, or net wages paid. This template has enough space for seven entries (one per day) or many entries per day. Finally, PDFs are read-only. Print the template for the best results.
How to use the timesheet templates
Step 1:
Download the timesheet template of your choice. Please note, you can enter values on XLS files on your computer. You must make a copy of the Google Sheet to fill in values on your computer. Do not request access to the Google Sheets.
On XLS files and Google Sheets, hours this day/week/month, rates, and sub-total formulas will calculate automatically. However, you’ll need to calculate “Total (Hours)” manually, based on clock-in and clock-out times. Word and PDF files are read-only, so print a paper copy and fill in values manually for best results.
Please note: These templates calculate an employee’s basic pay and do not include things like taxes, workman’s comp, or other paycheck deductions.
Step 2:
Fill in your employee’s name, their manager’s name, your company’s name, the date, your employee’s standard pay rate, and your employee’s overtime pay rate.
Step 3:
Employees can fill in the date, job/shift, their times in and out (including breaks), and any remaining hours (overtime, sick, holiday, and vacation).
Step 4:
When it’s time to hand the timesheet in, employees sign the top of the form. Managers can then calculate the employee’s total time for payroll.
How to create your own Excel timesheet
Follow this step-by-step guide to build a simple weekly Excel timesheet to share with your team. Please note that our example shows only basic formulas, as the calculations vary based on your business’ needs.
Step 1: Define your date ranges and relevant labels
Decide what kind of information you want to collect to run payroll. Typically, this starts with an employee’s details and defining the pay period (e.g., weekly, bi-weekly).
Next, define the format for the information you wish to collect. For example:
- Do you want employees to enter their total time worked or enter their clock-in and clock-out times instead?
- Do you want to include breaks, overtime, PTO, or sick time?
Step 2: Insert the formulas
In our free and downloadable Excel templates, we have included formulas for the following. Formulas multiply the corresponding rates for a dollar amount automatically:
- Total hours for the day, week, or month
- Total overtime hours
- Total sick hours
- Total holiday hours
- Total vacation/PTO hours
Step 3: Lock and protect
Once you have formulated the Excel timesheet as desired, be sure to lock it to protect it from unintentional changes. To do this, highlight the cells with formulas, right-click, and select “Format Cell.”
Under the “Protection” tab, check the “Locked” box to protect the formulas.
Timesheet compliance
Before using any timesheet, ensure you and your employees are adhering to any government compliance guidelines. To avoid any trouble—not to mention inaccurate payroll—consider these important questions.
1. Are you paying for unauthorized overtime? If not, you could be noncompliant. If your employees are entitled to overtime pay, you have to pay it, whether you authorized the overtime or not. Failing to pay unauthorized overtime is a Fair Labor Standards Act (FLSA) violation. So even if you have a strict no-overtime policy in place at your company.
Read more about overtime pay laws
2. Are your employees tracking employee breaks? The Fair Labor Standards Act (FLSA) does not require employers to provide meal or rest breaks to employees. Twenty-one out of 50 states mandate meal breaks for employees, nine of which mandate both meal and rest breaks. But only 1 in 5 employees steps away from their desk for a midday meal. If your employees are still working during their lunch breaks, it means you could be violating FLSA regulations and not tracking breaks.
Read more about employee rest and lunch break laws
3. Are your employees misclassified? If you misclassify nonexempt employees, you’re in violation of the Fair Labor Standards Act (FLSA). So what’s the difference between nonexempt and exempt employees? Typically, nonexempt employees are hourly employees, and they’re eligible for overtime pay. If you misclassify your employees and fail to pay overtime, you may owe back pay and penalties.
Read more about federal labor laws
More templates and timesheet options
Need a different timesheet solution? There are four more timesheet solutions for your business.
Timesheet software
QuickBooks Time timesheet software is a cloud-based time tracking solution. Accurately track time against jobs, customers, projects, and more. For a mobile workforce, GPS enables managers to see who’s working where, at any time. Take the guesswork out of employee time tracking.
Time card calculator
This time card calculator is useful for the unique needs of both managers and employees. Employees can calculate their expected pay for the week based on their hours worked. Managers can calculate break times and overtime options.
Bi-weekly timesheet template
This bi-weekly timesheet template for Google Sheets, Adobe Reader (PDF), Microsoft Word, and Microsoft Excel is free and easy to use. The template factors in your employees’ breaks, lunches, and clock-in and clock-out times.
Bi-weekly time card calculator
This bi-weekly time card calculator tracks two weeks of work at a time. Tracking time on a bi-weekly (or semi-monthly) basis means you save time on payroll processing. Spend less time on timesheets and payroll, and give your team more time to perfect processes that grow the business.
Call Sales: 1-888-836-2720
