About turn, you can use spreadsheets
HMRC has about-faced regarding the ban on using spreadsheets to work out your VAT return data from 1 April 2019, when the new requirement to file VAT returns using Making Tax Digital (MTD) format is introduced.
Bowing to pressure from industry, the accountancy profession and Parliamentary committees, HMRC has now agreed that you can use spreadsheets for VAT purposes; unfortunately, there is a large “but”.
The rationale behind the development of MTD is that HMRC wants your returns of data through its MTD portal to be linked directly to the source material, the accounting entries that make up the returns. They do not want you to cut and paste data from your accounting records (including spreadsheets) into HMRC’s digital accounts.
Accordingly, they have agreed to the use of spreadsheets as long as the data is transferred using bridging software that is compatible with its MTD systems.
Software developers are now faced with creating this bridging solution and we will be reviewing solutions to settle on the best-fit option for clients.