Employee holiday chart template

Flexible holiday entitlements can be customised across multiple years, and entitlements can be pro-rated for new employees. A shared online holiday calendar gives your team full visibility in to who's off and when — and syncs with your computer and smartphone calendar, too. Simple notifications keeps management informed , and highlights schedule conflicts automatically — making the approval process much more transparent.

And much more! Why not find out more about our free online staff holiday planner? If you need more advanced staff holiday planning features, don't miss our free online staff holiday planner. Keep up-to-date with the latest news from WorkSmarter, by following us on social media. By using our Excel template service, you agree to our privacy policy.

Our staff leave planner and employee absence tracker features are now completely free to use. We work tirelessly to make HR as easy as possible for companies like yours.

Submit and review holiday requests on an intuitive calendar, with full visibility as to who's off when. Track absenteeism by employees and departments, and understand the causes for repeated absences in your company.

Send announcements to key employees, with an audit trail showing who's read each announcements and when. Keep a record of all the training you provide to your staff, and send reminders and copies on demand.

Store your employee's HR documents securely, safely, and easily online — fully encrypted in secure cloud storage. A library of over fully compliant template documents, covering every scenario from recruitment to termination. Dedicated HR consultants, on hand to help with any HR concerns you may have — live and in real-time. Generate employment contracts for new recruits, and securely issue them for digital signing.

Receive regular updates and practical advice whenever changes are made to UK HR law. Join for free today, and discover why WorkSmarter is the smarter way to work. Setup is really simple, and only takes a few minutes. You'll be guided through the process, step-by-step — and in no time at all you'll have your first employee added to your account. If you need any assistance or have any questions, our friendly team will be happy to assist. Our comprehensive Help Centre is available too, with guides to all aspects of the platform.

Our Holiday Planner and Absence Tracker services are completely free — there's no catch! You can define the year in which the leave planner template will start. Since the template is generated dynamically any year is supported. The leave planner template is ready for the year , and beyond. By default the template contains 12 months 1 year , you can generate a multi year calendar template by entering 24 months 2 years or more.

When tracking absences in hours you simply enter a number into a cell to signify the hours of absence taken. The totals are a sum of the hours.

Tracking absences in days allowances you to specify the type of absence by entering a letter into the cell instead of a number. This option also allows you to track half day absences. Questions about how to adjust the template once it's been downloaded? Check out the FAQ at the bottom of the page. We would love to hear how well our Excel template worked for you and how we could improve.

Also check out our video explaining how to use the template on youtube. A big thank you to our friends at Ruiter for helping with the website design! This is the second year I have downloaded this as an IT outage planning tool for clients.

Many many thanks for this as it fits my needs perfectly with very minor adjustments. You have saved me a lot of work 2 years running now! This is a fantastic tool, is my second year using it. I would love when I add Absence Types I could add more colours.

Is it possible please to add more than employees, especially ? I tried but I could not. Answer: The limit has now been increased to employees. Thanks for using the PTO tracker spreadsheet! Great employee vacation tracker, it makes my life a lot easier. The only thing I need to figure out is how to sort the names alphabetically we adding new employees. Answer: I would recommend sorting your employee names with an online tool before entering them into the tracker template.

This looks excellent! Is it possible to have a conversion to hours taken as annual leave vacation per day; our annual leave works in hours not days as staff work different shift patterns - UK. Thanks :. Answer: There's now a new option to track the absences in hours rather than days. Just select 'Hours' in the 'Track absences in' dropdown box when generating the template. Hopefully that helps cater for your needs! It would be good if we can have week numbers also mentioned in the calendar.

Answer: Week numbers have been above the dates. Thanks for the suggestion. You guys are awesome. To improve this template, I suggest these couple changes. Answer: Thank you so much for your kind words! I will drop you an email when the updated template is ready.

I think the idea of being able to switch out the public holidays is a good idea, although it may be trickier to implement. I will definitely look into it. I think it is important for values on the weekends to still be counted in the off chance that someone does want to mark an absence on a non-working day.

It would be useful in the holiday tracker to have sick days, but not just 1 full day, having a option to input half day sick days. Answer: We're working on a new version that will support this! Fantastic, customized for employees and year. Simple Interface and easy to understand. It's perfect and 10 on Brilliant work guys!!!

Brilliant, perfect employee attendance tracker for our small business, thanks a million. How do I add somebody in half way through the year or delete a leaver without messing up the macros? I have tried to make changes on the first page - January and the last page, totals but it does not follow through? Can you advise? It's a great holiday chart. Adding an employee and removing an employee.

Improvement: That's a good idea. We've added a field for the number of months under the additional options section! This vacation tracker template has been a godsend for tracking all absence for staff, thank you so much. Public holidays for the UK would be nice but can be entered easily. This is the exact reason we have created a completely free staff holiday planner, that you can download and use for the whole of Not only are we giving you this completely free tool, to help you get the most out of it, but we have also provided a quick overview of how it works, along with a few answers to some questions you may have about the spreadsheet.

We have made the spreadsheet as easy as possible to use, meaning there are only a few tasks you need to do to get up and running and a very simple guide on how to use it. Meaning you can start tracking employee absences in a matter of minutes. To begin with, you will need to add details of the different teams in your business, who is the manager of these teams, and then add all the employees who are in these teams. In each tab, there are 3 team areas that you can include a total of 10 employees in.

Once you have done that, now add all the employees who sit in that team to each of the boxes. Remember to add the manager as well, they need to take a vacation too. Make sure that all employees that have been added, are in the same order on every sheet and the final tab. We have made it extremely easy to use our spreadsheet, with only 8 absence types to pick from.

These are:. To add one of these absences to an employee just type the code, that is next to the absence type, into the cell next to the employee. For example, if Employee 5 was off sick on January 20th, in cell V9 you would add S. Just keep adding the different absences for each employee every month to keep track of all your employee absences in In anticipation of any questions about the spreadsheet, we have created a couple below and answered them.

If you have any more questions about the spreadsheet, please email us at enquiries e-days. If you are looking to manage more than 30 employees, you really need to use an online system. Excel holiday planners are very basic and include lots of manual processes, leading to lots of errors. If you want to manage more than 30 employees why not book a demo of our system and see how we can help you.

Why do I keep seeing this error message? To make a change, unprotect the sheet. To help minimise human error we have locked some of the cells. The cookies defines under this category are absolutely essential for the website to function. Hence they are loaded by default irrespective if user consent. Analytics cookies help us understand how our visitors interact with the website.

It helps us understand the number of visitors, where the visitors are coming from, and the pages they navigate. The cookies collect this data and are reported anonymously.

Preference cookies are used to store user preferences to provide them with content that is customized accordingly. This includes the language of the website or the location of the visitor.

Get started. Solutions Our appoach Absence management: Freeing the world of absence headaches.