How to calculate and save your VIES Return - Ireland only

If you're registered for VAT and supply goods and services to VAT-registered customers in the EU, submit a VAT Information Exchange System (VIES) Return.

The VIES Return includes all transactions that meet the following criteria:

• It has a tax code that is linked to EC Sales. By default, T4 and T22
• Posted to a customer who is VAT registered in other EC member states
• The customer record includes a valid VAT number and EC country code

You can submit your VIES Return to Revenue on a monthly, quarterly, or annual basis depending on if it includes goods or services.

If you have more than one company, you must submit a VIES Return for each company.

 

 

For more information about this, refer to Revenue.

Calculate and save your VIES Return

1. On the navigation bar, click VAT then click VIES Return.
2. In From and To enter the start and end dates, choose the appropriate Period Ref then click Calculate.
   
   

   NOTE: VIES Return periods are defined as either a month, or fixed calendar quarters. For example, Quarter one = January, February and March, Quarter two = April, May, and June. Use the blank option when you want to run a Return that isn't either for a month or a quarter. The list appears showing the EC VAT registered customers who have received sales invoices with an EC tax code from you in the reporting period. The default EC tax codes are T4 and T22.

   The column headings are as follows:
   

   Country Code	The customer country code as defined in the customer record.
   Customer's VAT Registration No.	The customer's VAT Registration Number as defined in the customer record.
   Value of supplies of goods (to nearest Euro)	Total value of the invoiced goods and services less any credit notes posted with an EC tax code, in Euros.
   Flag	The flag column is used to indicate transactions where triangulation has occurred:   No Flag - Business to business transaction for goods T - A triangulation transaction S - Business to business transaction for services

---

Check your VIES Return and flag transactions for triangulation

1. To see a breakdown of the individual sales to one customer, In the Value of supplies of goods (to nearest Euro) column, click the drill button .
   
   The VIES Return Transactions window appears showing the following information for each transaction:
   

   A\C	The customer's account reference.
   Type	The type of transaction, either Sales Invoice, SI, or Sales Credit, SC.
   No.	Transaction number taken from the audit trail.
   N/C	Nominal Code.
   Date	Transaction date.
   Ref	Transaction reference.
   Goods\Service	Whether the transaction is goods or services. This is determined by the tax code used.
   Details	Transaction details.
   Amount	Transaction amount.
   Triangulated?	Select this checkbox if the transaction was triangulated*

   *Triangulation is the term used to describe the chain of intra-EC supplies of goods involving three parties. Instead of the goods physically passing from one to the other, they’re delivered directly from the first to the last party in the chain.
   
   For example, an Irish based company buys goods from a VAT Registered Trader in France and then later sells the goods on to a third party that's VAT registered in Italy. The goods never enter Ireland and are shipped directly from France to Italy.
   
   
2. To save any changes to the VIES Return - Transactions window click Save.
3. To save the VIES Return, click Save.
   
   A message appears advising that your VIES Return has been saved to a location on your computer. It saves as an XML file, read to upload to the Revenue Online Service (ROS) website.
   
   
4. To open the location, click Yes.
5. To return to the VAT module, click No then click Close.
   
   

   NOTE: The VIES Return saves to a folder, VIES Archives, alongside your ACCDATA folder. For example, if the path to your ACCDATA folder is C:\ProgramData\Sage\Accounts\2020\COMPANY.000\ACCDATA your VIES Return saves to C:\ProgramData\Sage\Accounts\2020\COMPANY.000\VIES Archives 

---

Print your VIES Return

1. On the navigation bar click VAT, click the VIES Return you want to print, click VIES Return then click Print.
   
   

   TIP: If you want to print a full breakdown of the VIES Return individual transactions, select the VIES Details checkbox.

2. Select Printer, Preview, File, or Email as required, then click Run.

---

Reasons why transactions don't appear on your VIES Return

For a transaction to appear on the VIES Return certain criteria must be met. If a transaction doesn't appear it may be due to one of the following:

Reason	How to check	How to correct
The transaction has an incorrect tax code. It must use an EC tax code to appear on the VIES Return. By default, these are set up as T4 and T22.	Transactions > locate the transaction and scroll to the T/C column.	If the tax code is correct, you must check that it's an EC sales tax code. Read more > If the tax code is incorrect you must delete or reverse the transaction, and repost it. NOTE: If the transaction is a foreign currency transaction, you must reverse it.
The customer record doesn't include an EC VAT number or country code or the record didn't at the time the transaction was posted.	Customers > select the relevant customer record > New/edit. Transactions > Right-click relevant transaction > View > Country	Choose the correct EC Country and enter the correct VAT Number and tax code in the customer record. In Sage 50 Accounts, if you use delivery addresses you must also check these details are correct. After making any amendments, for the transaction to appear in the VIES Return, you must delete and re-enter the transaction. If the customer record is correct now but the country code on the transaction is different or incorrect, the transaction will need to be deleted and reposted  NOTE:  Ensure the VAT Number is in the correct format for the country.
Sage 50 Accounts and above - The customer's delivery address doesn't include an EC VAT number or country code.	Customers > select the relevant customer record > Record > Addresses & Contacts > select the Delivery Address > Edit.	Choose the correct EC Country and enter the correct VAT Number and tax code in the customer record. If you use delivery addresses, you must also check these details are correct. Once you've corrected this you must delete and re-enter the transaction for it to appear in the VIES Return.
The country on the customer record isn't selected as an EC country. NOTE: If you select a secondary address inside the EU for the invoice or order, you can flag transactions for the VIES Return even if the customer's main address is outside the EU.	Settings > Countries.	On the required country select the EU Member checkbox > OK.
The transaction is dated outside of the VIES Return period	Transactions > locate the transaction and scroll to the date column.	If the date is incorrect, you can correct the transaction.
The T4 or T22 tax codes aren't flagged as EC tax codes.	Settings > Configuration > Tax Codes.	If you use T4 and T22 as your EC tax codes, you must ensure that the EC Code settings are correct. Read more >

---