VIES EU VAT validation connector

Use VIES VAT checks for compliant invoicing, audit trail and clean customer data.

Data Panda runs every B2B VAT number you trade with against the European Commission's VIES service and brings the result, the timestamp and the consultation number into your warehouse. From one place, we turn it into dashboards, automations, AI workflows and custom apps your sales, finance and tax teams use every day.

Data Panda Reporting Automation AI Apps
VIES EU VAT validation logo
About VIES EU VAT validation

The official EU service that says this VAT number is real, today.

VIES (VAT Information Exchange System) is the European Commission's public service for checking whether a VAT number is valid for intra-EU transactions. A request goes out to the issuing member state's own database in real time and comes back with a yes or no, the trader name and address where that member state shares them, and a consultation number that proves the check happened.

The service is reachable from the public Vies-on-the-Web page, the SOAP checkVatService endpoint that ERPs and accounting tools have used for years, and a more recent REST endpoint. It covers the 27 EU member states. The European Commission is explicit that VIES does not store the data itself and is not responsible for accuracy: the answer is only as fresh as the national tax authority's own database. That is exactly why the consultation number matters. It is the audit-grade proof that on a given date, that VAT number was valid according to the home country's records.

What your VIES EU VAT validation data is for

What you get once VIES EU VAT validation is connected.

Reporting on validation status

A complete log of every VIES check across the customer and supplier book, with the result and the consultation number tied to it.

  • Customers and suppliers grouped by VAT-validation status, last check date and country of issue
  • Reverse-charge invoices joined to the consultation number that backed the validation
  • Watchlist of VAT numbers that flipped from valid to invalid since the last check

Workflow automation

Trigger the VIES check at the moment a new partner or invoice appears, not weeks later.

  • New B2B account in the CRM is checked against VIES before the deal is closed-won
  • ERP blocks a reverse-charge invoice when the customer's VAT number is no longer valid in VIES
  • Quarterly re-check of every active customer and supplier with a result delta report

AI workflows

Use the VIES name and address response to clean and confirm what your own systems hold.

  • Reconcile the trader name returned by VIES against the legal name in the CRM and ERP
  • Flag accounts where the VIES address country does not match the billing country on the order
  • Suggest the right reverse-charge VAT code based on country of issue and validation result

Custom apps on your data

Internal tools on the validation log, for the people who carry the audit risk.

  • VAT-check console for sales, with the result, the date and the consultation number on the customer card
  • Bulk re-check screen for the AR clerk before the quarterly intra-community listing
  • Supplier-onboarding form that runs VIES inline and refuses to save without a valid result
Use cases

Use cases we deliver with VIES EU VAT validation data.

A list of concrete reports, automations and AI features we have built on VIES EU VAT validation data. Pick the one that matches your situation.

New-customer intake checkValidate every new B2B customer's VAT number the moment the CRM record is created.
Reverse-charge audit trailEvery intra-EU invoice tied to the VIES consultation number that justified the zero-rating.
Quarterly portfolio re-checkRe-validate the active customer and supplier book every quarter and surface what changed.
Supplier KYBBlock onboarding of any supplier whose VAT number does not return valid in VIES.
Trader name reconciliationCompare the trader name returned by VIES with the legal name on file.
Country-mismatch flagSpot accounts where the VIES address country differs from the billing country.
Listing prepBuild the intra-community sales listing on a customer book whose VAT numbers are all freshly validated.
Deregistered watchlistStanding report of customers whose VAT number flipped to invalid since the last check.
Bulk pre-quarter sweepOne-off bulk run before the quarter-end close to catch deregistrations early.
Sales-channel guardrailWebshop or order-entry tool refuses a B2B reverse-charge order without a valid VIES result.
Real business questions

Answers you will finally get.

Can we prove, per intra-EU invoice, that we validated the customer's VAT number on that day?

Yes. Every VIES check returns a consultation number; we store it next to the customer record and join it back to each invoice that booked at 0% reverse-charge VAT. At a tax inspection you have the date, the result and the EC-issued reference for every line, not a screenshot from a few months ago.

How many of our active customers and suppliers no longer have a valid VAT number?

A standing re-check across the active book gives a delta against the previous validation: which numbers flipped to invalid, in which country, and how many open invoices reference them. The conversation with the AR clerk and the account manager starts before the next quarterly listing has to be filed, not after.

Where does the trader name from VIES disagree with the customer name on our orders?

The VIES response carries the legal trader name and address for member states that share them. Joined against the CRM and the ERP, it picks up the customer that's been onboarded under a trading name, an old company name after a merger, or a typo that survived three years of invoicing.

Value for everyone in the organisation

Where each function gets value.

For finance leaders

Every reverse-charge invoice carries its own VIES consultation number in the warehouse, and the open AR file shows which customer numbers went stale. The quarterly intra-community listing leaves on a clean book, instead of triggering a correction file two months later.

For sales leaders

When a B2B prospect is qualified, the VAT number is validated against VIES inline, before the quote goes out. The rep stops promising 0% VAT terms to a counterparty whose VAT number was deregistered last quarter.

For operations

Supplier onboarding refuses to complete without a valid VIES check, and a quarterly sweep flags suppliers whose status flipped. Procurement stops paying invoices to a counterparty that lost its VAT registration somewhere in the past year.

Ideas

What you can automate with VIES EU VAT validation.

Pair with Exact Online

Validate every Exact Online B2B customer through VIES

New and updated B2B customers in Exact Online run through VIES the moment the VAT number changes, with the result and consultation number stored next to the customer card. Reverse-charge invoices in Exact reference the validation that justified the 0% line, and the quarterly intra-community listing leaves on a customer book that was re-checked.

Pair with MS Dynamics 365 Business Central

Block reverse-charge sales orders in Business Central without a valid VIES result

Sales orders in Business Central with an EU customer flagged for reverse-charge VAT trigger a VIES check before posting. Orders to a counterparty whose VAT number is no longer valid get stopped at the door, and the consultation number for valid checks is stored against the order so the audit trail follows the document, not the screenshot.

Pair with HubSpot

Run VIES on every HubSpot B2B deal at qualification

When a HubSpot deal moves into a qualified stage, the company's VAT number runs against VIES inline and the result lands on the deal and the company record. The rep sees on the CRM card whether the prospect is intra-EU eligible before the quote goes out, instead of finding out at invoicing that the number was never valid.

Pair with Salesforce

Keep Salesforce account VAT data fresh with periodic VIES sweeps

Active Salesforce accounts get a quarterly VIES sweep, with the validation result, last-check date and consultation number written back to the account record. Account owners see a flag on accounts whose VAT number went stale, in time to handle it before the next renewal or the next intra-community filing.

Pair with Octopus

Tie Octopus reverse-charge bookings to a VIES consultation number

Sales bookings in Octopus posted under a Belgian intra-community VAT code carry the VIES consultation number that backed the customer's validation. The accountant filing the BTW-aangifte and the IC-listing has the EC-issued reference per booking, instead of running a manual sweep at quarter-end.

Pair with Yuki

Validate Yuki client VAT numbers across the BeNeLux portfolio

Customer and supplier VAT numbers in Yuki run through VIES on a recurring schedule, with the result and consultation number stored per relation. Accounting offices serving Dutch and cross-border SMEs see one watchlist of relations whose VAT registration changed status, instead of catching it on a rejected invoice.

Your existing tools

Your data lands in a warehouse. Your BI tools read from it.

You keep the reporting tool you already have. We connect it to the warehouse where your VIES EU VAT validation data lives.

Power BI logo
Power BI Microsoft
Microsoft Fabric logo
Fabric Microsoft
Snowflake logo
Snowflake Data warehouse
Google BigQuery logo
BigQuery Google
Tableau logo
Tableau Visualisation
Microsoft Excel logo
Excel Sheets & pivots
Three steps

From VIES EU VAT validation to answers in three steps.

01

Connect securely

OAuth authentication. Read-only by default. We sign a DPA and your admin keeps the keys.

02

Land in your warehouse

Data flows into your warehouse on your schedule. Near real time or nightly, your call. You own the data.

03

Reporting, automation, AI

We build the first dashboard, workflow or AI feature with you, then hand over the keys. Or we stay on for ongoing delivery.

Two ways to work with us

Pick the track that fits how you work.

Track 01

Self-serve

We set up the foundation. Your team builds on top.

  • VIES EU VAT validation connector configured and running
  • Warehouse set up in your cloud account
  • Clean access for your Power BI, Fabric or Tableau team
  • Documentation on what's in the data model
  • Sync monitoring so you're warned before reports break

Best fit Teams that already have a BI analyst or data engineer and want to own the build.

Track 02

Done for you

We build the whole thing, end to end.

  • Everything in Self-serve
  • Dashboards built to the questions your team actually asks
  • Automations between your systems
  • AI workflows scoped to real tasks your team runs
  • Custom apps where a dashboard does not cut it
  • Ongoing delivery at a pace that fits your team

Best fit Teams without in-house BI or dev capacity. You tell us what you need and we deliver it.

Before you book

Frequently asked questions.

Who owns the data?

You do. It lands in your warehouse, on your cloud account. We don't resell or aggregate it. If you stop working with us, the warehouse stays yours and keeps running.

How fresh is the data?

Near real time for most operational systems. For heavier sources we schedule hourly or nightly. You pick based on what the reports need.

Do I need a warehouse already?

No. If you don't have one, we help you pick one and set it up as part of the first delivery. Common starting points are Snowflake, Microsoft Fabric, or a small Postgres start.

What is the VIES consultation number and why do you store it?

The consultation number is a reference the European Commission returns with each VIES check, on request. It is the audit-grade proof that on a given date, you validated a specific VAT number and got a specific result. We log it next to the customer record and tie it back to every reverse-charge invoice, so a tax-control conversation has a real paper trail, not a screenshot.

What if VIES does not return the trader name or address?

Some member states do not share the name and address through VIES. In those cases the response is still a yes or no on validity plus the consultation number, which is what reverse-charge compliance depends on. Our log captures whichever fields the response carried, so reconciliation against your CRM and ERP works for the countries that share them and skips silently for the ones that don't.

GDPR-compliant
Data stays in the EU
You own the warehouse

A first deliverable live in four to six weeks.

We review your VIES EU VAT validation setup and the systems around it. Together we pick the first thing worth building.