Andica MTD VAT Software is an Excel spreadsheet bridging software that enables Businesses, Book-keepers, Accountants and other organisations to link their Microsoft Excel spreadsheet containing VAT transactions into the software and extract VAT 9-Box values to submit periodic VAT returns digitally to HMRC's MTD VAT system.
Making Tax Digital for VAT legislation requires VAT registered businesses with turnover above the VAT threshold to keep records in digital form and file their VAT Returns using MTD functional compatible software.
While Making Tax Digital for VAT (MTD VAT) is a digital record keeping and VAT Returns filing requirements for VAT registered businesses, HMRC recognise that many Businesses and Accountants use Microsoft Excel to process VAT transactions. Andica MTD VAT Software provides facility to extract VAT 9 Box values and submit to HMRC. Software interacts with various HMRC's MTD VAT APIs (facilities) as described in the Features page.
Submission of VAT return can be accomplished in simple routines within the software.
Andica MTD VAT software does not enforce any specific format in which a customer should record transactions within an Excel spreadsheet. As long as the spreadsheet contains all the necessary transactions for a VAT period and there is a single 'Sheet' where the VAT 9 box values for a VAT period have been summarised, this will be sufficient for the software to extract that information. Customers can then use the mapping feature to integrate and extract VAT values into the software.
The transfer of data between Excel spreadsheet into the bridging software must be carried out digitally. According to HMRC, transferring data manually within or between different software is not acceptable. In short, you cannot manually type in the values within the VAT boxes of the bridging software.
Annual Licence: The software is supplied on an annual licence basis. Annual licence is granted for use of software for a year effective from the date of purchase. Licence is granted for use of a specific version of the software and a new licence should be purchased for each version. In case of version upgrade, annual licence of the new version will supersede the earlier version. Software licence expires at the end of the term and the software with all its functions will be deactivated unless the licence has been renewed.
You can only use one copy of the Software on a single computer and /or disk drive. A license must be purchased for each computer or hardware, including disk drives on which software is installed. For a network version of the software, use the software on a network provided that you have a licensed copy of the software for each computer that can access the software over that network. Software licenses are also restricted by the number of records that can be created and processed.
*1 We cannot provide any guarantee as the security also relies on security and safety of customer's computer and internet which is beyond our control.
The software provides a feature to link with your VAT transaction Microsoft Excel spreadsheet to extract VAT 9 box values from Excel spreadsheet.
Upon linking the software with VAT transaction spreadsheet, you can map software VAT fields with your VAT values in spreadsheet by simply dragging and dropping. Values will be populated in boxes 1 to 9 of VAT100 form ready to be sent digitally to HMRC.
Software provides a process for an agent to digitally obtain authorisation from HMRC to deal with client's VAT submissions. This process also includes facility to authorise Andica MTD VAT software to retrieve and submit VAT data for a VAT registered business.
Software can retrieve the current and future VAT returns obligation periods since signing up to MTD. HMRC will provide the next VAT returns obligation and not any future obligations beyond that. A new obligation will be created by HMRC once the previous obligation has passed, whether that obligation has been fulfilled or not.
You can submit your VAT 9 box values digitally to the HMRC using your HMRC login credentials. You will need a prior registration with the HMRC who will provide you with the login credential (such as Gateway User ID and Password).
The software provides a feature to digitally submit VAT Returns to HMRC. You can view and print the VAT100 style report before submitting.
Retrieve and view details of VAT returns submitted to HMRC since signing up to MTD VAT.
Once VAT Return is submitted through MTD, details of VAT liabilities can be retrieved within the software. Software will retrieve VAT liabilities information that HMRC have made available.
Retrieve details of payment made against a VAT return period. Software will retrieve VAT payments details that are made available by HMRC.
The software provides a range of reports that can be printed for your records. VAT100 style report can be printed for your records.
Microsoft Excel:
The software works with Microsoft Excel spreadsheet created with following versions of Microsoft Office Excel Microsoft Excel files must have file format XLSX, XLS, and CSV
Microsoft Office 2002
Microsoft Office 2003
Microsoft Office 2007
Microsoft Office 2010
Microsoft Office 2013
Microsoft Office 2016
Please note: Office 365 is a Microsoft subscription service, not a Microsoft Office product version number.
Antivirus software:
A small number of anti-virus software may need to be configured to exclude Andica data files from its scanning routines to optimise performance of the software. Details provided in FAQ section.
Note: Andica Software is not supported for installation directly onto Linux, Apple Mac or any other OS not listed above in the 'Operating systems supported' list.
We are aware of some of our customers using Andica software on Windows Emulation on Apple Mac. Since we do not test our products on Windows Emulation on Apple Mac or Apple Boot Camp, we cannot provide any technical support on installation.