UK Childminder Accounts Spreadsheet 2026/27

Why this one

Fees, funded entitlement hours and Tax-Free Childcare payments are tracked separately, so you can see where your income actually comes from rather than one lump. Food, craft materials, toys, outings and the household proportion of your costs each have their own category, and the household share is worked out rather than guessed.

What you get

• One Excel workbook (.xlsx) with 11 tabs: Start Here, Dashboard, Settings, Income, Expenses, Mileage, Home Working, Quarterly Summary, Tax Estimate, Rates 2026-27, Lists
• A quick start guide (PDF) with instructions for Excel and for Google Sheets
• Income and expense categories written for your trade, not a generic list
• A dashboard showing profit, tax to set aside and where the money went
• A sourced rates tab listing every figure with the GOV.UK page it came from

Built for the 2026/27 UK tax year

Every figure is for the 2026/27 tax year and sits on its own tab with the GOV.UK page it came from, so you can check our working.

• Mileage at 55p for the first 10,000 miles, then 25p. This rose from 45p and was backdated to 6 April 2026, so older templates under-claim.
• Personal allowance of £12,570, with the taper above £100,000
• Income tax for England, Wales and Northern Ireland, and all six Scottish bands from 19% to 48%
• Class 4 National Insurance at 6% and 2%, and the Class 2 position
• Working from home flat rates of £10, £18 and £26 a month
• Expense categories matching the boxes on the HMRC self-employment pages, so nothing needs re-sorting in January
• Making Tax Digital quarter dates: 7 Aug 2026, 7 Nov 2026, 7 Feb 2027 and 7 May 2027

Questions