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, QuickBooks Time is a cloud-based time tracking solution that you can try for free for two weeks. QuickBooks 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.
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.
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.
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.
Employees can fill in the date, job/shift, their times in and out (including breaks), and any remaining hours (overtime, sick, holiday, and vacation).
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).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?
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/PTO hours
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.
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.
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.
QuickBooks Time 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
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
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
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.
Important pricing, offers, and disclaimers
*Offer terms30-day free trial First thirty (30) days of subscription to QuickBooks Time, starting from the date of enrollment is free. To continue using QuickBooks Time after your 30-day trial, you’ll be asked to present a valid credit card for authorization, and you’ll be charged on a monthly basis at the then-current fee for the service(s) you’ve selected until you cancel. Each worker is an additional $[8/10]/month depending on your selection of QuickBooks Time Premium or Elite. If you add or remove services, your service fees will be adjusted accordingly. Sales tax may be applied where applicable. To be eligible for this offer you must be a new QuickBooks Time customer and sign up for the monthly plan using the “Try it free for 30 days” option. This offer can’t be combined with any other QuickBooks Time offers. Offer available for a limited time only. To cancel your subscription at any time go to “Account & Billing” in QuickBooks Time and select the “Close Account” tab then “Permanently Close My Account.” You will not receive a prorated refund. Terms, conditions, pricing, special features, and service and support options subject to change without notice. **Product InformationPhone Support: For hours of support and how to contact support, click here. System Requirement: QuickBooks Time requires a computer or a device with a supported Internet browser and an Internet connection (a high-speed connection is recommended). The QuickBooks Time mobile app works with iPhone, iPad, and Android phones and tablets. Devices sold separately; data plan required. Not all features are available on the mobile apps and mobile browser. QuickBooks Time mobile access is included with your QuickBooks Time subscription. Disclaimer: This content is intended to be informative. It should not be relied on for tax, legal, employment, or accounting advice. You should consult your own tax, legal, employment, and accounting advisors before engaging in any transaction.