NJT VAT Return Demo (MTD) - Version 2.2 released on 14th January 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'
Minimum System Requirements
Microsoft Windows: Windows 7 onwards. Both Windows '32-bit' and '64-bit' versions are supported.
Note: It is highly recommended that all Windows & Microsoft Updates are installed.
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.
How to install the 'NJT VAT Return Demo (MTD)'
Create a new folder on your computer. For example, "C:\My Demo".
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 Interent 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.
Open a blank workbook in Excel then change the Options as described in the 'Excel Configuration' section below.
Then exit Excel.
Finally, Open the workbook and follow the on-screen instructions.
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').
For Office 2007, Click on the 'Office' button as the 'File' menu does not exist.
Trusted Locations: Add the 'Location' of the folder where you saved the workbook,
(For example, "C:\My Demo"). Also tick the box 'Subfolders'.
Macro Settings: Tick the box 'Trust Access to the VBA project model'.
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'.
Recent Release History
Version 2.2 (14 Jan 2019)
Version 2.1 (08 Jan 2019)
Defect Fix - Amended 'New Version Data Transfer' routine to close the 'Progress Bar' form after an 'Invalid Backup File' message is displayed.
Minor Enhancement - User Guide Form now remains visible until closed and is positioned Top Right of screen.
Added Sage Instant Accounts V10 to the list of supported systems.
Version 2.0 (30 Dec 2018)
Minor Enhancement - Improved the 'Check New Product Version' routine to both download new versions and then automatically
transfer data via buttons.
Added Pegasus Opera V3.40 to the list of supported systems.
Version 1.5 (18 Dec 2018):
Medium Enhancement - Changed the 'Grant Authority' routine to launch the User's default Web Browser as opposed to Internet Explorer.
The Authorisation Code is now retrieved from HMRC via 'Copy' and 'Paste' buttons.
This change removes the restrictions imposed by the compulsory use of Internet Explorer.
Although an extra step is required, this process is only undertaken every 18 months.
Version 1.4 (04 Dec 2018):
Resolved the defect that returned the error message 'ActiveX component can't create object' whilst 'Building HTTP List', when opeing the Workbook.
This error was reported when using Windows 7 and Excel 2010 (64-bit).
Added QuickBooks 2014 to the list of supported systems.
Version 1.3 (26 Nov 2018):
Introduced a configurable option for the method used to retrieve obligated VAT Returns.
The choices are 'Automatic' or 'Manual'. 'Automatic' is the recommended option.
Added Sage Instant Accounts Version 20 to the list of supported systems.
Added 'Access export in Excel format' to the list of supported systems.
Within the Import Drop-Down list, reduced the number of 'Sage 50' items by combining all versions, resulting in 1 item in the list.
Version 1.2 (25 Nov 2018):
Resolved the error message "Unexpected Error (32809)",
which ocurred whilst opening the software in Excel versions 2007 and 2010.
Version 1.1 (20 Nov 2018):
Now supports both '32-bit' and '64-bit' versions of Microsoft Excel.
Introduced new facility to change the PDF Receipts default folder location for individual Business.
Applied minor defect fixes and cosmetic improvements.
Version 1.0 (18 Nov 2018):
Introduced the facility to select 'Business' or 'Agency' Licence Types.