Statutory Maternity Pay Calculator Excel (UK SMP Calculator 2026)
The Statutory Maternity Pay Calculator Excel is a powerful and easy-to-use SMP calculator UK designed to simplify maternity pay calculations for HR professionals, payroll teams, and employees.
Instead of manually working through complex HMRC rules, this maternity pay calculator allows you to input key information — including earnings, due date, and employment start date — to instantly calculate eligibility and estimated statutory maternity pay.
Why Use a Statutory Maternity Pay Calculator?
Calculating statutory maternity pay (SMP) manually can be time-consuming and prone to error. This Excel-based calculator automates the entire process, ensuring accuracy and compliance with current UK legislation.
It is ideal for:
- HR professionals managing maternity leave
- Payroll teams calculating SMP payments
- Employers ensuring compliance with UK law
- Employees estimating maternity income
Key Features of the SMP Calculator Excel
- Expected Week of Childbirth: Input your due date to anchor all calculations.
- Qualifying Week Calculation: Automatically identifies the 15th week before the due date.
- Length of Service Check: Confirms 26-week continuous employment requirement.
- Average Weekly Earnings Calculation: Calculates earnings over the relevant 8-week period.
- SMP Eligibility Check: Verifies earnings meet the statutory threshold.
- Full SMP Breakdown: Calculates 90% earnings for 6 weeks and statutory rate thereafter.
- Detailed Summary Report: Provides weekly breakdown and total maternity pay.
What Does This Maternity Pay Calculator Include?
This Excel maternity pay calculator automatically calculates:
- Average weekly earnings (AWE)
- SMP eligibility
- Weekly maternity payments
- Total maternity pay over 39 weeks
- Alternative Maternity Allowance scenarios
How the SMP Calculation Works
The calculator follows the official UK SMP structure:
- First 6 weeks: 90% of average weekly earnings
- Next 33 weeks: Statutory rate or 90% of earnings (whichever is lower)
This ensures your calculations are aligned with HMRC requirements and current statutory rates.
Screenshot of the Calculator
Who Is This For?
- HR professionals and consultants
- Small business owners and employers
- Payroll administrators
- Employees planning maternity leave
Benefits of Using This SMP Calculator
- Save time on complex calculations
- Reduce risk of payroll errors
- Ensure compliance with UK maternity pay rules
- Get instant, accurate results
Buy the Statutory Maternity Pay Calculator Excel
Take the guesswork out of maternity pay calculations with this easy-to-use Excel tool.
Instant download. Easy to use. Fully compliant with UK SMP rules.
