How to Install the 'NJT VAT Return Manager (Old Style)'

How to install
  1. Create a folder on your computer. For example, "C:\My VAT Returns".
  2. Download the 'NJT VAT Return Manager (Old Style)' workbook, then (move or save) it to the new folder, for example, "C:\My VAT Returns".
    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.
  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 (Old Style)' 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 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.

Organising Your Files

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

Receipt Files: When a receipt is saved as a PDF file it is stored automatically to the sub folder "\Receipts".

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 XML 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".

Excel Folder: When you Import a VAT Return from the 'NJT VAT Return Form' (selected via the Import Dropdown list), the routine first searches within the sub folder '\Excel'. This may be a convenient location to store the Excel forms.

CSV Folder: When you Import a VAT Return from a 3rd party Accounts CSV file (selected via the Import Dropdown list), the routine first searches within the sub folder '\CSV'. This may be a convenient location to store the CSV files.