The file contains a single Return element with the following attributes:
Intrastat report format for Ireland
Summary
This article provides the CSV and XML format for Intrastat Arrivals and Purchases in 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 - XML >
Istat element
The 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
|
| periodend | Date, required | The period end date of the Imtrastat tax period for which you are filling the return. Format is DD/MM/YYYY
|
| product | Alphanumeric, optional | This decribes the product used to generate the XML.
|
Return Element
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.
|
| 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. |
| 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-element
The 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:
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:
|
| 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 - element
The 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 - XML >
Istat element
The 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
|
| periodend | Date, required | The period end date of the Imtrastat tax period for which you are filling the return. Format is DD/MM/YYYY
|
| product | Alphanumeric, optional | This decribes the product used to generate the XML.
|
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.
|
| 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. |
| 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-element
The 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:
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:
|
| 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 - element
The 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. |
Solution Properties
- Solution ID
- 201106155851680
- Last Modified Date
- Mon Jul 31 10:39:45 UTC 2023
- Views
- 0