Produce your EC Sales List (ESL) or VIES return

Find this screen

Open: Customers > Customer Reports > Account Analysis > EC Sales List (XML)

How to

Produce the EC Sales List or VIES return

Open: Customers > Customer Reports > Account Analysis > EC Sales List (XML)

1. Specify the criteria for the report:

   • Calendar Quarter

     The calendar quarter covered by the ESL. Enter a number between 1 and 4:

     • 1 covers January, February and March.
     • 2 covers April, May and June.
     • 3 covers July, August and September.
     • 4 covers October, November and December.

   • First Calendar Month

     The first calendar month covered in the ESL. Enter a number between 1 and 12:

     • 1 = January.
     • 2 = February.
     • ...
     • 11 = November.
     • 12 = December.

   • For How Many Calendar Months

     The number of months that are to be included in the file.

     Sage 200 uses this number and the first month you specified to calculate which months to include.

   • Calendar Year

     The calendar year that is to be included.

   • Branch ID

     The branch ID given to you by HMRC if you are a self-accounting branch within a group VAT registration.

   • Contact Name

     The name of a contact within your organisation who can be contacted if there is an issue or query with the file.

2. Click Generate.

   The Save As window is displayed.

3. Give the file a name, browse to the location you want to save it and then click Save.

4. When the file is generated you can load it to the HMRC or ROS (Revenue Online Services) website.

   You perform this step outside of Sage 200. Go to the relevant website for further guidance.

---

Useful info

About the EC Sales List or VIES return

If you are registered for VAT and supply goods to customers in the EU you need to submit:

• An EC Sales List (ESL) to HMRC (for Northern Ireland, but not Great Britain).
• A VAT Information Exchange System (VIES) return to the Irish Revenue (for Ireland).

When you run the EC Sales List report in Sage 200, it produces an XML file that you can upload directly to the HMRC or Irish Revenue website.

Note: Although the report is called the EC Sales List, the information is also suitable for your VIES return in Ireland.

The report XML file includes the following information:

• The customer's country code.
• The customer's VAT registration numbers.
• The value of goods supplied in the period.
• The value of triangulated goods supplied in the period.
• The value of services supplied in the period.

---

What happens when

What happens when I generate the file?

Sage 200 displays a Save As window so that you can select a location on your PC or network to save the file.

You can then upload the file to the applicable tax authority through either the HMRC or Revenue website.