Free Timesheet Template for 2018
Download our free weekly timesheet template to track employee hours, overtime, vacation days, and more.
Download your preferred format
Need to download a bi-weekly timesheet template? Click here.
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.
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.
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 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.
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.
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 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.
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
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.
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!