Home > Support > Support Articles > MTD for VAT > Using VT MTD for Excel: Importing from VT Transaction+

Using VT MTD for Excel: Importing from VT Transaction+
   
If you use VT Transaction+ (or VT Cashbook) for bookkeeping it is best to use the MTD feature within the program to submit VAT returns directly from the software.

However there may be circumstances where you would need to submit a return using VT MTD for Excel with data imported from VT Transaction+, for example, if submitting a flat rate VAT return (which cannot be done directly in VT Transaction+)

Submitting an Excel VAT return imported from VT Transaction+

1. Make sure you have performed the procedures required for setting up MTD. If you have not, please refer to:

Setting up MTD for businesses
, if you are business submitting your own VAT return

Setting up MTD for agents, if you are an agent submitting clients' VAT returns through your Agent Services Account.


2. Open an Excel file and from the Excel menu select
Add-Ins > VT MTD > Import VAT return totals from VT Transaction+

3. Go to
Add-Ins > VT MTD > Specify VAT return Cells (VT Import Format)

4. To submit the VAT return, select Add-ins > VT MTD > Submit VAT Return to HMRC

5. To display the submission receipt, choose Add-Ins > VT MTD > Display Last Submission Receipt. You can print the receipt by clicking on the Print button.

Note that you should save your Excel spreadsheet carefully as it your VAT return record.


Digital Links

When using spreadsheets for your VAT return, figures cannot be copied and pasted in your spreadsheet(s) containing your VAT return and associated data.

Background

Under MTD for VAT rules, digital links must be in place between the different software elements that make up your digital VAT record keeping system. HMRC define a digital link in HMRC VAT Notice: 700/22, as follows:

'A 'digital link' is one where a transfer or exchange of data is made, or can be made, electronically between software programs, products or applications.'

They also state that linked cells in spreadsheets count as digital links:

'A digital link includes linked cells in spreadsheets, for example, if you have a formula in one sheet that mirrors the source's value in another cell, then the cells are linked.'

HMRC also state the following regarding copying and pasting data:

'HMRC does not consider the use of 'cut and paste' or 'copy and paste' to select and move information, either within a software program or between software programs, to be a digital link'.

The rules for digital links come into effect on 1 April 2021. For your obligations in this respect you should refer to HMRC VAT Notice: 700/22.