Add Purchaser VAT, Country of Origin and non-VAT registered flag to the Intrastat dispatch report - Republic of Ireland

Businesses in the Republic of Ireland with exports above the dispatch threshold must include the Purchaser VAT, Country of Origin (CoO) and non-VAT registered flag 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.

You should then amend the csv file by following the section below.

Amend the dispatch Intrastat csv file

1. Browse to and open the dispatch Intrastat csv file using Excel.
2. For each order, copy the 2 digit country code from column D and paste it into column N.
3. For each order, add the purchaser's VAT number in column N at the end of the 2 digit country code. 
4. If a purchaser has no VAT number as they're not registered for VAT, leave column N blank and in column O enter True.    
5. For each order, in column M add the appropriate stock Country of Origin. 
   
6. 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.