Add Partner VAT ID and Country of Origin to the Intrastat dispatch report - Northern Ireland

Businesses in the EU and Northern Ireland with exports above the dispatch threshold must include the Partner VAT ID and Country of Origin (CoO) in their dispatch Intrastat reports from 1 January 2022. Read more > 

To do this, you can amend your dispatch report csv file once you generate it from Sage 200. Let's take a look.

NOTE: Sage 200 v2022 R2 and later versions are able to output the correct information on the Intrastat Dispatch report csv file. We recommend either upgrading or following the steps below which guide you through producing and amending the csv file if you are not in a position to upgrade yet. 

Generate your dispatch Intrastat file

As there are no changes to the Intrastat process within Sage 200, your first step is to generate your dispatch Intrastat report csv file as you normally would.

When opened in Excel, your csv file has two key areas. The header area shows a line for the trader details, and if relevant a line for agent information. Below the header, the order information is listed.

TIP: You can find out more about what information appears in each column on the uktradeinfo.com website.  

You should amend these areas by following the section below.

Amend the dispatch Intrastat csv file

1. Browse to and open the dispatch Intrastat csv file using Excel.
2. In the header area, change CSV02 to CSV03. If your file has two header rows, one for trader and one for agent, amend both values.
3. In the order information section, for each order, enter the Partner ID in column H and the Country of Origin in Column I.
   
4. To save the changes, click File then click Save.

That's it. You've added the additional information required and can now submit your Intrastat report in the usual way.