Basics
- Reported is the physical flow or movement of goods between Slovenia and other EU members
- goods that are sold or purchased,
- goods that are sent for processing or returned after processing,
- free delivery of goods
- The change of services, goods in transit, and goods from the specific list determined by the community.
- The inclusion threshold amounts to 270.000 EUR for shipping and 200.000 EUR for receiving goods.
Source: http://www.rs-biro.si/splosne-informacije-o-intrastatu/
Useful documentation:
- https://www.stat.si/StatWeb/DataCollection/Intrastat Basic page
- https://www.stat.si/dokument/5229/IntrastatPrirocnikXML.pdf - XML format of messages
- https://www.fu.gov.si/carina/podrocja/nomenklatura_uvrscanje_in_taric/#c4733 - specific documents
Enabling Intrastat
Intrastat is enabled by ticking the Intrastat feature in Settings - Your company
Tick Intrastat and save changes.
When the changes are saved, refresh MetaKocka.
Enabling customs tariff, country of origin, and entry of product weight
Firstly, enabling the option to add the customs tariff, country of origin, and product weight is required.
This can be done by going to Settings/Your Company
For additional fields - products, tick Customs tariff and Weight.
save changes
When changes are saved, MetaKocka will refresh.
Entering Customs tariffs
Customs tariffs are entered by:
1. going to Settings/Registers
2. among selected registers, select Customs tariffs
4. enter the Value and description
5. save added Customs tariffs
Manually adding customs tariffs, weight, and country of origin to a product
Customs tariff, Country of origin, and weight can now be added to the product
When Customs tariff, Country of origin, and Weight are specified, save changes.
Customs tariff, weight, and country of origin can also be imported. Click here for instructions.
Exporting Intrastat
Intrastat is exported by going to Settings/Intrastat
For data export, click on (+)
Possible methods of data export:
The data source is specified based on the document type:
- Issued invoices: domestic, foreign, and credit notes. For time comparison, the invoice date is always taken into account (regardless of the selection for ''Date type'')
- Received invoices: domestic, foreign, and debit notes. For time comparison, the selection for ''Date type'' - invoice date or invoice receipt date is taken into account.
- Goods received notes: all goods received notes - manually added, automatically based on the invoice, or sales invoice cancellation.
Entering customs tariffs
Customs tariffs are entered by going to ''Settings'' -> ''Registers'' and selecting the ''Customs tariff'' register. In the first column (Value) entering a number is required, while in the second column, the value is arbitrary (typically a number is also entered there).
Meaning of columns:
| Column | Data type: Issued invoices | Data type: Issued invoices | Data type: goods received notes |
| Net w. | (invoice quantity * product "Weight") | (račun količina * product "Weight") | (goods received note quantity * product "Weight") |
| Qty | invoice quantity | invoice quantity | goods received note quantity |
| Inv. vl. | (invoice quantity * invoice net price) | (invoice quantity * invoice net price) | (goods received note quantity * goods received note net price) |
| Old. vl. | (invoice quantity * invoice net price) | (invoice quantity * invoice net price) | (goods received note quantity * goods received note net price) |
Verifying the missing weight
If weight should not be reported to Intrastat, the feature that validates whether the products contain weight can be disabled.
In that case, there will be no validation but if the weight is recorded for the product in the ''Weight'' field, it will be reported either way.
If the weight is recorded only for some products, it is suggested to record it for all products
Verifying Taric code
In case of the wrong Taric code, Intrastat import will display the following errors:
The ''Postavka'' number corresponds to the data output order in the MK report.
An Individual Taric code can be verified on the official web page of the Statistical office.
- https://ecarina.carina.gov.si/wps/portal/ecarina/home/dobrodosli/
- Link "Nomenklatura"
3. If the search finds no results, then the customs tariff does not exist and it should be adjusted accordingly.
The length of the customs tariff is too long
The entered customs tariff is too long if the following error is displayed
Wrong Parity
The parity code is determined according to INCOTERMS (Intrastat code) where the 3-letter codes represent the values. The register is provided in the document https://www.stat.si/dokument/8829/NAVODILA_ZA_PE_2016.pdf. If the value is wrong, the following error will be displayed upon import. DAP code is typically used for online stores.
Automatically and manually determining the type of business transaction
By default, the type of business transaction is set to ''11 - Direct purchase/sale''. This value is automatically set to ''21 - Return of goods'' value in the following cases:
- a credit note is automatically created through invoice cancellation, deleting an Order Management order, importing orders, etc.
- a credit note is added manually to the sales page for recently added products without the type of business transaction being manually specified.
The pre-condition is that the user for the ''type of business transaction'' enters ''21'' for the value.
Such values are valid from 13.9.2019 onwards.
For each product, it is possible to manually add the type of business transaction separately. This is possible with the following documents:
- Sales domestic invoice/foreign/credit note
- Purchase domestic invoice/foreign/debit note
- goods received note
If the goods received note is automatically created based on the purchase invoice, it will have the same values for the type of business transaction as the purchase invoice.
The register of the type of business transaction can be downloaded from the Statistical Office webpage - http://www.stat.si/dokument/5243/VrstaPosla.xls
Considering sets (components) for reporting
If the product is a set, then its components are used for the Intrastat report in the following cases:
- if the parent product is a set
- if the parent product has no customs tariff - otherwise, the parent product will be used for reporting
Moreover, the numbers will be adjusted in the following way:
- quantity: quantity of parent product + quantity of components
- value: if one component has a purchase price recorded, the proportion of purchase prices will be used for distribution. Otherwise, the values will be equally distributed among products.
For example, product ''Master'' comprises 1x cter1 and 2x cter2 products. Both have the indicated Purchase price and proportion accordingly. Moreover, 2x Master products are received for the purchase price of 100 EUR. Since this product represents a set, the following will be taken into account in Intrastat:
Quantities:
- cter1: 2 (Master quantity) * 1= 2
- cter2: 2 (Master quantity) * 3= 6
Values a piece:
- Note: total value is 1 * 20 + 3 * 5 = 35
- cter1: 2 (Master quantity) * 100 (Master price) * (1 * 20) / 35 (purchase price factor)/1 (cter1 quantity) = 200 * 20 / 35 = 114.29
- cter2: 2 (Master quantity) * 100 (Master price) * (3 * 5) / 35 (purchase price factor) / 3 (cter2 quantity) = 200 * 15 / 35 / 3 = 28.57
Note: if a product has a purchase value, the distribution by purchase prices will be used. If one set has a purchase value, and the other does not, the other set will automatically have 0 as a value and will not be part of the Intrastat report. Therefore, when adding purchase values, such must be added for all products.
If the ''Master'' product would not have a purchase price added, the quantity of components would be used for distribution. The calculation (concerning the picture of the set below) would be the following:
Quantities:
- cter1: 2 (Master quantity) * 1= 2
- cter2: 2 (Master quantity) * 3= 6
Values a piece:
- cter1: 2 (Master quantity) * 100 (Master price) * 1/2 (a set is composed of 2 products) / 1 (cter1 quantity) = 200 / 2 = 100
- cter2: 2 (Master quantity) * 100 (Master price) * 1/2 (a set is composed of 2 products) / 3 (cter2 quantity) = 200 /2 / 3 = 33.33
Error: 029027 For the goods tariff, the quantity in the additional unit of measurement must be entered.
If the system displays the following error, please provide our support with the following:
* list of all errors (since the consecutive row number would be visible that way)
* XML input file
Metakocka will verify the customs tariff entries and enter data for the output of the additional unit of measurement for that customs tariff.
Instructions for MetaKocka support: check the internal document ''Intrastat - Modifying tariff numbers''
Reporting previous periods
The Intrastat reporting period is determined based on the document date but for one month before. For example: if the document date is 10/2/2021 - the reporting period would automatically be January 2021 (1/2021).
Tax number QV999999999999
In 2022, reporting has changed somewhat, since now it also includes the sales to physical persons in EU countries. Since physical persons, typically do not leave their tax numbers, some value must be entered in the tax number field. In the data list for the report, something similar to what is displayed in the picture below will be shown.
A more detailed explanation can be found in Intrastat documentation - https://www.stat.si/StatWeb/File/DocSysFile/11270
In exceptional cases, the so-called dummy tax number QV999999999999 (QV code and 12 nines) can also be used for reporting. It is only allowed if the reporting unit that ships goods from Slovenia to another EU member country does not have the information available.
Disable warehouses
If you are shipping from foreign warehouses, such may not be included in Intrastat reporting. Example: you ship packages to 10 countries from your country. For faster delivery, you have a separate warehouse in the country of Denmark and you only ship from there. Packages come to this warehouse directly from a supplier from a third-world country (for example, China), which means that a goods rec. note will already be recorded for the acceptance of the goods.
Conditions for taking the warehouse into account:
automatically selected warehouse on the invoice (usual procedure for Order Management or any automatic invoice creation).
- warehouse on the delivery note, if only this is transferred to the invoice
the invoice has several different delivery notes that have different warehouses - in this case, only the warehouse of the first delivery is taken into account, and all values on the invoice for this warehouse only are taken into account.
You can choose one or multiple warehouses:
When data is generated, there is a special tab in the report where all excluded documents are listed.
