VAT – new submissions using Making Tax Digital

[George2009]

We use an Excel 2010 spreadsheet for all our accounts. It has several tabs which cover e.g. claims, transactions on a deposit account, etc. which are linked to the *main page* reflecting all our current account bank transactions.


Our VAT returns are on a 3-monthly basis. Therefore in the *main page* of the Excel spreadsheet it has entries for calculating VAT including the boxes. We intend to use the Excel Add-in VitalTax as MTD Bridging Software – we are aware this only works with later versions of Excel so for the MTD VAT return we intend to use the Excel online version. Is this going to be OK?


Do I need to create new tabs for each new VAT return period which has the 9 sections of the VAT return which takes the values from the *main page* transactions so that the bridging software can use it?

 

[SteveHa]

It's OK provided you are not manually transferring data from local spreadsheet to cloud.

 

[dvddarren]

There's plenty of other bridging software that supports Excel all the way back to Excel 2005.
I'm guessing VitalTax only supports Excel 2013+ because it's software runs inside Excel.
There's bridging software that works by loading the spreadsheet into their software.

 

[Paul Kelly ICHYB]

@George2009 Sorry for being nosey, but why don't you use an accounting package?

 

[paulears]

normally I get the reminder to file my return - same time each quarter. Nothing this quarter, and although I'll do the return tomorrow, how odd they don't send the email/

I just logged on - and it's ready but it says I have not sent the return for sept-dec that I have receipts for! Strange!

 

[alan1302]

normally I get the reminder to file my return - same time each quarter. Nothing this quarter, and although I'll do the return tomorrow, how odd they don't send the email/

They may have sent it and you not received it.