Hilfe
Import of insurance relations to be declared into the fire protection tax self-assessment form for policy holders (FeuerschStVN)
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 |
1.1 | Translation of the Excel-Sheet | |
1.1 | 1.1.8 | State code of Sint Maarten was changed to SX |
1.1 | 1.1.7 | Correction of the selection in the State field |
1.1 | 1.1.6 | Extension of the list of states to include EU states |
1.1 | 1.1.5 | Addition of the entry “Great Britain and Northern Ireland, United Kingdom” to the list of states |
1.1 | 1.1.4 | Column “Consideration (Euro, cent)” is now “Deviating consideration (Euro, cent)”. Due to calculations in the form, it is no longer necessary to state the consideration in Euro. |
1.1 | 1.1.3 | Addition of the entry “SSP” (South Sudanese Pound) to the currency list, increase of the maximum number of import lines to 1000 |
1.1 | 1.1.2 | Addition of the entry “South Sudan” to the list of states |
1.0 | 1.1.0 | First version of the import function for insurance relationships |
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 |
Record data table insurance rations (record type 1)
Field title | Format | Explanation | Mandatory field |
---|---|---|---|
Name 1 | A(40) | Name 1 of the insurance company. | Mandatory |
Name 2 | A(40) | Name 2 of the insurance company. | Optional |
Street | A(30) | Street of the insurance company. | Mandatory |
House number | A(10) | House number of the insurance company. | Optional |
Addition to the house number | A(10) | Addition to the house number of the insurance company. An entry in this field is only permitted if a house number is also specified. | Optional |
Postal code | A(12) | Postal code of the insurance company. | Optional |
Town/City | A(30) | Town/City of the insurance company. | Mandatory |
State | State of the insurance company. The two-digit country codes listed in list of codes and states must be used. | Mandatory | |
Number | A(30) | Policy number | Optional |
Risk | A(50) | Insured risk | Mandatory |
Goods | A(50) | Insured goods | Optional |
Start | A(10) | Start of the insurance period for which the payment was made. The entry must be made in the format DD.MM.YYYY (DD=day of the month, MM=number of the month, YYYY=year). If there is an entry in this field, there must also be an entry in the End field. | Optional |
End | A(10) | End of the insurance period for which the payment was made. The entry must be made in the format DD.MM.YYYY (DD=day of the month, MM=number of the month, YYYY=year). If there is an entry in this field, there must also be an entry in the Start field. | Optional |
Day of payment | A(10) | Day of payment. The entry must be made in the format DD.MM.YYYY (DD=day of the month, MM=number of the month, YYYY=year). | Mandatory |
Consideration | N(12,2) | Consideration paid in the respective currency. A number with up to 12 digits before and exactly 2 digits after the decimal point must be entered. | Mandatory |
Currency | Currency in which the consideration was paid. The three-digit currency abbreviations listed in the list of codes and currencies must be used. | Mandatory | |
Exchange rate | N(9,4) | Conversion rate between Euro and the currency in which the fee was paid (“1 Euro equals”). A positive number with up to 9 digits before and exactly 4 digits after the decimal point must be entered. | Mandatory |
Deviating consideration (Euro, cent) | N(12,2) | Differently paid consideration in Euro. A number with up to 12 digits before and exactly 2 digits after the decimal point must be entered. | 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.
#v1.1 #ve1.1.9 Name 1, Name 2, Straße, Hausnummer, Zusatz, Postleitzahl, Ort, Staat, Versicherungsscheinnummer, Versichertes Risiko, Versicherter Gegenstand, von, bis, Tag der Zahlung, Gezahltes Entgelt in der jeweiligen Währung, Währung, Umrechnungskurs für die Währung, Abweichend erklärtes gezahltes Entgelt Versicherer 1,Versicherer 1 Zweitname,Musterstraße,1234567890,,12345,Musterhausen,SS,12345,Beispielrisiko,Der Gegenstand der Versicherung,01.01.2011,01.06.2011,01.05.2011,12345.00,AED,0.0010,123456789012.00 Versicherer 2,Versicherer 2 Zweitname,Musterweg,1234567890,,12345,Musterhausen,AF,23456,Beispielrisiko,"Gegenstand, auf den sich die Versicherung bezieht",01.01.2011,01.06.2011,01.05.2011,12345.00,AED,0.0010,123456.00 Versicherer 3,Versicherer 3 Zweitname,Mustergasse,1234567890,,12345,Musterhausen,SS,45678,Beispielrisiko,"Gegenstand, auf den sich die Versicherung bezieht",01.01.2011,01.06.2011,01.05.2011,12345.00,AED,0.0010,123456.00
List of codes and states
Code | State |
---|---|
AF | Afghanistan |
AX | Aland Islands |
AL | Albania |
DZ | Algeria |
AS | American Samoa |
AD | Andorra |
AO | Angola |
AI | Anguilla |
AQ | Antarctica |
AG | Antigua and Barbuda |
AR | Argentina |
AM | Armenia |
AW | Aruba |
AU | Australia |
AT | Austria |
AZ | Azerbaijan |
BS | Bahamas |
BH | Bahrain |
BD | Bangladesh |
BB | Barbados |
BY | Belarus |
BE | Belgium |
BZ | Belize |
BJ | Benin |
BM | Bermuda |
BT | Bhutan |
BO | Bolivia |
BQ | Bonaire, Saint Eustatius and Saba |
BA | Bosnia and Herzegovina |
BW | Botswana |
BV | Bouvet Island |
BR | Brazil |
IO | British Indian Ocean Territory |
VG | British Virgin Islands |
BN | Brunei |
BG | Bulgaria |
BF | Burkina Faso |
BI | Burundi |
KH | Cambodia |
CM | Cameroon |
CA | Canada |
IC | Canary Islands |
CV | Cape Verde |
KY | Cayman Islands |
CF | Central African Republic |
XI | Ceuta |
TD | Chad |
CL | Chile |
CN | China |
CX | Christmas Island |
CC | Cocos Islands |
CO | Colombia |
KM | Comoros |
CK | Cook Islands |
CR | Costa Rica |
HR | Croatia |
CU | Cuba |
CW | Curacao |
CY | Cyprus |
CZ | Czech Republic |
CD | Democratic Republic of the Congo |
DK | Denmark |
DJ | Djibouti |
DM | Dominica |
DO | Dominican Republic |
TL | East Timor |
EC | Ecuador |
EG | Egypt |
SV | El Salvador |
GQ | Equatorial Guinea |
ER | Eritrea |
EE | Estonia |
ET | Ethiopia |
FK | Falkland Islands |
FO | Faroe Islands |
FJ | Fiji |
FI | Finland |
FR | France |
GF | French Guiana |
PF | French Polynesia |
TF | French Southern Territories |
GA | Gabon |
GM | Gambia |
GE | Georgia |
DE | Germany |
GH | Ghana |
GI | Gibraltar |
GR | Greece |
GL | Greenland |
GD | Grenada |
GP | Guadeloupe |
GU | Guam |
GT | Guatemala |
GG | Guernsey |
GN | Guinea |
GW | Guinea-Bissau |
GY | Guyana |
HT | Haiti |
HM | Heard Island and McDonald Islands |
HN | Honduras |
HK | Hong Kong |
HU | Hungary |
IS | Iceland |
IN | India |
ID | Indonesia |
IR | Iran |
IQ | Iraq |
IE | Ireland |
IM | Isle of Man |
IL | Israel |
IT | Italy |
CI | Ivory Coast |
JM | Jamaica |
JP | Japan |
JE | Jersey |
JO | Jordan |
KZ | Kazakhstan |
KE | Kenya |
KI | Kiribati |
KW | Kuwait |
KG | Kyrgyzstan |
LA | Laos |
LV | Latvia |
LB | Lebanon |
LS | Lesotho |
LR | Liberia |
LY | Libya |
LI | Liechtenstein |
LT | Lithuania |
LU | Luxembourg |
MO | Macao |
MK | Macedonia |
MG | Madagascar |
MW | Malawi |
MY | Malaysia |
MV | Maldives |
ML | Mali |
MT | Malta |
MH | Marshall Islands |
MQ | Martinique |
MR | Mauritania |
MU | Mauritius |
YT | Mayotte |
XJ | Melilla |
MX | Mexico |
FM | Micronesia |
MD | Moldova |
MC | Monaco |
MN | Mongolia |
ME | Montenegro |
MS | Montserrat |
MA | Morocco |
MZ | Mozambique |
MM | Myanmar |
NA | Namibia |
NR | Nauru |
NP | Nepal |
NL | Netherlands |
AN | Netherlands Antilles |
NC | New Caledonia |
NZ | New Zealand |
NI | Nicaragua |
NE | Niger |
NG | Nigeria |
NU | Niue |
NF | Norfolk Island |
KP | North Korea |
MP | Northern Mariana Islands |
NO | Norway |
OM | Oman |
PK | Pakistan |
PW | Palau |
PS | Palestinian Territory |
PA | Panama |
PG | Papua New Guinea |
PY | Paraguay |
PE | Peru |
PH | Philippines |
PN | Pitcairn |
PL | Poland |
PT | Portugal |
PR | Puerto Rico |
QA | Qatar |
CG | Republic of the Congo |
RE | Reunion |
RO | Romania |
RU | Russia |
RW | Rwanda |
BL | Saint Barthelemy |
SH | Saint Helena |
KN | Saint Kitts and Nevis |
LC | Saint Lucia |
MF | Saint Martin |
PM | Saint Pierre and Miquelon |
VC | Saint Vincent and the Grenadines |
WS | Samoa |
SM | San Marino |
ST | Sao Tome and Principe |
SA | Saudi Arabia |
SN | Senegal |
RS | Serbia |
SC | Seychelles |
SL | Sierra Leone |
SG | Singapore |
SX | Sint Maarten |
SK | Slovakia |
SI | Slovenia |
SB | Solomon Islands |
SO | Somalia |
ZA | South Africa |
GS | South Georgia and the South Sandwich Islands |
KR | South Korea |
SS | South Sudan |
ES | Spain |
LK | Sri Lanka |
SD | Sudan |
SR | Suriname |
SJ | Svalbard and Jan Mayen |
SZ | Swaziland |
SE | Sweden |
CH | Switzerland |
SY | Syria |
TW | Taiwan |
TJ | Tajikistan |
TZ | Tanzania |
TH | Thailand |
TG | Togo |
TK | Tokelau |
TO | Tonga |
TT | Trinidad and Tobago |
TN | Tunisia |
TR | Turkey |
TM | Turkmenistan |
TC | Turks and Caicos Islands |
TV | Tuvalu |
VI | U.S. Virgin Islands |
UG | Uganda |
UA | Ukraine |
AE | United Arab Emirates |
GB | United Kingdom |
US | United States |
UM | United States Minor Outlying Islands |
UY | Uruguay |
UZ | Uzbekistan |
VU | Vanuatu |
VA | Vatican |
VE | Venezuela |
VN | Vietnam |
WF | Wallis and Futuna |
EH | Western Sahara |
YE | Yemen |
ZM | Zambia |
ZW | Zimbabwe |
List of codes and currencies
Währungskürzel | Währung |
---|---|
AED | United Arab Emirates, Dirhams |
AFN | Afghanistan, Afghanis |
ALL | Albania, Leke |
AMD | Armenia, Drams |
ANG | Netherlands Antilles, Guilders |
AOA | Angola, Kwanza |
ARS | Argentina, Pesos |
AUD | Australia, Dollars |
AWG | Aruba, Guilders |
AZN | Azerbaijan, Manats |
BAM | Bosnia and Herzegovina, Convertible Marka |
BBD | Barbados, Dollars |
BDT | Bangladesh, Taka |
BGN | Bulgaria, Leva |
BHD | Bahrain, Dinars |
BIF | Burundi, Francs |
BMD | Bermuda, Dollars |
BND | Brunei Darussalam, Dollars |
BOB | Bolivia, Bolivianos |
BOV | Bolivia, Mvdol |
BRL | Brazil, Brazil Real |
BSD | Bahamas, Dollars |
BTN | Bhutan, Ngultrum |
BWP | Botswana, Pulas |
BYR | Belarus, Rubles |
BZD | Belize, Dollars |
CAD | Canada, Dollars |
CDF | Congo/Kinshasa, Congolese Francs |
CHF | Switzerland, Francs |
CLF | Chile, Unidades de fomento |
CLP | Chile, Pesos |
CNY | China, Yuan Renminbi |
COP | Colombia, Pesos |
COU | Colombia, Unidad de Valor Real |
CRC | Costa Rica, Colones |
CUC | Cuba, Convertible Pesos |
CUP | Cuba, Pesos |
CVE | Cape Verde, Escudos |
CZK | Czech Republic, Koruny |
DJF | Djibouti, Francs |
DKK | Denmark, Kroner |
DOP | Dominican Republic, Pesos |
DZD | Algeria, Algeria Dinars |
EEK | Estonia, Krooni |
EGP | Egypt, Pounds |
ERN | Eritrea, Nakfa |
ETB | Ethiopia, Birr |
EUR | Euro Member Countries, Euro |
FJD | Fiji, Dollars |
FKP | Falkland Islands (Malvinas), Pounds |
GBP | United Kingdom, Pounds |
GEL | Georgia, Lari |
GHS | Ghana, Cedis |
GIP | Gibraltar, Pounds |
GMD | Gambia, Dalasi |
GNF | Guinea, Francs |
GTQ | Guatemala, Quetzales |
GWP | Guinea-Bissau Peso |
GYD | Guyana, Dollars |
HKD | Hong Kong, Dollars |
HNL | Honduras, Lempiras |
HRK | Croatia, Kuna |
HTG | Haiti, Gourdes |
HUF | Hungary, Forint |
IDR | Indonesia, Rupiahs |
ILS | Israel, New Shekels |
INR | India, Rupees |
IQD | Iraq, Dinars |
IRR | Iran, Rials |
ISK | Iceland, Kronur |
JMD | Jamaica, Dollars |
JOD | Jordan, Dinars |
JPY | Japan, Yen |
KES | Kenya, Shillings |
KGS | Kyrgyzstan, Soms |
KHR | Cambodia, Riels |
KMF | Comoros, Francs |
KPW | Korea (North), Won |
KRW | Korea (South), Won |
KWD | Kuwait, Dinars |
KYD | Cayman Islands, Dollars |
KZT | Kazakstan, Tenge |
LAK | Laos, Kips |
LBP | Lebanon, Pounds |
LKR | Sri Lanka, Rupees |
LRD | Liberia, Dollars |
LSL | Lesotho, Maloti |
LTL | Lithuania, Litai |
LVL | Latvia, Lati |
LYD | Libya, Dinars |
MAD | Morocco, Dirhams |
MDL | Moldova, Lei |
MGA | Madagascar, Malagasy Ariary |
MKD | Macedonia, Denars |
MMK | Myanmar (Burma), Kyats |
MNT | Mongolia, Tugriks |
MOP | Macau, Patacas |
MRO | Mauritania, Ouguiyas |
MUR | Mauritius, Rupees |
MVR | Maldives (Maldive Islands), Rufiyaa |
MWK | Malawi, Kwachas |
MXN | Mexico, Pesos |
MXV | Mexico, Mexican Unidad de Inversion |
MYR | Malaysia, Ringgits |
MZN | Mozambique, Meticais |
NAD | Namibia, Dollars |
NGN | Nigeria, Nairas |
NIO | Nicaragua, Gold Cordobas |
NOK | Norway, Krone |
NPR | Nepal, Nepal Rupees |
NZD | New Zealand, Dollars |
OMR | Oman, Rials |
PAB | Panama, Balboa |
PEN | Peru, Nuevos Soles |
PGK | Papua New Guinea, Kina |
PHP | Philippines, Pesos |
PKR | Pakistan, Rupees |
PLN | Poland, Zlotych |
PYG | Paraguay, Guarani |
QAR | Qatar, Rials |
RON | Romania, New Lei |
RSD | Serbian Dinar |
RUB | Russia, Rubles |
RWF | Rwanda, Rwanda Francs |
SAR | Saudi Arabia, Riyals |
SBD | Solomon Islands, Dollars |
SCR | Seychelles, Rupees |
SDG | Sudan, Dinars |
SEK | Sweden, Kronor |
SGD | Singapore, Dollars |
SHP | Saint Helena, Pounds |
SLL | Sierra Leone, Leones |
SOS | Somalia, Shillings |
SRD | Suriname, Dollar |
SSP | South Sudan, Pounds |
STD | São Tome and Principe, Dobras |
SVC | El Salvador, Colones |
SYP | Syria, Pounds |
SZL | Swaziland, Emalangeni |
THB | Thailand, Baht |
TJS | Tajikistan, Somoni |
TMT | Turkmenistan, Manats |
TND | Tunisia, Dinars |
TOP | Tonga, Pa'anga |
TRY | Turkey, Liras |
TTD | Trinidad and Tobago, Dollars |
TVD | Tuvalu, Dollars |
TWD | Taiwan, New Dollars |
TZS | Tanzania, Shillings |
UAH | Ukraine, Hryvnia |
UGX | Uganda, Shillings |
USD | United States of America, Dollars |
UYU | Uruguay, Pesos |
UZS | Uzbekistan, Sums |
VEF | Venezuela, Bolivares |
VND | Viet Nam, Dong |
VUV | Vanuatu, Vatu |
WST | Samoa, Tala |
XAF | Communauté Financière Africaine BEAC, Francs |
XCD | East Caribbean Dollars |
XOF | Communauté Financière Africaine BCEAO, Francs |
XPD | Palladium Ounces |
XPF | Comptoirs Français du Pacifique Francs |
YER | Yemen, Rials |
ZAR | South Africa, Rand |
ZMK | Zambia, Kwacha |
ZWL | Zimbabwe, Zimbabwe Dollars |
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.