Your Cart
Loading

MTD Spreadsheet UK 2026/27 | Sole Trader & Landlord Bookkeeping

On Sale
£9.99
£9.99
Added to cart

Keep your books in a spreadsheet and still be ready for Making Tax Digital.


From 6 April 2026, sole traders and landlords with qualifying income over £50,000 have to send HMRC quarterly updates. The threshold drops to £30,000 in April 2027 and £20,000 in April 2028. HMRC says you can keep using spreadsheets, as long as you link them to recognised bridging software to send the figures. This workbook does the record keeping and the adding up, so the quarterly update is a five-minute job.


Not in MTD yet? It works just as well for a normal Self Assessment return. Every category shows the SA103 or SA105 box it belongs in.


WHAT IT DOES

• Income and expense ledgers with drop-down categories that match the fields HMRC uses for MTD quarterly updates

• Self-employment and UK property in one file, so it suits people who are both a sole trader and a landlord

• Quarter worked out from the date (standard 6th-to-5th or calendar periods), with per-quarter and year-to-date totals

• Business-use % on any expense (phone 70% business, for example)

• Mileage log at 55p for the first 10,000 miles and 25p after, plus the motorcycle rate

• Use-of-home flat rate (£10, £18 or £26 a month by hours worked)

• Tax estimate with 2026/27 rates for England, Wales and Northern Ireland, or Scottish bands at the flick of a setting

• Class 4 National Insurance, Personal Allowance taper over £100,000, the 20% mortgage interest credit for landlords, and the £1,000 trading and property allowances

• Payments on account and balancing payment worked out, plus how much to put aside each month

• Dashboard with profit, tax, monthly chart, expense mix and data checks that flag missing categories or receipts

• Deadline tracker with days left for every quarterly update and payment


WHAT YOU GET

• Blank workbook (.xlsx) ready for your own figures

• Sample workbook filled in for a made-up designer who also lets a flat, so you can see every sheet working

• Quick Start Guide (PDF)


WORKS IN

Microsoft Excel 2016 or later (Windows and Mac), Google Sheets, Apple Numbers and LibreOffice. No macros, no add-ins, no subscription.


PLEASE NOTE

• This is a digital download. Nothing will be posted.

• It keeps records and produces figures. It does not send anything to HMRC. To submit MTD updates you need HMRC-recognised bridging software (several have free versions; HMRC's software finder lists them).

• Tax figures are estimates based on 2026/27 rates published on GOV.UK. It does not cover savings or dividend tax, capital gains, student loans, the High Income Child Benefit Charge or losses. It is not tax advice; check anything unusual with HMRC or an accountant.


FAQ


Q: Is a spreadsheet allowed for Making Tax Digital?

A: Yes. GOV.UK says you can keep records in spreadsheets if you use software that links to them (bridging software) to send quarterly updates and your tax return.


Q: Does it submit to HMRC?

A: No. It prepares the figures. Your bridging software sends them.


Q: I'm in Scotland.

A: Set "Scottish taxpayer?" to Yes on the Settings tab and the Scottish bands are used.


Q: Will there be a 2027/28 version?

A: Yes. The rates sit on one tab, so updating is quick. Buyers get the update free.

You will get a ZIP (189KB) file