Free timesheet template

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

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.

Using the timesheet template

Step 1: Download the weekly timesheet template of your choice. Please note, values on XLS files can be filled in on your computer. Make a copy of the Google Sheet to fill in values on your computer. If you’re using the Google Sheet online, “Total (Hours)” will need to be added manually based on clock in/out times. Hours this week, rates, and sub-total formulas will calculate automatically. Word and PDF files are read-only, so print a paper copy for best results.

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

Create your own Excel timesheet

Follow this step-by-step guide to build and share a simple Excel timesheet. 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.

ditchTimesheets

Tired of spreadsheets and manually entering time?

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

Government compliance checklist

Before using any timesheet, we highly recommend checking to ensure you and your employees are adhering to any government compliance guidelines necessary. 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 important questions.

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.

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 steps away from their desk for a midday meal. If your employees are still working during their lunch breaks, 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.

With 8.6 million U.S. 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.

TSheets timesheet software is a time tracking solution in the cloud.

Timesheet software

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

TSheets timesheet software is a cloud-based time tracking solution.

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.

Download bi-weekly timesheet templates for Excel, and other formats.

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.

TSheets timesheet software is a cloud-based time tracking solution.

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 makes—free for 14 days!

No credit card required