CSV Generator Tool
An easy way of preparing a CSV file is to use the 'CSV Generator Tool,' a pre-prepared Excel workbook that is downloaded from the "Intrastat Internet System" or available here, save on your PC for future use.
The file contains 5 worksheets:
The trader CSV file has one header row with subsequent lines for data.
The agent CSV file has two header rows with subsequent lines for data.
Preparing a file
Using the helpfile and the example worksheet copy your data over the example data.
Saving a file
Prepare your file then saves as a CSV a save as option in Excel.
Submitting a file
The prepared file is uploaded through the "CSV File Upload" function. During submission the file is validated, any errors found will generate an Error Submission screen (at this point the submission terminates.) Files without errors will generate a Please Confirm Submission screen, to transmit the file click the Confirm button the Cancel button will abort the file.
Please note: only error free files can be transmitted.