Thank you for showing interest in our template. You can set employees with different starting leave balance. But the template is designed to track 1 year at a time. Hence you need to use separate copy of the template for each year and use the adjustment sheet to enter the starting leave balance of each employees on the beginning of a new year referring the template with previous year's data. Following link contains the procedure to enter starting leave balance of each employee: support.indzara.com/support/solutions/articles/62000214233-steps-to-enter-the-starting-leave-balance-of-each-employee We also have PTO manager template with 3 leave types with the feature to automatically calculate the rollover PTO balance each year. Following is the link to the template for quick reference. indzara.com/product/hr-excel-templates/small-business-paid-time-off-manager/ Best wishes.
How would 2 different types of leave taken on a single day be indicated? How to track with employees of organization in different Unions having different Leave types and availability and separate from Non Union employees?
Thank you for showing interest in our template. Currently, on purchase two different leave types on same day will be highlighted in First come First serve color. That means the color of the first applied leave type. But you can write back to get a new version of the template, which provides dual color for highlighting this scenario. Regarding different entitlement for each employee, you can set the same as described in the below link: support.indzara.com/support/solutions/articles/62000214233-steps-to-enter-the-starting-leave-balance-of-each-employee Best wishes.
Your products & videos are very impressive and helpful - thank you! Is it possible to use this template to track leave in hours instead of days? I see that it has a partial-day function, but I would need the reports to show leave balances in hours. Other than that, this is just what I'm looking for!
Thanks for your feedback. Please try the PTO Calculator template that tracks in hours along with tenure based PTO accrual. indzara.com/2015/09/employee-pto-tracker-free-excel-template/ Please let me know if any questions. Best wishes.
thanks so much for the quick response - I did look at that one before, but I need something with multiple leave types and for multiple employees... is there any chance that you would offer this option in the Employee Leave Manager format in the future, or is it just not feasible?
You are welcome. Yes, the PTO Manager can track only up to 2 leave types but supports multiple employees. Employee Leave Manager can be improved in the future to incorporate Hourly tracking in addition to Day tracking. It would become more complex but should be feasible. I am currently waiting on gathering customer feedback to Employee Leave Manager, before deciding on future enhancements. thanks for your feedback. Best wishes.
Employee Leave Manager can be used to track 1 year at a time. For the next year, you need to take a separate copy of the template and have the holiday setup done again. You can also use a single sheet, if required but it will increase the sheet's size and loading time. If you are using Single sheet for all year, I would like to inform you that there is no limit on number of holidays provided in the Holiday table. You can add the new year's holiday below the old year's holiday. Best wishes.
You are welcome. Thanks for feedback. The file has not been tested for Google sheets. It is not expected to function in Google Sheets. Please try Microsoft Excel. Best wishes.
Already half way through the video and I have to say its one hell of a leave tracker you made. Great work !
Thank you for sharing your valuable feedback.
Best wishes.
Hi I have purchased your product and would like to know how can i carry forward previous year leave balance for the employees.
Thank you for showing interest in our template.
You can set employees with different starting leave balance. But the template is designed to track 1 year at a time. Hence you need to use separate copy of the template for each year and use the adjustment sheet to enter the starting leave balance of each employees on the beginning of a new year referring the template with previous year's data. Following link contains the procedure to enter starting leave balance of each employee:
support.indzara.com/support/solutions/articles/62000214233-steps-to-enter-the-starting-leave-balance-of-each-employee
We also have PTO manager template with 3 leave types with the feature to automatically calculate the rollover PTO balance each year. Following is the link to the template for quick reference.
indzara.com/product/hr-excel-templates/small-business-paid-time-off-manager/
Best wishes.
How would 2 different types of leave taken on a single day be indicated? How to track with employees of organization in different Unions having different Leave types and availability and separate from Non Union employees?
Thank you for showing interest in our template.
Currently, on purchase two different leave types on same day will be highlighted in First come First serve color. That means the color of the first applied leave type. But you can write back to get a new version of the template, which provides dual color for highlighting this scenario.
Regarding different entitlement for each employee, you can set the same as described in the below link:
support.indzara.com/support/solutions/articles/62000214233-steps-to-enter-the-starting-leave-balance-of-each-employee
Best wishes.
Your products & videos are very impressive and helpful - thank you! Is it possible to use this template to track leave in hours instead of days? I see that it has a partial-day function, but I would need the reports to show leave balances in hours. Other than that, this is just what I'm looking for!
Thanks for your feedback.
Please try the PTO Calculator template that tracks in hours along with tenure based PTO accrual.
indzara.com/2015/09/employee-pto-tracker-free-excel-template/
Please let me know if any questions.
Best wishes.
thanks so much for the quick response - I did look at that one before, but I need something with multiple leave types and for multiple employees... is there any chance that you would offer this option in the Employee Leave Manager format in the future, or is it just not feasible?
You are welcome.
Yes, the PTO Manager can track only up to 2 leave types but supports multiple employees.
Employee Leave Manager can be improved in the future to incorporate Hourly tracking in addition to Day tracking. It would become more complex but should be feasible. I am currently waiting on gathering customer feedback to Employee Leave Manager, before deciding on future enhancements.
thanks for your feedback.
Best wishes.
I have a question. What about if the holydays that not count for leave balance are different every year. How do you set up that?
Employee Leave Manager can be used to track 1 year at a time. For the next year, you need to take a separate copy of the template and have the holiday setup done again.
You can also use a single sheet, if required but it will increase the sheet's size and loading time. If you are using Single sheet for all year, I would like to inform you that there is no limit on number of holidays provided in the Holiday table. You can add the new year's holiday below the old year's holiday.
Best wishes.
Thank you for the amazing work. May I know if this template support to use in Google Drive ? Thank you
You are welcome. Thanks for feedback.
The file has not been tested for Google sheets. It is not expected to function in Google Sheets.
Please try Microsoft Excel.
Best wishes.
Kindly can you send me a link for this sheet ?
Thank you for showing interest in our template.
Following is the link to the template:
indzara.com/product/employee-leave-manager/
Best wishes.