Andica MTD VAT Software

Excel Spreadsheet Bridging Software

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.

Top

Benefits of Andica MTD VAT software are:

  • Customers can continue to use their Excel spreadsheet, with only minimal modifications if necessary, for as long as HMRC permit this for digital record keeping.
  • Compliance with Making Tax Digital legislation.
  • Link your VAT transactions Excel spreadsheet and drag and drop mapping of VAT 9-Box fields.
  • Easy to use. Simple process to complete MTD VAT functions of authorisation, retrieval and submission of VAT data.
  • Integration with HMRC's MTD VAT API (Application programing interface).
  • Secure online submission and retrieval of MTD VAT data between your computer and HMRC.*1
  • Data security and GDPR - your data is stored on your computer system, no VAT data is held on our server and does not pass through our servers.*1
  • Incorporates all HMRC MTD VAT API end points as listed in the Features list.
  • Manage multiple VAT periods for the business.
  • Multiple VAT registered businesses or clients can be handled within the software (subject to software license).
  • On-screen preview of VAT return prior to submission.
  • Viewing and printing of reports and VAT100 form style information.
  • Easy to retrieve and view data on screen.
  • Password protection - you can setup access rights into the software.

Secure

  • Can set user name and password to access the software.
  • Security access rights to functions.
  • Backup and restore facilities.

*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.

Top

Microsoft Excel Spreadsheet Integration

The software provides a feature to link with your VAT transaction Microsoft Excel spreadsheet to extract VAT 9 box values from Excel spreadsheet.


Drag and Drop mapping of VAT fields

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.


Digital Authorisation for MTDfB VAT - Making Tax Digital for VAT

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.


Retrieve VAT Periods (VAT obligations)

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.


Online submission and retrieval of MTD VAT values

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).


Submit VAT return for period

The software provides a feature to digitally submit VAT Returns to HMRC. You can view and print the VAT100 style report before submitting.


View VAT Return

Retrieve and view details of VAT returns submitted to HMRC since signing up to MTD VAT.


Retrieve VAT liabilities

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 VAT payments

Retrieve details of payment made against a VAT return period. Software will retrieve VAT payments details that are made available by HMRC.


Reports

The software provides a range of reports that can be printed for your records. VAT100 style report can be printed for your records.

Top

Andica MTD VAT Software System Requirement

Operating systems supported:
  • Microsoft Windows 7 (Install with Administrative user rights)
  • Microsoft Windows 8 and Windows 8.1 (Install with Administrative user rights. Excluding Windows 8 and 8.1 RT tablet edition)
  • Microsoft Windows 10 (Install with Administrative user rights)
  • Software works on 32-Bit and 64-Bit editions of Microsoft Windows OS above. OS must have all the latest Microsoft Updates installed.
  • Microsoft .NET Framework 3.5, Microsoft .NET Framework 4.0 and Microsoft .NET Framework 4.5
Minimum hardware specifications:
  • A PC with at least 2 GHz speed processor
  • Minimum 2 GB of RAM (memory).
  • Hard disk drive with at least 200MB of free disk space for Andica MTD VAT Bridging Software and data files.
  • A CD-ROM drive (only required for software purchased on CD. This is not necessary for software purchased as download).
  • Minimum screen resolution of 1024x768 or higher.
  • Windows Display default text size of 100% or DPI settings of Normal Size 96 DPI. Screen resolution and text settings will ensure the software user interface is displayed correctly. Screen resolution and Display settings can be modified in Windows Control Panel.
  • An unrestricted broadband internet connection is required for product licensing and submission of returns online.
  • Internet Explorer version 10 or higher or another compatible browser

Other considerations:

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.

Top