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 and formats into the bridging software (See list below).



Excel workbook

(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.



CSV file

(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.



Microsoft 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)

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.



Infor CloudSuite Industrial (SyteLine) and SyteLine

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.



IRIS

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



'More' Accounts

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.



Money Manager V6

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



Pegasus Opera I

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:
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.



QuickBooks (via CSV file)

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



QuickBooks (via Excel file) - Preferred Method

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



Sage 50, 200 & Instant Accounts (via CSV file)

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 (version unspecified), Sage 50 (V10 to V22) & Sage Instant Accounts (V10 to V14).



Sage 50 & Instant Accounts (via Excel file) - Preferred Method where available

(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.



SAP Business One

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.



SAP ERP

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.
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: Version unspecified.



Solar Accounts

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.



Tally.ERP9

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.



TAS Books

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

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

Versions Tested: V6.



'VT Transaction+' or 'VT Cash Book' (Direct Import)

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.



Xero

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).