JavaScript isn't enabled in your browser. Please enable and reload.

Free Timesheet Template for 2018

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

TSheets offers free templates for Microsoft Excel, Word, Google Sheets, and PDF.

Updated March 2018

Using the Timesheet Template

The timesheet template is for tracking employee time. The template is printable and optimized for Excel. If your business is in need of 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 manually, TSheets by QuickBooks provides an online time tracking solution that you can try for free for two weeks. TSheets is the epitome of accurate, and it makes compliance even easier.

Step 1: Fill in your employee's name, their manager, your company's name, the week's start date, your employee's standard pay rate, and your employee's overtime pay rate.

Step 2: Employees can fill in the date, job/shift, job/shift code, their time in/out (including breaks), and any remaining hours (overtime, sick, holiday, and vacation).

Step 3: 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.

Create Your Own Excel Timesheet

Follow this step-by-step guide, to build a simple 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 in order 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 just enter their total time worked or enter their clock in and 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 template, we have included formulas for the following, which multiply with the corresponding rate for a dollar amount automatically:

  • Total hours for the week
  • Total hours of overtime
  • Total hours of sick time
  • 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 up to protect it from unwanted and unintentional changes.

To do this, just highlight the cells with formulas, right-click, and select “Format Cell.”

Under the “Protection” tab, make sure the “Locked” box is checked to protect the formulas.

Tired of creating spreadsheets and manually entering time?

Try TSheets and start saving 2-11% on gross payroll costs!

Try It Free For 14 Days

Government Compliance Checklist

Before using any timesheet, we highly recommend checking to ensure you and your employees are adhering to government compliance guidelines relating to time theft. Here are three of the most common laws being broken, though there are many to be aware of. To avoid any trouble (and paying out too much on payroll), consider these three important questions.

1. Are you paying for unauthorized overtime?

If not, you could be noncompliant. If your employees are entitled to overtime payments, you have to pay up, whether the overtime was authorized 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, employees must be paid for those hours, even if they aren't complying with your policy.

The ultimate guide to unauthorized overtime and the FLSA.

2. Are your employees tracking breaks properly?

The 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 step away from their desk for a midday meal. If your employees are still working during their lunch break, it means your team is in violation of the FLSA and not tracking breaks properly.

Take a break and read more about employee meal and rest breaks by state.

3. Are your employees misclassified?

With 8.6 million US workers misclassified, there's a chance you could have misclassified employees at your company as well. If you misclassify nonexempt employees, you're in violation of the FLSA. So what's the difference between nonexempt and exempt employees? Nonexempt employees are most commonly hourly employees, and they are expected to be paid for overtime hours. If you misclassify your employees and fail to pay overtime, you may owe back pay and penalties.

Can you name all seven deadly sins of the FLSA? Let's find out.


More Templates and Timesheet Options

Interested in handy timesheet solutions from TSheets by QuickBooks? Here are four more timesheet solutions for you to try.

Timesheet Software

TSheets timesheet software is a cloud-based time tracking solution. Accurately track time against employee, job, or materials. For mobile workforces, GPS enables you to see who's working where, at any time. No more guesswork. Precision timesheets.

Time Card Calculator

This time card calculator is useful for the unique needs of both managers and employees. Employees can easily calculate their expected pay for the week based on their hours worked. Managers can calculate break times and overtime options to

Bi-weekly Timesheet Template

This bi-weekly timesheet template for Google Spreadsheets, Adobe Reader (PDF), Microsoft Word, and Microsoft Excel is free and easy to use. The template factors in your employees' breaks, lunches, and in/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 your payroll department saves time on processing. Submitting timesheets and reviewing documents less frequently gives your team more time to perfect processes that grow the business.

Experience the difference automated time tracking from TSheets by QuickBooks makes — free for 14 days!

Tired of using paper timesheets?

Try TSheets time tracking free for 14 days!
Your time is valuable — don't waste it.