UK Home Baker and Caterer Accounts Spreadsheet 2026/27

Why this one

Ingredients bought and ingredients used are not the same figure, and food waste is a real cost that most templates have no home for. Both are tracked here. So are food hygiene registration, allergen training and the insurance that a council will ask about, all of which are allowable and all of which get forgotten.

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