Richard Cornelisse

Validation process of VAT numbers in SAP

In Audit Defense, Indirect Tax Automation, Processes and Controls, SAP add on, SAP add on for VAT, SAP for VAT, SAP SLO renaming tax codes, System Landscape Optimization, Technology, VAT automation on 01/04/2014 at 6:12 pm

Taxmarc™ SAP solution2
An important control measure in terms of material indirect tax is checking whether the 0% rate is correctly being applied.

A prerequisite for the application of the 0% rate for cross-border transactions within the European Union is a valid VAT number of the client. The valid VAT number must also be mentioned on the invoice.

Adequate monitoring of this is crucial to eliminating risks as much as possible.

Validation process of VAT numbers in SAP

In native SAP is it possible to check the syntax – the format of the VAT number, including the number of positions. However, it is not possible to check whether the VAT number is valid. To this end, the European Commission has provided an online database, VAT Information Exchange System (VIES) for the validation of VAT.

Standard SAP does not have an interface with the VIES database. In practice, it appears that 5 to 25 percent of the VAT numbers is incorrect or invalid. The KEY Group checked the VAT numbers through a data analysis for a client:

TABEL VIES

The number of erroneous VAT numbers is close to 25%. From a VAT perspective this implies material risks that exceed every risk tolerance (0 percent, client acceptance with regard to preventing VAT fraud).

Taxmarc™’s solution for validation of VAT numbers

Taxmarc™ can automatically check the VAT numbers when a VAT number is added to the customer master data. A real time link to VIES is made to validate the entered VAT number. The client can choose to treat the result of the VIES validation as:

  • An “error”: it is not possible to enter invalid VAT numbers in the customer master data or
  • A “warning”: invalid VAT numbers can be entered but are reported separately: check with the customer and/or correct. VAT numbers can expire or change due to changes in the legal structure of customers.

It is therefore important to periodically check the validity of the VAT numbers. In Taxmarc™ it is also possible to periodically carry out these controls as detective controls within the Tax Control Framework.

This can be done in a fully automated process.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: