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
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.
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.
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.