NJT VAT Return Manager

(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 and formats into the bridging software (See list below).
Click on the individual Title to view the details.



(The bridging software captures the details from a worksheet confirming to a 'Standard Format' as defined by NJT)

How to Import:
Select the 'Excel (Standard Format)' option from the Import dropdown list.
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.



(The bridging software captures the details from a CSV file conforming to a 'Standard Format' as defined by NJT)

How to Import:
Select the 'CSV (Standard Format)' option from the Import dropdown list.
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.



(The bridging software captures the details from an exported Access file in Excel format conforming to a 'Standard Format' as defined by NJT)

How to Import:
Select the 'Access (Exported to a Standard Excel Format)' option from the Import dropdown list.
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.



How to Export:
Export your 'VAT Return' file in 'Excel' format.

How to Import:
Select the 'Acorn Legal ('Excel' VAT Return Report)' option from the Import dropdown list.
You will be prompted to locate your 'Acorn Legal' VAT Return file (*.xlsx) then the VAT Return details will be validated and imported into the bridging software.

Versions Tested: Not specified.



How to Export:
Export your 'VAT Return' file in 'Excel' format.

How to Import:
Select the 'Avanti ('Excel' VAT Return Report)' option from the Import dropdown list.
You will be prompted to locate your 'Avanti' VAT Return file (*.xlsx) then the VAT Return details will be validated and imported into the bridging software.

Versions Tested: Version 4



How to Export:
Export your 'VAT Return' file in 'Excel' format.

How to Import:
Select the 'Exchequer ('Excel' VAT Return Report)' option from the Import dropdown list.
You will be prompted to locate your 'Exchequer' VAT Return file (*.xlsx) then the VAT Return details will be validated and imported into the bridging software.

Versions Tested: Version 2018.



How to Export:
Export your 'VAT Return' file in 'CSV' format.

How to Import:
Select the 'FBA-Promar ('CSV' VAT Return Export)' option from the Import dropdown list.
You will be prompted to locate your 'FBA-Promar' VAT Return file (*.csv) then the VAT Return details will be validated and imported into the bridging software.

Versions Tested: V3.39



How to Export:
This system has been enhanced to export VAT Returns that conform to the NJT 'Excel (Standard Format)'.

How to Import:
Select the 'Excel (Standard Format)' option from the Import dropdown list.
You will be prompted to locate your Infor SyteLine 'VAT Return' file (*.xlsx). Then the VAT Return details will be validated and imported into the bridging software.



How to Export:
Either export your 'VAT Return' file in 'Excel' format, specifying your Period Start and End Dates.
Or export your 'VAT Return' file in Rich Text Format 'RTF', specifying your Period Start and End Dates. Then open the file in Microsoft Word and save as a 'Plain Text' file.

How to Import:
Select either the 'IRIS ('Excel' VAT Return Report)' or 'IRIS ('TXT' VAT Return Report) - Via 'RTF' file saved as Text' option from the Import dropdown list.
You will be prompted to locate your IRIS 'VAT Return' Report file (*.xls or *.txt), then the VAT Return details will be validated and imported into the bridging software.

Versions Tested: V1.5



How to Export:
Export your 'VAT Return' file in 'Excel' format.

How to Import:
Select the 'Kingswood ('Excel' VAT Return Report)' option from the Import dropdown list.
You will be prompted to locate your 'Kingswood' VAT Return file (*.xls) then the VAT Return details will be validated and imported into the bridging software.

Versions Tested: V4.3



How to Export:
Export your 'VAT Return' file in 'Excel' format.

How to Import:
Select the 'More Accounts ('Excel' VAT Return Report)' option from the Import dropdown list.
You will be prompted to locate your 'More' VAT Return file (*.xls) then the VAT Return details will be validated and imported into the bridging software.

Versions Tested: V6.0.52 Client Edition.



How to Export:
Export your 'VAT Return' Report file in 'Tab delimited' format.

How to Import:
Select the 'Money Manager V6 ('Tab' Delimited VAT Return Report)' option from the Import dropdown list.
You will be prompted to locate your MM6 'VAT Return' Report file (*.REP) then the VAT Return details will be validated and imported into the bridging software.

Versions Tested: V6 and V7



How to Export:
Export your 'VAT Return' file in 'Excel' format.

How to Import:
Select the 'MS Dynamics Accounting ('Excel' VAT Return Report)' option from the Import dropdown list.
You will be prompted to locate your 'MS Dynamics' VAT Return file (*.xlsx) then the VAT Return details will be validated and imported into the bridging software.

Versions Tested: TBC.



How to Export:
Export your 'VAT Return' file in 'Excel' or ('Txt' comma separated) format.

How to Import:
Select the 'MYOB Accounting ('Excel/Text' VAT Return Report)' option from the Import dropdown list.
You will be prompted to locate your 'MYOB' VAT Return file (*.xls or *.txt) then the VAT Return details will be validated and imported into the bridging software.

Versions Tested: V17(2008) and V18(2009).



How to Export:
Export your 'VAT Return' report in 'TXT' format.

How to Import:
Select the 'Opsis Millennium ('Txt' VAT Return Report)' option from the Import dropdown list.
You will be prompted to locate your 'VAT Return' file (*.txt) then the VAT Return details will be validated and imported into the bridging software.

Versions Tested: V5.91



How to Export:
Export your 'VAT Return' summary report in 'TXT' format.

How to Import:
Select the 'PC Law ('Txt' VAT Return Report)' option from the Import dropdown list.
You will be prompted to locate your 'VAT Return' file (*.txt) then the VAT Return details will be validated and imported into the bridging software.

Versions Tested: V13



How to Export:
Select the 'Spool' option when completing your VAT Return. The file will be saved with a '.spl' extension to your default Opera Data folder.
Alternatively, you could select the 'Email' option. This will create a draft email, within your default email applicatiion, containing an attachment with a '.txt' extension. Then save the attachment to your computer.

How to Import:
Select the 'Pegasus Opera I ('Txt' or 'Spl' VAT Return Report)' option from the Import dropdown list.
You will be prompted to locate your 'VAT Return' file (*.txt or *.spl) then the VAT Return details will be validated and imported into the bridging software.

Versions Tested: V3.40

Pegasus Opera II is not currently supported: It appears that Opera II only generates PDF files, which are not appropriate for importing into the bridging software. Some users of Opera II are currently investigating ways to print a VAT Return to a Text file using a windows 'Generic / Text Only' printer.



How to Export:
Export your 'VAT Return' report in 'TXT' format.

How to Import:
Select the 'Perfect Books ('Txt' VAT Return Report)' option from the Import dropdown list.
You will be prompted to locate your 'VAT Return' file (*.txt) then the VAT Return details will be validated and imported into the bridging software.

Versions Tested: V426



How to Export:
Export your 'VAT Return' report in 'CSV' format.

How to Import:
Select the 'QuickBooks ('CSV' VAT Return Export)' option from the Import dropdown list.
You will be prompted to locate your QBooks 'VAT Return' file (*.csv) then the VAT Return details will be validated and imported into the bridging software.

Versions Tested: 2013



How to Export:
Export your 'VAT Return' report file in 'Excel' format.

How to Import:
Select the 'QuickBooks ('Excel' VAT Return Export)' option from the Import dropdown list.
You will be prompted to locate your QBooks 'VAT Return' file (*.xls or *.xlsx) then the VAT Return details will be validated and imported into the bridging software.

Versions Tested: 2001 to 2016



How to Export:
Export your 'VAT Return' report file in 'CSV' format.

How to Import:
Select the 'Sage ('CSV' VAT Return Report)' option from the Import dropdown list.
You will be prompted to locate your Sage 'VAT Return' file (*.csv) then the VAT Return details will be validated and imported into the bridging software.

Versions Tested: Sage 200 (V7), Sage 50 (V10 to V28) & Sage Instant Accounts (V10 to V14).



(via an exported 'VAT Return' report file in 'Excel' format)
How to Export:
Export your 'VAT Return' report file in 'Excel' format.

How to Import:
Select the 'Sage ('Excel' VAT Return Report)' option from the Import dropdown list.
You will be prompted to locate your Sage 'VAT Return' file (*.xls or *.xlsx) then the VAT Return details will be validated and imported into the bridging software.

Versions Tested: Sage 50 (V16 to V24) & Instant Accounts V20.



How to Export:
Export your 'VAT Return' report file in 'Excel' format.

How to Import:
Select the 'SAP Business One ('Excel' VAT Return Report)' option from the Import dropdown list.
You will be prompted to locate your SAP 'VAT Return' file (*.xls or *.xlsx) then the VAT Return details will be validated and imported into the bridging software.

Versions Tested: V9.3



How to Export:
Export your 'VAT Return' Sales/Purchases report file in 'Excel' format.

How to Import:
Select the 'SAP ERP ('Excel' VAT Return Sales/Purchases Report)' option from the Import dropdown list.
Initially you will be prompted to locate your SAP ERP 'VAT Return' file (*.xls or *.xlsx). Secondly you populate the Mapping Table for the calculation of Boxes 1 to 2, 4, & 6 to 9. Finally the VAT Return details will be validated and imported into the bridging software.

Versions Tested: Version unspecified.

Important Note: The SAP ERP system allows users to personalise the Codes used to calculate the VAT Return box totals. Therefore, during Import, the user is presented with a 'Mapping' table, which can be populated with these personalised codes.
It is strongly recommended that you throughly test your specific SAP ERP configuration, using the Demo software, before purchasing the Live software.



How to Export:
Export your 'VAT Return' Details file in 'Excel' format.

How to Import:
Select the 'Solar Accounts ('Excel' VAT Return Detail Report)' option from the Import dropdown list.
You will be prompted to locate your Solar 'VAT Return' file (*.xlsx) then the VAT Return details will be validated and imported into the bridging software.

Versions Tested: V3.9



How to Export:
Export your 'VAT Return' report file in 'Excel' format.

How to Import:
Select the 'Tally.ERP9 ('Excel' VAT Return Report)' option from the Import dropdown list.
You will be prompted to locate your Tally 'VAT Return' file (*.xlsx) then the VAT Return details will be validated and imported into the bridging software.

Versions Tested: Series A Release 4.93 (UK)



How to Export:
Export your 'VAT Return' Details file in 'Excel' or 'CSV' format.

How to Import:
Select the 'TAS Books ('CSV/Excel' VAT Return Detail Report)' option from the Import dropdown list.
You will be prompted to locate your TAS 'VAT Return' file (*.xlsx or *.CSV) then the VAT Return details will be validated and imported into the bridging software.

Versions Tested: V6



How to Import:
Select the 'VT Transaction+ and VT Cash Book' option from the Import dropdown list.
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.



How to Export:
Export your 'VAT Return' report file in 'Excel' format.

How to Import:
Select the 'Xero ('Excel' VAT Return Report)' option from the Import dropdown list.
You will be prompted to locate your Xero 'VAT Return' file (*.xls) then the VAT Return details will be validated and imported into the bridging software.

Versions Tested: (Version unspecified).



How to Export:
Export your 'VAT Return' file in 'PDF' Format, specifying your Period Start and End Dates. Then open the 'PDF' file in Microsoft Word and save as a 'Word XML Document' file.

How to Import:
Select the 'Zoho Books ('PDF to XML via Word' VAT Return report)' option from the Import dropdown list.
You will be prompted to locate your Zoho Books file (*.xml), then the VAT Return details will be validated and imported into the bridging software.

Versions Tested: