Download the Timesheet Calculator Template

Free Excel Timesheet Calculator Template for 2018

Are you looking for an efficient and reliable way to keep track the hours worked and calculate their value. Using this online template you can easily setup your employees, work days, vacations, weekends and hourly rates. This will simplify payroll, keep you organized.

The excel timesheet calculator is available to download online as a weekly, bi-weekly, or monthly online timesheet template to download for free.

Download the template

Thank you for the request.
Many thanks for downloading our template.

How to use the Timesheet Calculator Template?

Timesheet Calculator Template is an Excel file with four sheets: Weekly Time Sheet, Bi-Weekly Time Sheet, Monthly Time Sheet, and Masters. The first three define the most popular pay periods. The fourth one gives you the tools to automatize the entire process.

Note: If you are new to Excel tables, we don't recommend you to work with the masters.

Find below a walktrough of the use and feel of the employee timesheet template

Masters

From Masters sheet, you can setup the template. It contains the general information which will help you automatize the employees' timesheets. It is very important to personalize Master sheet before starting to work with this tool. It has to reflect your business' needs. It contains the following Excel tables:

  • Work Shift Master
  • Employee Master
  • Weekend Master
  • Pay Period Master
  • Public Holiday Master
  • Work Shift Master

In the Work Shift Master, there are all the possible work shifts for your employees. They need to have a unique identifier. In the example above, they are A, B, C, D, but you can use any other text identifier like Morning and Evening. Shifts also have a start time and an end time you can configure as you like. Enter the Start time and End time of the shift in the Begin and End columns in HH: MM format. You can set as many work shifts as you like.

Employee Master

In Employee Master you have to list down the employees and their respective work shifts. Work shifts entered here must match the work shifts defined in the Work Shift Master. Otherwise Weekly, Bi-Weekly and Monthly Sheets won't show correct data. Timesheet Calculator Template comes with some examples of employee names, but you can enter as many as you want.

Weekend Master

The weekend is a two days period of not working days. Still, not all the countries share the same weekend days. Timesheet Calculator Template gives you the possibility to choose the weekends. Weekends are important because you can have special fees for your employees. You can also have different employees with different weekend days. Weekend master gives you the possibility to add as many weekend setups as you need.

Pay Period Master

Pay Period refers to the date when your employee begins to work. This list can include the starting day of every working week, two weeks period, and month. It is a way of making sure you don't miss any important date. Do the setup before you start working with employees sheets. You'll save time and eliminate errors. Introduce valid dates in the Pay Period Starting Date column.

Public Holiday Master

Public Holidays are also important when you manage working hours. They usually involved doing overtime, special fees, and special work shifts. Setup Public Holiday Master according to your business schedule. Introduce valid dates in the Date column. In employee's sheet, Public Holidays will be signalled with a red asterisk.

Weekly Time Sheet

Weekly Time Sheet helps you to manage the amount of work done in a week. It contains data for all the employees in Employee Master. The first thing you need to do is to select an employee from the Employee list.

Each employee has the work shift you setup in Employee Master. Timesheet Calculator Template allows you to see each employee's work shift and working hours in the top right of the table.

The next step is setting the starting of the pay period and the weekend days. Here you'll use the lists setup in Pay Period Master and Weekend Master.

After each step, the template will be updated. This way, all your previous master settings will be in use.

Each day of work has several columns. They are:

  • Day - day of the week (e.g. Monday, Tuesdays etc.)
  • Date - date (beginning with Pay Period Starting)
  • Start - the time an employee starts the shift
  • End - the time an employee ends the shift
  • Time Break - the time (measured in hours) an employee is on a break (e.g. lunch break)
  • Regular Hrs. - the amount of time spent working in a day. The template computes it as the duration of employee's shift minus Time Break.
  • Overtime - the hours worked after the shift has ended
  • Sick - the hours excluded from the work shift due to illness
  • Vacation - the hours excluded from work due to vacation
  • Holiday - the hours excluded from work due to a specific holiday
  • Other - the hours excluded from work due to a specific reason, other than illness, vacation, and holidays.
  • Total Hours - the amount of hours an employee worked in a day.

For each day, you have only a few lines to complete: Time Break, Overtime, Sick, Vacation, Holiday, and Other. Timesheet Calculator Template computes the total amount of hours an employee worked in a day and in a week. It also provides weekly subtotals, like the total of vacation days or the total of overtime.

To have a complete paycheck, you need to enter a fee for each category. Consider regular hours, overtime, sick, vacation, holiday, and other factors. The template will compute the fees generated by each category and the total.

Bi-Weekly Time Sheet

Bi-weekly Time Sheet works similarly with the Weekly Time Sheet. The difference is that this time you manage two weeks of work in a single table.

As with the Weekly Time Sheet, you have to follow the next steps:

  • Choose the employee
  • Choose the starting date for the period of time this table covers
  • Choose the weekend days
  • For each day, enter the amount of working and non-working hours. Consider break time, overtime, sick time, vacation, holidays or other specific events.
  • For each category of working and non-working hours, enter a rate. Consider overtime, sick time, vacation, holidays or other specific events.

Monthly Time Sheet

Monthly Time Sheet starts with the date you provide as a starting pay period date. The table has all the days between the starting day and the ending of the month. For example, if you set Pay Period Starting to 26th of November 2018, the table will display the days between 26th of November and 30th of November. Monthly Time Sheet is designed for those who need to take into account the calendar month. Of course, if you set Pay Period Starting to the first day of the month, you'll have the entire month in the table.

To work with Monthly Time Sheet you have to follow the same steps as with Weekly Time Sheet. As always, setup the masters first to have all the data you need.

Download Timesheet Calculator Template

The Timesheet Calculator Template is a free tool. In order to use it, you need to install a software application able to open and edit an Excel file (.xlsx). Download Timesheet Calculator Template by filling the form on this page.