Service Charge Budget Excel
Budget, levies, arrears & sinking fund for OMCs
- Budget in the 9 categories of the MUD Act, vs actual
- Levy per unit from the lease share or floor area
- Arrears aged 0–30 / 31–60 / 61–90 / 90+ days
One-off purchase – no subscription
Annual Leave Tracker Excel
Annual leave, bank holidays and sick leave for Irish employers – statutory entitlement, balances, sick pay, team planner and calendar
€49incl. VAT
Every day off in one place – and the right entitlement for full-time, part-time and variable-hours staff
10sheets
40employees
0macros
- Statutory annual leave worked out the Irish way – the greatest of the 3 Working Time Act methods – next to contract leave
- Irish public holidays 2026–2027 incl. St Brigid's Day, with the extra day of leave, the pay due or a day-off reminder for each holiday benefit
- Statutory sick pay: 5 days, 70%, €110 cap, 13 weeks' service – used, left and paid per employee, only on certified days and never past 31 December
- Absence log with 22 leave types: certified and uncertified sick leave, force majeure, parent's leave, domestic violence leave…
- Team planner and 12-month calendar with cover per team and red days when you are short
- Carry-over deadline, 2-week block, limits for force majeure and other leave, and an optional Bradford factor
STARTSETTINGSPUBLIC HOLIDAYSEMPLOYEESABSENCE LOGANNUAL LEAVESICK LEAVETEAM PLANNERLEAVE CALENDARDASHBOARD
Found an error in the template? We'll fix it – or refund you.
An annual leave tracker built on Irish rules – not on a UK template
Enter your staff and their working days, then log every absence on one line. The workbook works out each person's statutory and contract leave, public holiday benefit, sick pay and balance – and shows who is off, day by day.
Most leave spreadsheets assume everyone works Monday to Friday and gets 20 days. In a real Irish small business you have part-timers on three days, weekend staff, someone on variable hours, people who work bank holidays and a seasonal hire who left in August. Their entitlement is the greatest of three methods in the Organisation of Working Time Act, each public holiday needs a benefit, and certified sick days now come with statutory sick pay.
This workbook does that work for you. ABSENCE LOG counts working days on each employee's own pattern, without public holidays and closure days. ANNUAL LEAVE compares the three statutory methods with the contract, adds carried-over leave and public holiday days, and shows what is taken, booked, pending and left. SICK LEAVE tracks statutory sick pay and the limits for force majeure, domestic violence and medical care leave, and the TEAM PLANNER warns you when a team falls below its minimum cover.
Without a template
- Part-time and variable-hours entitlements worked out by guesswork
- Bank holidays falling on a day off forgotten – or paid twice
- Nobody knows how many statutory sick days someone has used this year
- Two people from the same team booked off the same week
With ExcelGrand
- The 3 statutory methods side by side, with the winning one highlighted
- Public holiday benefit per employee: extra day of leave, the pay due or a reminder of the day off
- Statutory sick pay days, amount and days left per calendar year
- Cover per team, day by day, against your minimum – short days in red
What's in the file
START
Key figures, quick links and a step-by-step guide.
SETTINGS
Company, leave year (calendar or 1 April), records-as-at date, every statutory figure (Working Time Act methods, carry-over, sick pay, force majeure, part-time 40 hours, Bradford bands) with the date checked, 22 absence types and 6 teams with minimum cover.
PUBLIC HOLIDAYS
Irish public holidays 2026 and 2027 incl. St Brigid's Day, next holiday, staff off or due a benefit, company closure days (deduct from leave or not) and the rules in short.
EMPLOYEES
Start and end date, contract, working days Monday–Sunday, hours, weekly pay, contract leave, carry-over, public holiday option and status.
ABSENCE LOG
One line per absence with type, dates, half days, status, medical cert and hours off for partial days – working days, hours, statutory sick pay days and pay, and checks (overlaps, limits, balance, 13 weeks, cert pending, spells past 31 December).
ANNUAL LEAVE
Hours counted, the 3 statutory methods, contract pro rata, public holiday days, carry-over, taken, booked, pending, remaining, status (incl. public holiday days off still to give), carry-over deadline, 2-week block, PH pay and leavers' untaken days – plus hours per month.
SICK LEAVE
Certified and uncertified sick days, SSP used, left and paid, force majeure (12 and 36 months), domestic violence and medical care leave, family leave and the Bradford factor.
TEAM PLANNER
Any month for all staff or one team, codes per day, and people at work per team against the minimum.
LEAVE CALENDAR
One employee's leave year on 12 rows, totals per month and the list of their absences.
DASHBOARD
Leave left, requests to decide, sick days and sick pay, with four charts.
Take a look inside
Specifications
Format.xlsx
RequiresExcel 2016+ / Microsoft 365
Sheets10
Capacity40 employees · 400 absence lines · 22 absence types · 6 teams
RulesWorking Time Act (3 methods), sick pay 5 days at 70% up to €110 – all editable
MacrosNone
Who is it for?
- Small business owners
- HR & office managers
- Payroll & bookkeepers
- Shops, cafés & hospitality
- Trades & yards with shift staff
Frequently asked questions
How is annual leave calculated in Ireland?
Under the Organisation of Working Time Act there are three methods and the employee gets whichever gives the most: 4 working weeks if they worked at least 1,365 hours in the leave year, 1/3 of a working week for each month with at least 117 hours, or 8% of the hours worked (up to 4 working weeks). A 'working week' is the days the person normally works, so a 3-day week gives up to 12 days. The ANNUAL LEAVE sheet calculates all three for every employee and highlights the winner.
How many sick days do you get in Ireland in 2026?
5 statutory sick days a year, at 70% of normal pay up to €110 a day, for certified days after 13 weeks' service (Citizens Information). The workbook counts them per calendar year and stops at 31 December; the figures are editable in SETTINGS.
Do part-time workers get bank holidays?
Yes, once they have worked at least 40 hours in the 5 weeks ending the day before the public holiday; full-time staff qualify straight away. If the benefit is an extra day's pay, a holiday on a day they don't work is paid at one-fifth of their weekly pay (never more than a normal day's pay), and a holiday they work on a normal working day at a normal day's pay. The workbook adds the extra day of leave, shows the pay due or reminds you of the day off, per employee. The 40 hours are estimated from contract hours, so check borderline cases.
Can annual leave be carried over to next year?
Leave should be taken in the leave year, or by agreement within 6 months of it; anything longer has to be agreed. Leave missed because of illness can be carried for up to 15 months. The workbook shows the carry-over deadline and flags carried days that were not used in time.
What is an acceptable Bradford score?
There is no legal standard – each employer sets its own trigger points (51, 201 and 401 are common examples, editable in SETTINGS). The Bradford factor is optional here and should only start a supportive conversation: never use it to penalise statutory leave or absence linked to disability or pregnancy.
Does it work for a leave year from April to March?
Yes. Choose the month the leave year starts in SETTINGS (1 = January, 4 = the statutory leave year from 1 April). Statutory sick pay always runs per calendar year, and the public holidays for 2026 and 2027 are already filled in.
Guide for this template
- Public Holidays Ireland 2026 and 2027: Dates and Who Gets the Day Off or Extra PayAll 10 dates for 2026 and 2027, the four benefits an employer can give, the 40-hour rule for part-timers – and a worked example of one Christmas weekend with three very different answers.
- Statutory Sick Pay Ireland 2026: How Many Days, the Rate, the €110 Cap and the Records to KeepWhy it is still 5 days in 2026, how to work out the daily rate, a worked example with two employees, how Illness Benefit takes over – and the records the Sick Leave Act requires.
Other templates you may need
Fire Safety Register Excel
Fire safety log book with due-date alerts for Irish buildings
- Weekly fire alarm test log with call point rotation
- Monthly checks of fire doors, escape routes and emergency lighting
- Service due dates for extinguishers, alarm and other equipment
Risk Assessment Template Excel
Hazard register, 5×5 risk matrix, action plan & Safety Statement checklist
- Hazard register by area with who is at risk and existing controls
- 5×5 likelihood × severity scoring with colour-coded ratings
- Action plan with owner, target date from the rating and overdue alerts
Annual Leave Tracker Excel
Annual leave, bank holidays and sick leave for Irish employers – statutory entitlement, balances, sick pay, team planner and calendar · €49
Annual leave tracker Excel template for Irish employers – leave planner, sick leave and absence tracker
An annual leave tracker in Excel lets a small business see every employee's holiday entitlement, what has been taken and booked, and what is left – without HR software or a subscription. This leave tracker Excel template follows Irish rules: the three Working Time Act methods for full-time, part-time and variable-hours staff, public holiday benefit and carried-over leave.
It is also an absence tracker and staff holiday planner: log sick leave, force majeure, parent's leave or unpaid leave, see statutory sick pay used and left, plan cover per team in the month view and keep an optional Bradford factor score – all in one workbook with the 2026 and 2027 bank holidays included.
Annual Leave Tracker Excel€49