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 allows it.

To generate an EU Intrastat Report:

  1. Go to Reports > VAT/GST > EU Intrastat Report.

  2. Select a subsidiary.

  3. In the Report Type field, select Sale for Dispatches or Purchase for Arrivals.

  4. Select a country form.

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

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

  7. To display the report, click Refresh. You need 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. You'll see the following note at the bottom of 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'll need to 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 aren't 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.

  8. 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 the reference number to view the transaction.

  9. Check the Exclude box for each transaction you want to leave out of your report. You can also click Mark All or Unmark All.

  10. To save the report, click any of these options:

    • Print – Generates a PDF version you can print or save. Lines with the Exclude box checked aren't included in the PDF.

    • Export to Excel – Saves the Intrastat report as a Microsoft Excel (.xls) file. Lines with the Exclude box checked aren't included in the 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 it to the tax agency website. These are the formats used for EU Intrastat Filing:

EU Intrastat Reports

You can customize the following EU Intrastat reports and use it for any EU country. The reports are available from Reports > Saved Reports.

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

Related Topics:

General Notices