NJT VAT Return Demo (MTD) - Version 6.3 released on 1st July 2021
(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'
The software is compatible with Microsoft Windows and Microsoft Excel.
The software is Not compatible with Apple Mac Computers, 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 & 2013.
The most effective way to do this is to configure your computer to install 'Windows' Updates automatically
and to tick the 'Microsoft' options box.
For Windows 7 & 8, Open Windows 'Control Panel', click on 'Windows Update', then 'Change Settings'
& then turn-on 'Give me updates for Microsoft products ...'.
For Windows 10, Open Windows 'Settings' app, then click on 'Windows Settings', then 'Update & Security', then 'Advanced Options'
& then turn-on 'Give me updates for other Microsoft products ...'.
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), Excel 2010 (service pack 2) and Excel 2013 (service pack 1) onwards.
Note: Now supports both '32-bit' and '64-bit' versions of Microsoft Excel.
Plus a reliable internet connection.
Microsoft 'End of Support' Dates
When Microsoft products reach their 'End of Support' dates, they are no longer supported and do not receive security updates.
It is therefore recommended that you upgrade to later products before these dates.
Office 2007 - 10th October 2017
Office 2010 - 13th October 2020
Office 2013 - 11th April 2023
Office 2016 - 14th October 2025
Important Note for Bit Defender users
In July 2020, a new version of Bit Defender was released, which may now display incorrect error messages and prevent the NJT software from operating.
You may receive error messages as follows:
"Infected web resource detected" to https://neilsonjamestech.co.uk as accessed by EXCEL.EXE
"Infected web page detected" at https://neilsonjamestech.co.uk"
For information, the NJT Website is a secure website with a valid certificate. All NJT software is virus scanned using Windows Security, Malwarebytes and SuperAntiSpyware
before release. Additionally, the NJT software operates normally on computers protected by other 'main stream' Antivirus/AntiMalware solutions.
It appears that Bit Defender simply does not like Excel applications directly accessing the Internet via embedded software. Which of course is the intended purpose of the NJT software.
How to Resolve the Issue
- Open the Bit Defender Console
- Under "Online Threat Prevention" - Manage Exceptions
- Then save the configuration.
Important Note for OneDrive users
OneDrive is designed for synchronising or 'real-time collaboration' of single files, for example Excel workbooks.
OneDrive is not designed for applications like the NJT software, therefore it is recommended that you locate the NJT software outside the OneDrive folder.
Although the NJT software may run, you may encounter synchronisation issues as the NJT software actively creates and updates files located within
the pre-defined sub-folders.
Where OneDrive is configured to 'Collaborate on documents in real time', all files are accessed directly from the OneDrive cloud server.
(This now appears to be the default setting following a recent Microsoft update).
I.e. the folder location starts with 'https://'.
As a result, the NJT software will not function as it does not have the necessary permissions to maintain files and folders.
From Version 5.2 of the NJT software, a message is displayed upon start-up.
How to Remove the 'Collaborate on documents in real time' setting within OneDrive
- Close the NJT software where loaded.
- Within OneDrive, click on '... More'.
- Click on 'Settings'.
- Click on the 'Office' tab.
Untick the box within the 'File Collaboration' section.
Note: You may need to close then open OneDrive.
- Open the NJT software.
Important Note for Excel 2007, 2010 & 2013 users
Early releases of Excel 2007, 2010 & 2013 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.
Important Note for DropBox users
There is an outstanding defect in DropBox that affects certain installations of Microsoft Excel.
Within the NJT software, when you click on the 'Save & Close' button, you are prompted to 'Enter a Password'
and Excel freezes.
- Click on the 'Gear' icon.
- Then select 'Preferences'.
- Change the 'DropBox Badge' setting to 'Never Show'.
- Click 'Apply'.
- Click 'OK'.
How to install the 'NJT VAT Return Demo (MTD)'
Create New Folder
Create a new folder on your computer. For example, "C:\My Demo".
Tip: You may wish to create a shortcut on your Windows Desktop, which points to this folder.
Note: The actual file name of the software will change when subsequent versions are released,
so the shortcut needs to point to the Folder and not the file.
Change Excel Configuration (Options/Trust Centre)
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 Demo to function correctly, a few changes are required within the Excel Options.
Open a blank workbook in Excel. (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.
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'.
Then, click on the 'OK' button.
Finally, Exit Excel.
Download Software to Folder
Download the 'NJT VAT Return Demo (MTD)', then (move or save) it to the folder you have just created.
Click on the button to download the free demonstraion.
Note 1: The download process may vary depending upon which Internet browser you use and the browser's configuration.
Note 2: It is important that you store the software within it's own folder
as certain sub folders are automatically created when the software is opened.
Under certain circumstances the software file may remain 'Blocked' or 'Read-only':
- Open File explorer or Windows Explorer and navigate to the folder containing the software.
- Right click on the software file then click on 'Properties'.
- Remove the tick in the 'Read-Only' box where necessary.
- Unblock the file by clicking on the 'Unblock' button or 'Unblock' Tick box where necessary.
- Click 'OK'
Finally, Open the 'NJT VAT Return Demo (MTD)' software and follow the on-screen instructions.
Free Remote Support from NJT
If you are having difficulties installing the software, then you can contact NJT and arrange for assistance via the 'Remote log-in' service.
- Contact NJT and arrange a time.
[Click Here] to download the 'Splash Top' SOS software.
Run the software, then telephone NJT and give the 9-digit code when requested.
NJT will then remotely access your computer.
When the remote access session is complete, disconnect then exit the software.