Monthly Holiday Pay Provision Formula
Learn how a fixed monthly salary, annual holiday entitlement and working pattern are used to estimate a monthly holiday pay provision.
This calculator estimates the salary value associated with paid annual leave for a fixed-salary employee, then spreads that value evenly across 12 months. It can support internal payroll costing and budgeting, but it does not determine a legal holiday pay entitlement.
- 100% Free
- No Sign-Up Required
- Private & Secure
- Mobile Friendly
Monthly Holiday Pay Provision
Where:
Convert monthly salary to annual salary, divide it by estimated annual working days to get a daily rate, multiply by paid holiday days, then divide the annual value across 12 months.
Variables Explained
| Variable | What It Means | Unit |
|---|---|---|
| monthlySalary - Gross monthly salary | The employee's regular gross monthly salary before deductions, excluding irregular pay. | currency |
| workingDaysPerWeek - Working days per week | The employee's usual number of working days in a normal week. | days |
| holidayEntitlementDays - Annual holiday entitlement | The total number of paid holiday days for the year, including bank holidays only when they are part of the stated entitlement. | days |
Step-by-Step Calculation
Calculate annual salary
The regular monthly salary is multiplied by 12 to estimate the annual fixed salary.
annualSalary = monthlySalary * 12
Estimate annual working days
Usual weekly working days are multiplied by 52 weeks.
annualWorkingDays = workingDaysPerWeek * 52
Find the daily holiday pay rate
Annual salary is divided by estimated annual working days to produce a daily salary value.
dailyHolidayPayRate = annualSalary / annualWorkingDays
Calculate the annual holiday pay provision
The daily rate is multiplied by the number of paid holiday days.
annualHolidayPayProvision = dailyHolidayPayRate * holidayEntitlementDays
Spread the provision monthly
The annual holiday value is allocated evenly over 12 months.
monthlyHolidayPayProvision = annualHolidayPayProvision / 12
Example: employee on a £3,000 monthly salary
Annual salary
£3,000 × 12
£36,000
Annual working days
5 × 52
260 days
Daily holiday pay rate
£36,000 ÷ 260
£138.46
Annual holiday pay provision
£138.4615 × 28
£3,876.92
Monthly holiday pay provision
£3,876.9231 ÷ 12
£323.08
Final Result
Estimated monthly holiday pay provision: £323.08. Estimated annual provision: £3,876.92.
Assumptions
- ✓The employee is paid a fixed regular monthly salary throughout the year.
- ✓Annual working days are estimated using 52 weeks.
- ✓The stated holiday entitlement is measured in paid days.
- ✓The annual holiday value is allocated evenly across 12 months.
- ✓Irregular pay, overtime, commission, bonuses and future salary changes are excluded.
Limitations
- !The calculation is a planning estimate and is not payroll, employment law, tax or financial advice.
- !Holiday pay requirements may differ for employees with variable hours, variable pay or non-standard work patterns.
- !The result does not establish whether bank holidays are included in a contractual entitlement.
- !Actual payroll treatment may differ where salary changes, unpaid leave, joiners, leavers or other adjustments apply.
Common Mistakes to Avoid
Entering net pay rather than regular gross salary.
Including overtime, commission or bonuses in a calculator designed for fixed salary only.
Counting bank holidays twice when they are already included in the entered entitlement.
Using calendar days rather than paid working-day entitlement.
Entering a five-day week for an employee who normally works fewer days.
Treating the estimated provision as an extra payment on top of a salaried employee's normal pay.
Related Formulas
Frequently Asked Questions
How is monthly holiday pay provision calculated?
The calculator annualises monthly salary, divides it by estimated annual working days, applies the paid holiday days, and divides the resulting annual value by 12.
What is the formula for a daily holiday pay rate?
The formula is annual salary divided by annual working days, where annual working days equal usual working days per week multiplied by 52.
Why does the formula use 52 weeks?
It uses 52 weeks as a simple annual estimate for a regular working pattern. It is an assumption for budgeting rather than a detailed payroll rule.
Are bank holidays included in the formula?
They are included only when they are included in the holiday entitlement days entered.
Can this formula be used for a part-time employee?
Yes, as an estimate for fixed monthly pay. Enter the employee's actual usual working days per week and their entitlement in paid days.
Ready to calculate your result?
Use the calculator to get instant results with your own inputs.