| | Intrastat report format for Ireland |
| Description |  Important: 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 >
If you're not currently using Sage 50 Accounts Professional, and you're interested in upgrading, leave your details and we'll be in touch. |
| Resolution | If you choose to create a CSV report, it creates your Supplementary Declaration in the form of a comma-separated value (CSV) file. You can submit the CSV file electronically to your tax authority. XML is the default report format, and is available for you to e-submit to the tax authorities on the ROS web site.Arrivals (POP) - Ireland - CSV >
Header - ArrivalsLength | Value | Description |
|---|
| 3 | SHR | Record type | | 3 | SFO | File status | | 1 | C | File format | | 1 |
| Return status - N = normal return
- T = test return
| | 4 |
| Period, format YYMM | | 1 | A | Type of return - A = Arrival | | 8 |
| Trader's VAT number - excluding country code | | 8 |
| Declarant's VAT Number - excluding country code | | 6 |
| Date created, format DDMMYY | | 45 | Empty | Not used |
Item Line - ArrivalsLength | Value | Description |
|---|
| 3 | SDR | Record type | | 3 |
| Item number | | 8 |
| Commodity code | | 3 |
| Country of destination or Consignment | | 3 |
| Country of origin | | 2 |
| Mode of transport | | 2 |
| Nature of transaction | | 10 |
| Invoice value rounded to nearest euro | | 3 |
| Delivery terms | | 10 |
| Statistical value rounded to nearest whole euro | | 10 |
| Net mass rounded to nearest whole number | | 10 |
| Supplementary units rounded to nearest whole number | | 12 |
| Unique reference number - Statistical line number reference | | 1 |
| Not used |
Arrivals (POP) - Ireland - XML >
Istat elementThe file contains a single Istat element with the following: Attribute | Format | Description |
|---|
| formversion | Numeric, required | Must be equal to 1 for this version of the file format. This changes with each new edition of the form. | | language | E or G, required | The language that you're filing teh return under: | | periodstart | Date, required | The start of the year for which you're filing the Instrastat form. Format is DD/MM/YYYY  EXAMPLE: 01/01/2020
| | periodend | Date, required | The period end date of the Imtrastat tax period for which you are filling the return. Format is DD/MM/YYYY EXAMPLE: 31/12/2020 | | product | Alphanumeric, optional | This decribes the product used to generate the XML. EXAMPLE: ROS LAUNCHER for the ROS Offline Application. |
Return Element
The file contains a single Return element with the following attributes: Attribute | Format | Description |
|---|
| returnType | Integer, required | This must be either 0 or 1. The value 0 corresponds to a Nil Return | | flow | True or False, required | This must be either A or D. The value A corresponds to Arrival. The value D corresponds to Dispatch. | | statPeriod | Alpha, required | Period chosen for filing the return. This must be in the format MMYYYY. |
Party Elements The Party element has the following attributes: Attribute | Format | Description |
|---|
| partyType | String, required | This must be either PSI or TPD. A party type of PSI must exist. TPD will only exist if the trader is filing as a third party declarant.
- PSI = Provider of Statistical Information
- TPD = Third Party Declarant.
| | vatNUM | AlphaNumeric, required | This must contain a valid VAT Number. | | name | AlphaNumeric, required | The name of the PSI or TPD. The maximum number of characters is 35. | | address1 | Alpha, required | The first line of the address for the PSI/TPD The name of the PSI or TPD. The maximum number of characters is 35. | | address2 | Alpha, required | The second line of the address for the PSI/TPD The name of the PSI or TPD. The maximum number of characters is 35. | | address3 | Alpha, optional | The third line of the address for the PSI/TPD The name of the PSI or TPD. The maximum number of characters is 35 | | contact | Alpha, required | The contact name for the PSI or TBD. The maximum number of characters is 15. | | phone | AlphaNumeric, required | The phone number for the PSI or TBD. The maximum number of characters is 15. | | email | AlphaNumeric, required | The email address for the PSI or TPD. The email address must contain an @ symbol and a full stop. The maximum number of characters is 60. | | arrivals | Integer, optional | A 0 value indicates that the PSI is not liable for arrival returns. A 1 value indicates that the PSI is liable for arrival returns. | | dispatch | Integer, optional | A 0 value indicates that the PSI is not liable for dispatch returns. A 1 value indicates that the PSI is liable for dispatch returns. | | statsValueRequi red | Alpha, optional | A Y value indicates that the PSI is required to submit stat value, terms of delivery and means of transport for each line item. The N value indicates that the PSI is not required to submit stat value, terms of delivery and means of transport for each line item. This option is only relevant from 2012 onwards. |
Item Elements While an Item element itself has no attributes, it does have the following sub-elements, each with attributes: ItemDetails sub-elementThe ItemDetails sub-element contains the following attributes: Attribute | Format | Description |
|---|
ctryconsign-Destn | AlphaNumeric, optional | Country of consignment for arrivals and Country of Destination for dispatch. The country code has 2 alpha characters, for example NL. | | ctryOrigin | AlphaNumeric, optional | This value is only required for an arrival return. This value is not required for any of the following commodity codes: - 99500000
- 99302400
- 99302700
- 99309900
The country code has 2 alpha characters, for example NL. | | transaction | Integer, required | The nature of Transaction and must have values of between 1 and 9 inclusive. This value isn't required for the following commodity codes: - 99500000
- 99302400
- 99302700
- 99309900
| | transport | Integer, required Mandatory if the field statsValueRequired is Y | The mode of transport and must have values of between 1 and 5 and 7 and 9 inclusive. 1. SEA 2. RAIL 3. ROAD 4. AIR 5. POST 7. FIXED TRANSPORT INSTALLATIONS 8. INLAND WATERWAY 9. OWN PROPULSION | | delivery | String, optional Mandatory if the field statsValueRequired is Y | This corresponds to the terms of delivery. |
CN8 sub - elementThe CN8 sub-element contains the following attributes: Attribute | Format | Description |
|---|
code | Numeric, required | The commodity code. It must be a valid eight digit commodity code. | | netMass | Positive decimal, optional | Net mass is required if the commodity code returned, requires it | | netMassOpt | String, required | Period chosen for filing the return. This must be in the format MMYYYY. | | suCode | String, required | Indicates the type of supplementary unit. | | suQuanitity | Positive decimal, optional | Supplementary unit quantity is required if the commodity code returned requires it. |
ItemValues sub - element
The ItemValues sub-element contains the following attributes: Attribute | Format | Description |
|---|
invEuroValue | Positive decimal, required | The invoice euro value of the goods. | | statEuroValue | Positive decimal, optional Becomes mandatory if the field statsValueRequired is Y. | This is the Statistical Euro value of the goods. |
Dispatches (SOP) - Ireland - CSV >Header - DispatchesLength | Value | Description |
|---|
| 3 | SHR | Record type | | 3 | SFO | File status | | 1 | C | File format | | 1 |
| Return status - N = normal return
- T = test return
| | 4 |
| Period, format YYMM | | 1 | A | Type of return - D = Dispatches | | 8 |
| Trader's VAT number - excluding country code | | 6 |
| Date created, format DDMMYY | | 45 | Empty | Not used |
Item Line - DispatchesLength | Value | Description |
|---|
| 3 | SDR | Record type | | 3 |
| Item number | | 8 |
| Commodity code | | 3 |
| Country of destination or Consignment | | 3 |
| Country of origin | | 2 |
| Mode of transport | | 2 |
| Nature of transaction | | 10 |
| Invoice value rounded to nearest euro | | 3 |
| Delivery terms | | 10 |
| Statistical value rounded to nearest whole euro | | 10 |
| Net mass rounded to nearest whole number | | 10 |
| Supplementary units rounded to nearest whole number | | 12 |
| Unique reference number - Statistical line number reference | | 1 |
| Not used |
Footer - Dispatches Length | Value | Description |
|---|
| 3 | STR | Record type | | 3 |
| Total number of transactions | | 12 |
| Total invoice value rounded to nearest euro | | 12 |
| Total statistical value rounded to nearest euro | | 12 |
| Total net mass rounded to nearest whole unit | | 12 |
| Total supplementary units rounded to nearest whole unit | | 11 |
| Phone number | | 15 |
| Not used |
Dispatches (SOP) - Ireland - XML >
Istat elementThe file contains a single Istat element with the following: Attribute | Format | Description |
|---|
| formversion | Numeric, required | Must be equal to 1 for this version of the file format. This changes with each new edition of the form. | | language | E or G, required | The language that you're filing teh return under: | | periodstart | Date, required | The start of the year for which you're filing the Instrastat form. Format is DD/MM/YYYY EXAMPLE: 01/01/2020 | | periodend | Date, required | The period end date of the Imtrastat tax period for which you are filling the return. Format is DD/MM/YYYY EXAMPLE: 31/12/2020 | | product | Alphanumeric, optional | This decribes the product used to generate the XML. EXAMPLE: ROS LAUNCHER for the ROS Offline Application. |
Return Element
The file contains a single Return element with the following attributes: Attribute | Format | Description |
|---|
| returnType | Integer, required | This must be either 0 or 1. The value 0 corresponds to a nil Return | | flow | True or False, required | This must be either A or D. The value A corresponds to Arrival. The value D corresponds to Dispatch. | | statPeriod | Alpha, required | Period chosen for filing the return. This must be in the format MMYYYY. |
Party Element(s) The Party element has the following attributes: Attribute | Format | Description |
|---|
| partyType | String, required | This must be either PSI or TPD. A party type of PSI must exist. TPD will only exist if the trader is filing as a third party declarant.
- PSI = Provider of Statistical Information
- TPD = Third Party Declarant.
| | vatNUM | AlphaNumeric, required | This must contain a valid VAT Number. | | name | AlphaNumeric, required | The name of the PSI or TPD. The maximum number of characters is 35. | | address1 | Alpha, required | The first line of the address for the PSI/TPD The name of the PSI or TPD. The maximum number of characters is 35. | | address2 | Alpha, required | The second line of the address for the PSI/TPD The name of the PSI or TPD. The maximum number of characters is 35. | | address3 | Alpha, optional | The third line of the address for the PSI/TPD The name of the PSI or TPD. The maximum number of characters is 35 | | contact | Alpha, required | The contact name for the PSI or TBD. The maximum number of characters is 15. | | phone | AlphaNumeric, required | The phone number for the PSI or TBD. The maximum number of characters is 15. | | email | AlphaNumeric, required | The email address for the PSI or TPD. The email address must contain an @ symbol and a full stop. The maximum number of characters is 60. | | arrivals | Integer, optional | A 0 value indicates that the PSI is not liable for arrival returns. A 1 value indicates that the PSI is liable for arrival returns. | | dispatch | Integer, optional | A 0 value indicates that the PSI is not liable for dispatch returns. A 1 value indicates that the PSI is liable for dispatch returns. | | statsValueRequi red | Alpha, optional | A Y value indicates that the PSI is required to submit stat value, terms of delivery and means of transport for each line item. The N value indicates that the PSI is not required to submit stat value, terms of delivery and means of transport for each line item. This option is only relevant from 2012 onwards. |
Item Elements While an Item element itself has no attributes, it does have the following sub-elements, each with attributes: ItemDetails sub-elementThe ItemDetails sub-element contains the following attributes: Attribute | Format | Description |
|---|
ctryconsign-Destn | AlphaNumeric, optional | Country of consignment for arrivals and Country of Destination for dispatch. The country code has 2 alpha characters, for example NL. | | ctryOrigin | AlphaNumeric, optional | This value is only required for an arrival return. This value is not required for any of the following commodity codes: - 99500000
- 99302400
- 99302700
- 99309900
The country code has 2 alpha characters, for example NL. | | transaction | Integer, required | The nature of Transaction and must have values of between 1 and 9 inclusive. This value isn't required for the following commodity codes: - 99500000
- 99302400
- 99302700
- 99309900
| | transport | Integer, required Mandatory if the field statsValueRequired is Y | The mode of transport and must have values of between 1 and 5 and 7 and 9 inclusive. 1. SEA 2. RAIL 3. ROAD 4. AIR 5. POST 7. FIXED TRANSPORT INSTALLATIONS 8. INLAND WATERWAY 9. OWN PROPULSION | | delivery | String, optional Mandatory if the field statsValueRequired is Y | This corresponds to the terms of delivery. |
CN8 sub - elementThe CN8 sub-element contains the following attributes: Attribute | Format | Description |
|---|
code | Numeric, required | The commodity code. It must be a valid eight digit commodity code. | | netMass | Positive decimal, optional | Net mass is required if the commodity code returned, requires it | | netMassOpt | String, required | Period chosen for filing the return. This must be in the format MMYYYY. | | suCode | String, required | Indicates the type of supplementary unit. | | suQuanitity | Positive decimal, optional | Supplementary unit quantity is required if the commodity code returned requires it. |
ItemValues sub - elementThe ItemValues sub-element contains the following attributes: Attribute | Format | Description |
|---|
invEuroValue | Positive decimal, required | The invoice euro value of the goods. | | statEuroValue | Positive decimal, optional Becomes mandatory if the field statsValueRequired is Y. | This is the Statistical Euro value of the goods. |
[BCB:22:IE - Sales message :ECB]
|
|