NJT VAT Return Manager

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

Importing from a CSV file

The following section describe the detailed technical requirements for importing from a a CSV file using the NJT standard format.

One of the main principles of Making Tax Digital is that any transfer of data must be undertaken digitally. To facilitate 3rd party Accounting systems using this software, a function will be provided to allow preprared VAT returns to be imported via a Comma Separated Variable (CSV) file. The pre-requisite being that 3rd party Accounting systems are able to generate a CSV file compliant with the following specification.

Example (MyVATReturn.csv):

Item 1: always set to "NJT_MTD_VAT" (always enclosed in speech marks)
Item 2: contains the CSV file version number, currently 1.0
Item 3: contains the Import_ID, always set to "StdCSV" (always enclosed in speech marks)
Item 4: contains the Date and Time stamp. I.e. when the CSV file was generated. Format: DD/MM/YYYY HH:MM:SS
Item 5: contains the Taxpayer or Trading Name (always enclosed in speech marks)
Item 6: contains the VAT Registration Number
Item 7: contains the Period Start Date. Format: DD/MM/YYYY
Item 8: contains the Period End Date. Format: DD/MM/YYYY
Items 9 to 17: contains values for Boxes 1 to 9. (Box 1 to 5 values should be formatted to 2 decimal places, Box 6 to 9 values should be formatted to 0 decimal places and all Box display formatting should be removed E.G. commas and currency symbols).
Note: For zero values, Boxes 1 to 5 should be set to 0.00 and Boxes 6 to 9 should be set to 0.