Andica MTD VAT Excel Spreadsheet Bridging Software

Customers can link their Microsoft Excel Spreadsheet containing VAT transaction with Andica MTD VAT Software and extract VAT 9-Box values using the spreadsheet mapping screen and drag and drop VAT100 values from your spreadsheet to the software.

No one customer's Excel spreadsheet layout is likely to match another customer's layout. For the bridging feature to work, some level of uniformity is required. We have provided here key requirements:

1. All VAT transactions or at least summary of VAT 9 Box values must be within a single spreadsheet.

2. VAT 9 Box values must be within a single sheet of that spreadsheet. A sample spreadsheet for MTD VAT Template is provided.

3. HMRC VAT Notice 700/22 Making Tax Digital for VAT states that transferring data manually within or between different parts of a set of software programs, products or applications that make up functional compatible software is not acceptable under Making Tax Digital.

In short, you cannot manually type in the values within the VAT boxes of the bridging software.

There are two possible mapping formats that can be used within the software.

1. VAT100 style: A sheet within the spreadsheet containing a table of 9 boxes of the VAT return.

2. Spreadsheet style: A spreadsheet layout that contains values required for VAT return boxes where these values are shown within random fields of the spreadsheet. Effectively not in a structural format.