Short answer
A spreadsheet can hold your MTD for Income Tax records if every income and expense has its amount, date and category, using the same categories as Self Assessment. It can't send anything to HMRC itself. You digitally link it to HMRC-recognised bridging software, and that software sends your quarterly updates and tax return.
Last checked against GOV.UK: 21 October 2026. Sources are linked in each section. HMRC updates its guidance, so always check the source before you act.
What every row needs
GOV.UK calls each income or expense entry a digital record. Each one must show:
- the amount
- the date the income was received or the expense was incurred
- the category: MTD uses the same income and expense categories as Self Assessment (see the lists below)
Useful extras that GOV.UK doesn't require: a short description, who paid you or who you paid, and a receipt or invoice number so you can find the paperwork later.
You still keep your usual paperwork too, such as invoices, receipts and bank statements (or copies). Keep the records for at least 5 years after the 31 January deadline for the tax year.
Source: GOV.UK – Create digital records (what to include in each digital record; how long to store records).
The categories your spreadsheet should use
These are the categories in HMRC's quarterly update direction. Your quarterly update sends HMRC one total for each category, not your individual receipts.
| Sole traders (self-employment) | Landlords (UK property) |
|---|---|
| Income: Turnover; Other business income | Income: Total rent; Other income from property; Premiums for the grant of a lease; Reverse premiums and inducements |
| Expenses: Cost of goods bought for resale or goods used; Construction industry – payments to subcontractors; Wages, salaries and other staff costs; Car, van and travel expenses; Rent, rates, power and insurance costs; Repairs and maintenance of property and equipment; Phone, fax, stationery and other office costs; Advertising; Business entertainment costs; Interest on bank and other loans; Bank, credit card and other financial charges; Accountancy, legal and other professional fees; Other business expenses | Expenses: Rent, rates, insurance and ground rents; Property repairs and maintenance; Non-residential property finance costs; Residential property finance costs; Residential finance costs brought forward; Legal, management and other professional fees; Costs of services provided, including wages; Travel expenses; Other allowable property expenses |
Simpler categories under £90,000: if your turnover from a business is under £90,000, you can choose to record in less detail. Sole traders then only need to record whether each entry is income or an expense. Residential landlords must also record whether each expense is a restricted finance cost, such as mortgage interest.
Not sure what goes where? See the sole trader expenses list and the landlord expenses list.
Sources: GOV.UK – MTD for Income Tax: quarterly update direction (sections 1 and 2.1) · GOV.UK – Create digital records (simpler categorisation).
Year-to-date totals
Each quarterly update covers the tax year so far, from 6 April to the end of the update period, not just the last 3 months. So a useful template keeps a running total for each category at each period end. If you fix a mistake in an earlier month, the next update picks up the corrected total.
| Update | Covers (standard periods) | Deadline |
|---|---|---|
| 1 | 6 April – 5 July | 7 August |
| 2 | 6 April – 5 October | 7 November |
| 3 | 6 April – 5 January | 7 February |
| 4 | 6 April – 5 April | 7 May (the following tax year) |
If your accounts run from 1 April to 31 March you can use calendar periods instead (1 April to 30 June, and so on). The deadlines are the same. Dates for 2026/27 are in MTD quarterly deadlines 2026/27.
Source: GOV.UK – Send quarterly updates (each update covers the tax year so far; update periods and deadlines).
How a spreadsheet works with bridging software
Bridging software is HMRC-recognised software that connects to records you keep somewhere else, such as a spreadsheet, and makes your submissions to HMRC. Some bridging products send quarterly updates and the tax return; check before you choose.
- Digital links: the spreadsheet and the software must be linked digitally. GOV.UK's examples include formulas linking cells, CSV or XML import and export, uploading files, and API transfers.
- No retyping: once a record has been sent in a quarterly update, you mustn't move it by retyping it or by copy and paste.
- Fixing mistakes: correct the record in the spreadsheet, then link it to your bridging software again.
- One product per submission: for example, a landlord can't use two products to send property updates.
- Choosing software: HMRC's software finder lists products that have been through HMRC's recognition process. HMRC doesn't recommend any product. Free products exist for simple tax affairs, sometimes with limits such as the number of transactions.
Our tip: bridging products read spreadsheets in different ways. Before you rely on one, check its own help pages to make sure it can read your spreadsheet's layout.
Sources: GOV.UK – Choose the right software for MTD for Income Tax · GOV.UK – Create digital records (digitally linking records; correcting records) · GOV.UK – Find software that works with MTD for Income Tax.
What a spreadsheet template can't do
- It can't send quarterly updates or your tax return. Only MTD-compatible software can.
- It isn't HMRC software. GOV.UK says you must make sure your records are accurate, so check your figures before each update.
- It doesn't replace your paperwork. Keep invoices, receipts and bank statements as you do now.
Not sure you need MTD yet? The free MTD checker tells you if and when you need to start. More detail on the rules is in Can I use a spreadsheet for MTD?
Sources: GOV.UK – Create digital records · GOV.UK – Choose the right software.
Our record-keeping spreadsheets
If you'd rather not build your own, we sell two ready-made record-keeping spreadsheets for Excel and Google Sheets: one for landlords and one for sole traders. Both are laid out in HMRC's quarterly update categories and work out year-to-date totals for updates 1 to 4. They're spreadsheets only. They don't connect to HMRC or send anything, so you'd use one alongside bridging software of your choice.
Questions
Can I use Excel or Google Sheets for MTD?
Yes, as a place to keep your records. GOV.UK says bridging software can connect to records kept in spreadsheets and make your submissions to HMRC. Bridging products can differ in which spreadsheet types and layouts they can read, so check before you choose one.
What columns does an MTD spreadsheet need?
GOV.UK says each digital record must show the amount, the date the income was received or the expense incurred, and the category. A description and a receipt reference aren't required, but they make records easier to check later.
Does my spreadsheet need to be HMRC-recognised?
The software that sends your updates does. GOV.UK says every product in its software finder has been through HMRC's recognition process. A spreadsheet holds your records and is digitally linked to that software. HMRC doesn't recommend any product.
Do I need a separate spreadsheet for each business or property?
For each sole trader business, yes: GOV.UK says you keep separate digital records and send separate updates for each one. All your UK rental properties count as one UK property business, so one set of property records is enough.
Can a spreadsheet send my quarterly update to HMRC?
No. A spreadsheet can't send anything to HMRC. You need MTD-compatible software, such as bridging software, to send quarterly updates and submit your tax return.
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.
Free UK tax deadline reminders
A short email 1–3 weeks before key UK tax dates: Making Tax Digital quarterly updates, the 31 January Self Assessment deadline and the end of the tax year. Each one says what's due and who it applies to, and links to the GOV.UK source.
- How often: about once a month, never more than 2 a month.
- What else: occasionally a note about our record-keeping spreadsheets. No spam, and we never share or sell your address.
- Leave any time: there's an unsubscribe link in every email.