Excel-Skills.com

Which Excel leave template do you need?

Each leave template does a different job: calculating annual leave due and the leave provision, tracking sick leave against an entitlement, or planning who is on leave when. Many businesses use the annual leave and sick leave templates together, with the leave tracker for planning.

Quick answer: which template should you choose?

  • Annual Leave Template: choose it if you need annual leave accruals, days due and the leave provision for each employee.
  • Sick Leave Template: choose it if you need to track sick leave against each employee's entitlement and leave cycle.
  • Leave Tracker Template: choose it if you need to see who is on leave on which dates, so each department always has enough staff.

Feature comparison

Feature Annual LeaveSick LeaveLeave Tracker
Tracks Annual leave Sick leave Leave dates for planning
Leave balance per employee Accrued days due Remaining days in the cycle –No
Leave provision (value) ✓Yes –No –No
Monthly analysis of leave taken ✓Yes ✓Yes –No
Visual leave calendar with weekends and public holidays –No –No ✓Yes
Rolling forward Each new leave year Never needed Change one date

The templates in detail

Annual Leave Template

Annual leave calculator tracking annual leave of employees.

Best for:
Businesses calculating annual leave accruals, days due and the leave provision for any pay frequency
Not suitable for:
Sick leave (use Sick Leave) or planning who is on leave on which dates (use Leave Tracker)

View the Annual Leave template

Sick Leave Template

Sick leave calculator tracking sick leave of employees.

Best for:
Businesses tracking sick leave against an entitlement and leave cycle per employee
Not suitable for:
Annual (vacation) leave or leave that accrues monthly (use Annual Leave)

View the Sick Leave template

Leave Tracker Template

Leave planning template for when employees go on leave.

Best for:
Managers planning leave so each department always has enough staff
Not suitable for:
Calculating leave balances, accruals or provisions (use Annual Leave)

View the Leave Tracker template

Frequently Asked Questions

Can I track annual leave and sick leave in the same template?
No. They are calculated differently, so we provide separate templates. The Sick Leave template is not suitable for annual leave, and the Annual Leave template does not track sick leave cycles.
Can the annual leave template handle employees who are paid weekly or hourly?
Yes. It accommodates monthly, bi-weekly, weekly, daily and hourly pay periods, with leave accrued on total or worked hours or days.
Does the sick leave template need to be rolled forward each year?
No. It works on a cumulative basis and adjusts each employee's leave cycle automatically, so it never needs to be rolled forward.
What does the leave tracker show?
A visual summary of leave dates for every employee, with weekends and public holidays marked, over a review period of 60 days by default that you can extend or shorten.