You've probably got one of those payroll tasks sitting open right now, the kind that looks simple until you try to make it fit real people. A Saturday-only barista, a term-time admin assistant, or a zero-hours support worker all raise the same question, how do you calculate holiday entitlement UK without underpaying someone or overbooking leave you never budgeted for?
The good news is that the UK system starts with a fixed legal floor, not a vague guideline. The statutory minimum paid holiday entitlement is 5.6 weeks a year, which is 28 days for someone working five days a week, and Acas says the basic formula is days worked per week multiplied by 5.6 so a 4-day worker gets 22.4 days, a 3-day worker gets 16.8 days, and a 2-day worker gets 11.2 days (Acas holiday entitlement guidance). That's the starting point, and everything else in payroll flows from it.
If the team is carrying stress from understaffed rotas, it's worth dealing with the process as well as the numbers. For some managers, practical support like counselling support for burnout can help them stay on top of a job that often turns into a monthly fire drill when leave balances aren't trusted.
Table of Contents
- Why UK Holiday Entitlement Trips Up Small Businesses
- The Statutory 5.6-Week Baseline for Full-Time Staff
- Pro-Rating for Starters, Leavers and Part-Year Staff
- Calculating Entitlement for Irregular-Hours and Part-Year Workers
- Holiday Pay for Variable Hours and the 52-Week Reference Period
- Spreadsheets Versus a Leave Management Tool
- Putting It All Together and Avoiding Common Mistakes
Why UK Holiday Entitlement Trips Up Small Businesses
A café owner with three full-timers and two Saturday staff usually does not run into leave problems because of bad intent. The trouble starts when entitlement is treated like a favour instead of a legal minimum, then bank holidays, starters, leavers, and uneven patterns get layered on top. At that point, a tidy spreadsheet can turn into a payroll risk.
UK holiday entitlement follows a formula, and that is where small businesses get caught out. Acas sets the statutory floor at 5.6 weeks a year, so the answer depends on how many days someone works, not just whether they are “full-time” or “part-time” (Acas holiday entitlement guidance). A manager who applies one number across the team will usually get the Saturday worker wrong, and the mistake tends to show up when leave is booked or when someone resigns.
A part-time label does not tell you the allowance by itself. A regular 4-day worker is on 22.4 days, a 3-day worker on 16.8 days, and a 2-day worker on 11.2 days under the statutory formula. Once that is clear, the next question is whether bank holidays sit inside the allowance or are added on top.
Practical rule: if you cannot explain the calculation to a new starter in one minute, payroll will probably not enjoy checking it either.
The issue is not only time off. Holiday entitlement affects final pay, sickness cover, temporary cover, and the trust staff place in rota decisions. In a small team, one wrong balance can throw off a whole month, especially when someone is already stretched and may need counselling support for burnout.
The clean way to handle it is as an operational workflow. Identify the worker type first. Apply the right formula next. Then check whether bank holidays are included, whether the person is a starter or leaver, and whether hours-based accrual is needed for irregular patterns. That order keeps the maths in the right place and gives you a repeatable process before you hand the recurring calculation to a leave tool.
The Statutory 5.6-Week Baseline for Full-Time Staff
A full-time worker's holiday entitlement starts with one simple rule. A worker on a regular five-day week gets 28 days of paid leave, because 5.6 weeks multiplied by five days equals 28. That is the statutory floor for someone working five or more days a week, and it is the baseline every later calculation has to sit on (NIDirect holiday entitlements).
Use days worked per week as the multiplier
For fixed working patterns, the calculation is straightforward. Multiply the number of days worked per week by 5.6. That gives 22.4 days for a four-day worker, 16.8 days for a three-day worker, and 11.2 days for a two-day worker. The day pattern does not matter, only the number of days worked each week does (Acas holiday entitlement).
| Days Worked per Week | Statutory Entitlement (days) | Approx. Hours (5.6 × daily hours) |
|---|---|---|
| 5 | 28 | 5.6 × daily hours |
| 4 | 22.4 | 5.6 × daily hours |
| 3 | 16.8 | 5.6 × daily hours |
| 2 | 11.2 | 5.6 × daily hours |
| 1 | 5.6 | 5.6 × daily hours |
The table helps because managers do not need to recalculate the same entitlement every time a rota changes. If someone works fewer days, the allowance drops in proportion. If someone works five or more days, the statutory entitlement stays at 28 days (GOV.UK holiday entitlement calculation method).
Bank holidays sit inside or on top of the allowance
Bank holidays are where small businesses often trip over the contract wording. They are not a separate statutory entitlement, so the contract decides whether they sit inside the 28 days or are added on top. A contract that gives 20 days plus bank holidays can still meet the minimum. A contract that folds bank holidays into a lower allowance is the point where the risk starts.
For part-time staff, the point is sharper. A worker who does not work Mondays should not be treated as though every bank holiday falls neatly on a day they would not have worked anyway. Fairness comes from the contract and the worker's normal pattern, not from what feels convenient for the rota.
A good example is a part-timer who works Tuesday to Thursday. If the bank holiday falls on a Monday, it does not consume one of their usual working days. If the contract uses bank holidays within the allowance, the entitlement still has to be calculated against the worker's actual pattern rather than the full-time default. That is where the spreadsheet starts to show its limits, because the rule is simple but the rota underneath it rarely is.
If you want a practical way to check the pro-rated numbers against the statutory baseline, a holiday entitlement calculator for part-time staff can help once the contract terms and working pattern are entered correctly.
Pro-Rating for Starters, Leavers and Part-Year Staff
A worker doesn't have to be employed for the full leave year to earn leave. GOV.UK says entitlement can be calculated as full-year entitlement multiplied by the proportion of the leave year employed, or by using the months worked shortcut, with fractions rounded up to the nearest half or whole day depending on which is closer (GOV.UK holiday entitlement calculation method). That's the version I'd use in a spreadsheet when a starter or leaver lands mid-year.
Choose the method that matches your leave year
Many employer systems run the leave year from 1 January to 31 December, which makes the full-year proportion method easy to apply internally. If someone starts mid-year, you calculate the fraction of the year they're employed, then apply that fraction to the statutory leave allowance. If someone leaves part-way through the year, you do the same thing in reverse to work out what's been earned and whether anything was taken early.
A rough check can be done by months worked, which is faster when you need a quick answer. It's not as tidy as a proper start-date calculation, but it's practical when you're trying to confirm whether a balance looks sensible before payroll closes.
Operational habit: round the way GOV.UK sets out, then keep the underlying decimal in the record if your payroll system can hold it. That makes the next check much easier.
Part-year staff need special care because their working pattern is built around part of the year, not around a simple reduction in weekly days. A term-time worker who's only active in the weeks they work shouldn't be squeezed into a normal annual pattern. The leave year, the employment period, and the rounded entitlement all need to line up, or the balance becomes unreliable.
The simplest way to keep this under control is to separate three questions. How long was the person employed during the leave year. What was their working pattern. How does your contract treat bank holidays. Once those are answered, the pro-rata figure usually becomes obvious.
If you need a plain worked-through calculator to sanity-check the result, the internal guide on pro-rata holiday calculations is a useful cross-check alongside your payroll process.
Calculating Entitlement for Irregular-Hours and Part-Year Workers
A rota that changes every week needs a different method. A café assistant on fluctuating shifts and a term-time worker both fall outside the neat full-time pattern, so the old days-based spreadsheet soon starts producing odd balances. GOV.UK says irregular-hours and part-year workers accrue entitlement at 12.07% of hours worked in a pay period, and entitlement of 0.5 hours or more must be rounded up to the nearest hour. That is why the calculator on GOV.UK holiday entitlement calculator exists.
Accrue in hours, not days
Irregular-hours workers do not have a fixed weekly pattern. Part-year workers may have fixed hours, but they only work part of the year, for example term-time staff. For both groups, entitlement is built in hours as they work, rather than as a flat days balance based on a notional working week.
That change matters in payroll. A simple weekly formula based on 5.6 weeks can overstate or understate leave once hours rise and fall through the year. These workers sit in a separate calculation route, so the older full-time method is not the safe default.
A workable check is straightforward. Take the hours worked in the pay period, multiply them by 12.07%, and add the result to the running balance. If the result is 0.5 hours or more, round it up to the nearest whole hour, as GOV.UK sets out.
Keep the balance in hours until leave is taken
The cleanest workflow is to keep entitlement in hours while it accrues. That keeps the record tied to the actual hours paid, which matters when shifts move around from week to week or when the business runs on a zero-hours model.
A spreadsheet can show the maths, but it will not fix the contract type. If the worker is set up as the wrong type, the balance will still be wrong.
For irregular-hours and part-year workers, the practical question changes. The issue is not how many days a five-day year might suggest. The question is how many hours were worked, and how many hours of leave those hours generated. That fits flexible staffing better, and it keeps the balance aligned with the rota.
For a worked-through check on holiday pay calculations for variable patterns, see this guide to how to calculate holiday pay in the UK.
Holiday Pay for Variable Hours and the 52-Week Reference Period
Entitlement and pay are related, but they're not the same calculation. Acas says holiday pay for workers with variable pay should use the previous 52 weeks of paid earnings, excluding weeks with no pay, and GOV.UK says entitlement for certain irregular-hours and part-year workers is now calculated using the 12.07% accrual method in hours (Acas holiday pay guidance and GOV.UK leave entitlement rights). That means a worker can accrue leave in one system and be paid for it through another.
Build the pay figure from paid weeks, not calendar weeks
The reference period is based on paid weeks, not just elapsed time. If there are weeks with no pay, those weeks are excluded and earlier paid weeks are used instead, which is why payroll records need to hold enough history to reach the right average. The result is the worker's holiday pay rate for their leave, not their accrued entitlement balance.
The same logic helps explain why July holiday pay can be based on earnings from the previous July period rather than the current month. You're averaging the worker's normal remuneration over the reference period so the holiday pay reflects what they'd usually earn, not just their basic rate.
A short practical rule helps here.
Holiday pay should reflect normal pay patterns, not the cheapest week on the ledger.
For a worker with variable hours, the payable figure is built from the recent paid history, while the entitlement balance is built from hours worked at 12.07%. Those two systems sit side by side. If you mix them together, holiday balances and payslips quickly stop agreeing with each other.
For a payroll team, that's where a manual process gets painful. The calculation has to be right on the entitlement side, right on the pay side, and right on the record-retention side. A useful walkthrough on how to calculate holiday pay in the UK can help when you're reconciling variable earnings with leave taken.
Bank holidays and variable pay still need policy clarity
The 28-day minimum may include bank holidays, depending on the contract. Variable-hours pay doesn't change that contractual question. What changes is the way you calculate the leave balance and the holiday pay value once the person books time off.
That's why the old habit of “just use basic hourly pay” causes trouble. It ignores the reference period, and it creates a mismatch between what the worker earned and what they're paid while on leave.
Spreadsheets Versus a Leave Management Tool
A spreadsheet works for a small team with steady patterns and one person handling payroll from start to finish. Once people start moving between fixed hours, part-time schedules, and irregular shifts, a formula copied into the wrong cell can distort the whole leave balance.
An automated leave system handles the repeating calculation work. It can apply the 5.6-week statutory multiplier, manage 12.07% accrual for irregular-hours staff, and keep the 52-week holiday pay reference period attached to the record instead of buried in someone's inbox. LeaveWizard is one option that calculates leave entitlement, supports pro-rata and accrued leave, and keeps the leave record tied to approvals and balances in one place. For a closer comparison of the trade-offs, see our spreadsheets vs leave management software guide.
Where spreadsheets still work
A spreadsheet can still do the job if you have a tiny team on the same contract, the leave year stays fixed, and nobody changes pattern part way through the year. It gives you control and it costs little to set up. For a very simple workforce, that is often enough.
The weakness appears when the structure changes. If someone moves from full-time to part-time, or from regular hours to irregular hours, the formula has to be changed by hand. That is where errors creep in, especially if the same sheet is also trying to track carry-over, starters, leavers, and variable pay.
Where automation starts to pay for itself
The pressure point usually arrives when one worker's leave balance depends on more than one rule. If you need to pro-rate starters and leavers, accrue hours for irregular work, and refer back to paid weeks for holiday pay, the recurring admin starts to overtake the spreadsheet. At that stage, a leave platform is less about convenience and more about keeping the calculation repeatable.
If you are rechecking the same balances every month, the process has already outgrown the spreadsheet.
A system also gives you an audit trail. That matters because leave and pay are not just totals, they are decisions with dates attached. The record needs to show how the number was reached, not only what the number is.
Putting It All Together and Avoiding Common Mistakes
A worker starts the week on one pattern, changes mid-year, and the payroll sheet still expects last month's formula. That is usually where holiday calculations go wrong. The practical checklist is simple. Confirm the leave year, decide whether bank holidays sit inside or on top of the 28-day cap, classify each worker correctly, apply the right calculation for the contract type, and make sure variable pay is handled through the 52-week reference period where it applies. A full-year worker gets the lower of 28 days or 5.6 × days worked per week, and many small employers still run the leave year from 1 January to 31 December.
The mistakes are predictable because the process is usually inconsistent, not because the law is mysterious. Employers forget to pro-rate starters and leavers, pay irregular-hours workers at basic rate only, use the wrong reference period, or ignore the 0.5-hour rounding rule for accrued leave. Once the worker type is classified correctly, each of those errors becomes much easier to spot before it lands in payroll.
The bigger problem is operational. A spreadsheet can cope with one rule set, but it starts to break when the same team needs starter calculations, leaver adjustments, irregular-hours accrual, and holiday pay based on the right 52-week pay history. In that situation, a leave tool is not a nice extra, it is the cleaner way to run the recurring calculation without relying on someone to remember the exception from last quarter.
LeaveWizard helps small businesses turn holiday entitlement into a repeatable process instead of a monthly spreadsheet scramble. If you want a system that handles leave calculations, approvals, and records in one place, visit LeaveWizard and see how it fits the way your team already works.
