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 Leave | Sick Leave | Leave 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)
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)