# EU VAT ID Validation Log Worksheet

> Source: https://netray.co/tools/eu-vat-id-validation-log-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

An editable log of customer VAT number checks with country, date, result, consultation number and annual sales at risk.

## Category

cost-finance

## Region

European Union

## Audience

- Accounts receivable
- Tax accountant
- Finance controller

## Tool

**Kind:** worksheet

**Mode:** editable

**Currency:** EUR 

**Columns:**

#### Customer

**Key:** customer

**Type:** text

#### Country code

**Key:** country

**Type:** select

**Options:**

- AT
- BE
- CZ
- DE
- DK
- EL
- ES
- FR
- IE
- IT
- NL
- PL
- SE

#### VAT number

**Key:** vat

**Type:** text

#### Date checked

**Key:** checked

**Type:** date

#### Result

**Key:** result

**Type:** select

**Options:**

- Valid
- Invalid
- Service unavailable
- Not checked

#### Consultation number

**Key:** ref

**Type:** text

#### Zero-rated sales (year)

**Key:** sales

**Type:** number

**Format:** currency

#### VAT at risk at 20%

**Key:** at_risk

**Type:** number

**Expr:** sales * 0.2

**Format:** currency

**Help:** Illustration only. Use the rate of your own member state.

**Rows:**

**Customer:** Brauer Maschinenbau GmbH

**Country:** DE

**Vat:** DE123456789

**Checked:** 2026-10-01

**Result:** Valid

**Ref:** WAPIAAAAXyz1

**Sales:** 184000

**Customer:** Van Dijk Components BV

**Country:** NL

**Vat:** NL123456789B01

**Checked:** 2026-10-02

**Result:** Valid

**Ref:** WAPIAAAAXyz2

**Sales:** 96500

**Customer:** Rossi Elettromeccanica SRL

**Country:** IT

**Vat:** IT12345678901

**Checked:** 2026-10-05

**Result:** Service unavailable

**Sales:** 61200

**Customer:** Nowak Automatyka Sp z o.o.

**Country:** PL

**Vat:** PL1234567890

**Checked:** 2026-09-12

**Result:** Invalid

**Ref:** WAPIAAAAXyz4

**Sales:** 38750

**Customer:** Lindqvist Verkstad AB

**Country:** SE

**Vat:** SE123456789001

**Result:** Not checked

**Sales:** 22400

**Totals:**

#### Customers logged

**Key:** customer

**Agg:** count

#### Total zero-rated sales

**Key:** sales

**Agg:** sum

**Format:** currency

#### Total VAT at risk (illustrative)

**Key:** at_risk

**Agg:** sum

**Format:** currency

**Notes:** Example rows are fictitious. Replace them with your customers. Anything not marked Valid should be reviewed before the next zero-rated shipment. The 20% column is only an illustration of exposure and should be adjusted to the rate that would apply in your own country.

## Content

**Intro:** When you zero-rate an intra-EU sale you need proof that the customer's VAT number was valid. This worksheet is a simple log that finance can keep and hand to an auditor.

**Sections:**

#### How to use the worksheet

**Body:** Add one row per customer VAT number. Record the date of the VIES check, the result and any consultation number the service returned. Enter the year's zero-rated sales to see how much VAT could be reassessed if a number turns out to have been invalid. Sort or filter to find rows that are not Valid or that are older than your policy limit, and fix them before the next shipment. Export to Excel for the month-end file or to PDF for the audit binder.

**Bullets:**

- Keep one row per VAT number, not per customer account.
- Record the check date even for valid numbers.
- Highlight anything not marked Valid for follow-up.

#### Why the log matters

**Body:** Tax authorities generally accept that you applied the zero rate in good faith if you checked the VAT number, held transport evidence and invoiced correctly. A dated log showing the check result is the easiest way to show the first of those. Without it you may have to rerun checks months later, when the registration may have changed. The exposure column shows the order of magnitude of the issue: a handful of unverified customers can represent a meaningful tax liability if the supplies are reclassified as domestic.

#### Common mistakes and ERP notes

**Body:** Mistakes include checking only when the customer is created, recording a pass without the date, failing to repeat checks after a service outage, and mixing up the VAT number format by country. Your ERP may keep a validation flag on the customer record but not the date or consultation number, so a separate log is still useful. Once the process is stable, move the log into the ERP or a small integration that calls VIES on a schedule and writes the result to an audit table.

**Cta:** If the log works but takes too much manual effort, we can help build a scheduled VIES check that writes results into your ERP.

**Faq:**

#### How often should I check a customer's VAT number?

**Answer:** Check at onboarding and before the first zero-rated supply, and repeat periodically for active accounts, for example quarterly or before each period-end. A registration can lapse, so an old check is weaker evidence.

#### What if VIES is unavailable?

**Answer:** Record the result as service unavailable, retry later and keep the retry attempts. Do not treat it as invalid, but hold shipments if you cannot obtain a result for a new customer.

#### Is a consultation number mandatory?

**Answer:** It is not always mandatory but is useful evidence. You receive one when you make an approximate check with your own VAT number as the requester, and it proves when and by whom the check was made.

#### Does the log replace transport evidence?

**Answer:** No. The VAT number check is one part. You also need proof the goods left your member state and reached the customer's, plus a correct invoice and the reporting forms your country requires.

## Search terms

VAT number validation log, VIES check evidence template, intra-community supply VAT ID log, EU customer VAT number register excel, VAT zero rating evidence log, VIES audit trail, customer VAT ID check spreadsheet

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json