Childminder Accounts Spreadsheet 2026/27 (Excel & Google Sheets)

Run your childminding business from one spreadsheet. Log each child's sessions, take funded hours off the parent's bill, make invoices in a minute, see who owes you (and what the council still owes you), and claim your home bills, food and wear and tear the way HMRC allows childminders - for the 2026/27 tax year. Works in Excel and Google Sheets.

Built for UK registered childminders (Ofsted or a childminder agency), whether you mind one child or six. People also call it home daycare or home-based childcare. It isn't built for nannies or babysitters who work in the family's own home.

WHAT IT DOES FOR YOU

• Pick the child and the fee and the price fills in - hourly, full day, before and after school, holiday days and extras
• Funded hours come off the parent's bill automatically, and the council's share is tracked so you can see what's still due
• Invoice tab: pick a family and dates and every child's sessions fill in - print it or save it as a PDF
• Shows what each family has been charged, what they've paid (including Tax-Free Childcare) and what they owe you
• HMRC's childminder shortcuts done for you: your share of gas, electricity, water, council tax, rent or mortgage interest from your weekly hours, the 10% wear and tear allowance and a food estimate with no receipts
• Making Tax Digital switch: if you're in MTD, the kit changes to the normal rules for you
• Mileage at 55p a mile for school runs and outings, expenses matched to HMRC's boxes, and an Income Tax and NI estimate

WHAT'S INSIDE (18 tabs + an example file)

• Attendance: 4,000 rows for sessions, hours, funded hours, extras and food, with a Check column that flags mistakes
• Families and Children: who pays, each child's details, age, sessions, hours and funded hours this year
• Payments: from parents, Tax-Free Childcare and the council
• Invoice: a ready-to-send invoice for any family and dates
• Home & Food: your share of home bills, 10% wear and tear and HMRC's food estimate, worked out for you
• Dashboard: money received, owed by families, funding due, profit, tax set aside, tax bill, hours of care and who owes you most
• Expenses and Mileage: nappies, food, toys, equipment, Ofsted fee, insurance, training, first aid and your car miles
• Tax Estimate and Annual Summary: Income Tax, Class 4 NI, the £1,000 trading allowance check, payments on account and the figures for your tax return
• Plus Start Here guide, Settings, Fees, Monthly Summary, Key Dates (Ofsted fee, insurance, first aid and DBS renewals), What Goes Where and Rates (with GOV.UK sources)

YOU'LL RECEIVE

• Blank Excel spreadsheet (.xlsx)
• Example Excel spreadsheet filled with a sample childminder
• PDF with your Google Sheets links (click "Make a copy")

WORKS WITH

Microsoft Excel 2016 or newer (Windows and Mac) and Google Sheets with a free Google account. Set up on a computer; after that you can log sessions on your phone.

PLEASE NOTE

• Digital download only. No physical item will be sent.
• This is not a childcare app and it doesn't send invoices or reminders for you. It keeps your records and works out your figures. It doesn't send anything to HMRC.
• It doesn't replace the records Ofsted and the EYFS ask you to keep.
• Children's and families' details are personal data. Keep your copy private and only record what you need.
• It's a record-keeping tool, not tax or financial advice.
• Built for self-employed childminders. Nurseries, limited companies, VAT-registered businesses and payroll for assistants aren't covered.
• Uses 2026/27 rates for England, Wales and Northern Ireland. Scottish income tax bands are different, so the estimate won't be exact in Scotland.
• Designed by me with the help of AI tools, then checked and tested by hand.
• For your own use only. Please don't share or resell.

Questions or stuck? Use the Contact link at the top of my store and I'll reply within 24 hours.