How to calculate and save your VIES Return - Ireland only
Description

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

  • Has a tax code which 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 on a monthly, quarterly or annual basis depending on if it includes goods or services.

NOTE: Quarterly is calendar quarter but not based on your financial year so should be submitted for Jan - Mar, Apr - Jun, Jul - Sep and Oct - Dec.

For more information about this, please refer to Revenue at http://www.revenue.ie/en/customs/businesses/vies-intrastat.html

Cause
Resolution

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 1 = January, February and March, Quarter 2 = 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've 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 CodeThe 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.
    FlagThe 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\CThe customer's account reference.
    TypeThe type of transaction, either Sales Invoice, SI, or Sales Credit, SC.
    No.Transaction number taken from the audit trail.
    N/CNominal Code.
    DateTransaction date.
    RefTransaction reference.
    Goods\ServiceWhether the transaction is goods or services. This is determined by the tax code used.
    DetailsTransaction details.
    AmountTransaction amount.
    Triangulated?Select this check box if the transaction was triangulated*
    *Triangulation is the term used to describe the chain of intra-EC supplies of goods involving three parties. But instead of the goods physically passing from one to the other, they are delivered directly from the first to the last party in the chain.

    For example, a Irish based company buys goods from a VAT Registered Trader in France and then subsequently 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 Oonline 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 break down of the VIES Return individual transactions, select the VIES Details check box.

  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:

ReasonHow to checkHow 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:  You must 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 check box > OK.
The transaction is dated outside of the VIES Return periodTransactions > 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 >

[BCB:43:CSAT - Move feedback:ECB] [BCB:62:F1 Help Centre promo:ECB]

Steps to duplicate
Related Solutions