Leave & Absence Management

Free Leave & Holiday Tracker Spreadsheet 2020

December 13, 2019
Calendar

[vc_row][vc_column width=”1/1″][vc_single_image media=”81864″ media_width_percent=”46″ alignment=”center” el_class=”noBorder”][/vc_column][/vc_row][vc_row][vc_column width=”1/1″][vc_raw_html]JTNDZGl2JTIwc3R5bGUlM0QlMjJ0ZXh0LWFsaWduJTNBJTIwY2VudGVyJTNCJTIwYmFja2dyb3VuZCUzQSUyMCUyM2NjZTVmZiUzQiUyMGNvbG9yJTNBJTIwJTIzMDA0MDg1JTNCJTIwcGFkZGluZyUzQSUyMDIwcHglM0IlMjBib3JkZXItcmFkaXVzJTNBJTIwMTBweCUzQiUyMG1hcmdpbi1ib3R0b20lM0ElMjAwJTNCJTIyJTNFJTBBJTNDcCUzRUxvb2tpbmclMjBmb3IlMjB0aGUlMjAyMDIxJTIwdmVyc2lvbiUzRiUyMENsaWNrJTIwJTNDYSUyMGhyZWYlM0QlMjIlMkZibG9nJTJGZnJlZS1sZWF2ZS1ob2xpZGF5LXRyYWNrZXItc3ByZWFkc2hlZXQtMjAyMSUyRiUyMiUzRWhlcmUlM0MlMkZhJTNFJTNDJTJGcCUzRSUwQSUzQyUyRmRpdiUzRQ==[/vc_raw_html][/vc_column][/vc_row][vc_row row_height_percent=”0″ overlay_alpha=”50″ gutter_size=”3″ column_width_percent=”100″ shift_y=”0″ z_index=”0″ css=”.vc_custom_1566916632872{margin-top: 20px !important;}”][vc_column column_width_percent=”100″ gutter_size=”3″ overlay_alpha=”50″ shift_x=”0″ shift_y=”0″ shift_y_down=”0″ z_index=”0″ medium_width=”0″ mobile_width=”0″ width=”1/2″ css=”.vc_custom_1566914645104{padding-right: 10px !important;}”][vc_column_text]Free Leave & Holiday Tracker Excel Template

Trying to keep track of leave and absences can be very hard to achieve. For this reason, we have created a free Excel leave calendar and tracker template in Excel for 2020 which you can sign-up to download on the right hand side.

  • Track different types of leave
  • Track employee leave allowance and how much they have booked off
  • Exclude weekends and bank holidays from consuming the allowance
  • See how much time each person has had off for each type of leave or absence

[/vc_column_text][/vc_column][vc_column column_width_percent=”100″ align_horizontal=”align_center” gutter_size=”3″ overlay_alpha=”50″ shift_x=”0″ shift_y=”0″ shift_y_down=”0″ z_index=”0″ medium_width=”0″ mobile_width=”0″ width=”1/2″][vc_raw_html]JTNDZGl2JTIwc3R5bGUlM0QlMjJ0ZXh0LWFsaWduJTNBJTIwY2VudGVyJTNCJTIwcGFkZGluZyUzQSUyMDQwcHglMjAzMHB4JTIwMzBweCUyMDMwcHglM0JiYWNrZ3JvdW5kJTNBJTIwJTIzM2VjZjhlJTNCYm9yZGVyLXJhZGl1cyUzQSUyMDEwcHglM0IlMjBjb2xvciUzQXdoaXRlJTIxaW1wb3J0YW50JTNCJTIyJTNFJTBBJTNDaDIlMjBzdHlsZSUzRCUyMmNvbG9yJTNBJTIzZmZmJTNCJTIyJTNFU2lnbi11cCUzQyUyRmgyJTNFJTBBJTNDZGl2JTNFJTNDcCUyMHN0eWxlJTNEJTIybWFyZ2luLWJvdHRvbSUzQSUyMDIwcHglM0IlMjIlM0VFbnRlciUyMHlvdXIlMjBlbWFpbCUyMGFkZHJlc3MlMjB0byUyMHJlY2VpdmUlMjB0aGUlMjBkb3dubG9hZCUyMGxpbmsuJTBBJTBBJTNDJTJGcCUzRSUzQyUyRmRpdiUzRSUzQ2Zvcm0lMjBjbGFzcyUzRCUyMmpzLWNtLWZvcm0lMjIlMjBpZCUzRCUyMnN1YkZvcm0lMjIlMjBhY3Rpb24lM0QlMjJodHRwcyUzQSUyRiUyRnd3dy5jcmVhdGVzZW5kLmNvbSUyRnQlMkZzdWJzY3JpYmVlcnJvciUzRmRlc2NyaXB0aW9uJTNEJTIyJTIwbWV0aG9kJTNEJTIycG9zdCUyMiUyMGRhdGEtaWQlM0QlMjIyQkU0RUYzMzJBQTJFMzI1OTZFMzhCNjQwRTkwNTYxOTdBMUJERjVFMzE1NEM1OThCNEQ4NUJFNTA4MjZGNUU4NkQ4MDM2OTlEQjk3REQ4NjNDODE2NkI0OTAyMUQ4RDQ5RjYwRkNGNDU4OUY4MUY3NEZBMTdBOTI3MURDQ0I1QSUyMiUzRSUzQ2RpdiUzRSUzQ2RpdiUzRSUzQ2lucHV0JTIwcGxhY2Vob2xkZXIlM0QlMjJQbGVhc2UlMjBlbnRlciUyMGElMjB2YWxpZCUyMGVtYWlsJTIwYWRkcmVzcyUyMiUyMGF1dG9jb21wbGV0ZSUzRCUyMkVtYWlsJTIyJTIwYXJpYS1sYWJlbCUzRCUyMkVtYWlsJTIyJTIwY2xhc3MlM0QlMjJqcy1jbS1lbWFpbC1pbnB1dCUyMiUyMHN0eWxlJTNEJTIyd2lkdGglM0ExMDAlMjUlM0IlMjBjb2xvciUzQWJsYWNrJTNCJTIwbWFyZ2luLWJvdHRvbSUzQTIwcHglM0IlMjIlMjBpZCUzRCUyMmZpZWxkRW1haWwlMjIlMjBtYXhsZW5ndGglM0QlMjIyMDAlMjIlMjBuYW1lJTNEJTIyY20td3d0amktd3d0amklMjIlMjByZXF1aXJlZCUzRCUyMiUyMiUyMHR5cGUlM0QlMjJlbWFpbCUyMiUzRSUzQyUyRmRpdiUzRSUzQ2RpdiUzRSUzQ2RpdiUzRSUzQ2RpdiUzRSUzQ2lucHV0JTIwYXJpYS1yZXF1aXJlZCUzRCUyMiUyMiUyMGlkJTNEJTIyY20tcHJpdmFjeS1jb25zZW50JTIyJTIwbmFtZSUzRCUyMmNtLXByaXZhY3ktY29uc2VudCUyMiUyMHJlcXVpcmVkJTNEJTIyJTIyJTIwdHlwZSUzRCUyMmNoZWNrYm94JTIyJTNFJTNDbGFiZWwlMjBmb3IlM0QlMjJjbS1wcml2YWN5LWNvbnNlbnQlMjIlM0UlMjZuYnNwJTNCJTIwSSUyMGFncmVlJTIwdG8lMjByZWNlaXZlJTIwZW1haWxzJTIwZnJvbSUyMFNjaGVkdWxlTGVhdmUlM0MlMkZsYWJlbCUzRSUzQyUyRmRpdiUzRSUzQ2lucHV0JTIwaWQlM0QlMjJjbS1wcml2YWN5LWNvbnNlbnQtaGlkZGVuJTIyJTIwbmFtZSUzRCUyMmNtLXByaXZhY3ktY29uc2VudC1oaWRkZW4lMjIlMjB0eXBlJTNEJTIyaGlkZGVuJTIyJTIwdmFsdWUlM0QlMjJ0cnVlJTIyJTNFJTNDJTJGZGl2JTNFJTNDJTJGZGl2JTNFJTNDJTJGZGl2JTNFJTNDYnV0dG9uJTIwc3R5bGUlM0QlMjJib3JkZXItcmFkaXVzJTNBMjBweCUzQiUyMHBhZGRpbmclM0ElMjAxM3B4JTNCJTIwd2lkdGglM0ElMjAxNTdweCUzQiUyMG1hcmdpbiUzQSUyMDAlMjBhdXRvJTNCJTIwY29sb3IlM0ElMjBibGFjayUzQiUyMG1hcmdpbi10b3AlM0EyMHB4JTNCJTIyJTIwdHlwZSUzRCUyMnN1Ym1pdCUyMiUzRURvd25sb2FkJTNDJTJGYnV0dG9uJTNFJTNDJTJGZm9ybSUzRSUzQyUyRmRpdiUzRSUzQyUyRmRpdiUzRSUzQ3NjcmlwdCUyMHR5cGUlM0QlMjJ0ZXh0JTJGamF2YXNjcmlwdCUyMiUyMHNyYyUzRCUyMmh0dHBzJTNBJTJGJTJGanMuY3JlYXRlc2VuZDEuY29tJTJGamF2YXNjcmlwdCUyRmNvcHlwYXN0ZXN1YnNjcmliZWZvcm1sb2dpYy5qcyUyMiUzRSUzQyUyRnNjcmlwdCUzRSUzQ2RpdiUzRQ==[/vc_raw_html][/vc_column][/vc_row][vc_row row_height_percent=”0″ overlay_alpha=”50″ gutter_size=”0″ column_width_percent=”100″ shift_y=”0″ z_index=”0″ css=”.vc_custom_1584787193961{margin-bottom: 0px !important;border-bottom-width: 0px !important;padding-bottom: 0px !important;}”][vc_column column_width_percent=”100″ gutter_size=”0″ override_padding=”yes” column_padding=”0″ overlay_alpha=”50″ shift_x=”0″ shift_y=”0″ shift_y_down=”0″ z_index=”0″ medium_width=”0″ mobile_width=”0″ width=”1/1″ css=”.vc_custom_1584787279364{border-bottom-width: 0px !important;padding-top: 0px !important;padding-bottom: 0px !important;}”][vc_column_text css=”.vc_custom_1584787370890{margin-bottom: 0px !important;border-bottom-width: 0px !important;padding-bottom: 0px !important;}”]

Want more functionality and an easier to use leave booking system?

[/vc_column_text][vc_row_inner][vc_column_inner column_width_percent=”100″ align_horizontal=”align_center” gutter_size=”3″ overlay_alpha=”50″ shift_x=”0″ shift_y=”0″ shift_y_down=”0″ z_index=”0″ medium_width=”0″ mobile_width=”0″ width=”1/1″ css=”.vc_custom_1584787348562{padding-top: 20px !important;}”][vc_button button_color=”color-742106″ size=”btn-lg” radius=”btn-circle” border_animation=”btn-ripple-out” border_width=”0″ link=”url:https%3A%2F%2Fapp.scheduleleave.com%2Fregister|title:START%20YOUR%20FREE%20TRIAL||” el_class=”text-center”]START YOUR FREE TRIAL[/vc_button][vc_column_text]

If you want more advanced functionality as shown below, please try out software free for 1 month:

  • Fully self managed
  • Simple approval of bookings
  • Customisable leave types
  • Definable company year
  • Definable allowance for the company, department or users
  • Definable carry over lieu days
  • Automatic lieu carry over to next year’s allowance
  • Integration with Slack, Outlook, Gcal and other calendars
  • Multi-stage approval
  • Email notifications
  • Desktop / Laptop / Tablet and Mobile support

[/vc_column_text][/vc_column_inner][/vc_row_inner][/vc_column][/vc_row]

Related posts

The image depicts a business meeting where participants are discussing annual leave policies, surrounded by charts and documents outlining holiday entitlements, including statutory leave and unused annual leave. Key topics include the legal responsibilities regarding paid holiday and how employees accrue annual leave within their employment contracts.
Tips

Carry Over Annual Leave: Complete UK Guide

September 24, 2025

Understanding your rights to carry over annual leave can make the difference between losing valuable holiday time and maximizing your work life balance. Many employees across the UK remain unclear about when they can carry forward unused leave, how much they’re legally entitled to keep, and what circumstances trigger automatic carry over rights. Changes to […]

Release
Releases

Release 2.31 – Booking / Audit log improvements

September 2, 2025

Features and Enhancements Booking / Audit log to show deactivated users Users who have been deactivated now show in the audit and booking log, so any queries that arise when a staff member leaves can be checked in the system.   Bug Fixes Registering – Double click now isn’t possible, which was causing an issue […]