pixi
Ask AI
What's an 'Ideas Portal'?
DE

Report: Intrastat


Short Description

The pixi* Intrastat report is based on invoices and credits of intra-European shipments (outgoing invoices). It serves as a data basis for further processing in appropriate systems such as IDES (Destatis). The data is meant to be sent to the German Federal Statistics Office.

Open pixi* Reports application and choose the report "Intrastat" under the Sales directory.



Warning: This report is not meant to be forwarded to the German Federal Statistics Office without any changes. It is more like a database and should be changed accordingly after it was exported.


Back to top

Available Parameters

You can filter the report by multiple parameters:

  • Year: (Mandatory) Enter the year for the report.

  • Month: (Mandatory) Enter the month for the report.

  • Location: Choose the location from the dropdown list.

  • Shop: Choose the client/shop from the dropdown list.

  • Shipping Country: Choose the shipping country for the invoices from the dropdown list.

  • Business Type: Enter, which invoices should be considered. You can enter:

    • "B2B": Only invoices with order type B2B are considered.

    • "B2C": Only invoices with order type B2C are considered.

    • empty: All invoices are considered.

  • Include Returns: Choose whether returns should also be considered in the report (Yes/No).


Back to top

Columns

  • Transport Direction (Verkehrsrichtung): In case of invoices, this column contains the value "2" (invoices) and in case of returns "1" (returns).

  • Report Year (Berichtsjahr): Contains the year from the creation date of the invoice.

  • Report Month (Berichtsmonat): Contains the month from the creation date of the invoice.

  • Date (Datum): Contains the creation date of the invoice for the shown invoice line.

  • Invoice Nr. (Rechnungsnr.): Contains the invoice number for the shown invoice line.

  • Location: Contains the location ID of the invoice.

  • Destination Country (Bestimmungsland): Contains the country of the invoices shipping address. The value is taken from the "Code ISO 2" column in the countries table in pixi* Control Center.

  • Zip Code (PLZ): Contains the zipcode of the invoices shipping address.

  • Country of Origin (Ursprungsland): Contains the items country of origin which can be imported to pixi* using the <CustomsCountryOfOrigin> tag in the item import XML. The value is taken from the "Code ISO 2" column in the countries table in pixi* Control Center.

  • Customs Tariff Number (Warennummer): Contains the items tariff number which can be imported to pixi* using the <CustomsTariffNumber> tag in the item import XML. If no tariff number was imported, the items barcode is shown in this column.

  • Customer Tariff Text (Warenbezeichnung): Contains the items tariff text which can be imported to pixi* using the <CustomsTariffText> tag in the item import XML. If no tariff text was imported, the items barcode and name are shown in this column.

  • Weight (Eigenmasse): Contains the item weight rounded to full kilograms.

  • Item Quantity (Besondere Maßeinheit): Contains the ordered quantity of the invoice line.

  • Net Invoice Amount (Rechnungsbetrag netto): Contains the net sum amount of the invoice line (incl. discount).

  • Net Shipping Costs (Versandkosten netto): Contains the net shipping costs which were split proportionally to the invoice line. The value is calculated from: Net Shipping Costs / number of invoice lines.

  • Net Voucher Amount (Gutscheinbetrag netto): Contains the net voucher amount which was split proportionally to the invoice line. The value is calculated from: Net Voucher Amount / number of invoice lines.

  • Amount in full Euros (Rechnungsbetrag in vollen Euros): It is shown in full euros and is calculated from: Net Invoice Amount + Net Shipping Costs - Net Voucher Amount.

  • Missing (Fehlt): Can contain different values:

    • "Nummer": This string is shown, if no tariff number was imported for the item. In case tariff number and text are missing, this string is also shown.

    • "Bezeichnung": This string is shown, if no tariff text was imported for the item.

    • empty: No string is shown, if both tariff number and text were imported for the item.


Additional Information

  • The report contains invoice lines in statuses "EIN" and "AUS".

  • Manual invoices and credits are not considered in this report since no shipments happen in both cases.

  • For getting information about ingoing invoices (receipts) you can use the API call pixiFederalStatisticsReport.


Back to top