Staff holiday planner template

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. Love it!!!! One Thing missing was public holidays which i have added as a Absence Type. How can we reach out for more templates? Answer: The public holidays type is a good idea! You can reach us from our support page!

Answer: Maybe we could add a section for types that don't count as an absence. If more people ask for this we can add it :. Improvement: Added the year above every month to make it a bit clearer. Hi, Is there that I can add in additional leave types for example - exam leave, study leave, certified sick leave, uncertified sick leave?

Answer: Ofcourse, adding an additional leave type is not too tricky. I've added the answer to the FAQ. Hi, Is there a way that I can add in Public Holidays so that they are treated the same as weekends? Answer: Weekends only marked a different colour for convenience and do not affect calculations. You may change the colour of public holidays to match weekends if you like. Fix: Fixed a bug where templates which don't start in January showed the wrong dates when the year ticked over.

In the totals page it need to have a breakdown of totals by code so you can tell straight away how many days annual leave have been had. That's more! LeaveBoard is entirely free for businesses with less than nine employees.

What are you waiting for? Please register for an account and boost your team's efficiency and performance with our web-based HR app and staff holiday planner. Staff Holiday Planner Excel Template LeaveBoard is providing free holiday tracking software that helps you track work time and employee absences.

See who was present, when they are sick or in vacations from any device. And if you want even more details on how the software works, we have a presentation and a walkthrough of each functionality of the staff holiday planner software. Check it out:. With this Excel template you can: Track absences of your employees. If you want to track Sick leave, add an S into the cell for the specific day, when the employee is sick, or V when he or she is in holidays.

Plans Free and paid options available. Help Centre The complete guide to WorkSmarter. Contact Us Our team will be happy to help you. Register For Free Create your free account. Forgot Your Password? Reset your password here. Free Excel Staff Holiday Planner An easy downloadable Excel template for organising employee holidays in and What's the best way to plan staff holidays? How to use our Excel staff holiday planner Using our Excel holiday planner template couldn't be easier.

Need More Features? Show Me. Stay Informed Keep up-to-date with the latest news from WorkSmarter, by following us on social media. Twitter Follow us on Twitter. Facebook Like our Facebook page.

Total employees Total employees Total employees. Holiday entitlement days per year Holiday entitlement days per year Holiday entitlement days per year. Your Details Your name Your name Your name. Your email address Your email address Your email address. Create my Excel Holiday Planner template. WorkSmarter brings HR to the 21 st century.

Get Started. Easy Setup Setup is really simple, and only takes a few minutes. We're Here to Help If you need any assistance or have any questions, our friendly team will be happy to assist.

Your Company's Name. Email Address.