Time tracking

Easy to Use Timesheet Templates

Get printable free timesheet templates for your time tracking needs. From hourly to monthly timecards, download a timesheet template for Excel, Google Sheets, PDF and more.

Tracking time has never been easier with QuickBooks Time . It’s a simple way to track employees’ time, not only will the software help you track your employees’ time, but it can also build employee schedules, automate overtime rules, and help you gain overall business insights with real-time reporting and analytics.

Be efficient and on-top of your company’s transactions! Add TSheets to your QuickBooks software to get a complete picture of your business operations.

Try QuickBooks Online Time today!

Daily Timesheet Template

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.

DOWNLOAD: EXCEL

Weekly Timesheet Template

Use this template if you’re tracking your employees’ hours and pay period on a weekly basis. Your employees can add their start and finish times, and record any vacation time, holiday pay or sick leave, before an administrator calculates their work hours, including any applicable overtime. There is also an area to record the date and job code details to assist in keeping things organized. To fill out the timesheet manually, download the PDF or Word document, if you prefer an automated version please download the Excel or Google Sheets versions of this template.

DOWNLOAD: EXCEL

Bi-Weekly Timesheet Template

This template can be used to track your employees’ hours and pay period on an every-other week basis. Probably one of the more popular pay period methods, in this template you can track the total number of hours worked, plus sick leave, holiday, and vacation pay. You can also document the specific date beside day of the week, alongside the billable hours. This bi-weekly template is printable and optimized for Excel and Google Sheets. If you want to print the template, download the PDF or Word document, for an automated version please choose the Excel or Google Sheet versions of the template.

DOWNLOAD: EXCEL

Monthly Timesheet Template

Use this template if you’re tracking your employees’ hours and pay periods on a monthly basis. A great tool for time tracking, this monthly timesheet can be easily filled out by your employees. Keep track of each hour worked, as well as any holiday, vacation, or sick leave pay within the monthly pay period. To track time by hand simply download the PDF or Word document and print out the template. To track time intuitively download the Excel or Google Sheets version of this template and watch the numbers add up!

DOWNLOAD: EXCEL

Semi-Monthly Timesheet Template

This template is great for tracking your employees’ hours and pay periods on a semi-monthly basis. This template is perfect for when a pay period is between the 1st and 15th and from the 16th until the final day of the month. All your employees have to do is indicate the specific month and date, and start filling out hours worked, vacation time, holiday pay, and any applicable overtime hours. As with the previous templates for a manual timesheet please download the Word Document or PDF. Or download the Excel or Google Sheets spreadsheets for an automated formula.

DOWNLOAD: EXCEL

How to Use an Excel Timesheet

A quarter of businesses surveyed use paper or spreadsheets to track employee time, and it’s not hard to understand why. Most of us know how to use Microsoft Excel, and it’s a step up from printed paper timesheets.

There are easier and more accurate ways to track employee hours, but if you’re set on sticking to manual timesheets, it helps to know what you’re looking for. And while we have found that a mobile time clock app is the best time tracking solution, for the spreadsheet enthusiast, we’ve designed a free Excel solution. Once you’ve downloaded it, here’s how to use it.

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

Step 2: Employees can fill in the day, 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.

Pros and Cons: Excel Time Tracking Vs. Automated Time Tracking

Automated timesheets

  • Take payroll processing from hours to minutes.
  • Save 5% on gross payroll costs, on average.
  • Categorize hours by job, shift, client, or employee for easy reporting.
  • Consolidate each day’s time entries.
  • Provide clear and unchangeable audit trails.
  • Store timesheets safely in the cloud.
  • Approve timesheets easily from a computer or mobile device.

Excel spreadsheets

  • Can’t automatically generate reports by job, shift, client, or employee
  • Require multiple time entries per day.
  • Can lead to costly payroll errors.
  • Take hours to process internally or with an accountant.
  • Are vulnerable to external audits and wage and hour disputes.
  • Can be lost on computer hard drives.
  • Must be manually entered into payroll and accounting software

Related Articles

Your privacy

We collect data when you use our website to improve its performance. Doing so also helps us provide a secure, personalized experience. Select 'Accept cookies' to agree or 'Cookies settings' to choose which cookies we use. You can change your preferences anytime by clicking the 'Manage cookies' link in the footer.

Choose your cookie preferences

Some cookies are needed to make our website work and can't be turned off. But we need your consent to use others that are not essential. You can make your choices below and update them at any time using the 'Manage Cookies' link. To find out more, visit our Cookies Policy.

These cookies are necessary for the site to function. They also help us keep your data safe.
These cookies allow us to enhance your experience and remember your preferences, region or country, language, and accessibility options.
These cookies tell us how customers use our website. We study and organize this data to help us optimise our content and provide you with personalised experiences.
These cookies help us provide you with relevant communications and ads in our products and on other sites.

Looking for something else?

Get QuickBooks

Smart features made for your business. We've got you covered.

Firm of the Future

Expert advice and resources for today’s accounting professionals.

QuickBooks Support

Get help with QuickBooks. Find articles, video tutorials, and more.