How To: Set Up and Report Intrastat

Article
12/01/2017

All companies in the European Union must report their trade with other EU countries/regions. You must report the movement of goods to the statistics authorities in your country/region every month, and the report must be delivered to the tax authorities. This is referred to as Intrastat Reporting. You use the Intrastat Journal page to complete periodic Intrastat reports.

Required and Optional Setups

Before you can use the Intrastat journal to report Intrastat information, there are several things you must set up:

Intrastat journal templates: You must set up the Intrastat journal templates and batches you will use. Because Intrastat is reported monthly, you must create 12 Intrastat journal batches based on the same template.
Commodity codes: Customs and tax authorities have established numerical codes that classify items and services. You specify these codes on items.
Transaction nature codes: Countries and regions have different codes for types of Intrastat transactions, such as ordinary purchase and sale, exchange of returned goods, and exchange of non-returned goods. Set up all of the codes that apply to your country/region. You use these codes on sales and purchase documents, and when you process returns.
Transport methods: There are seven, one-digit codes for Intrastat transport methods. 1 for sea, 2 for rail, 3 for road, 4 for air, 5 for post, 7 for fixed installations, and 9 for own propulsion (for eample, transporting a car by driving it). Dynamics NAV does not require these codes, however, we recommend that the descriptions provide a similar meaning.

Optionally, you can also set up:

Transaction specifications: Use these to supplement the descriptions from the transaction nature codes.
Areas: Use these to supplement information about countries and regions.
Entry/exit points: Use these to specify the locations where you ship or receive items to or from other countries. Heathrow Airport is an example of an entry or exit point. You enter entry or exit points on sales and purchase documents on the Foreign Trade FastTab. This information will also be copied from the item entries when you create the Intrastat journal.

To set up Intrastat templates and batches

The Intrastat batch jobs include only item entries, and not general ledger entries. If you have general ledger entries that qualify for Intrastat reporting, you must enter them manually. For example, if you purchase a computer from another EU country or region, the computer is not placed in inventory, but is posted to a general ledger account. You must manually enter this type of entry in the Intrastat journal.

You can export the entries to a file that you can send to your Intrastat authorities. You can also print a report, manually enter the information on the forms from your authorities, and then submit the information.

[!Note] We recommended that you set up an Intrastat journal batch for each month.

Choose the icon, enter Intrastat Journal Templates, and then choose the related link.
Fill in the fields as necessary. Choose a field to read a short description of the field or link to more information.. Create a template for each Intrastat form you use.
To create batches, choose the Navigate tab, and then choose Batches.
Fill in the fields as necessary. Choose a field to read a short description of the field or link to more information.. Create a template for each Intrastat form you use..

Note

In the Statistics Period field, enter the statistics period as a four-digit number, where the first two digits represent the year and the next two digits represent the month. For example, enter 1706 for June, 2017.

To set up commodity codes

All items that you buy or sell must have a commodity code.

Choose the icon, enter Commodity Codes, and then choose the related link.
Fill in the fields as necessary. Choose a field to read a short description of the field or link to more information.
To assign a commodity code to an item, go to the Item Card page, expand the Costs & Posting FastTab, and then enter the code in the Commodity Code field.

To set up transaction nature codes

Choose the icon, enter Transaction Nature Codes, and then choose the related link.
Fill in the fields as necessary. Choose a field to read a short description of the field or link to more information.

Tip

If you frequently use a particular transaction nature code, you can make it the default. To do this, go to the Intrastat Setup page, and choose the code.

To set up transport methods

Choose the icon, enter Transport Methods, and then choose the related link.
Fill in the fields as necessary. Choose a field to read a short description of the field or link to more information.

To Report Intrastat

After you fill in the Intrastat journal, you can print the Checklist report to make sure that that all information in the journal is correct. Afterward, you can print an Intrastat report as a form, or create a file to submit to the tax authority in your country/region.

To fill in Intrastat journals

Choose the icon, enter Intrastat Journal and then choose the related link.
On the Intrastat Journal page, in the Batch Name field, choose the relevant journal batch, and then Choose the OK button.
Choose the Suggest Lines action. The Starting Date and Ending Date fields will already contain the dates specified for the statistics period on the journal batch.
In the Cost Regulation % field, you can enter a percentage to cover transport and insurance. If you enter a percentage, the content of the Statistical Value field in the journal is proportionally higher.
Choose OK to start the batch job.

The batch job retrieves all the item entries in the statistics period and inserts them as lines in the Intrastat journal. You can edit the lines if needed.

Important

The batch job retrieves only the entries that contain a country/region code for which an Intrastat code has been entered on the Countries/Regions page. Therefore, you must enter Intrastat codes for the country/region codes for which you will run the batch job.

How to: Report Intrastat on a form or a file

To get the information that is required on the Intrastat form from the statistical authorities, you must print the Intrastat – Form report. Before you can do this, you must prepare the Intrastat journal and fill it in. If you have both sales and purchase transactions, you must complete a separate form for each type, so that you must print the report two times.

Choose the icon, enter Intrastat Journals, and then choose the related link.
On the Intrastat Journal page, choose the relevant journal batch in the Batch Name field.
If you have not already done this, fill in the journal manually or choose Suggest Lines.
Choose the Prints Intrastat Journal action.
On the Intrastat Jnl. Line FastTab, add a Type filter and then specify whether this is a Receipt or a Shipment.
Choose Send to to print the report.

How to: Report Intrastat in a file

You can submit the Intrastat report as a file. Before creating the file, you can print a checklist that contains the same information that will be in the file.

Choose the icon, enter Intrastat Journal, and then choose the related link.
In the Intrastat Journal window, select the relevant journal batch in the Batch Name field.
If you have not already done this, fill in the journal manually or by choosing Suggest Lines.
Choose the Create File action.
In the batch job window, Choose the OK button.
Choose Save.
Browse to the location where you want to save the file, enter the file name, and then choose Save.

How to: Reorganise Intrastat Journals

Because you must submit an Intrastat report every month, and you create a new journal batch for each report, you will eventually have many journal batches. The journal lines are not deleted automatically. You may want to reorganize the journal batch names periodically. You do this by deleting the journal batches that you no longer need. The journal lines in these batches are also deleted.

Choose the icon, enter Intrastat Journals, and then choose the related link.
To view the options, choose the Batch Name field.
Choose the journal batches to deleted, and then choose Delete.

Share via