General 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
Inventory Items
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.
Net weight 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 headingsDate Direction Account Account name Item Item name Field transfer type Commodity code Weight/Pcs Pcs Weight Supplementary quantity Country Invoice number Invoice amount Triangular trade SystemInfo
Description of buttons/functions in IntrastatAdd Delete Create file
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’.
Compress The screenshot below shows the previous three transactions compressed to two lines, for example. (Click on the screenshot to enlarge.)
Editing Intrastat transactions
| General links: Layout Templates Search Attachments Filter/Clear Filter |