AutomationDownload
Right to Work Follow-Up Checks
Makes sure every member of staff had a right to work check before they started, and warns you before time-limited permission runs out
£29.00
Download
Holiday Entitlement Tracker
Works out each person's statutory holiday - full-time, part-time, starters, leavers and irregular hours - and tracks what is left
£39.00
How you’ll receive this product
Available to download as soon as your payment is confirmed
This is delivered digitally. As soon as your payment is confirmed you will get a private link to your files on your order page. Keep the link to that page — it is where your purchase lives.
You receive
- Holiday Entitlement Tracker — holiday-entitlement-tracker.zip
- Secure Stripe checkout — we never see your card details
- Your files appear on your order page the moment payment clears
About this product
Holiday is where small employers most often get the sums wrong. This works it out the gov.uk way for everyone.
Workers are entitled to 5.6 weeks' paid holiday a year. For someone on regular hours that is their days a week times 5.6, capped at 28 days - so 16.8 days for three days a week. Someone who starts or leaves during the year gets a share of it, rounded up to the nearest half day. For irregular-hours and part-year workers, it uses the method for leave years from 1 April 2024: 12.07% of the hours worked in each pay period, rounded to the nearest hour, from the hours you log.
Keep 'Taken this year' up to date and 'Left to take' fills itself, with anyone who has taken more than their entitlement reported. Eight weeks before your leave year ends you get one list of everyone with 5 or more days left, so nobody loses holiday by accident. You can also send each person their balance on the 1st of each month.
It is a record-keeping aid, not legal advice, and uses the rules for Great Britain as they stood in September 2026.
Features
- 5.6 weeks per person: days a week x 5.6, capped at 28 days
- Starters and leavers: a share of the year, rounded up to the half day
- Irregular hours: 12.07% of hours worked per pay period, rounded to the nearest hour
- Contractual extra days and carried-over days included
- One list 8 weeks before the year ends of anyone with 5+ days left
- Optional monthly balance email to each person
- Starts in test mode - everything comes to you until you say otherwise
- Keeps a record of every message it sends, so nothing goes twice
- The wording lives on a tab in the sheet, so you change it without touching code
- An Example tab in your own sheet shows a filled-in version, with made-up data
- Runs inside your own Google account. Nothing is sent to us or to anyone else
Product questions
No. It is a reminder and record-keeping aid built around the GB rules it names in the guide. For a decision about a particular member of staff, take advice from Acas or a solicitor.
A Google account - a free Gmail account works, and so does Google Workspace - and Google Sheets in your web browser. Nothing is installed on your computer.
Open a new Google Sheet, go to Extensions > Apps Script, paste in the script from your download and run install once. It builds the tabs, the settings and the daily schedule for you. The setup guide shows every click.
No. Test mode is on when you install it: every message comes to you first, marked [TEST], with a line saying who it would have gone to. You switch test mode off in the Settings tab when you are happy with it.
Google asks you to approve any script that reads your sheet or sends email from your account. Because the script runs in your own account rather than as a published app, Google shows its standard warning screen. The setup guide explains each button.
No. Everything stays inside your own Google account. The script cannot contact any other website, and we never see your sheet or your emails.
It stops at 50 a day unless you change that in Settings. Google's own limit is about 100 recipients a day on a free Gmail account and 1,500 on Google Workspace.
No. You pay once. It runs on Google's free Apps Script service in your own account, so there is nothing to renew.
Reviews
No reviews yet. If you have bought this product, yours could be the first.
You might also like
- Download
Staff Training & Certificate Expiry
Every staff certificate and licence - first aid, forklift, CSCS and more - with a warning before each one needs renewing
£29.00 - Download
Probation & Contract Reminders
Day-one written statements, probation reviews and fixed-term contract end dates - reminded in time, for every new starter
£29.00
