erpware logo

VAT Validation: XLSX import interface

With the import interface for Microsoft Excel (XLSX) file, the module VAT Validation offers you a possibility to check your entire database from your master data.

We take care to maintain compatibility (also with Microsoft Excel) when extending the XLSX VAT Validation interface. This means that you can always use the latest version without generating additional effort when integrating it into your ERP system.

In order to be able to uniquely assign an XLSX data record from your ERP system in the VAT Validation, 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. However, you can also leave these two fields (Key_1 and Key_2) blank.

Please note that all highlighted fields must be specified in the VAT registration number import file. Depending on the fields specified, a qualified check will be performed automatically. The qualified check is currently only available for the BZSt interface.

The names of the column headings of the VAT Validation are searched for within the XLSX file during import and assigned during import. Please enter only one name at a time, e.g. “Company name” and not “Company,Company name”.

The upper and lower case of the column headers is not relevant for the import.

We have included two empty example files with English or German column headings.

Structure — VAT XLSX Import File

Column header (1st row!) Format Example
key1, key_1 String 4711
key2, key_2 String 2
ownvat, own ust-idnr, ustid1 String EN123456789
foreignvat, foreign ust-idnr, ustid2 String AT12345678
company, company name String
town, place String
zip, zip code String
street, street String

Structure — VAT XLSX Export File

The XLSX export file of the VAT Validation contains the returned values of the individual checks, also in the same data format unless otherwise specified.

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

XLSX Versions

We support all XLSX versions up to and including the latest version of Office 365 in the VAT Validation module. Please understand that we will no longer support older versions (XLS).

Our test scope for the VAT Validation module includes many different variants of how a Microsoft Excel document can look like. Nevertheless, we could not test all functions and possibilities. If you encounter a problem when importing XLSX files, please contact us and send us one or two test data sets so that we can help you quickly.