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.
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.
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.
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.
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.
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.
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.
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.
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.
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:
In our free and downloadable Excel templates, we have included formulas for the following. Formulas multiply the corresponding rates for a dollar amount automatically:
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.
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.
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.
Need a different timesheet solution? There are four more timesheet solutions for your business.
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.
This timesheet 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.
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.
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.