Can I use Excel for Making Tax Digital?
Yes. You can keep your records in a spreadsheet, as long as bridging software sends the figures from it to HMRC.
What bridging software is
It is a small program or add-in that reads the totals in your spreadsheet and sends them to HMRC. HMRC keeps a list of software that works with Making Tax Digital for Income Tax, and you must use something on it.
HMRC does not provide its own free software for this.
The digital link rule
Once a figure is in your spreadsheet, it has to travel to HMRC without being retyped or copied and pasted by hand. Formulas and linked cells are fine.
What your spreadsheet needs
- Each sale and each cost on its own line, with the date and amount
- Costs sorted into HMRC's categories
- Totals for each quarter
- A separate sheet for each business or rental property type
When Excel is not worth it
If you have a lot of transactions, pay CIS tax or claim mileage, a phone app that reads receipts and bank feeds is usually less work than a spreadsheet.
Questions about spreadsheets
Can I keep paper records?
You can keep paper receipts, but the record of each sale and cost has to be digital.
Is there free software?
Some providers have free versions for simple cases. Check HMRC's software list for what is current.
Can you do it from my spreadsheet?
Yes. Send us your spreadsheet or your receipts each quarter and we do the updates.
More on Making Tax Digital
Rather hand it over?
We do the four quarterly updates and your year-end return for £50 a month including VAT, paid by Direct Debit.