NJT VAT Return Manager (MTD)

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

Accounting Systems Supported



Prepared VAT Returns can be imported from a variety of accounting systems into the bridging software (See list below).


  1. From 'VT Transaction+' or 'VT Cash Book'
    You will be prompted to locate your VT file then the VAT Return details will be automatically imported into the bridging software.
    Note 1: There is no need to use the 'MTD Export' button available within the VT application as the software accesses the VAT Return directly from your VT 'Company' file.
    Note 2: Direct imports are only available when using '32-bit' versions of Microsoft Excel.

  2. From an Excel workbook
    (The bridging software captures the details from a worksheet confirming to a 'Standard Format' as defined by NJT)
    Firstly, you will be prompted to locate your Excel workbook. Then the workbook will be opened and each worksheet inspected in turn. The bridging software will attempt to find a worksheet named 'MTD-VAT', then attempt to capture the VAT Return details from Cells 'B1 to 'B13'.
    The software also caters for workbooks that contain details of multiple VAT Returns, for example, an annual workbook containing the 4 quarterly VAT Returns or the 12 monthly Returns, you can create up to 12 individual worksheets named 'MTD-VAT1' to 'MTD-VAT12. The software will automatically inspect each of these worksheets and attempt to match the Period Start and End Dates to the Obligated VAT Return.
    [Click here to view the Import specification]

  3. From a CSV file
    (The bridging software captures the details from a CSV file conforming to a 'Standard Format' as defined by NJT)
    You will be prompted to locate your CSV file then the VAT Return details will be validated and imported into the bridging software.
    [Click here to view the Import specification]

  4. From an 'Access Export file' in Excel format
    (The bridging software captures the details from an exported Access file in Excel format conforming to a 'Standard Format' as defined by NJT)
    You will be prompted to locate your Excel file then the VAT Return details will be validated and imported into the bridging software.
    [Click here to view the Import specification]

  5. From Money Manager Version 6 (via an exported 'VAT Return' Report file in 'Tab delimited' format)
    You will be prompted to locate your MM6 9-Box 'VAT Return' Report file (*.REP) then the VAT Return details will be validated and imported into the bridging software.

  6. From Pegasus Opera Version 3.40 (via an exported 'VAT Return' file in 'TXT' format)
    You will be prompted to locate your 9-Box 'VAT Return' file (*.txt) then the VAT Return details will be validated and imported into the bridging software.

  7. From QuickBooks Version 2013 (via an exported 'VAT Return' file in 'CSV' format)
    You will be prompted to locate your QB 9-Box 'VAT Return' file (*.csv) then the VAT Return details will be validated and imported into the bridging software.

  8. From QuickBooks Versions '2014 to 2016' (via an exported 'VAT Return' file in 'Excel' format)
    You will be prompted to locate your QB 9-Box 'VAT Return' file (*.xlsx) then the VAT Return details will be validated and imported into the bridging software.

  9. From Sage 50 Versions '16 to 24' (via an exported 'VAT Return' file in 'Excel' format)
    You will be prompted to locate your Sage 9-Box 'VAT Return' file (*.xls or *.xlsx) then the VAT Return details will be validated and imported into the bridging software.

  10. From Sage Instant Accounts Version 10 (via an exported 'VAT Return' file in 'CSV' format)
    You will be prompted to locate your Sage 9-Box 'VAT Return' file (*.csv) then the VAT Return details will be validated and imported into the bridging software.

  11. From Sage Instant Accounts Version 20 (via an exported 'VAT Return' file in 'Excel' format)
    You will be prompted to locate your Sage 9-Box 'VAT Return' file (*.xls or *.xlsx) then the VAT Return details will be validated and imported into the bridging software.

  12. From Solar Accounts Version 3.9 (via an exported 'VAT Return' Details file in 'Excel' format)
    You will be prompted to locate your Solar 9-Box 'VAT Return' file (*.xlsx) then the VAT Return details will be validated and imported into the bridging software.

  13. From Tally.ERP9 Series A Release 4.93 (via an exported 'VAT Return' file in 'Excel' format)
    You will be prompted to locate your 9-Box 'VAT Return' file (*.xlsx) then the VAT Return details will be validated and imported into the bridging software.