Download our free Excel template to calculate holiday pay including accrued leave, pro-rata calculations, and statutory entitlements. Ensure compliance with UK regulations.
No email required • Instant download • Works with Excel & Google Sheets
Automatically calculate how much holiday employees have earned based on hours worked
Calculate holiday entitlement for part-time staff and new starters with accurate pro-rata formulas
Verify employees receive their full 5.6 weeks statutory holiday entitlement
Track unused holiday that can be carried over to the next holiday year
Account for UK bank holidays in your holiday calculations and entitlements
Specific formulas for calculating part-time worker holiday entitlements accurately
Click the download button above to get the Excel file with built-in formulas
Add employee names, start dates, and contracted hours per week
Record actual hours worked to calculate accurate accrued holiday entitlement
The template automatically calculates entitlement, accrued days, and remaining balance
Update when employees take holiday to maintain accurate remaining balances
While our template is free and useful, TimeTally automates the entire process. No more manual calculations, no more spreadsheet errors.
Holiday accrues automatically based on hours worked. No formulas needed.
Employees see their current holiday balance in real-time.
Staff request holiday. System checks balance and flags conflicts.
