For managers, HR and payroll

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
Add to basket
Leave & Sick Days Tracker – Dashboard

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 trackedWhere
Certified and uncertified sick daysSICK LEAVE
Statutory sick pay days used and leftSICK LEAVE
Pay at 70% up to the daily capSETTINGS (editable)
Bradford factor per personSICK 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?
Part-timers qualify if they have worked at least 40 hours in the five weeks before the holiday. The tracker records public holidays separately so you can see how each one was granted.
Can leave be carried over?
You can enter a carry-over balance per person. Leave should normally be taken in the leave year or, by agreement, within six months after it.
Our leave year runs April to March – does that work?
Yes. Choose a calendar year or a year starting on 1 April in SETTINGS, and all balances follow.

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.

Answer "how many days have I left?" in seconds

Add the tracker to your basket and continue to payment.

Add to basket