01
Checks eligibility for each case
26 weeks' continuous service into the qualifying week and AWE at or above the £129 lower earnings limit
For UK employers & bookkeepers, 2026/27 rates
7 reasons to work out SMP, SAP, SPP and ShPP in one place
An employee has handed you a MATB1, or told you they are adopting or becoming a dad. Do they qualify? What is the weekly rate, when does pay start and stop, how much goes on each payslip, and how much can you claim back from HMRC? This calculator answers all of it for every case in one workbook.
- Excel & Google Sheets, no macros
- Example + blank file
- Start-here guide
- One-off price, no subscription
Screens from the included example file. All names and figures are fictional.
100cases
39weeks on every pay schedule
£194.32a week, 2026/27 rate
0macros, add-ons or subscriptions
The list
Why a ready-made calculator beats paper and a blank spreadsheet
02
Works out the qualifying week, the earliest SMP start, weeks 1–6 at 90% of AWE
(rounded up to the penny) and the rate after that
Get the calculator · £10.99 Instant download · Excel & Google Sheets
03
Cases tab for up to 100 SMP, SAP, SPP and ShPP cases
With last day of pay, total pay and the amount you can reclaim (92%, or 109% with Small Employers' Relief)
Pay Schedule
Pick a case to see all 39 weeks and the pay in each calendar month, ready for payroll and printable
AWE Calculator for weekly and monthly pay over the 8-week relevant period
Names the refusal form (SMP1, SAP1 or SPP1) when someone does not qualify
Flags missing or odd dates
Dashboard with pay by month
Who is on leave or coming up, cases by status, pay by type and a "What needs your attention" list
Get the calculator · £10.99 Instant download · stuck? Email us for help
Compare
Three ways to keep these records
| Feature | Paper or notes | A blank spreadsheet | This calculator |
|---|---|---|---|
| Checks eligibility for each case | ✗No | ~ If you build it | ✓ Built in |
| Cases tab for up to 100 SMP, SAP, SPP and ShPP cases | ✗No | ~ If you build it | ✓ Built in |
| Pay Schedule | ✗No | ~ If you build it | ✓ Built in |
| Dashboard with pay by month | ✗No | ~ If you build it | ✓ Built in |
| Cost | Free, plus your time | Free, plus your time | £10.99 once |
What's inside
Everything you download
3 files
- XLSX UK-Maternity-Paternity-Pay-Calculator.xlsxfilled with fictional example data (13 cases) so you can see how it works
- XLSX UK-Maternity-Paternity-Pay-Calculator-BLANK.xlsxan empty copy, ready for your own staff
- PDF Start-here.pdfone-page quick-start guide, including how to open it in Google Sheets
Also included
- Start Here tab with a 3-step plan and a health check
Good to know
- A Health check on the Start Here tab and a Check/Status column on every log flag missing or odd entries
- Dates show as DD/MM/YYYY
Is it right for you?
Made for some, honestly not for others
A good fit if you…
- UK employers, practice managers and bookkeepers under the 2026/27 rules: £194.32 a week or 90% of average weekly earnings if lower, with 90% of AWE for the first 6 weeks of SMP and SAP, and a £129 lower earnings limit
- use Excel or Google Sheets on a computer
- want to pay once, not another subscription
Not for you if you…
- need Apple Numbers or mobile-only editing
- want someone to do the records for you
How it works
Three steps to get going
- 1
Set up once
Business name, tax year and Small Employers' Relief on Settings (2026/27 rates are filled in)
- 2
Work out average weekly earnings on the AWE Calculator
- 3
Add each case on Cases
Print the Pay Schedule for payroll.
Microsoft Excel2010 or newer (Windows & Mac) and Microsoft 365
Google SheetsFree Google account. Upload the .xlsx, then set the locale to United Kingdom
0
No macrosNothing to enable, no add-ons or subscriptions. Not designed for Apple Numbers or mobile-only editing. A computer is recommended
- Instant download
- Example + blank file
- Start-here guide
The offer
Complete UK Maternity & Paternity Pay Calculator
£10.99one-off · no subscription
- Filled with fictional example data (13 cases) (UK-Maternity-Paternity-Pay-Calculator.xlsx)
- An empty copy, ready for your own staff (UK-Maternity-Paternity-Pay-Calculator-BLANK.xlsx)
- One-page quick-start guide, including how to open it in Google Sheets (Start-here.pdf)
- Licensed for use within one business or household
Price includes VAT where applicable — calculated at checkout. Secure checkout by Payhip.
14-day money-back guaranteeIf the template doesn't work for you, email info@phkmedia.co.uk within 14 days of purchase and we'll refund you in full — no hoops.
Questions? Email info@phkmedia.co.uk
Stuck after you buy? We'll help you set it up.
Digital download, nothing is posted. This calculator is a calculation aid, not payroll, tax or legal advice. Terms & licence.
14-day money-back guarantee
If the template doesn't work for you, email info@phkmedia.co.uk within 14 days of purchase and we'll refund you in full — no hoops.
Full policy in our Terms.
FAQ
Questions people ask
Does it run payroll or send anything to HMRC?
No. It works out the figures; you pay them through payroll and claim on your EPS.
Does it cover enhanced (company) maternity pay or KIT days?
No, statutory pay only.
Can several people use it?
Yes, in Google Sheets you can share it with your team.
What if it doesn't work for me?
You're covered by our 14-day money-back guarantee. If the template doesn't work for you, email info@phkmedia.co.uk within 14 days of purchase and we'll refund you in full — no hoops.
What happens after I pay?
This is a digital product. Nothing physical will be shipped. Your download link appears straight after checkout and is also emailed to you.
Can I get help if I'm stuck?
Yes. Message us at info@phkmedia.co.uk and we'll help you set it up.