Intrastat information includes, for example, the amount, weight and value of goods traded in the EU. These details are included in customer and vendor invoices.
Intrastat set up
To enter a ‚Tariff number‘, use the navigation panel to go to Inventory/Items and click on the ‚Add item‘ button in the toolbar/ribbon. The EU Sales ‚Tariff number‘ and ‚Country of origin‘ can be entered here as shown in the screenshot below.
(Click on screenshots to enlarge).
Item ‚Tariff numbers‘ can also be entered under Inventory/Maintenance/Item groups, as shown in the screenshot below.
The item group Tariff number will be used for an item where no Tariff number is included for the individual item.
The Intrastat report needs to include the weight to the nearest kilogram, so it may be necessary to convert the weight to kilograms here. Several ‚Unit‘ options are available, as shown in the dropdown menu in the screenshot below.
Uniconta’s Intrastat reporting function will convert the weight to the nearest kilogram. If the item weighs less than one kilogram, it will automatically be rounded up to 1 kilogram. If no unit is given, then the system assumes that the weight unit is kilograms. The example below shows the ‚Unit‘ in ‚Pcs‘ (pieces). This records the weight as 25 Kg.
(Click on the screenshot to enlarge).
These details can also be edited in the Intrastat screen before sending.
Net weight is optional for item Tariff numbers with supplementary units. The packaging weight should not be included.
Country specific websites are available detailing the weight requirements, such as the Danish site: www.dst.dk/varekoder.
Intrastat in Uniconta
Select the period for the Intrastat report. Select ‚Import‘ and/or ‚Export‘ and click the ‚Search‘ button.
Description of Intrastat column headings
Field transfer type
Description of buttons/functions in Intrastat
The file can be saved in a folder on a local PC and named as wished. In Denmark, for example, the file is then uploaded to the Danish Statistics site: IDEP.web as shown below.
Choose ‚Dataimport‘ and the import format ‚NY INTRA-DK‘.
The screenshot below shows the previous three transactions compressed to two lines, for example.
(Click on the screenshot to enlarge.)
Editing Intrastat transactions