NJT VAT Return Manager (MTD)

(Bridging software for online filing of the MTD compliant VAT Returns to Her Majesty's Revenue and Customs)

How to Install on a Server & Configure Excel



The bridging software can be stored on a File Server on your computer network. You just need to Map a drive to a location on your server, for example 'Z:\' then create a folder. For example: 'Z:\My VAT Returns'

How to Install
  1. Create a folder on your File Server. For example, "Z:\My VAT Returns".

  2. Download the 'NJT VAT Return Manager (MTD)' workbook, then (move or save) it to the new folder, for example, "Z:\My VAT Returns".
    Note 1: Alternatively, the software can be downloaded during the purchasing process.

    Click on the button to download the MTD VAT Return Manager (Live evaluation).

    (For further information on purchasing, see the 'Software Purchase & Renewal' section via the menu item 'VAT Return Manager (MTD)'.

    Note 2: The download process may vary depending upon which Interent browser you use and the browser's configuration.
    Note 3: 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 'NJT VAT Return Manager (MTD)' 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, "Z:\My VAT Returns"). 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.


Introduction

The bridging software can be stored on a File Server on your computer network. You just need to Map a drive to the folder located on your server. For example: 'Z:\My VAT Returns'

The software within the Excel workbook, is a 'Single User' application. This means it can be opened for editing by only One User at any one time.
However, when an attempt is made to open the workbook that is already being used by another User, it can be opened in 'Read Only' or 'Notify' mode. Whilst opened in 'Read Only' or 'Notify' mode, the User can view and navigate as normal, however, all updating functions are disabled.



MTD File in Use Image
Option 1: Open in 'Read Only' Mode

Whilst in 'Read Only' mode, You can use the software to navigate, search, print, save as PDF, and display payments and liabilities.

When complete, click on the 'Close Workbook' button on the Dashboard.


Option 2: Open in 'Notify' Mode

Whilst in 'Notify' mode, You can use the software to navigate, search, print, save as PDF, and display payments and liabilities.

When the User, editing the software, saves and closes the workbook, the 'File Now Available' message will be displayed and you will be prompted to re-open the workbook in 'Read-Write' mode or 'Cancel'.


MTD File Available Image

If you click on the 'Read-Write' button, the 'File Changed' message will be displayed.

If you click on the 'Cancel' button, you can close the workbook, via the 'Close Workbook' button.


MTD File Changed Image

Always click on the 'Discard' button. (See Important Note below).

The workbook will be re-opened and you can then continue using the workbook as normal.


Important Note

When you open the workbook in 'Notify' mode, the software automatically refreshes certain information within the workbook. Although this does not affect your data, Excel thinks the workbook has changed. Hence the 'File Changed' message.

Therefore you always click on the 'Discard' button.



Files created by this product are organised using a preset folder structure. Sub folders are created automatically within the folder where the workbook is located. It is recommended that the VAT Return workbook is stored in a specific folder. For example, "C:\My MTD VAT Returns".

Archive Folder: The sub folder "\Archive" is automatically created when you first use the software. After you have updated to a new version, this may be a convenient location to store your previous version. This may avoid confusion as to which is your latest version.

Receipt Files: When a draft or finalised VAT Return is saved as a PDF file it is stored, by default, to the sub folder "\Receipts". However, For each Business, the folder location can be changed, essentially allowing you to store the PDF receipts in any accessible location. Once changed, the new folder location becomes the default for that business.

Evidence Files: During each VAT Return submission, copies of the full submission and HMRC response are saved to the sub folder "\Evidence". These files are stored in Text and JSON format and can be viewed using a 'Text' editor such as NotePad or WordPad.

Data Backup Folder: Each backup created by the 'Backup Data' routine is stored in the sub folder "\Backup".

Import Folder: When you Import a VAT Return from, for example an Excel workbook, the routine first searches in the sub folder 'Import'. This may be a convenient location to store the files. However, For each Business, the file folder location is saved automatically after each import, therefore you can essentially store the files in any accessible location. This folder location then becomes the default for future imports.

Bin Folder: The sub folder "\Bin" used to store technical log files created by the software. These log files may assist in the resolution of technical issues that may occur during the use of the software.