• Preview of Maternity and Paternity Leave Planner and Pay Calculator (UK)Excel workbook preview

Leave, Absence and Time Tracking

Maternity and Paternity Leave Planner and Pay Calculator (UK)

$17.99 Free XLSX
Excel workbook · 17 KB

3 downloads per free account, no card needed.

Need more than 3? Get all 300 templates for $249 One payment, lifetime access, including every template added later.

Who this is for

An HR or payroll officer who received a MATB1 and must confirm the employee's leave dates and statutory pay in writing within 28 days.

What is inside

  • 8 sample cases: 5 maternity, 3 paternity, with failing service and earnings tests shown
  • Expected week of childbirth and qualifying week worked out from the due date
  • SMP: 6 weeks at 90% of AWE, then GBP 194.32 or 90% for 33 weeks, live formulas
  • SPP for up to 2 weeks and the total statutory pay per case
  • Pay Schedule sheet listing all 39 pay weeks for the employee picked in one cell
  • Rates sheet for 2026 to 2027, and a red flag when leave starts before the earliest date

How to use it: Enter the due date, start of continuous employment, average weekly earnings and planned leave start for each case; update the Rates sheet every April.

Files & formats
  • XLSXuk-maternity-and-paternity-leave-planner-and-pay-calculator.xlsx17 KB

Opens in Microsoft Word or Excel, Google Docs or Sheets and LibreOffice. Delivered instantly from your browser.

Free downloads & full access

Every account gets 3 free downloads. Re-downloading a template you already have does not count. This template on its own is $17.99, and buying it keeps your free downloads for something else. Full access is a one-time $249 for all 300 templates, for life.

Bought with a different email? Open your account and enter your order number.

Licence

Use and adapt the document inside your own organisation or for your own clients. Do not resell or republish the templates themselves.