Free Timesheet Templates – Printable Excel Timesheet for 2020

Free timesheet templates

Download our free daily, weekly, and monthly timesheet templates to track employee hours, overtime, vacation days, and more.

No credit card required.

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, TSheets by QuickBooks is a cloud-based time tracking solution that you can try for free for two weeks. TSheets 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).

Weekly timesheet - define your date ranges and relevant labels.

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?
Weekly timesheet - define the format of the information.

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/time-off hours
Weekly timesheet - insert the formulas.

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.

Weekly timesheet - lock and protect.
Format and lock cells screenshot

More templates and timesheet options

Need a different timesheet solution? There are more timesheet solutions for your business.

Timesheet software icon.

Timesheet software

TSheets 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 icon.

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 icon.

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 icon.

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.

Experience the efficiency of automated time tracking.

No credit card required.
* The timesheet templates and content on this page have been developed to provide general guidance and estimates. They should not be relied upon to calculate gross pay, deductions, or net pay for your employees or yourself. You should refer to a professional accountant regarding any payroll related inquiries and for submissions to applicable taxation authorities