Pro UK HR & Absence Bundle

Who is off next week, whose sickness is becoming a pattern, what holiday pay is your casual worker owed, and whose forklift ticket runs out this month? Five HR trackers answer those questions without HR software.

Made for small UK employers and office, practice or shop managers looking after 2 to 200 staff. Each tool takes about 5 to 15 minutes to set up. Not payroll software and not legal or HR advice.

▶ Easy Start Here guide for every tool included – video tutorials coming to our YouTube channel

What you get: 5 PHKSheets tools (5 spreadsheets) in one download. Spreadsheets work in Microsoft Excel and Google Sheets, with no macros.

Save 40% compared with buying the 5 tools separately at our current listing prices (£63.95 separately, £37.99 for the bundle, both before VAT).

What it does for you

• PTO & Leave Tracker: annual leave balances, UK bank holidays and a team calendar
• Bradford Factor Absence Tracker: sickness absence log with Bradford scores and return-to-work tracking
• Holiday Pay Calculator: 12.07% accrual for irregular hours and the 52-week average holiday pay check
• Training Matrix: every employee x every course, with certificate expiry dates in red, amber and green
• Right to Work Check Register: manual, share code and digital ID checks with follow-up dates for time-limited permission

How it works (3 steps)

1. Open each example file to see how it works, then use the -BLANK copies.
2. Enter your staff list once per tool (names, start dates, work pattern).
3. Check each Dashboard weekly: leave balances, Bradford scores, expiring training and right to work follow-ups.

What's included

• Start-here.pdf: open this first. It lists every file, says which one to open first, and includes each tool's one-page guide
• 1-PTO-Leave-and-Bradford-Absence.zip: PTO & Leave Tracker (example .xlsx with fictional data, -BLANK .xlsx, Start-here guide); Bradford Factor Absence Tracker (example .xlsx with fictional data, -BLANK .xlsx, Start-here guide)
• 2-Holiday-Pay-Calculator.zip: Holiday Pay Calculator (example .xlsx with fictional data, -BLANK .xlsx, Start-here guide)
• 3-Training-Matrix.zip: Training Matrix (example .xlsx with fictional data, -BLANK .xlsx, Start-here guide)
• 4-Right-to-Work-Register.zip: Right to Work Check Register (example .xlsx with fictional data, -BLANK .xlsx, Start-here guide)
• Why zips? To keep the download tidy, the 5 tools come as Start-here.pdf plus 4 clearly named .zip files. Each zip opens to one folder per tool

Compatibility

• Spreadsheets: Microsoft Excel 2010 or newer (Windows & Mac) and Microsoft 365, and Google Sheets (free Google account). To use Google Sheets: upload the .xlsx to Google Drive, right-click > Open with > Google Sheets, then File > Save as Google Sheets. Set File > Settings > Locale to United Kingdom for £ and UK dates
• Spreadsheets are not designed for Apple Numbers or mobile-only editing. A computer is recommended
• No macros, add-ons or subscriptions

Instant download

This is a digital product. Nothing physical will be shipped. Your download link appears straight after checkout and is also emailed to you. Stuck or have a question? Email info@phkmedia.co.uk and I'll gladly help you set it up.

Good to know

• Every example file uses fictional names and figures
• Each spreadsheet has built-in checks that flag missing or odd entries
• FAQ: Do the tools share one staff list? No. Each file is separate, so you enter staff in each one you use (copy and paste works)
• FAQ: Does it work out statutory sick pay? No. It tracks absence and Bradford scores; check SSP with your payroll
• FAQ: Is it a subscription? No. You pay once and keep the files

DISCLAIMER

These templates are record-keeping aids, not legal or HR advice. Check gov.uk, Acas or a qualified adviser for your situation. All names and figures in the example files are fictional.

Licence: Licensed for use within one business. Please do not resell, share or redistribute the files.

AI disclosure: These templates and their listing images were designed by PHK MEDIA LTD with the help of AI tools. All formulas were tested and the files were reviewed and finalised by the seller.

© PHK MEDIA LTD

Licence: Licensed for use within one business or household. You may edit and print the files for that business. You may not resell, share or upload them for others.