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
Staff Rota Template Excel
Weekly staff rota and hours record for Irish employers – breaks, rest, the 48-hour average, under-18 rules, cover and staff cost
€49incl. VAT
Plan the rota, post it, record the hours – and see the problems before an inspector does
10sheets
30staff · 6 weeks
0macros
- 6-week rota with your own shift codes – times, unpaid breaks and paid hours worked out for every person and week
- Cover check per area and time slot (e.g. kitchen evenings, night porter) against the minimum you set – short slots in red
- 11-hour daily rest, weekly rest, 15 / 30-minute breaks and the 48-hour average over the reference period checked per person
- Under-18 rules built in: 8 h a day, 40 h a week, 30-minute break, 12 h rest, no work before 06:00 or after 22:00
- Clock in / clock out record per person and day – the working-time record you keep for 3 years
- Staff cost per week with Sunday premium, paid leave, employer PRSI (Class A, J and M, rates by date), MyFutureFund pension and the minimum wage by age
STARTSETTINGSSHIFTSSTAFFROTAWEEKLY ROTAHOURS RECORDWORKING TIMESTAFF COSTDASHBOARD
Found an error in the template? We'll fix it – or refund you.
A staff rota that checks the Irish working-time rules as you plan
Type a shift code per person and day. The workbook adds up the hours, shows who is on in each area and time slot, flags short rests, missing breaks and under-18 limits, and prints a clean weekly rota for the staff noticeboard.
Most rotas in Irish cafés, hotels, shops and care homes live on a whiteboard or a spreadsheet that only shows names and shift times. Nobody sees that the bartender closing at 1am is back on the lunch shift at 11, that the 17-year-old kitchen porter stayed until 22:35, or that the head chef's average is creeping past 48 hours. And when the WRC asks for working-time records, the rota and the hours actually worked are in two different places.
This workbook puts it together. The ROTA works with your own shift codes and areas, checks cover per time slot and marks problems in red. The WEEKLY ROTA prints one week on A4 for the noticeboard, with the date it was posted. The HOURS RECORD takes the clock-in and clock-out times and the break taken, and the WORKING TIME sheet checks daily and weekly rest, breaks, the 48-hour average and the young-worker rules for each person. STAFF COST adds the Sunday premium, paid leave, employer PRSI at the rates in force each week and the MyFutureFund employer contribution.
Without a template
- Clopening shifts: closing late and opening early with less than 11 hours off
- Under-18s rostered too late, too long or without their 30-minute break
- Nobody knows who is averaging over 48 hours – or which slot is short-staffed next Saturday
- No proper record of the hours actually worked when the WRC asks
With ExcelGrand
- Rest between shifts checked on every line, with the hours shown
- Young-worker limits and breaks checked from the date of birth
- 48-hour average per person over the reference period, plus a cover check per area and time slot
- A clock in / clock out record per day, kept with the rota for 3 years
What's in the file
START
Key figures, quick links and a step-by-step guide.
SETTINGS
Business, the Monday the rota starts, working-time and young-worker rules, minimum wage by age, Sunday and overtime premium, PRSI Class J and M limits, MyFutureFund auto-enrolment rules and an employer PRSI table by date (2026, the €600 threshold announced for 2027 and the October 2027 increase) – each with the source and date checked – plus areas, cover time slots, minimum staff per area and slot, when each week was posted and the 2026–2027 public holidays.
SHIFTS
Your shift codes with start, finish, unpaid break, paid hours, night hours, a break check and the time slots each shift covers – plus day off, requested off, annual leave, public holiday, sick and unpaid leave codes.
STAFF
30 people: role, home area, contract (full-time, part-time, banded hours, if-and-when), contract hours, days, rate, date of birth, age group, minimum wage for that age checked week by week (birthdays during the rota), MyFutureFund status with an eligibility check and hours already worked in the reference period.
ROTA
6 weeks × 30 people with a code per day, colours per area, leave and days off, red for rest, break or under-18 issues, rostered hours per week and a cover check per area and time slot against your minimum.
WEEKLY ROTA
Printable A4 landscape week for the noticeboard – all staff or one area, shift times, hours, staff on duty, short cover slots, shift code legend and the posted date.
HOURS RECORD
Clock in, clock out and break taken per person and day: hours worked, Sunday and night hours, rest before the shift and a check on every line – with filters.
WORKING TIME
Per person: hours per week, average and reference-period average against 48 hours, longest day, shortest rest, weeks without weekly rest, break and under-18 issues – and the issues by type.
STAFF COST
Basic pay, Sunday premium, overtime premium, paid leave, employer PRSI (Class A, J or M per person and week, at the rates in force that week), MyFutureFund employer pension and total cost per person and per week, plus pay by area.
DASHBOARD
Staff, hours, staff cost and issues to check, with charts of hours and cost per week, average weekly hours and issues by type.
Take a look inside
Specifications
Format.xlsx
RequiresExcel 2016+ / Microsoft 365
Sheets10
Capacity30 staff · 6-week rota · 40 shift codes · 6 areas · 20 cover rules
RulesWorking Time Act and young-worker limits checked 16/10/2026; minimum wage 2026, PRSI and MyFutureFund checked 22/10/2026 – all editable
MacrosNone
Who is it for?
- Cafés, restaurants, pubs and hotels
- Shops and small retailers
- Nursing homes, clinics and care services
- Managers who draw up the rota
- Owners and bookkeepers watching staff cost
Frequently asked questions
How do I create a rota in Excel?
List your staff down the side and the days across the top, decide a short code for each shift with its start, finish and unpaid break, and type one code per person per day. This template already does the rest: it counts the paid hours per week, checks rest and breaks, shows who is on in each time slot and prints a weekly rota for the noticeboard.
How do I create a rota for my staff?
Start with the cover you need – how many people per area and time of day – then build shifts around it and give each person their contracted hours and days off. In this workbook you enter the minimum per area and time slot in SETTINGS, and the cover check under the ROTA turns red wherever a slot is short.
How many hours' rest do employees need between shifts in Ireland?
Under the Organisation of Working Time Act, 11 consecutive hours in each 24 hours, plus a weekly rest of 24 consecutive hours after a daily rest. Breaks are 15 minutes after 4½ hours worked and 30 minutes after 6 hours. Workers aged 16 and 17 need 12 hours off between shifts and a 30-minute break after 4½ hours. The workbook checks these on every shift.
What records of working hours must an employer keep in Ireland?
The hours worked each day and week, leave taken, and a copy of the rota or other notice of working time, kept for 3 years and available to a WRC inspector. You can use a clock-in system or the WRC's form OWT1. The HOURS RECORD sheet holds the same information next to the rota.
Do I have to pay extra for Sunday work in Ireland?
Unless Sunday work is already reflected in the pay, employees are due a reasonable allowance, a reasonable pay increase or reasonable paid time off. There is no fixed legal percentage – the Sunday premium in the workbook is an example you set to match your contracts or sectoral agreement.
Can I plan 4-week rotas with it?
Yes. The rota always shows 6 weeks from the Monday you choose; use the weeks you need and leave the rest. Save a copy for each period – the hours before week 1 keep the 48-hour average running across the reference period.
Guide for this template
- Minimum Wage Ireland 2026: Rates by Age and What a Worker Really CostsThe hourly rates from 1 January 2026, what Budget 2027 changes, and a worked example showing why the 40th hour of a minimum-wage week costs the employer €28.18 in pay and PRSI.
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
Staff Rota Template Excel
Weekly staff rota and hours record for Irish employers – breaks, rest, the 48-hour average, under-18 rules, cover and staff cost · €49
Rota template in Excel for Irish employers – weekly staff rota and hours record
A staff rota template in Excel lets a small business plan shifts without rota software or a monthly fee. This rota template is built for Ireland: a 6-week rota with your own shift codes, a weekly rota template to print for the staff noticeboard, and checks on daily rest, weekly rest, breaks and the 48-hour average from the Organisation of Working Time Act.
It also works as a shift schedule and timesheet: record clock in and clock out times, see Sunday and night hours, apply the rules for workers under 18, check the minimum wage by age and follow the weekly staff cost with Sunday premium, employer PRSI and the MyFutureFund pension – for restaurants, hotels, shops, nursing homes and clinics.
Staff Rota Template Excel€49