Plan pregnancy and the first year in Excel: baby budget, maternity and paternity pay, Child Benefit, childcare, birth registration deadlines and checklists.
Expecting parents in England, Wales, Scotland and Northern Ireland: employees, self-employed (Maternity Allowance to check), married, living together or single parent. No Excel skills needed: mint cells are yours, everything else is calculated.
One file to get ready for your baby without forgetting anything: deadlines dated from your own due date, purchases and your gift list, your leave and an estimate of your income during leave, childcare compared, and a month-by-month budget up to your baby's first birthday, with SMP, paternity pay, Child Benefit and registration deadlines.
The New Baby Planner (UK) is an Excel workbook in pounds, with no macros, for Excel 2016 or later. It comes with a sample file filled in by a fictitious couple (Priya and Owen, first baby) so you can see every calculation before you type your own dates.
The deadlines from your due date (tell your employer, MATB1, SMP notice, register the birth, claim Child Benefit…), SMP week by week from your average weekly earnings at the official 2026 to 2027 rates (weeks after the rates' review date, 4 Apr 2027, are flagged so you check the new rate on GOV.UK), Statutory Paternity Pay, childcare with the Tax-Free Childcare top-up, what's left to buy, and what the baby changes in your budget, month by month. In the sample, SMP comes to £9,760.56 over 39 weeks before tax at the 2026 to 2027 rates: a calculation on fictitious data, not a promise.
Built in Excel with functions that Google Sheets also supports (no macros, no XLOOKUP, LET, LAMBDA or dynamic arrays). If you import it into Google Sheets, check charts, colours and drop-down lists after import. Tested with Excel, no macros: recalculated with 0 formula errors, on the sample and on an empty workbook, and checked against an independent calculation of the sample.
Fictitious sample data. Written with AI assistance. Not legal, tax or financial advice, and not medical advice: for your health and your baby's, follow your midwife or GP; for your rights, your employer and GOV.UK have the final word.
Personal and family use · resale, redistribution and publication of the content prohibited
Sold through Gumroad, which collects payment and issues the invoice. Consumers: 14-day withdrawal right, legal guarantee of conformity for digital content, SMP consumer mediator. Details in the terms of sale and the legal notice.