Less time crunching numbers.

More time chasing leads.

DAYS

HOURS

MINS

SECS

Limited time only

MONDAY

% OFF
for 3 months*

Buy now

Buy now & save

How to create a timesheet in Excel

Q: How do I add my employees to QuickBooks Time from Excel?

It’s easy to upload employee information into QuickBooks Time, should you decide to track time digitally. If your spreadsheet is a CSV file, follow these instructions to get started, then send your employees an invitation, straight to their mobile device, to start tracking time.

Q: Simply smarter team, time & project tracking

Find out more about QuickBooks Time

A step-by-step guide to make a printable or digital timesheet

Excel timesheet

Create an Excel timesheet

FAQs about Excel timesheets

Add Timesheet Forumulas

Tracking employee time in an Excel spreadsheet isn’t the easiest way to keep track of hours worked for payroll. For that, you might check out automated time tracking that integrates seamlessly with your payroll solution. But if you’re still shopping around and wondering if spreadsheets are right for you, download one of our free timesheet templates or learn how to create a timesheet in Excel. If you want to know how to create a timesheet template in excel, the following is a step-by-step guide to assist.

How to create an Excel timesheet

Every business has different needs. They depend on the type of work you do, how many people you employ, and about a hundred other variables. That’s why the first step to making a timesheet in Excel is to identify the categories you’ll need to create to run payroll—and your business—successfully. This timesheet includes space for employees to write down the following for each week.

The date
The job or shift
The times they clock in (before and after lunch breaks)
The times they clock out (before and after lunch)
Their total number of hours
The total number of overtime hours
Their total number of sick hours
Their total number of holiday hours
Their total number of vacation hours

Your timesheet Excel might also include columns for answers to yes or no questions (e.g. Were you injured on the job? Is the project complete?) or space for client signatures.

Once you know which columns or labels you want in your timesheet, it’s time to create the working product. Here’s how to create a timesheet any employee can use.

Step 1: Format your spreadsheet

To create a spreadsheet that’s easy to read, first you need to format. Make all your cells wider, by first widening cell A (ours is set to 14.83). Then right-click on column A, select Copy, highlight columns B through L, right-click again, and select Paste Special, then Formatting.

Time-tracking-how-to-make-a-timesheet-in-Excel-Timesheet

Step 2: Title your timesheet

Type the name of your business into cell A1. Centre the text by width and height, and format the text by font, size (we used size 38), and colour, then bold it. Highlight cells A1 through L1. Select Merge & Centre on the Home toolbar.

Step 3: Add labels to your timesheet

Add labels like EMPLOYEE and MANAGER (with signature and date lines for each), THIS WEEK’S START DATE, STANDARD PAY RATE, and OVERTIME PAY RATE. We used cells A2, A4, F2, F4, K2, K4, E6, H6, and K6.

For THIS WEEK’S START DATE, STANDARD PAY RATE, and OVERTIME PAY RATE, select Wrap Text, so the words don’t take up more than one cell.

In the cells following each label, make a line for employees and managers to write or type over by merging the cells and then applying a Bottom Border (from the borders tool, located on the Home toolbar). Merge cells A7 through L7 to create a small barrier between the next set of labels.

Step 4: Add timesheet labels

In row 8, create labels for each column: DAY, DATE, JOB/SHIFT, TIME IN, TIME OUT, TIME IN, TIME OUT, TOTAL (HOURS), OVERTIME (HOURS), SICK (HOURS), HOLIDAY (HOURS), and VACATION (HOURS). TIME IN and TIME OUT are listed twice to account for lunch breaks.

Fill the row with any colour of your choice, and use the borders tool to put boxes around the column labels. Center and bold the text.

For this weekly timesheet, we’ve labelled the cells below DAY with the days of the week, starting with Monday in cell A9 and ending with Sunday in cell A15. Centre the labels up and down and side to side. Then widen rows 8 through 19 for better readability. Our rows are all about 46.00 high. Apply borders to all cells beneath the row of labels. Then add Thick Box Borders to better divide the table.

Step 5: Print the timesheet

If your plan is to print this template and have employees turn in handwritten timesheet data, you’re almost done!

The last thing you need to do is set up labels for totals. In cells G16, G17, and G18, write HOURS THIS WEEK, RATE, and SUB-TOTAL. In cell K19, write TOTAL. Make these cells whatever colour you like, then centre and bold the text. Use the borders tool to make these sections stand out.

Put some final spit and polish on your document by removing any unnecessary gridlines. Select View and uncheck the box that says Gridlines.

Now you can print copies of this Excel timesheet for employee use.

Highlight everything you want printed (A1 across to L1 and down to row 19).
Click on File > Print > Show Details
Select landscape orientation
Under Print, choose Selection
Under Margins, choose Wide Margins
Check the box that says Scale to fit and click Print

That’s it—you’re done! Don’t want to print? Keep reading.

How to add formulas for automatic calculations

This is where we start making spreadsheet magic. Assuming you haven’t removed or added any days to your spreadsheet, HOURS THIS WEEK should be in cell G16, while TOTAL should be in cell K19.

Step 1: Prepare to add formulas for digital use

Follow instructions from step 5, then highlight cells H16 over L16 and down to row 18. Turn these and cell L19 grey. Now the boxes with your calculations will stand out from the rest of the employee’s timesheet entrees.

Step 2: Click on cell H16 or whatever cell is directly beside the box that says HOURS THIS WEEK. In the formula bar, type in =SUM(H9:H15) and press Enter. This box will now add any numbers entered in the column labelled TOTAL (HOURS).

Step 3: Click on cell I16. In the formula bar, type in =SUM(I9:I15) and press Enter. This box will now add any numbers entered in the column labelled OVERTIME (HOURS).

Step 4: Click on cell J16. In the formula bar, type in =SUM(J9:J15) and press Enter. This box will now add any numbers entered in the column labelled SICK (HOURS).

Step 5: Click on cell K16. In the formula bar, type in =SUM(K9:K15) and press Enter. This box will now add any numbers entered in the column labelled HOLIDAY (HOURS).

Step 6: Click on cell L16. In the formula bar, type in =SUM(L9:L15) and press Enter. This box will now add any numbers entered in the column labelled VACATION (HOURS).

Step 7: In cell H17 (or whatever cell is directly beside RATE), type in the employee’s hourly rate. In the cell beside that, type in the employee’s overtime rate.

If your business provides paid time off (PTO) for sick time, vacations, and holidays, fill J17, K17, and L17 with the employee’s standard hourly rate.

As an example, if your employee makes $10 per hour, the bottom of your spreadsheet will look like this:

Step 8: Now to calculate sub-totals. Click on cell H18 (or whatever cell is directly beside SUB-TOTAL). In the formula bar, type in =SUM(H16*H17) and press Enter. This box will now multiply the employees total hours by their standard pay rate to show how much money they’re owed.*

Step 9: Click on cell I18. In the formula bar, type in =SUM(I16*I17) and press Enter. This box will now multiply the employee’s overtime hours by their overtime pay rate to show how much they’re owed.*

Step 10: Click on cell J18. In the formula bar, type in =SUM(J16*J17) and press Enter. This box will now multiply the employee’s paid sick hours by their standard pay rate to show how much money they’re owed.*

Step 11: Click on cell K18. In the formula bar, type in =SUM(K16*K17) and press Enter. This box will now multiply the employee’s paid holiday hours by their standard pay rate to show how much money they’re owed.*

Step 12: Click on cell L18. In the formula bar, type in =SUM(L16*L17) and press Enter. This box will multiply the employee’s paid vacation hours by their standard pay rate to show how much money they’re owed.*

For example, say an employee worked 42 hours this week. Cell H16 should now say 40, while cell I16 should say 2. If your formulas are correct. H18 will say 400, while I18 will say 30.

*These are basic calculations and do not include things like taxes, workman’s comp, or other paycheck deductions.

Step 13: At last, we get to calculate the total money owed. Select cell L19. In the formula bar, type in =SUM(H18:L18) and press Enter. This box will now add the five sub-totals to show how much money your employee has made total (before bonuses,

Now you know how to make a timesheet in excel. Think that’s simple? Check out our digital timesheet solution with easy integrations to QuickBooks, ADP, and other payroll providers. And keep in mind, paper timesheets are the leading cause of timesheet errors. An automated time tracking tool like QuickBooks Time could save your business time and money every time you run payroll—and grant you more peace of mind.

Need a more sophisticated solution, QuickBooks Time can help

Time tracking for your small business can be made easier with QuickBooks Time. QuickBooks Time can help your small business track time, manage teams and projects and help reduce the time it takes to run payroll.

Employees can clock in and clock out through their mobile (via QuickBooks Workforce, the QuickBooks Time Mobile app) or a fixed location tablet at your shop or building site (via the Time Clock Kiosk)
Managers can create & share rosters with teams in minutes
GPS time tracking can be used to keep track of remote teams.

Get a free 30-day trial to QuickBooks time now.

FAQs about Excel timesheets

What does this Excel timesheet include?

This Excel timesheet has space for workers to record their daily clock in and clock out times. It also has a place for them to record hours for vacation, illness, or holidays. If your company does not provide paid time off, you’ll want employees to still write down when they’re out on vacation or sick, so your records are complete. In the row titled RATE, however, you’ll want to put 0 in cells J17, K17, and L17, so that the employee does not show earnings for those hours.

This timesheet calculator is designed to be efficient. It provides automatically calculated figures, catering to regular hours the employee worked, overtime rate, and time spent at lunch or vacation, etc. And you can do weekly and monthly timesheets.

What doesn't this Excel timesheet include?

This Excel timesheet template is a simple weekly timesheet template for those wondering how to create a monthly timesheet in Excel. It is a basic template for calculating an employee’s pay, prior to deductions like taxes, Social Security, or Medicare.

This excel timesheet template doesn’t include space for any additional income, such as bonuses or commissions.

Additionally, if you bill hours to client projects, you’ll need more robust features than this timesheet offers that will allow you to track hours for specific projects.

More advanced time tracking features like automated location-based tracking prompts (geofencing), scheduling and a time tracking mobile app can help employers save time and money on payroll, cut down common issues like time theft, time card errors, or compliance errors. If this is something your company can benefit from, check out QuickBooks Time tracking software and sign up for a free trial.

Should my salaried employees track time?

Yes, salaried employees should track time. This is more than an issue of good record-keeping. Employers should have two years’ worth of time cards for each employee. Should a dispute over compliance or pay arise, the company is protected from legal recourse. Additionally, salaried employees can use their time cards to their own benefit, be it for making a case for a raise or proving their own attendance.

Tracking time on the job holds everyone accountable so that employers and employees each give and take what is expected for all to benefit.

How do I add my employees to QuickBooks Time from Excel?

Simply smarter team, time & project tracking

- - QuickBooks reserves the right to change pricing, features, support and service at any time. Prices are in AUD and include GST. See our Terms of Service for further information.
  - Pricing: All prices are in AUD and include GST.
  - ProAdvisor Program: Please find the terms of our ProAdvisor program here.
  - 50% off for 3 months: For new subscribers, enjoy a 50% off price subscription on QuickBooks Online Simple Start, QuickBooks Online Essentials or QuickBooks Online Plus for the first 3 months of your subscription (Offer). The discount will applied from the date of your enrolment and will continue for 3 months. From month 4, you will be charged the then current monthly retail price for your subscription. See current prices here. QuickBooks Payroll and QuickBooks Time prices are not eligible for any discount and will be invoiced separately according to your usage on a monthly basis during your subscription. Intuit reserves the right to request information to verify the eligibility of a purchaser of the Offer. Acceptance of such verification information is at the reasonable discretion of Intuit, which may revoke the Offer and impose a monthly cost for the subscription at the then current retail prices, at any time if it considers the purchaser is ineligible for the Offer.
  - 50% off for 12 months: For new subscribers, enjoy a 50% discount off the current monthly retail price for QuickBooks Self-Employed, QuickBooks Online Simple Start, QuickBooks Online Essentials or QuickBooks Online Plus for the first 12 months of your subscription (Offer). The discount will applied from the date of your enrolment and will continue for 12 months. From month 13, you will be charged the then current monthly retail price for your subscription. See current prices here. QuickBooks Payroll and QuickBooks Time prices are not eligible for any discount and will be invoiced separately according to your usage on a monthly basis during your subscription. Intuit reserves the right to request information to verify the eligibility of a purchaser of the Offer. Acceptance of such verification information is at the reasonable discretion of Intuit, which may revoke the Offer and impose a monthly cost for the subscription at the then current retail prices, at any time if it considers the purchaser is ineligible for the Offer.
  - 50% off for 3 months (existing subscribers): For existing QuickBooks subscribers who upgrade to QuickBooks Online Essentials, Plus or Advanced, enjoy a 50% discount off the current monthly retail price for 3 months of your subscription (Offer). The discount will be applied from the date you upgrade in-product and will continue for 3 months. From month 4, you will be charged the then current monthly retail price for your subscription. See current prices here. QuickBooks Payroll and QuickBooks Time services and prices are not eligible for any discount and will be invoiced separately according to your usage on a monthly basis during your subscription. Intuit reserves the right to request information to verify the eligibility of a purchaser of the Offer. Acceptance of such verification information is at the reasonable discretion of Intuit, which may revoke the Offer and impose a monthly cost for the subscription at the then current retail prices, at any time if it considers the purchaser is ineligible for the Offer.
  - Free Trial: First thirty (30) days of subscription to QuickBooks Online, QuickBooks Self-Employed and QuickBooks Payroll (including QuickBooks Advanced Payroll), starting from the date of enrolment, is free. During the free trial, you may pay any number of employees using QuickBooks Payroll free of charge. To continue using QuickBooks after your 30-day trial, you'll be asked to present a valid credit card for authorisation and you'll be charged monthly at the then-current fee for the service(s) you've selected.
  - QuickBooks Payroll powered by Employment Hero: Payroll services are offered by a third party, Employment Hero. QuickBooks Payroll is only accessible via QuickBooks Online subscriptions. You will be charged $6.00 (incl. GST) per month for each ‘active employee’ paid using QuickBooks Payroll. An ‘active employee’ is one who has been paid at least once in the billing month. For Advanced Payroll, there is an additional monthly subscription fee of $10 (incl GST). Pricing, terms and conditions, including service options, are subject to change.
  * Employment Hero was voted the leading payroll solution for SMBs <50 employees (Australian Payroll Association 2021 Payroll Benchmarking Study)
  - Customer support: Call or chat to an expert for QuickBooks Online Accountant, QuickBooks Simple Start, Essential, Plus, and Advanced or use in-product QB Assistant and chat for QuickBooks Self-Employed. You'll also find useful resources in the QuickBooks Community.
  - Compatible Devices: QuickBooks Online, QuickBooks Self-Employed and QuickBooks Payroll require a computer with Internet Explorer 10, Firefox, Chrome, or Safari 6 and an Internet connection (a high-speed connection is recommended). The QuickBooks Online mobile app works with iPhone, iPad, and Android phones and tablets. QuickBooks Online and QuickBooks Payroll are accessible on mobile browsers on iOS, Android, and Blackberry mobile devices. Devices sold separately; data plan required. QuickBooks Payroll cannot be used on the mobile apps. Not all features are available on the mobile apps and mobile browser. QuickBooks Online mobile access is included with your QuickBooks Online subscription at no additional cost. Data access is subject to cellular/internet provider network availability and occasional downtime due to system and server maintenance and events beyond your control. Product registration required.
  - Get paid faster: Get paid 2.5x faster invoicing with PayPal
  * PayPal and QuickBooks customers get paid on average in less than 5 days, which is over 7 days faster than the average for invoices that get paid with other payment methods. Data is for paid invoices that were created in QuickBooks in Australia between 23.05.22 and 23.11.22
  - Tax deductions: Tax deductions not guaranteed due to being subject to user data entry errors. Mileage calculation provided by the Australia Taxation Office - 85 cents per kilometre for the 2023-2024 income year. To a maximum of 5,000 business kilometres per car (Deductions are only applicable to cars)
  - Customer Service Awards: Excellence in Customer Service Award at the CX Australia Awards 2022
  - Multiple file discount: Multiple file discount applies to QuickBooks Australia customers only and valid when signing up for more than one QuickBooks Online subscription in one order. Further terms and conditions available here. Not applicable to QuickBooks Self Employed.
  - Reviews: GetApp, Capterra, Google Play Store, Apple App Store reviews as at date 08/01/24.
  - Cost per day claim (annual): Based on a QuickBooks Simple Start plan at its regular retail price of $313 per year and a 365 day year.
  - Annual Billing: You may pay for your QuickBooks Online subscription on an annual, upfront basis to enjoy a discount on the current fees. If you use QuickBooks Payroll powered by Employment Hero, your payroll costs will still be charged monthly to your nominated payment method in accordance with your usage as set out here. If you cancel your QuickBooks Online subscription within the pre-paid 12 month period, you will not be eligible for a refund, but will retain full access to your QuickBooks Online subscription for the remainder of the 12-month period. Unless cancelled by you prior, your annual subscription will auto-renew on the 12 month anniversary of your sign-up date using the billing details you have given us. Discounts, prices, terms and conditions are subject to change.
  - Over 7 million customers: Based on number of global QB customers (ecosystem) (7.1m) worldwide as of October 2022.
  - Free Onboarding: Applicable to Buy Now subscriptions on QuickBooks Simple Start, Essentials and Plus plans. Not available for QuickBooks Self-Employed.
  - Save Hours: Save up to an average of 29 hours per month with QuickBooks.
  - * Based on a survey conducted by Intuit Australia Pty Ltd in September 2022. Time saving is in comparison to previous accounting method, based on 184 responses from customers that saw time savings.
  - Get access to QuickBooks Tax: ***Access QuickBooks Tax, powered by LodgeiT, by becoming a member of the QuickBooks ProAdvisor Program (it’s free to join). Find out more about the ProAdvisor Program here, including the terms of the QuickBooks Tax offer in the Program here.
  - QuickBooks Time Disclaimers & Offers for Australia: For Important pricing offers and disclaimers with further information, please see here.
  - *Full terms and conditions for access to QuickBooks Tax, powered by LodgeiT as part of the the Proadvisor Program can be found here. QuickBooks reserves the right to change pricing, features, support and service at any time.
  - **Intuit conducted a study involving 56 interviews with accountants and bookkeepers who used Books Review for BAS preparation between March to December 2021 and found that when using Books Review, participants reduced the time spent preparing their clients BAS Reports by around 40%.
  - Our Terms of Service apply to all QuickBooks Online subscriptions. Please review them carefully.

Intuit helps put more money in consumers’ and small businesses’ pockets, saving them time by eliminating work, and ensuring they have confidence in every financial decision they make.