Annual leave tracker for Irish employers – with sick leave and public holidays
Annual leave in Ireland can be earned three ways, part-timers get public holiday benefit on their own terms, and statutory sick pay has its own limits. The tracker keeps all of it in one place, so each employee's balance is worked out the same way every time.
- 40 employees and 400 absence lines
- 22 absence types including half days
- Irish public holidays 2026 and 2027
- Leave year by calendar year or from 1 April
Annual leave the way the Act counts it
ANNUAL LEAVE calculates entitlement under each of the three methods in the Organisation of Working Time Act – the working-week method, hours worked and the monthly method – side by side for each employee. Contract entitlement above the minimum is pro-rated for starters and leavers.
Workbook facts
- START
- SETTINGS
- PUBLIC HOLIDAYS
- EMPLOYEES
- ABSENCE LOG
- ANNUAL LEAVE
- SICK LEAVE
- TEAM PLANNER
- LEAVE CALENDAR
- DASHBOARD
- File format
- .xlsx
- Tabs
- 10
- Capacity
- 40 employees · 400 absence lines · 22 absence types · 6 teams
- Requires
- Excel 2016+ / Microsoft 365
- Macros
- None
Sick days and statutory sick pay
| What is tracked | Where |
|---|---|
| Certified and uncertified sick days | SICK LEAVE |
| Statutory sick pay days used and left | SICK LEAVE |
| Pay at 70% up to the daily cap | SETTINGS (editable) |
| Bradford factor per person | SICK LEAVE |
The 2026 settings give 5 days of statutory sick pay at 70% of pay up to €110 a day. All three values are editable.
What the tabs look like
Before you buy
Do part-time staff get public holiday benefit?
Can leave be carried over?
Our leave year runs April to March – does that work?
Planning the team
TEAM PLANNER shows any month for everyone or for one of up to six teams, with a code per day, so overlapping holidays are easy to spot before they are approved. LEAVE CALENDAR lays out one employee's whole leave year on twelve rows with monthly totals.