Sage 200 Brexit - Intrastat

As part of leaving the EU, companies in both the United Kingdom and the Republic of Ireland will need to make the following considerations in relation to Intrastat reporting, to remain compliant with government legislation.

 The following changes will already be in your software in the following variants:

• Sage 200 Professional 2020 R2
• Sage 200 Standard Online
• Sage for Education

If you do not have the above versions, you will have to make manual changes in the software as outlined below.

 CAUTION: From 1 January 2022, movements of goods between Great Britain and the EU, or Great Britain and Northern Ireland, are no longer covered by Intrastat. Northern Ireland businesses are still covered by Intrastat as part of the Northern Ireland Protocol. For more information about this and other changes, visit our Legislation Help Centre > 

GB companies (England, Scotland & Wales)  

Even though the UK is no longer part of the EU, as a temporary measure, companies are still required to submit Intrastat reports for goods being transported from EU to the UK (Arrivals Declarations).  

The versions listed above (or later) will use the address on the Purchase Order to determine inclusion on the Intrastat arrivals report.

There is no longer a reliance on the EU check box being ticked for GB (it will still be needed for remaining EU countries) for relevant transactions to be included on the Intrastat reports. This gives manual control so that when appropriate (once you have correctly completed any in-progress submissions) the EU check box will need to be cleared for the country code for GB.

NOTE: New company databases created in the versions list above (or later) will not have GB flagged as an EU country. 

NOTE: For older versions of Sage 200: GB will need to remain flagged as an EU country to generate the report.  

Please see below for instruction on clear the EU check box:  

Sage 200 Professional  

1. Click Accounting System Manager, Settings, then click Country Codes.  
2. For Great Britain clear the EU check-box.   
3. Click OK.   

Sage 200 Standard / Education  

1. Click Settings, Organisational and Financial, then click Country Codes.  
2. For Great Britain clear the EU check-box.   
3. Click OK. 

Northern Ireland companies

As part of the Northern Ireland Protocol it will be necessary to continue to submit Intrastat reports for goods being transported between EU and Northern Ireland (arrivals and despatches).  

The versions listed above (or later) will use the address on the Purchase Order/Sales Order to determine inclusion on Intrastat reports.   

There will be no longer a reliance on the EU check box being ticked for GB (it will still be needed for remaining EU countries) for relevant transactions to be included on the Intrastat reports. This gives manual control so that when appropriate (once you have correctly completed any in-progress submissions) the EU check box will need to be cleared for the country code for GB.   

NOTE: For older versions of Sage 200: GB will need to remain flagged as an EU country to generate the report.   

Please see below for instruction on clear the EU check box:  

Sage 200 Professional  

1. Click Accounting System Manager, Settings, then click Country Codes.  
2. For Great Britain clear the EU check-box.   
3. Click OK.   

Sage 200 Standard / Education  

1. Click Settings, Organisational and Financial, then click Country Codes.  
2. For Great Britain clear the EU check-box.   
3. Click OK.

Republic of Ireland Companies  

As a remaining member of the European Union, companies in the Republic of Ireland will still be required to produce Intrastat reports. At the end of the transition period on 31/12/20, they will no longer report on goods being transported to and from Great Britain (England, Scotland and Wales).

For Trading goods with customers or suppliers in Northern Ireland.  

Once you have correctly completed any in-progress submissions, customer/supplier accounts that are based in Northern Ireland, their country code should be changed to XI.   

Please see below for instruction on changing the Country Codes for your Customer and Supplier Accounts:  

Sage 200 Professional 

Customers  

Click Sales Ledger, Sales Accounts, Amend Account Details, then open Trading tab and select the country code from the dropdown menu.  

Information on updating Customer records on-mass can be found here.  

Suppliers  

Click Purchase Ledger, Purchase Accounts, Amend Account Details, then open Trading tab and select the country code from the dropdown menu.  

Information of updating Supplier records on-mass can be found here.   

Sage 200 Standard / Education  

Customers  

Click Customers, Create & Amend Accounts, Amend Customer Details, then open Trading tab and select the country code from the dropdown menu.  

Information on updating Customer records on-mass can be found here.

Suppliers  

Click Suppliers, Create & Amend Accounts, Amend Supplier Details, then open Trading tab and select the country code from the dropdown menu.  

Information of updating Supplier records on-mass can be found here.  

When trading with companies in GB the customer/supplier country code should remain GB, the EU check box will need to be cleared for the country code for GB.   

Please see below for instruction on clear the EU check box:  

Sage 200 Professional

1. Click Accounting System Manager, Settings, then click Country Codes.   
2. For Great Britain clear the EU check-box.   
3. Click OK.   

Sage 200 Standard / Education  

1. Click Settings, Organisational and Financial, then click Country Codes.   
2. For Great Britain clear the EU check-box.   
3. Click OK.  

NOTE: Companies in ROI will still need to ensure from/to countries if in EU are ticked to include on the Intrastat .

Stock Records

Update the country of origin to XI on stock records if they originate from Northern Ireland. 

Please see below for instruction on amending the Country of Origin on Stock records:  

Sage 200 Professional 

1. Click Stock Control, Stock items, Maintain stock items, Amend a stock item then open the Analysis tab 
2. Amend the Country of Origin  

Information of updating Stock records on-mass can be found here.  

Sage 200 Standard / Education  

1. Click Stock Control, Stock records, Amend a stock item details then open the Analysis tab 
2. Amend the Country of Origin  

Information of updating Stock records on-mass can be found here.

NOTE: Further information on recommended country code settings for trading under the Northern Ireland Protocol click here.