erpware logo

VAT Validation: CSV Import Interface

We recommend using the XLSX or JSON import interfaces.

By using a simple CSV file, the VAT Validation module offers you a possibility to check your entire database.

We take care to maintain compatibility when extending the CSV import interface of the VAT Validation module. This means that you can always use the latest version without generating additional effort when integrating it into your ERP system.

In order to ensure that the individual VAT registration number records belong to your master data, you have the option of specifying up to two unique keys in the import file. These will be returned in the export file and can be used for re-import into your ERP system. You can also leave these two fields (Key_1 and Key_2) blank.

The default separator of the individual elements for the VAT Validation is the ‘|’ character (pipe). This can be changed in the settings. Bold field names are mandatory fields (the separator can be changed via settings).

Please note that all fields must be specified in the import file of the VAT Validation, even if you only want to perform a simple check. The qualified check is currently only available for the BZSt interface.

Structure — VAT CSV Import File

Field Format Example
Key_1 String 4711
Key_2 String 2
Own VAT String DE123456789
Foreign VAT String AT12345678
Company Name String
Location String
Zip Code String
Street String

Example in the form of a CSV file: 4711|2|EN123456789|AT12345678|||… (other VAT validations)

Note

When creating the VAT registration number import file, please pay attention to the correct number of columns (8 columns). This note is important for possible errors during import when using CSV. In the future we will support other import formats that do not have this restriction.

Structure — VAT CSV Export File

The CSV export file of the VAT Validation contains the returned values of the individual checks.

Field Format Example
key1 String 4711
key2 String 2
ownvat String DE123456789
foreignvat String AT12345678
errorcode String 200
errorcode_description String The requested VAT number is valid.
valid_from String
valid_to String
errorcode_hint String
timestamp String 2021-01-05 16:12:37
company String
town String
zip String
street String

Example in the form of a CSV file (with standard delimiter):

4711|2|EN123456789|AT12345678|200|The requested VAT number is valid.|2019-11-05 14:35:43

The naming of the fields of the VAT Validation within the CSV import or export file is in German. In the course of the extension of the import formats, these will be internationalized, i.e. we will keep the field names in English in the future. However, we have considered a configuration of the field names in order to increase flexibility.

The output of the export file in CSV format of the VAT Validation always includes an additional column containing the headings. Please keep this in mind for a possible automatic re-import of the check results.