Hilfe
General information
In this import help, you will find form-specific information on the structure of a CSV file and the current version of the CSV interface.
If you are unfamiliar with the import function and require general information on creating CSV files, please use the general instructions for creating CSV files for the import function .
Important notes
In connection with the use of the import functionality, the Federal Central Tax Office draws attention to the following:
Use of the import function is at your own risk. The Federal Central Tax Office excludes any liability for direct and indirect damages incurred by the applicants due to the use of this functionality or the inability to use this functionality, in particular for loss of data, additional expenses or incorrect results, loss of profit, business interruption, loss of business information and other financial losses.
Version table
| CSV version | Excel version | Content of the changes |
| 3.0 | Switching the encoding of the CSV files from ISO-8859-15 to UTF-8. Zero values are no longer permitted for basis of charge and different VAT amounts. | |
| 2.0 | 2.2.0 | Expansion to include adjustments |
1.1 | 1.1.1 | Changed Country Code for Greece to EL |
| 1.0 | 1.1.0 | First version of the import function for OSSNONEUST sales. |
Data record tables and record types
The following data record tables describe all record types available in the import function.
A maximum of 1000 data rows in a CSV file can be imported.
Legend for the abbreviations of the format in the column description:
Abbreviation | Format |
A or AN | alphanumeric, i.e. text and figures |
N | numeric, i.e. figures |
(X) | X is the maximum number of characters that can be entered |
Data record table country installations (record type 1)
| Field title | Format | Explanation | Mandatory field |
|---|---|---|---|
| Record type | N(1) | In this column, the value "1" must always be indicated for country installations. | Mandatory |
| Country of consumption | A(2) | Code of the country.
The list of permitted codes can be found in the list of countries. | Mandatory |
Data record table revenue installations (record type 2)
| Field title | Format | Explanation | Mandatory field |
|---|---|---|---|
| Record type | N(1) | In this column, the value "2" must always be indicated for revenue installations. | Mandatory |
| Country of consumption | A(2) | Code of the country.
The list of permitted codes can be found in the list of countries. | Mandatory |
| VAT type | A | Type of VAT rate.
| Mandatory |
| VAT rate | N(2,2) | The percentage applicable for the country of consumption.
| Mandatory |
| Basis of charge, net amount | N(12,2) | The net sales to be reported for the country of consumption in the tax period.
| Mandatory |
| VAT amount | N(12,2) | The VAT amount calculated at the VAT rate based on the net amount/tax base.
| Mandatory |
Data record table adjustment installations (record type 3)
| Field title | Format | Explanation | Mandatory field |
|---|---|---|---|
| Record type | N(1) | In this column, the value "3" must always be indicated for adjustment installations | Mandatory |
| Country of consumption | A(2) | Code of the country.
The list of permitted codes can be found in the list of countries. | Mandatory |
| Year of the tax period being adjusted | N(4) | Year of the tax period being adjusted. | Mandatory |
| Quarter of the tax period being adjusted | N(1) | Quarter of the tax period being adjusted.
| Mandatory |
| Tax amount declared previously | N(12,2) | Tax amount that was declared previously for the tax period to be adjusted in the country of consumption.
| Mandatory |
| Adjusted tax amount | N(12,2) | Adjusted tax amount for the tax period that needs to be adjusted in the country of consumption.
| Mandatory |
Example CSV file
The following example of a CSV file can be imported into the form using the import function. The example only serves to illustrate the import function and does not represent a real data set.
#v3.0 #ve3.3.0 1,AT 1,BE 1,BG 1,IT 1,SK 2,AT,STANDARD,20.00,200.00,40.00 2,AT,REDUCED,10.00,300.00,30.00 2,BE,STANDARD,21.00,200.00,42.00 2,BE,REDUCED,6.00,200.00,12.00 2,BG,STANDARD,20.00,200.00,40.00 2,IT,STANDARD,22.00,200.00,44.00 2,IT,REDUCED,4.00,200.00,8.00 2,SK,STANDARD,23.00,200.00,40.00 3,SK,2021,3,15.00,10.00 3,BG,2021,3,0.01,0.00 3,IT,2021,3,100.00,200.00
List of countries
| Code | Content of the changes |
|---|---|
| BE | Belgium |
| BG | Bulgaria |
| DK | Denmark |
| DE | Germany |
| EE | Estonia |
| FI | Finland |
| FR | France |
| EL | Greece |
| IE | Ireland |
| IT | Italy |
| HR | Croatia |
| LV | Latvia |
| LT | Lithuania |
| LU | Luxembourg |
| MT | Malta |
| NL | Netherlands |
| XI | Northern Ireland |
| AT | Austria |
| PL | Poland |
| PT | Portugal |
| RO | Romania |
| SE | Sweden |
| SK | Slovakia |
| SI | Slovenia |
| ES | Spain |
| CZ | Czech Republic |
| HU | Hungary |
| CY | Cyprus |
Hotline and user support
In addition to the information available in the online help accessed directly from My BOP , you can contact a hotline set up by the federal and state tax administrations, which is available
- Monday to Friday 7:00 a.m. to 10:00 p.m. and
- Saturday and Sunday 10:00 a.m. to 6 p.m.,
with any questions or problems relating to My BOP . Assistance is provided with individual questions at +49 (0)1805/235055 (EUR 0.14 per minute). The hotline can also be contacted via
- fax (+49 (0)1805/235054) or
email (hotline@ELSTER.de).
Please note: Tax advice cannot be provided via this hotline.