NJT VAT Return Demo (MTD) - Version 3.0 released on 17th March 2019

(This free software simulates the submission of VAT Returns for businesses & agents, it does not actually communicate with HMRC)

The free 'NJT VAT Return Demo (MTD)' is a separate software product that simulates the live 'NJT VAT Return Manager (MTD)' software product.
For information, before you can use the 'Live' software product, you first need to sign up to MTD. This is because the first step is to 'Grant Authority' using your MTD VAT account.
Consequently, it is difficult to obtain a practical understanding of how the 'Live' software works. This is where the demonstration software may help to improve knowledge and awareness.

The demonstration software allows you to simulate the full 'End to End' process without being signed up to MTD. This is a perfectly safe method to familiarise yourself with the functionality of the 'Live' software' without actually communicating with HMRC. Additionally, you may wish to use this software to assist in training or to improve understanding of the required processes under MTD.

All you need to use this software, is a valid VAT Registration Number and the ability to create VAT returns in any of the formats supported by the software.
For information, you can also 'Reset' the demonstration software, via the 'Administration Routines', and repeat the processes as many times as you wish.

Please Note: The 'Demo' and 'Live' software are different products. If you wish to purchase the 'Live' software, then click on the menu item 'VAT Return Manager (MTD)' and follow the instructions within the 'Software Purchase & Renewal' section.


The software is compatible with Microsoft Windows and Microsoft Excel.
The software is Not compatible with Mac Office/Excel, OpenOffice or LibreOffice.

Minimum System Requirements

Microsoft Windows: Windows 7 onwards. Both Windows '32-bit' and '64-bit' versions are supported.
Note: All 'Important' Windows & Microsoft Updates should be installed, particularly for Excel 2007 & 2010.
The most effective way to do this is to configure your computer to install 'Windows' Updates automatically and to tick the 'Microsoft' options box.
The 'Windows Update' routine can be found within your Windows 'Control Panel'. Then click on 'Change Settings'.

Web Browser: Since the version 2.0 release, it is no longer compulsory to use the Microsoft Internet Explorer. The bridging software now automatically launches your default Web Browser when required.

Microsoft Excel: Excel 2007 (service pack 3) and Excel 2010 (service pack 2) onwards.
Note: Now supports both '32-bit' and '64-bit' versions of Microsoft Excel.

Plus a reliable internet connection.

Important note for Excel 2007 & 2010 users

Early releases of Excel 2007 & 2010 contained serious errors and security issues. Some of these errors may not be encountered during normal use. However, the bridging software uses certain advanced features of Excel, which will trigger these errors. Consequently, all 'Important' Windows & Microsoft updates should be installed as described above.

How to install the 'NJT VAT Return Demo (MTD)'
  1. Create a new folder on your computer. For example, "C:\My Demo".
  2. Download the 'NJT VAT Return Demo (MTD)' workbook, then (move or save) it to the new folder, for example, "C:\My Demo".
    Note 1: The download process may vary depending upon which Internet browser you use and the browser's configuration.
    Note 2: It is recommended that you store the workbook within it's own folder as certain sub folders are automatically created when the workbook is opened.
  3. Open a blank workbook in Excel then change the Options as described in the 'Excel Configuration' section below. Then exit Excel.
  4. Finally, Open the workbook and follow the on-screen instructions.

Excel Configuration
Microsoft has taken a much tighter approach to software security. As a result of this, some Excel features are disabled during initial installation. In order for the VAT Return Manager to function correctly, a few changes are required within the Excel Options.
Open a blank workbook. (For recent versions of Excel, Click on 'File' menu, then 'Options', then 'Trust Centre' then click on 'Trust Centre Settings').
Note: For Office 2007, Click on the 'Office' button as the 'File' menu does not exist.
  1. Trusted Locations: Add the 'Location' of the folder where you saved the workbook,
    (For example, "C:\My Demo"). Also tick the box 'Subfolders'.
  2. Macro Settings: Tick the box 'Trust Access to the VBA project model'.
  3. Finally, click on the 'OK' button.

Click on the button to download the free software.
Note: Depending on your browser configuration an additional window may be displayed before the file is downloaded. For Google Chrome, choose a folder and file name, then click 'Save'. For Internet Explorer, choose 'Save' or 'Save As'. For Fire Fox, choose 'Save File'.

Release History

Version 3.0 (17 Mar 2019) Version 2.9 (07 Mar 2019) Version 2.8 (03 Mar 2019) Version 2.7 (24 Feb 2019) Version 2.6 (17 Feb 2019) Version 2.5 (10 Feb 2019) Version 2.4 (03 Feb 2019) Version 2.3 (27 Jan 2019) Version 2.2 (14 Jan 2019) Version 2.1 (08 Jan 2019) Version 2.0 (30 Dec 2018) Version 1.5 (18 Dec 2018) Version 1.4 (04 Dec 2018) Version 1.3 (26 Nov 2018) Version 1.2 (25 Nov 2018) Version 1.1 (20 Nov 2018) Version 1.0 (18 Nov 2018)