Number of employeesĪny number of employees can be specified. The default template will contain a full year from the start date specified.įor example, if your annual leave year matches the financial year from April to March, select April as the starting month. Custom start dateĪny start date can be chosen for your leave tracker.

Our template is designed to be useful for the majority of teams with the default options but there are a number of customisation options. It's a sum of the 'Absences this month' column across all months. The 'Absence count' field shows the sum of all absences while counting half days as 0.5 appropriately. If tracking absences in days, the last tab of the template contains the totals of all absences for each employee as well as a breakdown by absence type.

There is also an extra custom leave types which you can rename and use as you need. Half days can be recorded by using the H1 and H2 codes, these count as 0.5 in the totals. Leave types are provided by default when using the 'Track absences in Days' option. Track absences in HoursĮnter the number of absent hours into the cell relating to the day of the absence. For example, in case of sick leave, enter S into the cell.Īll the absence types and their codes are shown in a handy key alongside the calendar month. Track absences in DaysĪbsences are recorded by inserting the relevant code into the cell for the day. The template differs slightly based on the 'Track absences in' option selected in the customisations. Yearly totals are displayed in a separate tab called Totals.

Monthly totals are displayed at the end of each row for each employee. BasicsĮnter your employee names into the name cells on the first sheet, the names on the other sheets will pull through from the first sheet. Start a 30 day free trial to give it a try today.īack to the Excel template, here's what you need to know. Greatly reducing queries, manager input and holiday clashes within the team.Ībsences are still approved by a manager via the holiday request system. Our managed system enables employees to book absences and view planned holidays on a self-serve basis. If you're looking to reduce time spent on absence management, you may also consider our staff holiday booking system.

Monthly rota template excel