VAT Validation Tool
Check VAT numbers of all your EU customers. If you sell products or services with zero rated VAT to organisations in other EU member states you are obliged to check the validity on a regular basis.
Sanocast VAT Validation lets you check multiple VAT registration numbers directly in Excel. Quickly check all the numbers in your spreadsheet by simply clicking a single button. A free version is available in the Microsoft Office Store.
The tool is compatible with Excel for Windows, Excel for Mac and Excel Online (Office 365). The free plan has a limit on how many numbers you can check in one go and it is also limited in speed. It is however possible to upgrade to a paid plan for just 4€/mth to remove this limit.
Using the VAT Validation Excel Add-In is very easy. Here is the process:
Put your customers VAT numbers in column A
The system now consults the VIES system and the results are shown in column B to F
Flexible pricing
Free
Lite
Essential Most popular
Premium Team
VIES is short for VAT Information Exchange System. The VIES system was set up to allow for the flow of the VAT data held across the internal frontiers in EU which enables companies to obtain confirmation of the VAT identification numbers of their customers.
The unit responsible for the control of intra-Community trade in each Member State , the Central Liaison Office (CLO), has a direct access through VIES to the VAT registration database of the other Member States.
Our service queries the EU system directly. VIES however is not a standalone database but rather a proxy that relays information from national systems in EU member countries.
For further information about the VIES system have a look here. Still voting on whichs system to use? If so then you might want to read this article that sums up some of the solutions for validating EU VAT Identification numbers: Is this EU VAT number valid?
comprobación del número de iva
проверка на номера на ДДС
BTW-nummer controle
alv-numeron tarkistus
Vérification du numéro de TVA
Kontrolle der Umsatzsteuer-Identifikationsnummer
έλεγχος αριθμού ΦΠΑ
áfaszám-ellenőrzés
controllo del numero di partita iva
PVN numura pārbaude
PVM numerio tikrinimas
käibemaksukohustuslase numbri kontroll
kontroll av momsnummer
sprawdzenie numeru vat
controlo do número de IVA
verificarea numărului tva
kontrola čísla DPH
preverjanje številke DDV