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 query. 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.
|Column header (1st row!)||Format||Example|
|ownvat, own ust-idnr, ustid1||String||EN123456789|
|foreignvat, foreign ust-idnr, ustid2||String||AT12345678|
|company, company name||String|
|zip, zip code||String|
The XLSX export file of the VAT Validation contains the returned values of each query, also, unless otherwise specified, in the same Data format.
|Own VAT ID||String||DE123456789|
|Foreign VAT ID||String||AT12345678|
|ErrorCodeDesc||String||The requested VAT number is valid.|
|Timestamp||Date + time||2021-01-05 16:12:37|
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.