TaxYearSheets

UK Sole Trader MTD Record-Keeping Kit 2026/27

Track your self-employed turnover, SA103F business expenses, 55p/25p business mileage and flat-rate home-working hours in Excel or Google Sheets – with automatic cumulative quarterly totals for Making Tax Digital.

Short answer

Our UK Sole Trader MTD Record-Keeping Kit 2026/27 (£19.99) is a one-off Excel (.xlsx) and Google Sheets workbook for self-employed sole traders and freelancers. You log sales, expenses, business mileage and home-working hours once; the workbook totals your cumulative quarterly MTD figures across HMRC's SA103F categories and keeps year-end simplified expenses separate until your annual return. Record-keeping only; does not submit directly to HMRC.

Last checked against GOV.UK: 23 October 2026. Sources are linked in each section. HMRC updates its guidance, so always check the source before you act.

The problem self-employed sole traders face under Making Tax Digital

Under HMRC's Making Tax Digital for Income Tax rules, sole traders with qualifying gross income over £50,000 (from 6 April 2026, based on 2024/25) or over £30,000 (from 6 April 2027, based on 2025/26; £20,000 from 6 April 2028) must keep digital records of every business income and expense transaction and send four cumulative quarterly updates a year.

  • SA103F categories vs simplified expenses: HMRC's quarterly updates follow the Self Assessment self-employment categories (SA103F boxes 15–30), while flat-rate business mileage (55p/25p per mile in 2026/27) and flat-rate working-from-home hours (£10/£18/£26 per month) are simplified-expense adjustments you review before finalising your annual return (GOV.UK).
  • Disallowable and capital items must not leak into allowable expenses: client entertaining (box 24, tracked separately from allowable advertising), capital equipment purchases and personal drawings need to be recorded clearly without inflating your deductible expenses.
  • Cumulative year-to-date quarters & the 1–5 April boundary: each quarterly update reports cumulative totals from 6 April (or from 1 April if your accounting year runs 1 April–31 March and you elect calendar quarters in software before sending Update 1) to the end of that quarter. If your 2025/26 Self Assessment return ran to 5 April 2026, transactions dated 1–5 April 2026 belong to 2025/26 and must not be entered into your 2026/27 workbook.

Check when MTD applies to you in our free Making Tax Digital deadline checker, or test a vehicle claim in our free 2026/27 mileage allowance calculator.

See the finished result (fictional sample data)

Below are actual screenshots from our UK Sole Trader MTD Record-Keeping Kit 2026/27 populated with fictional sample transactions only (an imaginary freelance design and consulting business in Q1–Q2 2026/27). Select either image to open the full-resolution PNG in a new tab on mobile.

Screenshot of the Quarterly Summary worksheet in the UK Sole Trader MTD Record-Keeping Kit 2026/27 populated with fictional sample data, showing Update 1 to 4 deadlines, cumulative SA103F figures in Section A, discrete 3-month figures in Section B, and memo items (capital purchases and flat-rate mileage) in Section C.
Quarterly Summary tab (fictional sample data): Section A calculates cumulative year-to-date totals mapped to SA103F boxes (Turnover box 15, Other business income box 16, and expense boxes 17–30) across Updates 1–4. Section B shows each 3-month period on its own; Section C tracks capital purchases and flat-rate mileage separately as memo items. Open full-size image.
Screenshot of the Use of Home worksheet in the UK Sole Trader MTD Record-Keeping Kit 2026/27 populated with fictional monthly hours (40 to 80 hours per month) and automatic HMRC flat-rate calculations (£10 or £18 per month).
Use of Home tab (fictional sample data): Enter your monthly hours worked from home (when 25+ hours a month) and the sheet works out HMRC's simplified flat rate automatically (£10 for 25–50 hrs, £18 for 51–100 hrs, £26 for 101+ hrs per month). Open full-size image.

What this spreadsheet does – and what it does not do

Record-keeping only; does not submit directly to HMRC. We do not promise tax savings, guaranteed time saved, or universal MTD compliance from buying a spreadsheet alone.

What this kit DOES

  • Records date, amount, client/supplier description and HMRC SA103F category for up to 500 income rows and 500 expense rows in 2026/27.
  • Supports both standard tax-year quarters (from 6 April) and calendar quarters (from 1 April) via a single Settings dropdown, plus HMRC's under-£90,000 two-total expense consolidation view.
  • Calculates 2026/27 flat-rate business mileage automatically across up to 500 journeys (55p per mile for the first 10,000 car/van miles, 25p thereafter; 24p for motorcycles; 20p for cycles).
  • Calculates optional flat-rate working-from-home expenses across all 12 months and compares your total expenses against the £1,000 trading allowance on the Annual Summary tab.

What this kit DOES NOT do

  • Record-keeping only; does not submit directly to HMRC. Spreadsheets cannot send updates to HMRC's API by themselves.
  • Does not replace MTD bridging or filing software (you still need HMRC-recognised software to send quarterly updates and your Final Declaration).
  • Does not calculate your total personal Income Tax or Class 4 National Insurance bill across other income sources (PAYE employment, pensions, dividends or student loans).
  • Does not handle VAT returns (MTD for VAT), CIS contractor monthly returns, partnerships (SA800) or limited companies.
  • Negative cumulative category limitation: individual refund or credit-note rows reduce a category's cumulative total while it stays at £0.00 or above, but HMRC's MTD API and bridging templates reject net-negative category totals (< £0.00). If a credit note or refund makes an entire SA103F category negative for the year to date, export for that box is blocked (CHECK (<0)) until you review or adjust the entry.
Bridging software compatibility notice: To send figures from a spreadsheet to HMRC under Making Tax Digital, you must use HMRC-recognised bridging software linked via digital links (formulas or CSV/workbook import, not manual copy-and-paste). Compatibility with our spreadsheet has not yet been verified. Read our neutral MTD filing & bridging software guide before choosing a filing tool.

What's inside the UK Sole Trader MTD Record-Keeping Kit (£19.99)

The workbook contains 10 unlocked worksheets with formula protection hints, dropdown validation and zero macros:

Worksheet tabWhat it records or calculates
1. Start HereSetup checklist, colour key (pale yellow = your inputs; white/grey = automatic formulas) and links to official GOV.UK guidance.
2. SettingsBusiness name, accounting basis (cash basis is the default for most sole traders), update period type (Standard 6 April vs Calendar 1 April), and under-£90,000 consolidated expense toggle.
3. Income Log500-row digital log for Turnover (box 15) and Other business income (box 16), with automatic quarter assignment and uncategorised-row warnings.
4. Expense Log500-row digital log mapped to all 13 HMRC self-employment expense categories (SA103F boxes 17–30, including Bank, credit card and other financial charges in box 26), plus separate tags for capital purchases and personal/non-allowable items.
5. Mileage Log500-row journey log (date, from/to, vehicle type, business miles) that automatically applies HMRC's 2026/27 55p / 25p car and van threshold and 24p motorcycle rate.
6. Quarterly SummaryUpdate 1–4 deadline tracker, Section A cumulative MTD figures mapped to SA103F boxes, Section B discrete 3-month figures, and Section C memo items (capital purchases, personal items and flat-rate mileage).
7. Monthly SummaryMonth-by-month breakdown of turnover, allowable expenses and net profit from April 2026 to March 2027.
8. Use of Home12-month log for HMRC's simplified flat-rate home-working scale (£10 / £18 / £26 per month when working 25+ hours a month at home).
9. Annual SummaryFull-year SA103F summary combining logged expenses with optional simplified mileage and home-working adjustments, plus a side-by-side comparison with the £1,000 trading allowance.
10. ListsReference table of HMRC self-employment categories and SA103F box numbers used by the dropdown menus.

Also have rental property, or only a small side hustle?

If you have both self-employed income and UK rental property, our UK MTD Spreadsheet Bundle (£29.99) includes both the Sole Trader and Landlord MTD kits. If you only sell online casually (on Etsy, eBay, Vinted or Depop) and want to separate personal clear-out sales from taxable trading and check the £1,000 trading allowance, see our UK Side Hustle & Online Seller Tax Records Kit (£12.99).

Questions

What file format do I get, and how is it delivered?

You receive an instant digital download immediately after checkout containing the unlocked .xlsx spreadsheet workbook (no macros or VBA) and a PDF Quick-Start Guide with a one-click link to copy the workbook into a free Google Sheets account.

Which spreadsheet programs and devices are supported?

The workbook works in Microsoft Excel (2016, 2019, 2021 and Microsoft 365 on Windows and Mac), free Google Sheets in any modern browser, and LibreOffice Calc.

Does this spreadsheet submit my quarterly updates to HMRC?

No. This kit is for record-keeping only; it does not submit directly to HMRC. If you are required to use Making Tax Digital for Income Tax, you must use HMRC-recognised bridging or filing software to send your quarterly updates and Final Declaration. See our MTD filing and bridging software guide.

Will I have to pay separate software fees to file with HMRC?

Possibly. Buying our workbook is a one-off payment (£19.99) for the spreadsheet itself. Bridging and filing software is provided by third-party vendors listed on GOV.UK: some offer free tiers for quarterly updates, while others charge monthly or annual fees or restrict free plans at year-end. Check our software explainer and the official GOV.UK software finder before choosing a filing tool.

What is your refund and cancellation policy for digital downloads?

Under Regulation 37 of the UK Consumer Contracts (Information, Cancellation and Additional Charges) Regulations 2013, you have a 14-day statutory cancellation period for digital downloads. You only lose that 14-day right to cancel before the 14 days expire if you start downloading or copying the files after giving explicit prior consent to immediate supply and acknowledging that your right to cancel will be lost once the download begins (where those consent and acknowledgment steps are not completed, or before downloading starts, the 14-day cancellation right remains). Separate from cancellation rights, under the Consumer Rights Act 2015 (sections 34–37), digital content must be of satisfactory quality, fit for purpose and as described – if a file is faulty or does not match its description, email [email protected] for a repair, replacement or refund.

What if I have more than one self-employed trade or also let UK property?

Under Making Tax Digital, each separate self-employed trade has its own quarterly updates. Because you own the unlocked file, you can save a separate copy of this workbook for each trade. If you also have UK rental property (which uses SA105 categories), see our UK MTD Spreadsheet Bundle (£29.99) below.

How do I get support if I have a question about the workbook?

Email [email protected] if you need help downloading, opening or using the spreadsheet formulas. We cannot provide personal tax, legal or accounting advice.

About TaxYearSheets: what we do and don't do

What we do: UK record-keeping spreadsheets (Excel and Google Sheets) and free browser-based checkers for landlords, sole traders and online sellers. Every date and rate is sourced to GOV.UK or legislation.gov.uk.

What we don't do: we're not HMRC software and we're not connected to HMRC. Our spreadsheets don't submit anything to HMRC; if you're in Making Tax Digital you still need software that works with it. Nothing here is personal tax advice. More about us.

Not tax or legal advice. This free tool shows dates and figures worked out from the GOV.UK and legislation.gov.uk rules linked on each page, checked on 23 October 2026. Rules change and your situation may differ – always check the source, and speak to an accountant, solicitor or HMRC if unsure. TaxYearSheets is not connected to HMRC or the government.