This is what happens in the video
The VAT VIES report shows how much you have sold to companies in other EU countries. Every company in Denmark, and across the EU, has to report this to the authorities. The report only covers sales, and only the value of those sales. You report per VAT registration number for specific periods, normally per month.
In Business Central, you run this from the EC Sales List report. You report physical items, services, and third-party trade. You only include business-to-business sales. Sales to end customers, where there is no VAT involved, are not reported.
If you sell to the same few customers, you often only have a handful of lines, which you can enter manually. If you have many customers, you can export a file from the VAT VIES reporting and import it directly to the authorities.
Make sure you remove your own country from the EU Country/Region Code field in the Countries/Regions setup. If you leave your own country marked as an EU country, the report will include your domestic sales as well, which is wrong.
What the VAT VIES report covers
The VAT VIES report displays how much you have sold to another EU company. Every company, at least in Denmark, has to report to the authorities how much they have sold to other EU companies.
This reporting is only done on the sales side, and it only concerns the value of the sales. You normally report per VAT registration number for specific periods. What needs to be reported includes physical items, services, and third-party trade.
Using the EC Sales List report in Business Central
The report that shows you how much to report to the authorities is called the EC Sales List. There are actually two versions. The first one is used when there is no third-party trade involved.
From the report, you select a posting date. This is normally done per month, because you have to report it by month. You then preview the report and get the information you have to give the authorities.
The report is written only in total amounts that you have to report per VAT registration number.
Manual entry versus exporting a file
Many customers only have a few lines in the report, because they sell to the same customers. In that case you can insert the figures manually.
If you have many customers, you can instead export a file with the VAT VIES reporting. You find the file option in the menu and then report it as a file to import to the authorities.
Which sales are reported
You only report business-to-business sales to companies in other EU countries. If you sell to end customers, where there is no VAT, those sales are not reported here.
Setting up the EU country/region codes correctly
In the Countries/Regions setup table, you need to remove the EU country code from your own country. Otherwise, the report will include VAT VIES figures for your domestic sales as well.
For example, if Denmark is listed in the EU Country/Region Code field and Denmark is your own country, it should not be there, because you are not going to report domestic sales. Remove it from your country/region setup to avoid reporting it by mistake.
Q&A
What is the VAT VIES report used for?
It shows how much you have sold to companies in other EU countries, so you can report this value to the authorities. It only covers sales and only the value of the sales.
What needs to be reported in the VAT VIES report?
You report physical items, services, and third-party trade. You report per VAT registration number for specific periods, normally per month.
Do I have to report sales to end customers?
No. You only report business-to-business sales. Sales to end customers, where there is no VAT, are not reported.
Can I export the VAT VIES report as a file?
Yes. If you have many customers, you can export a file from the VAT VIES reporting and import it directly to the authorities. If you only have a few lines, you can also enter them manually.
Why is the report including my domestic sales?
Your own country is probably still marked as an EU country in the Countries/Regions setup. Remove your own country from the EU Country/Region Code field so the report only includes sales to other EU countries.