|
<< Click to Display Table of Contents >> Navigation: Appendixes > Specification ICT file format |
The Digital Tax Declaration module can import files that contain Intra Community Transaction (ICT) information. This appendix gives a specification of the supported file formats.
D-basics can import three kinds of ICT files:
| 1. | TEXT |
| 2. | EXCEL |
| 3. | XML |
I. Specification format TEXT files
There are four different types of TEXT files:
| 1. | Correction ICT |
| 2. | Correction ABC ICT |
| 3. | Declaration ICT |
| 4. | Declaration ABC ICT |
A separate file must be made for each different part of the ICT declaration. Each of these files must have the correct file format, further the proper file extension must be used (the rest of the file name is free). Each line in the file must be closed with a Carriage Return (hexadecimal value "0D") followed by a 'line feed' (hexadecimal value "0A").
1. Correction ICT
Extension: .coi
Field |
Position |
Format |
Values |
Period |
1-4 |
9999 |
Pos (0-1): Year, {00 - 99} Pos (2-3): Quarter:{01 - 04} |
Inter spaces |
5-6 |
|
|
Country code |
7-8 |
X(2) |
AT,BE,CY,CZ,DE,DK,EE,EL,ES,FI,FR,GB, HU,IE,IT,LT,LU,LV,MT,PL,PT,SE,SI,SK |
Inter spaces |
9-10 |
|
|
Number |
11-22 |
X(12) |
|
Inter spaces |
23-24 |
|
|
Sign |
25-25 |
X(1) |
{-,<interspace>}, Explanation: - = Negative, <interspace> = Positive |
Amount |
26-35 |
9999999999 |
|
Example:
0304 BE 012345678901 -0000000064
0401 DK 323223 1234567890
0402 DE 645656 0000000045
2. Correction ABC-ICT
Extension: .coa
Field |
Position |
Format |
Values |
Period |
1-4 |
9999 |
Pos (0-1): Year, {00 - 99} Pos (2-3): Quarter:{01 - 04} |
Inter spaces |
5-6 |
|
|
Country code |
7-8 |
X(2) |
AT,BE,CY,CZ,DE,DK,EE,EL,ES,FI,FR,GB, HU,IE,IT,LT,LU,LV,MT,PL,PT,SE,SI,SK |
Inter spaces |
9-10 |
|
|
Number |
11-22 |
X(12) |
|
Inter spaces |
23-24 |
|
|
Sign |
25-25 |
X(1) |
{-,<interspace>}, Explanation: - = Negative, <interspace> = Positive |
Amount |
26-35 |
9999999999 |
|
Example:
0304 BE 012345678901 -0000000064
0401 DK 323223 1234567890
0402 DE 645656 0000000045
3. Declaration ICT
Extension: .ICT
Field |
Position |
Format |
Values |
Country code |
1-2 |
X(2) |
AT,BE,CY,CZ,DE,DK,EE,EL,ES,FI,FR,GB, HU,IE,IT,LT,LU,LV,MT,PL,PT,SE,SI,SK |
Inter spaces |
3-4 |
|
|
Number |
5-16 |
X(12) |
|
Inter spaces |
17-18 |
|
|
Sign |
19-19 |
X(1) |
{-,<interspace>}, Explanation: - = Negative, <interspace> = Positive |
Amount |
20-29 |
9999999999 |
|
Example:
BE 012345678901 -1234567890
DK 302020 0000004821
BE 5433343 0000343434
4 Declaration ABC-ICT
Extension: .ica
Field |
Position |
Format |
Values |
Country code |
1-2 |
X(2) |
AT,BE,CY,CZ,DE,DK,EE,EL,ES,FI,FR,GB, HU,IE,IT,LT,LU,LV,MT,PL,PT,SE,SI,SK |
Inter spaces |
3-4 |
|
|
Number |
5-16 |
X(12) |
|
Inter spaces |
17-18 |
|
|
Sign |
19-19 |
X(1) |
{-,<interspace>}, Explanation: - = Negative, <interspace> = Positive |
Amount |
20-29 |
9999999999 |
|
Example:
BE 012345678901 -1234567890
DK 302020 0000004821
BE 5433343 0000343434
II. Specification format EXCEL files
There are four different types of EXCEL files:
| 1. | Correction ICT |
| 2. | Correction ABC ICT |
| 3. | Declaration ICT |
| 4. | Declaration ABC ICT |
A separate file must be made for each different part of the ICT declaration. Each of these files must have the correct file format, further the proper file extension must be used (the rest of the file name is free).
1. Correction ICT
Extension: .coi.xls
Field |
Position |
Format |
Values |
Period |
A |
9999 |
Pos (0-1): Year, {00 - 99} Pos (2-3): Quarter:{01 - 04} |
Country code |
B |
X(2) |
AT,BE,CY,CZ,DE,DK,EE,EL,ES,FI,FR,GB, HU,IE,IT,LT,LU,LV,MT,PL,PT,SE,SI,SK |
Number |
C |
X(12) |
|
Amount |
D |
9999999999 |
|
Example:
A B C D
0304 BE 012345678901 -0000000064
0401 DK 323223 1234567890
0402 DE 645656 0000000045
2. Correction ABC-ICT
Extension: .coa.xls
Field |
Position |
Format |
Values |
Period |
A |
9999 |
Pos (0-1): Year, {00 - 99} Pos (2-3): Quarter:{01 - 04} |
Country code |
B |
X(2) |
AT,BE,CY,CZ,DE,DK,EE,EL,ES,FI,FR,GB, HU,IE,IT,LT,LU,LV,MT,PL,PT,SE,SI,SK |
Number |
C |
X(12) |
|
Amount |
D |
9999999999 |
|
Example:
A B C D
0304 BE 012345678901 -0000000064
0401 DK 323223 1234567890
0402 DE 645656 0000000045
3. Declaration ICT
Extension: .ICT.xls
Field |
Position |
Format |
Values |
Country code |
A |
X(2) |
AT,BE,CY,CZ,DE,DK,EE,EL,ES,FI,FR,GB, HU,IE,IT,LT,LU,LV,MT,PL,PT,SE,SI,SK |
Number |
B |
X(12) |
|
Amount |
C |
9999999999 |
|
Example:
A B C
BE 012345678901 -1234567890
DK 302020 0000004821
BE 5433343 0000343434
4 Declaration ABC-ICT
Extension: .ica.xls
Field |
Position |
Format |
Values |
Country code |
A |
X(2) |
AT,BE,CY,CZ,DE,DK,EE,EL,ES,FI,FR,GB, HU,IE,IT,LT,LU,LV,MT,PL,PT,SE,SI,SK |
Number |
B |
X(12) |
|
Amount |
C |
9999999999 |
|
Example:
A B C
BE 012345678901 -1234567890
DK 302020 0000004821
BE 5433343 0000343434
III. Specification format XML files
It is possible that an accounting package can create ICT declaration files in the XML format prescribed by the Tax authorities but does not offer the possibility to send that file to the TAX authorities. In that case d-basics can be used to transfer the XML file, provided this file is in the XML format prescribed by the Tax authorities. Please refer to the Tax Authorities for a specification of the XML file format.