VAT Validation: XLSX import interface

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

We make sure that the XLSX VAT Validation interface is maintained (also with Microsoft Excel). This allows you to use the latest version without additional effort when integrating into your ERP system.

In order to be able to assign an XLSX record from your ERP system uniquely in the VAT Validation, you have the option to up to two unique keys in the import file. These are returned in the export file and can be used for reimport into your ERP system. However, you can leave these two fields (key_1 and key_2) blank.

The qualified validation of your VAT data within the XLSX file is only available using the interface of BZSt, which is currently only available for german customs.

Please note that all bold fields must be specified in the import file. Depending on the specification of the fields, automatically performs a qualified validation. The names of the column headings are searched for during import within the XLSX file and assigned during import. Please enter each always enter only one name, e.g. “company name” and not “company, company name”.

The upper and lower case of column headings is not relevant to the import.

We have added two empty sample files, each with English or German column labels.

Structure — VAT XLSX Import File

Column header (1st row!)FormatExample
key1, key_1String4711
key2, key_2String2
ownvat, own ust-idnr, ustid1StringEN123456789
foreignvat, foreign ust-idnr, ustid2StringAT12345678
company, company nameString
town, placeString
zip, zip codeString
street, streetString

Structure — VAT XLSX Export File

The XLSX export file of the VAT Validation contains the returned values of each validation, also, unless otherwise specified, in the same Data format.

FieldFormatExample
key1String4711
key2String2
ownvatStringDE123456789
foreignvatStringAT12345678
errorcodeString200
errorcode_descriptionStringThe requested VAT number is valid.
valid_fromString
valid_toString
errorcode_hintString
timestampString2021-01-05 16:12:37
companyString
townString
zipString
streetString

XLSX Versions

We support all XLSX versions up to and including the latest version of Office 365 in the VAT Validation module. will support you.

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 have all the functions and possibilities check. If you encounter a problem while importing XLSX files, please contact us and send us one or two test records so that we can can help.