Complete UK Maternity & Paternity Pay Calculator

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.

Made for 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. It covers Statutory Maternity, Adoption, Paternity and Shared Parental Pay.

▶ Easy Start Here guide included – video tutorial coming to our YouTube channel

Works in Microsoft Excel and Google Sheets, with no macros.

What it does for you

• Checks eligibility for each case: 26 weeks' continuous service into the qualifying week and AWE at or above the £129 lower earnings limit
• 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
• 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, and 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
• Start Here tab with a 3-step plan and a health check

How it works (3 steps)

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, then print the Pay Schedule for payroll

What's included

• UK-Maternity-Paternity-Pay-Calculator.xlsx: filled with fictional example data (13 cases) so you can see how it works
• UK-Maternity-Paternity-Pay-Calculator-BLANK.xlsx: an empty copy, ready for your own staff
• Works in Google Sheets: upload the .xlsx to Google Drive, right-click > Open with > Google Sheets, then File > Save as Google Sheets (tested: formulas and charts kept)
• Start-here.pdf: one-page quick-start guide, including how to open it in Google Sheets

Compatibility

• Microsoft Excel 2010 or newer (Windows & Mac) and Microsoft 365
• Google Sheets (free Google account). Set File > Settings > Locale to United Kingdom for £ and UK dates
• 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

• Cream (pale yellow) cells are for your input. White and grey cells are worked out for you, and the sheets are protected (no password) so formulas are not overwritten by mistake
• A Health check on the Start Here tab and a Check/Status column on every log flag missing or odd entries
• 2026/27 rules checked on GOV.UK (Rates and thresholds for employers 2026 to 2027; Statutory Maternity Pay, Paternity Pay and Adoption Pay employer guides; Get financial help with statutory pay) on 02/11/2026. Rates are on the Settings tab, so you can update them for a new tax year
• Dates show as DD/MM/YYYY
• FAQ: 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
• FAQ: Does it cover enhanced (company) maternity pay or KIT days? No, statutory pay only
• FAQ: Can several people use it? Yes, in Google Sheets you can share it with your team

DISCLAIMER

This calculator is a calculation aid, not payroll, tax or legal advice. Check unusual cases (premature births, backdated pay rises, curtailed leave) with GOV.UK guidance or your payroll adviser. All names and figures in the example file are fictional.

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

AI disclosure: This template and its 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.