Intrastat Export to Spreadsheet Program (R74Y030)

The Intrastat Export to Spreadsheet report (R74Y030) runs automatically from the Generate Intrastat Services Declaration-Final Step program if you set the processing option appropriately. In this case, the report runs the versions ZJDE0002, ZJDE0003, ZJDE0004, and ZJDE0005 and generates four .csv files. Two versions of the report are for services vouchers or invoices (received and supplied) and the other two are for adjustments (received and supplied). You can also generate the output file on demand, using the standalone Intrastat Export to Spreadsheet program. You can choose to run version ZJDE0001 that contains all four sections for Intrastat in the same file, or you may run versions ZJDE0002 to ZJDE0005 to generate all sections in separate files. You run the program to manually generate the declaration details in the required Microsoft Excel spreadsheet format. You must import this Microsoft Excel spreadsheet to Intr@web application because the government accepts only the declarations imported through Intr@web. You must change the file extension from .csv to .xls, to import the file successfully to Intr@web.