Intrastat report

The intrastat system provides statistical information on dispatches and arrivals of goods within EU and Northern Ireland.

Each Member State in the EU have a system of automatic data processing. The companies in each Member State, report Intrastat information by electronic data transmission.

Each Member State has to define thresholds expressed in annual values of trade within EU and Northern Ireland. If below these thresholds, the company are exempted for provoding Intrastat information.

You can find more information on Intrastat in Regulation No 638/2004 of the European Parliament and the Council.

 

The Intrastat report in tracezilla

The report in tracezilla provides you with information about arrival and dispathes of goods, value of the goods, quantity and partner member state based on the data from orders, partners and SKUs (stock keeping units) in tracezilla.

The tabs in the report provides you with information about the nature of transaction.

In order to generate the report, your SKUs must have enabled the attribute EU Tariff Code, and have the eight-digit code of Customs Tariff indicated in the field Default value.

 

How to generate the report

  1. To find the report, click Warehouse in the top menu and then select Intrastat in the Reports section.
  2. Enter or select dates in the Delivery Date filter on the left. This is the period of delivery of goods. The period is also called the Reference Period in relation to intrastat.
  3. You can change the view of the report by switching the tab between Purchased, Moved, Finished and Invoiced.
  4. You can download the report by clicking the XLSX button on the right. You can also view the report in a printer-friendly version by clicking Printer Friendly.

Below you will find a description of the tabs in the report.

Note: orders with status as a draft does not appear in this report.

The informations on the tab Purchased

Column header Description
Order # Each order in tracezilla is assigned a sequential order number by type of order.

The column shows the number of the order on which the goods was purchased. Read more about purchase orders.
Supplier This is the name of the partner who delivered the goods on the purchase order. Read more about partners.
Delivery date This is the date of delivery on the purchase order. This can also be seen in the order’s Delivery Details.
Stock Keeping Unit This is the SKU code and name of the goods that have been purchased on the purchase order.  Read more about SKUs.
Country, Pick up This is the country code for the country of dispatch, ie. the country from which the goods are picked up.
Country, Deliver to This is the country code for the country of arrival, ie. the country to which the goods are delivered.
EU Tariff Code This is the eight-digit code of Customs Tariff indicated in the field Default value for the SKU. Read more about SKUs.
Net Weight The net weight is the weight of the goods without packaging.

This is the total of the net weight of the goods on the order ie. the summed net weight. When creating the SKU, you enter the net weight on the Measures and Units tab.
Amount (currency) This is the invoice value of the goods.

The currency is determined by the default currency of your company profile. You can view and change the currency by clicking on your company name and then selecting Company settings.

 

The informations on the tab Moved

Column header Description
Order # Each order in tracezilla is assigned a sequential order number by type of order.

The column shows the number of the warehouse order on which the goods has been moved. If it says (Production) in parentheses in this column, it is the number of the production order for the comsumed lots (raw materials for a production).
Pickup from This is the name of the partner from whom the goods are picked up. Read more about partners.
Delivery date This is the date of delivery on the order. This can also be seen in the order’s Delivery Details.
Stock Keeping Unit This is the SKU code and name of the goods that has been moved on the order. Read more about SKUs.
Country, Pick up This is the country code for the country of dispatch, ie. the country from which the goods are picked up.
Country, Deliver to This is the country code for the country of arrival, ie. the country to which the goods are delivered.
EU Tariff Code This is the eight-digit code of Customs Tariff indicated in the field Default value for the SKU. Read more about SKUs.
Net Weight The net weight is the weight of the goods without packaging.

This is the total of the net weight of the goods on the order ie. the summed net weight. When creating the SKU, you enter the net weight on the Measures and Units tab.
Cost price (currency) This is the calculated cost price of the goods. The cost price is calculated on the basis of the purchase price and other costs which are related to the lot, eg freight.

The currency is determined by the default currency of your company profile. You can view and change the currency by clicking on your company name and then selecting Company settings.

 

The informations on the tab Finished

Column header Description
Order # Each order in tracezilla is assigned a sequential order number by type of order.

The column shows the number of the order on which the item was produced. Read more about production orders.
Producer This is the name of the partner who produced the goods. Read more about partners.
Delivery date This is the date of delivery on the order. This can also be seen in the order’s Delivery Details.
Stock Keeping Unit This is the SKU code and name of the goods that has been produced on the order. Read more about SKUs.
Country, Pick up This is the country code for the country of dispatch, ie. the country from which the goods are picked up.
Country, Deliver to This is the country code for the country of arrival, ie. the country to which the goods are delivered.
EU Tariff Code This is the eight-digit code of Customs Tariff indicated in the field Default value for the SKU. Read more about SKUs.
Net Weight The net weight is the weight of the goods without packaging.

This is the total of the net weight of the goods on the order ie. the summed net weight. When creating the SKU, you enter the net weight on the Measures and Units tab.
Cost price (currency) This is the calculated cost price of the goods. The cost price is calculated on the basis of the purchase price for the consumed lots and other costs which are related to the lot, eg freight and analysis.

The currency is determined by the default currency of your company profile. You can view and change the currency by clicking on your company name and then selecting Company settings.

 

The informations on the tab Invoiced

Column header Description
Order # Each order in tracezilla is assigned a sequential order number by type of order.

The column shows the number of the order on which the goods was sold. Read more about sales orders.
Invoice No. This is the unique, sequential number of the invoice.
Customer This is the customer who bought the goods. Read more about partners.
Delivery date This is the date of delivery on the order. This can also be seen in the order’s Delivery Details.
Stock Keeping Unit This is the SKU code and name of the goods that has been sold on the sales order. Read more about SKUs.
Location before sale This is the country code for the country of dispatch, ie. the country from which the goods are picked up.
Location recipient This is the country code for the country of arrival, ie. the country to which the goods are delivered.
EU Tariff Code This is the eight-digit code of Customs Tariff indicated in the field Default value for the SKU. Read more about SKUs.
Net Weight The net weight is the weight of the goods without packaging.

This is the total of the net weight of the goods on the order ie. the summed net weight. When creating the SKU, you enter the net weight on the Measures and Units tab.
Amount (currency) This is the invoice value of the goods.

The currency is determined by the default currency of your company profile. You can view and change the currency by clicking on your company name and then selecting Company settings.

Outline