← All prebuilt solutions
Payroll & HR

Irregular-Hours Holiday Pay Calculator

12.07% accrual, rolled-up holiday pay, balances, holiday pay rates and leavers – for irregular-hours and part-year workers

£20

Secure checkout. Your file is ready in your client portal as soon as payment clears.

Irregular-Hours Holiday Pay Calculator

Overview

For leave years starting on or after 1 April 2024, irregular-hours and part-year workers build up holiday at 12.07% of the hours they actually work, and employers may pay rolled-up holiday pay instead. Holiday pay must also include regular overtime, commission and allowances, averaged over the previous 52 paid weeks. This calculator records hours and pay for up to 40 workers, accrues their holiday, values holiday taken at the correct average rate, and works out what a leaver is owed.

Price
£20
Who it’s for
Payroll & HR
Works with
Microsoft Excel for Windows and Mac
Buy now

See how it works

A walk through the main sheets

The sheets you will use most, in the order you will use them – shown with the sample data every workbook comes with.

Step 1

Hours & Pay

Hours and pay each period, with holiday accrued. What you do: one row per worker per pay period.

Hours & Pay
Leave Taken

Step 2

Leave Taken

Holiday taken and its value at the 52-week average rate. What you do: enter each period of leave.

Step 3

Balances

Accrued, taken and remaining holiday per worker, and leaver pay. What you do: nothing to enter.

Balances

Step 4

Who it is for

Made for people like you

  • Example – text
  • Employers with zero-hours or casual staff – Holiday worked out the way the law now requires.
  • Hospitality, care, events and seasonal work – Part-year and term-time workers handled correctly.
  • Payroll and HR teams – Clear balances to share with staff and a leaver calculation.

Quick start

Up and running in minutes

  1. Example – text
  1. Settings – Enter your business name and the leave year start date.
  2. Workers – List each worker, their start date and whether you accrue holiday or pay it rolled-up.
  3. Hours & Pay – Each pay period, enter hours worked and pay (basic and variable).
  4. Leave Taken – Record holiday taken in hours.
  5. Balances – See holiday accrued, taken and left, the average holiday rate and any leaver payment.

Key features

  • Up to 40 workers and 1,500 pay periods, with holiday accrued at 12.07% of hours worked.
  • Choice of accrual or rolled-up holiday pay (12.07% added to each payment).
  • Holiday pay rate averaged over the last 52 paid weeks, including regular overtime and commission.
  • Balances, leave taken and the payment due to leavers.

What’s included

  • Dashboard – Holiday at a glance
  • Settings – Leave year and accrual
  • Workers – Who and how
  • Hours & Pay – Hours and pay from payroll
  • Leave Taken – Holiday taken
  • Balances – Accrued, taken and owed
  • Guide – How to use this workbook

How buying works

Your file is only released to your client portal once payment has cleared.

1

Click Buy now

You are taken to our secure checkout.

2

Pay securely

Checkout takes a minute and you get a receipt by email.

3

Download your file

Your file is ready in your client portal as soon as payment clears, and we email you your invoice with a link to the portal.

Explore the range

Need it tailored to your business?

We can adapt any prebuilt solution or build something bespoke, with a lifetime bug-free guarantee.

Part of AML Finance Group

Need an accountant too?

Our sister firm, AML Accountancy Solutions, is an award-winning accountancy practice helping businesses and individuals across the UK with their accounts, tax, bookkeeping and payroll.

Visit AML Accountancy Solutions