Generating an EU Intrastat Report

The EU Intrastat Report collates the information for the monthly Intrastat Supplementary Declaration form for goods sold to or purchased from another EU member state. You can directly send the information to your tax agency or save the report as a CSV file and submit electronically, if your country permits it.

To generate an EU Intrastat Report:

Go to Reports > VAT/GST > EU Intrastat Report.
Select a subsidiary.
In the Report Type field, select Sale for Dispatches or Purchase for Arrivals.
Select a country form.
Select a reporting period. Using the date selector, select the start date in Tax Period and the end date in To. Note that Intrastat reports are submitted monthly.
In the Accounting Book field, select which accounting book will be used to generate the report. The dropdown list shows all active books associated with the selected subsidiary.

Note:
This field is available if the Multi-Book Accounting feature is enabled in your account. For more information, see Multi-Book Accounting for International Tax Reports.
To display the report, click Refresh. Note that you have to click Refresh each time you change the reporting criteria.
Important:
For saved reports in the International Tax Reporting SuiteApp, results are limited to 25,000 rows. The following note is displayed at the bottom of the page for truncated reports:

“The results of this report are too large. Please narrow your results.” If you want to request for an increase in the limit, you must file a support case through the NetSuite Partner Center.

The following countries have specific conditions for transaction consolidation in saved reports:
- For the Netherlands, transaction lines with values less than 200 Euros are consolidated per member state and declared as one transaction. For consolidated transactions, the value of Commodity Code is 9950 0000. Credit memos and vendor credits are not consolidated. Instead, the report displays the amounts as negative numbers for these transactions.
- For Belgium, transaction lines with the same values of Commodity Code, Member State, NOTC, Region of Origin, Mode of Transport, and Incoterm are consolidated and declared as one transaction. For consolidated transactions, Net Mass, Value in Euro, and Supplementary Unit columns are added.
- For Denmark, transaction lines with the same values of Commodity Code, Member State, and NOTC are consolidated and declared as one transaction.
Review the report. Take note of the following when reviewing reports:
- Review all pages of the report.
- to To specify the number of rows displayed on each page, go to the General subtab in Home > Set Preferences.
- Column headers vary depending on the country form selected.
- For some country forms, you can click the customer name to view the customer record or click the reference number to view transaction record.
Check the Exclude box for each transaction that you want to omit from your report. You can also click Mark All or Unmark All.
To save the report, click any of the following options:
- Print - to generate a PDF version of the report that you can print or save for your own records. Lines with the Exclude box checked are not included in the PDF.
- Export to Excel - to save the Intrastat report as a Microsoft Excel (.xls) file. Lines with the Exclude box checked are not included in the .xls file.

Electronic Filing of Intrastat Reports

For Belgium, Denmark, Finland, Germany, the Netherlands, and United Kingdom, NetSuite’s International Tax Reports SuiteApp lets you export Intrastat reports in a format acceptable for upload to the tax agency website.

You can export the report in electronic format and upload the file to the tax agency website. The following are the formats used for EU Intrastat Filing:

When you select a Netherlands subsidiary on the EU Intrastat Report page, click Export to ASCII to generate an ASCII file of the report.
When you select a Belgium, Finland, Germany, or UK subsidiary on the EU Intrastat Report page, click Export to CSV to generate a CSV file of the report.

Important:
When asked to open or save a CSV file, click Save File. Opening the file in Microsoft Excel causes the format to change. Save the file first, and then if you want to open it, use a text editor such as Notepad.
When you select a Belgium subsidiary on the EU Intrastat Report page, click Export to XML to generate an XML file of the report.
When you select a Denmark subsidiary on the EU Intrastat Report page, click Export to Excel to generate an XLS file of the report.

Customizable EU Intrastat Reports

The following customizable EU Intrastat reports can be used by any EU country, and are available from Reports > Saved Reports.

Intrastat Purchases Report [Custom]
Intrastat Sales Report [Custom]

For information about how to customize a report, see Report Customization.

To generate an EU Intrastat Report:

Electronic Filing of Intrastat Reports

Customizable EU Intrastat Reports

Related Topics: