Accounting For VAT With Making Tax Digital
Making Tax Digital for VAT applies to every VAT-registered business, whatever its turnover. You keep your VAT records digitally and file your VAT return using software. A spreadsheet can keep the records. Bridging software sends the return to HMRC.
Making Tax Digital (MTD) Frequently Asked Questions:
I am not VAT registered, does this impact me? Making Tax Digital for VAT applies only to VAT-registered businesses, so your VAT submissions do not change. Making Tax Digital for Income Tax started on 6 April 2026 for sole traders and landlords with qualifying income over £50,000. It starts on 6 April 2027 for qualifying income over £30,000.
I am VAT registered but below the VAT registration threshold, does this impact me? Yes. Since April 2022 all VAT-registered businesses must use Making Tax Digital for VAT, whatever their turnover. Businesses above the threshold have used it since April 2019.
I am using the Flat Rate Scheme, will this affect me? This will depend on circumstances, as you don't need to keep an electronic record of your purchases unless you have capital expenditure goods, in this case you should record them and claim the VAT.
Why do I need extra software? Your VAT return must go to HMRC from software. For businesses using spreadsheet based software this means you will need bridging software, which connects the spreadsheet to HMRC.
Can I use different bridging software?
There is no HMRC requirement to use any specific solution. HMRC has a service to search for record keeping software and bridging software. DIY Accounting also provides DIY Accounting Submit, a web service that sends your VAT return to HMRC without an Excel add-in. VitalTax has been designed to work specifically with the layout of the DIY Accounting VAT calculations.
What is an Excel Add-In?
An Excel Add-In is a file that Excel can load when it starts up. It contains code that adds additional functionality to Excel, usually in the form of new functions. In the case of VitalTax for DIY Accounting it allows you to submit your quarterly VAT return at the click of a few buttons.
Which version of Excel do I need?
VitalTax works for Excel 2013, 2016, 2019 for windows, Excel 2016, 2019 for Mac, Office 365and Excel for iPad. If you have an older version our recommendation is that you upgrade Excel or use free Excel online version.
How do I get the add in?
The add in is available in Excel. On the Insert menu click on get Add Ins. A window called office add-ins will appear. Type in VitalTax and click add. When using the tool, you will need to select “DIY Accounting – VAT” in the templates window. This links with the format of the DIY Accounting spreadsheets. If you’re struggling watch this video.
What if I use Open Office or an earlier version of Excel?
Unfortunately VitalTax doesn't support Open Office or the earlier versions of Excel directly, but you can export your vat spreadsheet as an Excel file by using 'free office online' - you can get it here, please see the following link that helps explain the installation process: Excel Online Guide
Could I get a demonstration before downloading?
A demonstration video is available on YouTube
Where do I go for further support with the VitalTax bridging software?
Support is available by contacting VitalTax directly on their website
Why have DIY Accounting not developed their own solution? This is something we considered but, to ensure something was ready for April 2019 we decided to collaborate with a small business which already had created a solution. We have since built DIY Accounting Submit.
Are there any more videos I can watch?
Yes, this one is a bit longer and not designed for DIY Accounting but gives a general idea of how it all works. Happy Watching!
**
Editor's note (2026): The VAT registration threshold is now £90,000. See GOV.UK: when to register for VAT for current thresholds.
DIY Accounting Submit: DIY Accounting provides a Making Tax Digital VAT submission service at submit.diyaccounting.co.uk, which connects to HMRC's Making Tax Digital API. A free day pass gives you 3 VAT returns to try it. After that, the Resident VAT bundle costs £9.99 a year or £0.99 a month. See how to file a VAT return from a spreadsheet.
Spreadsheets for VAT-registered businesses: Self Employed and Company Accounts.
Tax reference: Making Tax Digital for VAT - Source: GOV.UK: find software that's compatible with Making Tax Digital for VAT; who must use it: GOV.UK: Making Tax Digital for VAT is coming; Flat Rate Scheme records: GOV.UK: VAT Notice 700/22; Income Tax: GOV.UK: find out if and when you need to use Making Tax Digital for Income Tax
Citations checked:
File with HMRC and Companies House
DIY Accounting Submit is HMRC recognised. It files VAT returns, and company accounts and confirmation statements to Companies House. £9.99 a year (£0.99 a month), with a free day pass to try it.