This workaround is suitable for Sage 200 2015 and below a fix is available here for newer versions of Sage 200.

This workaround is also for customers using Sage 200 Professional 2016 and above that have not been able to apply the relevant fix prior to their submission due date.

NOTE: Further information on Intrastat within Sage 200 can be found in the in product Help files for the version of the software you are using.

NOTE: Further information on Intrastat, including submitting over the internet can be found here.

1. Continue to process orders as normal.
2. Generate Intrastat Entries as normal - Go to Accounting System Manager, then Intrastat (SSD) and then Generate Intrastat Entries and enter the relevant date.
3. Check the entries you need - Go to Accounting System Manager, then Intrastat (SSD) and then Intrastat Entry Maintenance.
4. To extract the entries which you want to include on the submission:

NOTE: As the Intrastat declaration cannot be produced within Sage 200, transactions will not be flagged as included in a prior Intrastat run, you will need to keep a separate record of what has been submitted to avoid transactions being included in multiple submissions.

1. Change the Status criteria to select Valid entries (you may have to correct any invalid entries as normal).
2. Change the Invoice / Despatch Date criteria to the period you are reporting on e.g 01/01/2021 to 31/01/2021 NOTE: You may need to check if you have any late entries (i.e. entries dated in a previous period which have not been included in a previous submission).
3. Select Display, the Intrastat Entries grid will be populated with all entries.
4. Complete other tasks on this form you require using the actions available NOTE: It may not be possible to use Add Entry, any additional entries would need to be accounted for manually in Excel prior to submitting online.
5. Right-click on the list, select Export, then All to Excel to send all the information in the grid to Excel.
6. You will then need to re-arrange the data in the format as outlined in the relevant guides linked below. TIP: If you have a previous Intrastat Declaration.csv saved you can use this as a template.

UK Companies

A guide to submitting via CSV which includes information on the required file format can be found here.

TIP: If you have a previous Intrastat Declaration.csv saved you can use this as a template.  

Republic of Ireland Companies

The VIES and INTRASTAT Traders Manual, which includes information on the required file format can be found here. 

TIP: If you have a previous Intrastat Declaration.csv saved you can use this as a template.

 NOTE: Statistical value is not shown on the grid for Intrastat Maintenance – to view this data you will need to select the Edit/ View button from with the Intrastat maintenance form and manually copy the data.