Can I do MTD for Income Tax with a spreadsheet or my bank statement?
Short answer: Yes, a spreadsheet can hold your digital records, but it cannot send anything to HMRC, so you also need compatible software to submit. A bank statement is not enough by itself: you must keep it as a supporting document, and your records need an amount, a date and a category for each item. You do not strictly need full accounting software, but you do need something HMRC’s rules accept.
Not sure MTD applies to you? Try the MTD checker. For the choices of tool, see MTD software options compared.
What a digital record must contain
GOV.UK says each record must show three things:
- the amount
- the date the income was received or the expense was incurred
- a category, which uses the same categories as Self Assessment
The default is one record per transaction, created as close to the transaction date as possible. There are simpler options in some cases:
| Situation | What you may record instead |
|---|---|
| Income source with turnover under £90,000 | Simpler categorisation: sole traders need only mark an item as income or expense. Landlords with residential property must still identify restricted finance costs |
| Retailer | Daily gross takings rather than each sale |
| Jointly let property | Your own share only, with less detailed records allowed (for example one income record per property category per update period) |
Some income does not need digital records, such as dividends, savings interest and pensions. For the categories used in the update itself, see what goes in a quarterly update.
You must keep your digital records for at least 5 years after the 31 January submission deadline for the tax year.
Does a spreadsheet count?
Yes. GOV.UK gives a spreadsheet as an example of separate record-keeping software. Your spreadsheet records can be the digital records, as long as they hold the three items above.
What a spreadsheet cannot do is submit your update. For that you need bridging software, which connects to your existing records and makes the submission to HMRC. GOV.UK describes it as software that connects to records kept in spreadsheets or other tools and can make submissions for you. Some bridging products send the quarterly updates and the final declaration. Check which products are on HMRC’s list.
The digital links rule
If you use more than one product, for example a spreadsheet and bridging software, you must digitally link them. GOV.UK lists these methods as acceptable:
- linked spreadsheet cells
- emailing a spreadsheet
- XML or CSV files
- APIs
Link them before you send a quarterly update or your tax return.
The rule that catches people out: once a record has been sent to HMRC in a quarterly update, you must not move it manually. GOV.UK specifically rules out cut and paste or copy and paste to move records, and copying information into other cells or software.
Example: Sam, a plumber, keeps a sheet with one tab per quarter. To build the figures for the template, Sam uses formulas that sum the tabs, then the bridging tool reads the template. That is a digital link. If Sam instead read the totals off the screen and typed them into the tool, the link would be broken.
Updates are cumulative, so a formula that sums from 6 April to the period end is safer than a separate tab per quarter that you add up by hand.
Can a bank statement or CSV be your records?
Not on its own, for three reasons.
- Bank statements are supporting documents. GOV.UK says you must keep your original records and supporting documents, such as bank statements and invoices, to prepare your tax return. It does not say a PDF statement can be your digital record.
- A statement has no category. Your record needs a Self Assessment category. A bank line says “Screwfix £42.10”, not “premises running costs”.
- Bank feeds can be incomplete. GOV.UK warns that some transactions may not appear in full in your bank feed, and you must create those records separately. You are responsible for checking your records are accurate before sending an update.
A CSV export can still be a useful starting point. GOV.UK lists CSV files as an accepted way to digitally link products. So a workable flow is: export the CSV from your bank, import it into software that stores the records, add categories, review, then send. Tools like SendMTD (not yet launched, not yet on HMRC’s list, waitlist open) are built around that flow. Whether a given tool satisfies the digital records rules is something to confirm with the provider.
Practical tips for a business-only bank account
- Keep the account business-only. Every line is then business income or expense, and you need no sorting of personal spending.
- Export regularly. Do not wait for the deadline. Some banks limit how far back a CSV goes, and the 7 August, 7 November, 7 February and 7 May deadlines come around quickly.
- Keep the statements. Save each CSV and PDF for at least 5 years after the filing deadline.
- Add what the bank does not show. Cash takings, expenses paid personally and anything missing from the export.
- Check categories before sending. Mistakes are corrected in the next cumulative update, but late updates can carry penalties in later years.
- Do not copy and paste totals between products. Use an import, a linked cell or a file.
So do I need accounting software?
Not necessarily. You need three things: digital records that hold amount, date and category; digital links between any products you use; and a recognised product that sends the updates. A spreadsheet plus bridging software meets those if you keep it disciplined. Full accounting software is one route among several, covered in the software comparison.
Sources
This guide is general information, not tax or legal advice. Rules can change: check GOV.UK or speak to an accountant about your situation. SendMTD is not affiliated with HMRC.