The VAT Registration No. Check report checks VAT registration number formats and duplicates for customers, vendors, and contacts. It compares numbers with the country/region formats configured in Business Central. It doesn't contact the European Union (EU) VAT Information Exchange System (VIES) or verify that a number is registered.
Use Format Check to list numbers that don't match a configured format. Use Duplicate Check to find repeated numbers within customers, vendors, or contacts. Both options are initially selected. Records with blank VAT registration numbers are excluded.
Use cases
Check VAT registration number formats and find duplicates within customers, vendors, or contacts. Use the report to improve master data before EU sales reporting. The report doesn't validate numbers with VIES.
Tip
Here are some tips on how to use the report:
- Run the report regularly to maintain up-to-date and accurate VAT number records.
- Use it as a pre-check before submitting EU sales reports to avoid compliance issues.
- Configure VAT registration number formats for the relevant countries/regions before checking formats.
- Investigate duplicate numbers to determine whether they are appropriate for the records involved.
Finance teams and compliance officers can use this report to:
- Check VAT number formats and identify duplicates.
- Ensure readiness for EU cross-border reporting.
- Reduce the risk of audit findings or penalties due to incorrect VAT data.
Try the report
Try the report here: VAT Registration No. Check
Tip
If you hold down the Ctrl key while you select the report link, the report opens on a new browser tab. The new tab lets you stay on the current page while you explore the report on the other browser tab.
Related information
VAT management overview
Built-in VAT reports in Business Central
Built-in key finance reports
Ad hoc analysis on finance data
Financial analytics overview