Edit

Share via

Netherlands Intrastat

  • Article

The Intrastat page is used to generate and report information about trade among European Union (EU) countries/regions. The Netherlands Intrastat declaration contains information about the trade of goods for reporting.

The following table lists the fields that are included on the Intrastat report. Some of the fields are available on arrivals while others are available on dispatches. If the field is available, we have indicated that it's included. If it's not available, we have indicated that it's not included. When there is a fixed field value, the value is provided in the table.

Field Description Arrivals Dispatches
Record type Fixed text indicating the start of the report. "9801" "9801"
PSI/Agent VAT number The Dutch value-added tax (VAT) number (BTW-nummer) of the company that is providing the statistical declaration to Statistics Netherlands. It consists of nine digits, the letter B, and then two more digits (for example, 123456789B01).
(PSI is an abbreviation for "party liable to provide statistical information.")		 Yes Yes
Reporting period The period (year and month) that the declaration applies to. Yes Yes
PSI/Agent name The name of the company that is providing the statistical declaration to Statistics Netherlands. Yes Yes
Statistics Netherlands registration number The software registration number. Yes Yes
Version number The software version number. Yes Yes
Creation date and time The date and time of the report creation. Yes Yes
PSI/Agent telephone number The telephone number of the PSI or agent. Yes Yes
Transaction period The year and month when the transfer of commodities occurred. Yes Yes
Flow An indication of the nature of the commodity flow. Yes Yes
Reporting agent's VAT number The VAT number of the trader that the information is provided for. It consists of nine digits, the letter B, and then two more digits (for example, 123456789B01). Yes Yes
Country of origin The country or region where the commodities were produced or manufactured. No Yes
Partner member state The country or region of origin (the country or region that the commodities were transported to the Netherlands from).
Alternatively, the country or region of destination (the country or region that the commodities are intended to be transported to).		 Yes Yes
Mode of transport The way that the commodities are transported to or from the Netherlands. Yes Yes
Container This field doesn't apply for Intrastat. "0" "0"
Traffic region/port This field doesn't apply for Intrastat. "00" "00"
Statistical system This field doesn't apply for Intrastat. "00" "00"
Commodity code The eight-digit commodity code according to the Combined Nomenclature. Yes Yes
Taric This field doesn't apply for Intrastat. "00" "00"
Weight The weight rounded off in kilograms. Yes Yes
Special measure The supplementary unit. Yes Yes
Invoice value The value that the seller charges to the buyer. This value must be specified in euros. Yes Yes
Statistical value This field doesn't apply for Intrastat. "0000000000" "0000000000"
Administrative number The invoice number. Yes Yes
Transaction The nature of the agreement that forms the basis for the delivery of commodities. No Yes
Partner ID The customer's foreign VAT number in an EU member state. No Yes
Record type (end record) Fixed text indicating the end of the report "9899" "9899"

Set up Intrastat

From the Global repository, import the latest version of the following Electronic reporting (ER) configurations:

  • Intrastat model
  • Intrastat report
  • Intrastat (NL)

For more information, see Download ER configurations from the Global repository of Configuration service.

Set up VAT IDs

Create registration type for company code

  1. Go to Organization administration > Global address book > Registration types > Registration types.
  2. On the Action Pane, select New to create the registration type for the VAT ID.
  3. In the Enter registration type details dialog box, in the Name field. enter a name for the new registration type. For example, enter VAT ID.
  4. In the Country/region field, select NLD.
  5. Select Create.

You also have to create VAT ID registration types for all the countries or regions that your company does business with.

Match the registration type with registration category

  1. Go to Organization administration > Global address book > Registration types > Registration categories.
  2. On the Action Pane, select New to create new link between registration type and registration category.
  3. For the registration type for the VAT ID, select the VAT ID registration category.
  4. Repeat steps 2 through 3 for the other countries/regions' registration types that you created earlier.

Set up a VAT ID of data provider for your company

  1. Go to Organization administration > Organizations > Legal entities.
  2. In the grid, select your company.
  3. On the Action Pane, select Registration IDs.
  4. On the Registration ID FastTab, select Add.
  5. In the Registration type field, select the registration type that you created earlier.
  6. Enter your company's data provider VAT ID.

Create Customer's VAT registration number:

  1. Go to Accounts receivable > Customers > All customers and in the grid select a customer.
  2. On the Action Pane on the Customer Tab, in the Registration section select Registration IDs.
  3. On the Registration ID FastTab select Add to create new registration ID.
  4. In the Registration type field select the registration type that you created on the Create registration type for company code step.
  5. In the Registration number field enter the company's VAT number.
  6. On the Action Pane select Save and close the page.

For more information, see Registration IDs.

Alternatively, you can create Customer's VAT registration numbers using Tax exempt number page:

  1. Go to Tax > Setup > Sales tax > Tax exempt numbers.

  2. For each tax-exempt number, create a record that includes the following information:

    • In the Country/region field, select the tax registration of the counterparty.
    • In the Tax exempt number field, enter the tax-exempt number of the counterparty.
    • In the Company name field, enter the name of the counterparty.

  3. Go to Accounts receivable > Customers > All customers and in the grid select a customer.

  4. On the Invoice and delivery FastTab, in the Sales tax section, in the Tax exempt number field select the registration number created on the previous step.

Set up foreign trade parameters

  1. Go to Tax > Setup > Foreign trade parameters.
  2. On the Intrastat tab, on the Electronic reporting FastTab, in the File format mapping field, select Intrastat (NL).
  3. In the Report format mapping field, select Intrastat report.
  4. On the Commodity code hierarchy FastTab, in the Category hierarchy field, select Intrastat.
  5. In the Transaction code field, select the transaction code for property transfers. You use this code for transactions that produce actual or planned transfers of property against compensation (financial or otherwise). You also use it for corrections. Companies in the Netherlands use two-digit transaction codes.
  6. In the Credit note field, select the transaction code for the return of goods. You use this code for the return of goods after the transaction that was originally recorded under the transaction code.
  7. On the Country/region properties tab, in the Country/region field, list all the countries or regions that your company does business with. For each country that is part of the EU, in the Country/region type field, select EU, so that the country appears on your Intrastat report.
  8. On the Agent tab, on the Agent FastTab, enter information about the company that is providing the statistical declaration to Statistics Netherlands.

Set up product parameters for the Intrastat declaration

  1. Go to Product information management > Products > Released products.

  2. In the grid, select a product.

  3. On the Foreign trade FastTab, in the Intrastat section, in the Commodity field, select the commodity code.

  4. In the Origin section, in the Country/region field, select the product's country or region of origin.

  5. On the Manage inventory FastTab, in the Net weight field, enter the product's weight in kilograms.

  6. Go to Tax > Setup > Foreign trade > Compression of Intrastat, and select the fields that should be compared when Intrastat information is summarized. For Netherlands Intrastat, select the following fields:

    • Commodity
    • Transaction code
    • Country/region of origin
    • Transport
    • Country/region of sender
    • Country/region
    • Correction
    • Tax exempt number
    • Direction
    • Invoice

Set up transport parameters for the Intrastat declaration

Follow these steps to set up the transport method and assign a transport mode to a mode of delivery.

  1. Go to Tax > Setup > Foreign trade.
  2. On the Action Pane, select New.
  3. In the Transport field, enter a unique code. Note that companies in the Netherlands use one-digit transport codes.
  4. Go to Procurement and sourcing > Setup > Distribution > Modes of delivery.
  5. In the grid, select a mode of delivery.
  6. On the Foreign trade FastTab, in the Transport field, select the corresponding transport.

Intrastat transfer

On the Intrastat page, on the Action Pane, you can select Transfer to automatically transfer the information about intracommunity trade from your sales orders, free text invoices, purchase orders, vendor invoices, vendor product receipts, project invoices, and transfer orders. Only documents that have an EU country as the country or region of destination or consignment will be transferred.

You can also manually enter transactions by selecting New on the Action Pane.

Generate an Intrastat report

  1. Go to Tax > Declarations > Foreign trade > Intrastat.

  2. On the Action Pane, select Output > Report.

  3. In the Intrastat Report dialog box, set the following fields.

    Field Description
    From date Select the start date for the report.
    To date Select the end date for the report.
    Generate file Set this option to Yes to generate a .txt file for your Intrastat report.
    File name Enter the name of the .txt file.
    Generate report Set this option to Yes to generate an .xlsx file for your Intrastat report.
    Report file name Enter the name of the .xlsx file.
    Only corrections Set this option to Yes to generate an Intrastat report that includes only corrections.

  4. Select OK, and review the generated reports.

Example

This example shows how to post arrivals and dispatches for Intrastat by using the DEMF legal entity.

Preliminary setup

  1. Go to Organization administration > Organization > Legal entities, and select the DEMF legal entity.

  2. On the Addresses FastTab, select Edit, and then, in the Country/region field, select NLD (Netherlands).

  3. Import the latest version of the following ER configurations:

    • Intrastat model
    • Intrastat report
    • Intrastat (NL)

Create registration types for company codes

  1. Go to Organization administration > Global address book > Registration types > Registration types.
  2. Verify that VATID registration type for German VAT ID have been created.
  3. On the Action Pane, select New to create the registration type for the VAT ID.
  4. In the Enter registration type details dialog box, in the Name field enter VAT ID.
  5. In the Country/region field, select NLD.
  6. Select Create.

Match the registration type with registration category

  1. Go to Organization administration > Global address book > Registration types > Registration categories.
  2. Verify that registration type VATID for Germany have been matched with the VAT ID registration category.
  3. On the Action Pane, select New to create new link between registration type and registration category.
  4. For the registration type VAT ID, select the VAT ID registration category.

Set up a VAT ID of data provider for your company

  1. Go to Organization administration > Organizations > Legal entities.
  2. In the grid, select DEMF.
  3. On the Action Pane, select Registration IDs.
  4. On the Registration ID FastTab, select Add.
  5. In the Registration type field, select VAT ID.
  6. In the Registration number field enter 000099998B57.

Set up Customer's VAT registration number:

  1. Go to Accounts receivable > Customers > All customers and in the grid select DE-016.
  2. On the Action Pane on the Customer Tab, in the Registration group select Registration IDs.
  3. On the Registration ID FastTab select Add to create new registration ID.
  4. In the Registration type field select VATID.
  5. In the Registration number field enter DE0234.
  6. On the Action Pane select Save and close the page.

Set up foreign trade parameters

  1. Go to Tax > Setup > Foreign trade > Foreign trade parameters.
  2. On the Intrastat tab, on the General FastTab, in the Transaction code field, select 11.
  3. On the Electronic reporting FastTab, in the File format mapping field, select Intrastat (NL).
  4. In the Report format mapping field, select Intrastat Report.
  5. On the Commodity code hierarchy FastTab, in the Category hierarchy field, verify that Intrastat is selected.
  6. On the Country/region properties tab, select New.
  7. In the Party country/region field, select NLD.
  8. In the Country/region type field, select Domestic.
  9. In the Party country/region field, select DEU. Then, in the Country/region type field, select EU.
  10. On the Agent tab, on the Agent FastTab, in the Contact information section, in the Telephone field, enter 12345678901.
  11. In the Sales tax section, in the Tax exempt number field, enter 123456789B01.

Set up product information

  1. Go to Product information management > Products > Released products.
  2. In the grid, select D0001.
  3. On the Foreign trade FastTab, in the Intrastat section, in the Commodity field, select 100 200 30.
  4. In the Origin section, in the Country/region field, select NLD.
  5. On the Manage inventory FastTab, in the Weight measurements section, in the Net weight field, enter 2.
  6. On the Action Pane, select Save.
  7. In the grid, select D0003.
  8. On the Foreign trade FastTab, in the Intrastat section, in the Commodity field, select 100 200 30.
  9. In the Origin section, in the Country/region field, select DEU.
  10. On the Manage inventory FastTab, in the Weight measurements section, in the Net weight field, enter 5.
  11. On the Action Pane, select Save.

Change the site address

  1. Go to Warehouse management > Setup > Warehouse > Sites.
  2. In the grid, select 1.
  3. On the Addresses FastTab, select Edit.
  4. In the Edit address dialog box, in the Country/region field, select NLD.
  5. Select OK.

Set up transport parameters

  1. Go to Tax > Setup > Foreign trade > Transport method.
  2. On the Action Pane, select New.
  3. In the Transport field, enter 3.
  4. In the Description field, enter Transport by road.
  5. Go to Procurement and sourcing > Setup > Distribution > Modes of delivery.
  6. In the grid, select 10.
  7. On the Foreign trade FastTab, in the Transport field, select 3.

Create a sales order with an EU customer

  1. Go to Accounts receivable > Orders > All sales orders.
  2. On the Action Pane, select New.
  3. In the Create sales order dialog box, on the Customer FastTab, in the Customer section, in the Customer account field, select DE-016.
  4. On the General FastTab, in the Storage dimensions section, in the Site field, select 1.
  5. In the Warehouse field, select 11.
  6. Select OK.
  7. On the Header tab, on the Delivery FastTab, in the Misc. delivery info section, in the Mode of delivery field, select 10.
  8. On the Lines tab, on the Sales order lines FastTab, in the Item number field, select D0001. Then, in the Quantity field, enter 10.
  9. On the Line details FastTab, on the Foreign trade tab, verify that the Transaction code, Transport, Commodity, and Country/region of origin fields are automatically set.
  10. On the Action Pane, select Save.
  11. On the Action Pane, on the Invoice tab, in the Generate group, select Invoice.
  12. In the Posting invoice dialog box, on the Parameters FastTab, in the Parameter section, in the Quantity field, select All.
  13. Select OK to post the invoice.

Transfer the transaction to the Intrastat journal and review the result

  1. Go to Tax > Declarations > Foreign trade > Intrastat.

  2. On the Action Pane, select Transfer.

  3. In the Intrastat (Transfer) dialog box, in the Parameters section, set the Customer invoice option to Yes.

  4. Select Filter.

  5. In the Intrastat Filter dialog box, on the Range tab, select the first line, and verify that the Field field is set to Date.

  6. In the Criteria field, select the current date.

  7. Select OK to close the Intrastat Filter dialog box.

  8. Select OK to close the Intrastat (Transfer) dialog box, and review the result. The line represents the sales order that you created earlier.

    Line that represents the sales order on the Intrastat page.

  9. Select the transaction line, and then select the General tab to view more details.

    Sales order details on the General tab of the Intrastat page.

  10. On the Action Pane, select Output > Report.

  11. In the Intrastat Report dialog box, on the Parameters FastTab, in the Date section, select the month when the sales order is created.

  12. In the Export options section, set the Generate file option to Yes. Then, in the File name field, enter the required name.

  13. Set the Generate report option to Yes. Then, in the Report file name field, enter the required name.

  14. Select OK, and review the report in .txt format that is generated. The following table shows the values in the example report.

    Field Value
    Record type 9801
    PSI/Agent VAT number 123456789B01
    Reporting period 202108
    PSI/Agent name Finanzamt Berlin
    Creation date and time 20210826074437
    PSI/Agent telephone number 12345678901
    Transaction period 202108
    Flow 7
    Reporting agent's VAT number 000099998B57
    Line number 00001
    Country of origin NL
    Country of origin/destination DE
    Mode of transport 3
    Container 0
    Traffic region/port 00
    Statistical system (does not apply for Intrastat report) 00
    Commodity code 10020030
    Taric 00
    Weight +0000000020
    Special measure +0000000000
    Invoice value +0000003290
    Statistical value (does not apply for Intrastat report) +0000000000
    Administrative number CIV-000165
    Transaction 11
    Partner ID DE0234
    Record type 9899

  15. Review the report in Excel format that is generated.

    Intrastat report on dispatches.

Create a purchase order

  1. Go to Accounts payable > Purchase orders > All purchase orders.
  2. On the Action Pane, select New.
  3. In the Create purchase order dialog box, in the Vendor account field, select DE-001.
  4. Select OK.
  5. On the Header tab, on the Delivery FastTab, verify that the Mode of delivery field is set to 10.
  6. On the Foreign trade FastTab, in the Transaction code field, select 1.
  7. Verify that the Transport field is set to 3.
  8. On the Lines tab, on the Purchase order lines FastTab, in the Item number field, select D0003. Then, in the Quantity field, enter 6.
  9. On the Line details FastTab, on the Foreign trade tab, in the Foreign trade section, verify that the Transaction code, Transport, Commodity and Country/region of origin fields are automatically set.
  10. On the Action Pane, on the Purchase tab, in the Actions group, select Confirm.
  11. On the Action Pane, on the Invoice tab, in the Generate group, select Invoice.
  12. On the Action Pane, select Default from. In the Default quantity for lines field, select Ordered quantity. Then select OK.
  13. On the Vendor invoice header FastTab, in the Invoice identification section, in the Number field, enter 0001.
  14. In the Invoice dates section, in the Invoice date field, select 8/26/2021 (August 26, 2021).
  15. On the Action Pane, select Post to post the invoice.

Create an Intrastat declaration for arrivals

  1. Go to Tax > Declarations > Foreign trade > Intrastat.

  2. On the Action Pane, select Transfer.

  3. In the Intrastat (Transfer) dialog box, set the Vendor invoice option to Yes.

  4. Select OK to transfer the transactions, and then review the Intrastat journal.

    Line that represents the purchase order on the Intrastat page.

  5. Review the information on the General tab for the purchase order.

    Purchase order details on the General tab of the Intrastat page.

  6. On the Action Pane, select Output > Report.

  7. In the Intrastat Report dialog box, on the Parameters FastTab, in the Date section, select the month when the purchase order is created.

  8. In the Export options section, set the Generate file option to Yes. Then, in the File name field, enter the required name.

  9. Set the Generate report option to Yes. Then, in the Report file name field, enter the required name.

  10. Select OK, and review the report in .txt format that is generated. The following table shows the values in the example report.

    Field Value
    Record type 9801
    PSI/Agent VAT number 123456789B01
    Reporting period 202108
    PSI/Agent name Finanzamt Berlin
    Creation date and time 20210826074437
    PSI/Agent telephone number 12345678901
    Transaction period 202108
    Flow 6
    Reporting agent's VAT number 000099998B57
    Line number 00002
    Country of origin/destination DE
    Mode of transport 3
    Container 0
    Traffic region/port 00
    Statistical system (does not apply for Intrastat report) 00
    Commodity code 10020030
    Taric 00
    Weight +0000000030
    Special measure +0000000000
    Invoice value +0000000965
    Statistical value (does not apply for Intrastat report) +0000000000
    Administrative number 0001
    Transaction 11
    Record type 9899

  11. Review the report in Excel format that is generated.

    Intrastat report on arrivals.