What is Intrastat and why we compile this report?

Intrastat is EU member countries trade data collecting system, that started in year 1993. with establishing the common market and disappearance of the customs control on the EU borders.

Foreign trade statistics will be compiled based on information from Intrastat reports. It is important for monitoring EU inner market, economy and EU money euro and also for preparing political and trade negotiations. Statistics Office sends every month foreign trade statistics data to EU Statistics Office (Eurostat).

Companies who trade sales between EU countries exceeds statistic threshold established for year under review have to submit Intrastat report. Statistics Office determines the statistic threshold, based on last year foreign trade data. Determining the report obligation, both trade flows are inspected separately. Report must only be submitted about trade flow which has exceeded the statistical threshold.

Compiling Intrastat report in ERPLY Books

Only those ERPLY Books customers can compile Intrastat report, who use priced package.

  1. Open “Reports” > “Report generator”
  2. Under “Tables” choose last description “ERPLY Sales Report”
  3. Select date period and for type choose “PURCHASE_BY_INVOICE_ROWS”
  4. Then add following descriptions in Output cell:
    • label_erply_sales_report.countryCode
    • label_erply_sales_report.originCountryCode
    • label_erply_sales_report.code3
    • label_erply_sales_report.netWeight
    • label_erply_sales_report.purchasedQuantity
    • label_erply_sales_report.unitName
    • label_erply_sales_report.price
    • label_erply_sales_report.name
  1. In “Show in groups” cell add “label_erply_sales_report.code3”
  2. Then add following parameters and click “Save”

Intrastat report for sales

  • Go to “Reports” > “Report Generator”
  • In tables, choose “ERPLY Sales Report”
  • In output choose:
    • ERPLY Sales Report.code3
    • ERPLY Sales Report.soldQuantity
    • ERPLY Sales Report.grossWeight
    • ERPLY Sales Report.netWeight
    • ERPLY Sales Report.countryCode
    • ERPLY Sales Report.originCountryCode
    • ERPLY Sales Report.netSalesTotal
  • Show in groups choose “ERPLY Sales Report.code3”

Add two parameter rows:

  • Parameter: ERPLY Sales Report.countryCode
  • Type: Doesn’t Equal
  • Value: EE
  • Parameter: ERPLY Sales Report.originCountryCode
  • Type: Doesn’t Equal
  • Value: EE

In opened window choose date period and type: “SALES_BY_INVOICE_ROWS”

Intrastat report for purchases

  • Go to “Reports” > “Report Generator”
  • In tables, choose “ERPLY Sales Report”
  • In output choose:
    • ERPLY Sales Report.code3
    • ERPLY Sales Report.soldQuantity
    • ERPLY Sales Report.grossWeight
    • ERPLY Sales Report.netWeight
    • ERPLY Sales Report.countryCode
    • ERPLY Sales Report.originCountryCode
    • ERPLY Sales Report.netSalesTotal
    • ERPLY Sales Report.code
    • ERPLY Sales Report.purchasedQuantity
    • ERPLY Sales Report.price
    • ERPLY Sales Report.name
    • ERPLY Sales Report.purchaseValue
  • Show in groups choose “ERPLY Sales Report.code3”

Add four parameter rows:

  • Parameter: ERPLY Sales Report.countryCode
  • Type: Doesn’t Equal
  • Value:EE

 

  • Parameter: ERPLY Sales Report.originCountryCode
  • Type: Doesn’t Equal
  • Value: EE

 

  • Parameter: ERPLY Sales Report.originCountryCode
  • Type: Not Empty

 

  • Parameter: ERPLY Sales Report.purchasedQuantity
  • Type: More Than
  • Value: 0

In opened window choose date period and add a type: “PURCHASES_BY_INVOICE_ROWS”

NB! Raport works provided that vendor has a code (if it is not 3, then you should choose other code in report). Net weight have to be marked in ERPLY POS product card.