Whenever an EU VAT-registered business sells goods or cross-border B2B services to a business customer in another EU member state, zero-rating (0% intra-Community supply or Reverse Charge under Article 196 of the EU VAT Directive) requires proving that the buyer held an active VAT ID on the European Commission VIES database at the time of supply.
Manually pasting 200 customer VAT IDs one by one into the European Commission's web portal before every quarterly EC Sales List (ESL / Zusammenfassende Meldung) wastes hours—and still gives you no structured audit CSV. Worse, individual national tax databases (especially Germany `DE`, Spain `ES`, and Italy `IT`) frequently return temporary `MS_UNAVAILABLE` or `MS_MAX_CONCURRENT_REQ` timeouts that break naive batch scripts.
5-Step Bulk EU VAT Verification & Audit-Trail Workflow
- 1
Normalize country prefixes and strip punctuation before querying VIES
Clean spaces, hyphens, and dots from customer inputs (e.g., `DE 123.456.789` → `DE123456789`). Watch for Greece's ISO quirk: Greece uses `EL` (not `GR`) as its VIES VAT prefix, and Northern Ireland Protocol businesses use `XI`.
- 2
Run local regex & checksum pre-validation before hitting EC VIES
Reject obviously malformed IDs locally (such as a 7-digit German ID or missing French 2-character prefix) before making network calls. This catches typos instantly and preserves national VIES concurrency quotas.
- 3
Query EC VIES live in paced batches & handle UK (`GB`) separately
Since Brexit, mainland UK (`GB`) VAT numbers are no longer served by EC VIES—only Northern Ireland (`XI`) remains on VIES. Validate `GB` format/HMRC checks separately while batching EU27 + `XI` IDs through VIES with clean retry handling for `MS_UNAVAILABLE`.
- 4
Cross-check returned company name & address (note Germany's privacy rule)
Most EU member states return the legal company name and registered address in the VIES response. Note that Germany (`DE`) and Spain (`ES`) intentionally omit name/address on basic VIES queries due to national privacy rules—record the `valid: true` status, timestamp, and consultation ID.
- 5
Download & archive your timestamped Bulk CSV Verification Report
Export a single audit CSV containing VAT Number, Country, Format Check, VIES Live Status, Returned Company Name, Verification Timestamp (UTC), and Request Identifier, and attach it to your monthly/quarterly VAT working papers.
Common EU VIES Bulk Verification Edge Cases & Country Formats (2026)
| Country / Error Code | Exact Format / Meaning | How to Handle in Bulk Audits |
|---|---|---|
| Germany (DE — USt-IdNr) | DE + 9 digits (e.g., DE123456789) | VIES confirms validity but omits name/address; archive timestamp + BZSt/VIES proof. |
| Greece (EL — ΑΦΜ) | EL + 9 digits (NOT GR!) | Auto-normalize `GR` inputs to `EL` before calling EC VIES or queries fail. |
| UK (GB) vs N. Ireland (XI) | GB + 9 or 12 digits; XI + 9 or 12 digits | Only `XI` queries EC VIES; verify `GB` against HMRC VAT API / format rules. |
| MS_UNAVAILABLE / TIMEOUT | Member state's national tax database is offline | Do NOT mark customer invalid—queue for automatic retry 15–30 minutes later. |
| INVALID (valid: false) | VAT ID deregistered or never enabled for intra-EU trade | Hold zero-rating! Charge local destination/origin VAT until buyer supplies active ID. |
EU Reverse-Charge Audit Proof Checklist
- Verify the buyer's VAT ID BEFORE issuing a 0% VAT invoice—retroactive checks months later do not prove validity on the supply date.
- Confirm the buyer's VAT prefix is in a DIFFERENT EU member state from your dispatch country (domestic B2B sales still charge local VAT).
- Keep transport/dispatch proof (CMR, courier tracking, signed delivery receipt) alongside your VIES CSV log for goods shipments.
- Note Spain (`ES`), Italy (`IT`), and Poland (`PL`) national vs intra-EU VAT splits: a local taxpayer ID is only valid for 0% cross-border sales if registered in ROI / VIES.
- Store bulk verification CSV reports for 10 years to satisfy statutory EU VAT record-keeping rules.
3 Bulk VIES Pitfalls That Cause Rejected EC Sales Lists
- Treating a regex pass as legal proof of validity: a correctly formatted 9-digit Italian VAT number can still be deregistered or not enrolled in Italy's VIES registry, triggering immediate audit clawbacks.
- Firing 500 concurrent requests at EC VIES simultaneously: national gateways (notably Germany and Spain) throttle bursts with `MS_MAX_CONCURRENT_REQ` errors—always pace bulk requests cleanly.
- Confusing a German domestic Steuernummer (e.g., 12/345/67890) with a German EU USt-IdNr (`DE` + 9 digits): domestic Steuernummern cannot be used for intra-EU reverse charge.
Validate Single or Bulk CSV EU27 & UK VAT Numbers Live Right Now
Paste a list or upload a CSV in ExemptFlow's live EC VIES checker—get instant format + live VIES validation and download a timestamped audit CSV with zero login.
Frequently Asked Questions
Why does VIES return valid=true without a company name for German (DE) VAT numbers?
Germany's Federal Central Tax Office (BZSt) restricts name and address disclosure on standard VIES lookups for data-protection reasons. A confirmed valid status with UTC timestamp (or qualified confirmation via BZSt for German sellers) satisfies standard verification.
What should I do if a Spanish or Italian customer's VAT number fails VIES?
Both Spain (ROI — Registro de Operadores Intracomunitarios) and Italy require domestic businesses to opt in separately for intra-EU VIES registration. Until the buyer completes VIES enrollment, you cannot apply 0% intra-Community exemption and must charge applicable VAT.
Can ExemptFlow validate a CSV of EU VAT numbers without creating an account?
Yes. Switch to the Bulk CSV tab inside ExemptFlow's free workbench on the homepage to verify multiple EU27, Northern Ireland (XI), and UK (GB) VAT numbers live against EC VIES and export a timestamped audit CSV.