Report this item to Etsy

UK Childminder Income and Expenses Spreadsheet 2026/27 | Self Assessment

NowPrice:$18.58

Original Price: $23.23

Loading

20% off

•

Sale ends on December 20

Includes Etsy Purchase Protection

You can only make an offer when buying a single item

Highlights

Keep a 2026/27 record as a UK self-employed childminder — fees, food, household-cost percentages and the 10% wear-and-tear deduction, with a transparent tax estimate.

What you get
• SAMPLE and BLANK Excel workbooks
• Instructions, Dashboard, Settings, Income, Food and drink, Expenses, Mileage, Tax estimate, Rates and dropdown lists
• If you are not required to use Making Tax Digital for Income Tax, you can apply HMRC’s published household-cost percentages (by weekly hours) and the 10% wear-and-tear deduction on home-based income. If you say you use MTD, those methods are switched off and you should use actual, reasonably apportioned costs instead.
• Official 2026/27 figures from GOV.UK and the Business Income Manual (BIM52751), plus Income Tax and Class 4 rates

How to use it
1. On Settings, say whether you must use MTD, choose a weekly hours band, and enter household running and fixed costs if you will use the published table.
2. Log weekly fees, food and drink, and other expenses. Do not also claim the same household bills in full if you are using the percentage method.
3. Read the Dashboard. Confirm which methods you may use on GOV.UK before you file.

Google Sheets: use File → Import → Upload. Core formulas use SUM, SUMIFS, IF, MIN, MAX, ROUND and SEARCH. Excel sheet protection often does not transfer — re-protect the Rates and workings sheets in Sheets if you want to. After importing, change one figure and confirm the Dashboard updates.

What this is not
It is not a filing tool, not MTD software, and not tax advice. Eligibility for the special childminder methods depends on your circumstances. If you are unsure, or your affairs are complex, speak to a qualified accountant.

Disclaimer: This is a record-keeping and planning tool. Figures are estimates based on the amounts you enter and on HMRC rates published on GOV.UK as at 17 November 2026. It is not official HMRC or GOV.UK software, not tax, legal or financial advice, and not a substitute for a qualified accountant or for filing your Self Assessment return (or a VAT return) with HMRC. You are responsible for checking that rates, thresholds, dates and your own figures are current and correct. April Sixth is a trading name, not a government body.

Sources (checked 17 November 2026): https://www.gov.uk/guidance/claiming-expenses-and-keeping-records-if-youre-a-childminder · https://www.gov.uk/hmrc-internal-manuals/business-income-manual/bim52751 · https://www.gov.uk/guidance/check-if-you-need-to-use-making-tax-digital-for-income-tax · https://www.gov.uk/income-tax-rates · https://www.gov.uk/self-employed-national-insurance-rates · https://www.gov.uk/simpler-income-tax-simplified-expenses/vehicles

AI-assistance disclosure: This listing text and the spreadsheet were produced with assistance from AI tools, then reviewed, edited and tested by a person. Official rates and dates were checked against GOV.UK (17 November 2026) and the formulas were recalculated independently. This is not official HMRC software and is not tax advice.

File format: Microsoft Excel .xlsx (SAMPLE and BLANK). Instant digital download. No physical item will be sent.

Instant Download

Your files will be available to download once payment is confirmed.  Here's how.

Instant download items don’t accept returns, exchanges or cancellations. Please contact the seller about any problems with your order.

Etsy Purchase Protection
Shop confidently on Etsy knowing if something goes wrong with an order, we've got your back for all eligible purchases — see program terms