NJT VAT Return Manager (MTD) - Soon to be available for the MTD VAT 'Public' Pilot

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

Product Summary

The 'NJT VAT Return Manager (MTD)' bridging software is an application, within 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).
HMRC refer to this as 'Bridging software' as it's function is to provide an MTD compliant digital link between accounting software and the HMRC system.

For information, HMRC only require the 9-Box totals to be submitted under the new MTD system. There are currently no plans by HMRC to implement a mandatory requirement to submit transaction level details (Supplementary Information) that support the 9-box totals.

This product contains a customised application developed in Microsoft Visual Basic for Applications (VBA). The software runs automatically when the workbook is opened and interacts with the user by displaying various User Forms (Windows). The worksheets are not accessed in the traditional way and are therefore hidden from view.




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.



  • Fully MTD compliant
  • Designed for use by single Taxpayers or Agencies that manage returns for multiple Clients.
  • Facility to retrieve the latest MTD VAT Return obligation for each Taxpayer/Client from HMRC.
  • Prepared VAT Returns can be imported directly from:
    • VT Transaction+ or VT Cashbook.
    • An Excel workbook or a CSV text file.
  • Also, prepared VAT Returns can be imported via files exported from the following systems:
    • Money Manager Version 6 (via a VAT Return Report file in 'Tab' delimited format).
    • Sage 50 Versions 18, 23 & 24 (via a VAT Return file in 'Excel' format).
    • Tally.ERP9 Series A Release 4.93 (via a VAT Return file in 'Excel' format).
  • HMRC responses can be viewed on screen, printed or saved as PDF file.
  • Facility to retrieve and view historic MTD VAT Returns from HMRC. For example, where previous MTD VAT Returns have been submitted using other software.
  • Facility to retrieve and view payments and liabilities from HMRC.
  • Retains a full history of submissions and receipts returned by HMRC.
  • Facility to amend, delete and search for clients (Relevant mainly to Agency versions).
  • For the Agency versions, an 'Obligation Manager' function is available to assist the management of returns, including clients without an obligation and a chronological list of outstanding client obligations.
  • Facility to backup and restore all data. Can be used, for example, to restore data following a new product release.


This section will be populated when the product is formally released.