Employee Leave Tracker / Schedule
Track employee leave using a spreadsheet | Updated 4/11/2022
The free Employee Leave Tracker template on this page allows you to track sick leave, vacation, personal leave, paid and unpaid leave. You can record either full day or half day leave for any number of employees and summarize the results on both a monthly and yearly basis. The template can also be used to create a leave schedule or shift schedule.
Employee Leave Tracker
for Excel
Description
You can use this spreadsheet as both a leave tracker and a leave schedule. If you are entering planned leave, then you'll need to realize that the YearToDate worksheet is counting everything you've entered in the 12 monthly worksheets (not just the leave used up to the current date). In that case, it may be more accurate to call the "Year To Date" worksheet a "Yearly Summary" instead.
