Welcome to Neilson James Technology

Neilson James Technology (NJT), based in South Manchester, is a provider of software applications and a wide range of IT support services.

Featured software includes the 'NJT VAT Return Manager (MTD)' (due for release late 2018), the 'NJT VAT Return Manager (Old Style)' and the 'NJT Bank Assistant' (each summarised below). NJT has extensive experience in developing customised Microsoft Office based applications to suit the individual customer requirements. NJT has specialist expertise in developing Excel based applications that interact with accounts software, in particular, applications supplied by VT Software Limited.

NJT additionally offers IT support services including computer maintenance and repairs, IT operational support, contingency planning, data migration and IT implementation projects. NJT possesses a wealth of operational and technical experience within the IT industry spanning over 3 decades in both the Private and Public sector.


Compatibility Checker VAT Return Manager (MTD) VAT Return Manager (Old Style) Bank Assistant
A free Microsoft Excel workbook application that checks to see if the NJT 'Old Style' and 'MTD' VAT Return software is compatible with your computer.

[Click here for more details]
A Microsoft Excel workbook application that provides a quick and secure online filing of MTD compliant VAT Returns to HMRC. Prepared VAT Returns can be imported from VT Transaction+, VT Cashbook, an Excel workbook or a CSV text file.

[Click here for more details]
A Microsoft Excel workbook application that provides a quick and secure online filing of 'Old Style' VAT Returns HMRC. Prepared VAT Returns can be imported from VT Transaction+, VT Cashbook, an Excel workbook or entered manually. The term 'Old Style' means VAT Returns submitted to the original HMRC 'None MTD' system.

[Click here for more details]
A Microsoft Excel workbook application that provides a structured approach to achieve a bank reconciliation, driven by downloaded bank statement. This product is designed as a companion application for use with 'VT Transaction+' and 'VT Cash Book' book keeping packages.

[Click here for more details]
(check to see if the NJT 'Old Style' and 'MTD' VAT Return software is compatible with your computer)

Both the 'Old Style' and 'MTD' versions of the 'NJT VAT Return Manager' require certain Windows and Excel libraries to be installed on your computer. The 'NJT Compatibility Checker' is a free Microsoft Excel workbook that checks the configuration of your machine and displays the results.
Note: This software captures and displays information only. It does not change any settings on your machine.
This may prove a useful tool to check the compatibility of your computer in advance of the 'MTD' software release later this year.

Click on the button to download the 'free of charge' NJT Compatibility Checker. Please 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'.

How to install the Compatibility checker
  1. Download the 'NJT Compatibility Checker' workbook and save to a folder on your computer.
  2. Open a blank workbook in Excel then change the Options as described in the 'Excel Configuration' section below. Then exit Excel.
  3. Finally, Open the 'NJT Compatibility Checker' workbook.
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 path of the folder where you saved the VAT Return Manager (MTD) workbook. 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.
(Online filing of MTD compliant VAT Returns to Her Majesty's Revenue and Customs)

The 'NJT VAT Return Manager (MTD)' is a Microsoft Excel workbook that provides a quick and secure online filing of MTD compliant VAT Returns to Her Majesty's Revenue and Customs (HMRC). Prepared VAT Returns can be imported from VT Transaction+, VT Cashbook, an Excel workbook or a CSV text file.
[Click here to see latest MTD Development news]


Sample Screenshot: Example of where a VAT Return has been submitted to HMRC (may be subject to change).


MTD Dashboard3
Summarised Features:
  • Fully MTD compliant.

  • Designed for use by single Taxpayers or Agencies that manage returns for multiple clients.

  • VAT returns can be imported directly from VT Transaction+, VT Cash Book, an Excel workbook or from a CSV file.

  • Completed 'Fulfilled' VAT Returns can be viewed on screen, printed or saved as a PDF file. Rejected submissions can be imported again then re-submitted.

Minimum System Requirements

Microsoft Windows: Windows 7 onwards. Both Windows '32-bit' and '64-bit' versions are supported.
Microsoft Excel: Excel 2007 (service pack 3) onwards. Note: only Excel '32-bit' versions are supported.
This software also requires Microsoft Internet Explorer to be installed (version 11 onwards is recommended), Plus a reliable internet connection.

(Online filing of 'Old Style' VAT Returns to Her Majesty's Revenue and Customs legacy system)

The 'NJT VAT Return Manager (Old Style)' is a Microsoft Excel workbook that provides a quick and secure online filing of 'Old Style' VAT Returns to Her Majesty's Revenue and Customs (HMRC). HMRC normally accepts submissions within 15 seconds. The term 'Old Style' means submission of VAT Returns to the original HMRC 'None MTD' system.


VAT Dashboard
Summarised Features:
  • Designed for use by single Traders or Agencies that manage returns for multiple clients. VAT returns can be imported directly from VT software bookkeeping products, from an Excel workbook template or from a pre-defined CSV layout. Alternatively, the VAT return details can be populated manually.

  • HMRC responses can be viewed on screen, printed or saved as a PDF file. Rejected submissions can be amended then re-submitted. Trader Submission Status reports can be obtained from HMRC as required.

  • The product has received formal recognition by HMRC for Live submissions and is fully compliant with HMRC security and encryption requirements.

  • The Product is listed on the official UK Government website, which can be viewed via www.GOV.UK. Search for 'VAT Returns' then scroll down and click on link 'VAT Returns and EC Sales List: commercial software suppliers'. Then click on link 'VAT: commercial software suppliers'. Then scroll down the alphabetical list to find 'Neilson James Technology'.

The minimum system requirements for use of this product are:
Microsoft Windows: Windows 7 onwards. Both Windows '32-bit' and '64-bit' versions are supported.
Microsoft Excel: Excel 2007 (service pack 3) onwards. Note: only Excel '32-bit' versions are supported.
Plus a reliable internet connection.

For a more detailed description of the NJT VAT Return Manager (Old Style) please [Click Here].

Click on the respective buttons to download the VAT Return Manager (Test evaluation) and/or the VAT Return Form. Please 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'.

(Perform VT Transaction+ Bank Reconciliations from downloaded Bank Statements)

The 'NJT Bank Assistant' is a Microsoft Excel workbook that provides a structured approach to achieve a bank reconciliation, driven by the bank statement. Internet banking is required to download your bank statement, which is then imported into the workbook. This product is designed as a companion application for use with 'VT Transaction+' and 'VT Cash Book' book keeping packages supplied by VT Software Limited.


BA Dashboard
Summarised Features:
  • Import bank statements downloaded in 'Excel/CSV' format. Currently supports Barclays, Co-Op, HSBC Bank and Credit Cards, Lloyds, NatWest, RBS and Santander On-Line bank accounts. Additional banks can be supported on a request basis.

  • Supports multiple bank accounts including non-UK Currency accounts. For example 'Euro' bank accounts.

  • Match VT bank account transactions against the bank statement at the click of a button. Displays unmatched transactions in an Exceptions list. Highlights 'Close matches' (Called an 'Assumed Match'). Also highlights Customer & Supplier transactions that are awaiting invoice allocation.

  • A useful Administrative function called 'Create Generic Transactions', enables the creation of VT bank transactions for a range of bank statement transactions at the click of a button. For example, an empty VT File can be populated quickly by importing a bank statement for the whole accounting period.

  • Supports the processing of Bank Deposit Lists using pre-designed Excel templates including UK (Base) and Currency receipts.

  • Supports the creation & amendment of individual bank transactions from the bank statement.

  • Perform a VT bank reconciliation from within the Bank Assistant.

  • Archive 'Reconciled' bank statement transactions. This process can be reversed using the 'Recall' routine.


The minimum system requirements for use of this product are:
Microsoft Windows: Windows 7 onwards. Both Windows '32-bit' and '64-bit' versions are supported.
Microsoft Excel: Excel 2007 (service pack 3) onwards. Note: only Excel '32-bit' versions are supported.

For a more detailed description of the Bank Assistant please [Click Here].

Click on the button to download the Bank Assistant 60-day trial workbook. Please 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'.