Information on Intrastat Product Data

In order to create the Intrastat declarations, we need a range of product information. You will receive a monthly e-mail from us with a list in case any information about products is missing. Please check this list carefully, as missing information means that we have to skip items that actually belong in the Intrastat declaration.

In the e-mail, a deadline is given by which you have to fill in the missing product information. If information is still missing after the deadline, the Intrastat declaration will be created leaving out the items with missing product information and may therefore be incomplete.

Notes on individual fields

purchasePrice

Here you have to enter the (net) purchase price of the product. The purchase price usually includes all costs associated with making the product available. If you are unsure how to determine the purchase price exactly in your case, please consult your tax advisor.

You can either use a point or a comma as the decimal separator.

Example: The purchase price of the product is € 5 and 50 cents. The following entries are correct in this case: 5.50 and 5,50

commodityCode

You have to enter the 8-digit goods number, which you can find in the index of products for the external trade statistics, in the version valid for the respective period. A list of the respective commodity codes for all chapters is available on the homepage of the Federal Statistical Office. All changes to goods numbers and special units of measurement are compiled in an overview and are available free of charge with further information under “Gegenüberstellung der geänderten Warennummern 2022 zu 2021” in PDF and Excel format.

The commodity code can have a leading zero, which must also be specified.

Tip: Format the corresponding column in your spreadsheet program as "Text" so that leading zeros are not cut off.

description

In this field, you enter the product description. This information is usually already retrieved via the connected interfaces, but there may be cases where this information is missing and must be provided by you.

countryOfOrigin

Here you enter the country in which the goods were completely obtained or manufactured. If companies from two or more countries are involved in the production of a product, the country of origin is the country in which the last significant and economically justified processing took place, provided that this was carried out in a suitably equipped company and resulted in the production of a new product or represents a significant production stage. If you do not know the exact country of origin, you should indicate the presumed country of origin.

You have to enter the ISO-Alpha-2-Countrycode. You can find a list here.

weightUnit

You have to enter the unit of measurement in which the weight of the product should be specified. Possible values are kg (kilograms), lbs (pounds) and g (grams).

weightValue

In this column you enter the net weight of the goods per unit sold (in the unit of measurement that you previously entered in weightUnit). Net mass is the mass of the goods without any enclosures. Please specify the value to 3 decimal places, if available (if the decimal places are 0, you do not need to enter them).

Example: A unit of goods weighs 525 grams. The following entries are correct in this case: 525 (if weightUnit = g) or 0.525 (if weightUnit = kg)

supplementaryUnit

Please enter the special unit of measurement per unit sold if the goods number requires this according to the index of products for the external trade statistics. The Excel file IntrastatSupplementaryUnit.xls attached to the email shows you whether a special unit of measurement is required for a certain commodity code. If ZZZ (no special unit of measure necessary), KGR (kilograms) or GRM (grams) is displayed there, you can leave supplementaryUnit and supplementaryValue empty, because the values ​​are either not required or are determined by Taxdoo. The list of possible values ​​for the special unit of measurement is also available here.

supplementaryValue

In the event that a special unit of measurement has to be specified for the product, you enter the numerical value here in the unit previously provided in the supplementaryUnit field. If no special unit of measurement is stipulated, you leave the field blank.

Example: 

natural mineral water non-carbonated

Goods number: 22011011

Special unit of measurement: LTR (liter)

In the example, the amount in liters must be specified as the "special unit of measurement". If a bottle of mineral water with a content of 750 ml has been sent, the value "0.75" must be given. Please specify the value to 3 decimal places, if available (if the decimal places are 0, you do not need to enter them).