EC Sales List Export File
The EC Sales List Export File, found on the EC Reports menu, enables you to generate an XML file of EC Sales List data.
The EC Sales List report is required by HMRC from all UK Companies selling more than a set value per annum to foreign EU States.
The report can be printed from the EC Reports menu.
HMRC will now accept the EC Sales List electronically, in either a CSV or XML format.
The EC Sales List Export File option will produce your EC Sales List as an XML file so that you can upload it to the HMRC website.
You can also print the Audit file from this window. If selected, you will have the option of printing the Audit file to screen, printer or file. You will still be prompted to enter a file name for the Export file.
See Also:
EC Sales List, EC Sales List Audit, Intrastat Reports
Import XML Format
To be able to create the file, you must first import the XML format.
Open the System Options window.
Go to the Documents tab and open the XML Formats window.
Click on the Import formats icon.
Select the EC Sales List format (e.g. EC Sales List_1.01.tbt) and click Accept.
The template will be examined and processed and the result will be displayed.
If successful, you may just close the results window by clicking Accept.
If the import fails, copy the information from the results window to your clipboard so that you can paste it into Notepad or Word and print it for reference. You will need to contact your support provider for assistance.
When you close the results window, you will be returned to the XML Formats window.
The EC Sales List format should be visible in the list of imported formats. The format will be active and cannot be edited or deleted.
Producing the EC Sales List Export File
Select EC Sales List Export File to open the EC Sales List Export File window.
Configuring the report
As with the printed report, the EC Sales List Export File allows the selection of a Period or Quarter range within Last, Current or Next Years.
Please note that attempting to select transactions by entering a period range for Last Year will not display any returns if the Nominal Ledger Year End has not been run. This is the case even if the Sales Ledger Year End has been run.
The Quarter reference should be entered in the format QQ/YY so that the period range dates can be added to the report. For example, If you are in period C5, this falls in Quarter 2, so your reference would be 02/12.
Note: If you prefer to work with Period reference (e.g. PP/YY), this can be set up by selecting the 'Use 2010 Format' option in System Control Options [Documents tab].
Tick the print option if you wish to print the EC Sales List Audit Report after the Export file has been produced.
The Audit Report shows the detail behind the EU Sales List.
Select to print the audit file to screen, printer or file.
When you have configured the report, click OK to produce the report in XML format. An Output window will open, prompting you to name the file.
A file name will be suggested, this will contain today's date.
The directory in which the file will be saved will be displayed.
You can enter your own filename and use the browse button to locate a different directory if you wish.
Click OK to create the file. If you have selected to print the Audit report, this will be printer after the Export file has been produced. If you are printing the Audit report to file, you will be prompted for a file name.
About the EC Sales List
VAT Type G - Invoice and credit note transactions posted via both Sales Ledger and Sales Orders for VAT Registered customers using VAT Type G (Goods and Related Services) will be included on the EC Sales List.
VAT Type X - EU Reverse Charge accounting where the supply is subject to VAT will be included on the EC Sales List.
VAT Type S - The list does not include transactions posted using VAT Type S (Non-related Services)
VAT Type Y - The list does not include EU Reverse Charge accounting where the supply is not subject to VAT.