LaunchKit resource
MTD spreadsheet guidance for UK sole traders
If you are preparing for Making Tax Digital for Income Tax, the useful question is not just which spreadsheet looks tidy. It is whether your income and expense records are kept digitally and can move through a permitted digital link into compatible software. This editorial guide explains that boundary.
What an MTD spreadsheet should actually do
A useful MTD spreadsheet is a working record, not a magic filing button. It should help you keep income, expenses, dates, categories and notes in a repeatable weekly rhythm, so the numbers are easier to review before they reach filing software. For a sole trader, that means the workbook should make business transactions easier to identify, separate from personal spending, and summarise without promising to submit anything to HMRC.
Spreadsheet versus compatible software
GOV.UK guidance is clear that Making Tax Digital relies on compatible software. A spreadsheet can still be useful as part of the admin workflow, especially for collecting source records, checking categories and spotting missing receipts before software submission. Treat the workbook as preparation and record discipline. Treat compatible software, your accountant, or HMRC guidance as the place to confirm filing obligations and submission steps. If you plan to keep a spreadsheet in the workflow long-term, look specifically at bridging products on the HMRC compatible-software list, and check how each one expects the workbook to be structured before you build a year of records around a layout that would need re-typing later.
A weekly workflow that reduces year-end panic
The safest habit is a small weekly session: add sales, add expenses, attach or file proof, review categories, and flag anything unclear while the job is still fresh. That keeps the workbook practical for quotes, invoices and receipts rather than becoming a once-a-year reconstruction exercise. It also gives you cleaner totals when you need to discuss records with an accountant or move figures into another system.
Which LaunchKit page should you use next
The free readiness check is a general planning tool, and Financial Forms provide routine invoice, income, expense, receipt and mileage records. Neither option files updates or decides whether MTD applies to you. Confirm your actual duties, start date, digital-link workflow and compatible-software requirements against current GOV.UK guidance before acting.
What to review before you rely on the workbook
Before you make the spreadsheet part of your routine, check whether the categories match the way you already keep records, whether your bank and receipt workflow gives you enough proof, and whether any accountant or software you use needs a different export format. That review keeps the workbook in the right role: a cleaner working record, not a replacement for current HMRC requirements or professional judgement.
Compare the next step
Questions before you choose
Does this replace MTD compatible software?
No. The free readiness check and this guide do not replace compatible software. Check GOV.UK or a qualified adviser for submission requirements.
What counts as a digital record for MTD?
HMRC expects income and expense records to be created and kept digitally, with transfers between programs handled by permitted digital links rather than manual re-typing. Check the current GOV.UK definition before settling on a workflow, because the detail of what must be digital can change.
Can I use it before I am required to use MTD?
Yes, as a record-keeping habit. Whether and when MTD applies to you should be checked against current GOV.UK guidance.