Accounts Tax (VAT) EC Sales List Tab
Table Of Contents
Overview
Important: The EC Sales List (ECSL) is no longer required for most UK businesses following Brexit. However, some customers may still need to produce ECSL reports in specific circumstances.
The EC Sales List report is used to identify the value of sales made to VAT-registered customers in EU member states.
Unlike Intrastat reporting, which focuses on the movement of goods, the EC Sales List is concerned with:
- VAT-registered customers.
- The total value of sales.
- Delivery charges included within the order value.
- Reporting by customer VAT registration number.
The report is available from:
Accounts | Tax (VAT) | EC Sales List
For details on configuring ECSL reporting, see EC Sales List (ECSL).
Note: For information about the Other Actions menu, press F9 or see Accounts Other Actions Menu.
Running an EC Sales List Report
The screen consists of:
- Filters and options at the top of the screen.
- A results grid displaying ECSL data.
After selecting the required criteria, click Go to generate the report.
Filters and Options
Go
Click Go to populate the report using the selected filters.
Period
Choose how the data should be reported.
Quarterly
The standard format typically used for electronic ECSL submissions.
When selected, you can specify:
- Year
- Quarter
Monthly
Returns ECSL data for a single month.
When selected, you must specify:
- Year
- Month
Date Range
Returns ECSL data between two dates.
When selected, you must enter:
- From Date
- To Date
Warning: Reports produced using a date range are suitable for analysis only and are not intended for electronic or online submission.
Past VAT Returns
Displays previously submitted EC Sales List returns.
When selected, choose the relevant year from the available list.
Date Range Panel
The options displayed depend on the reporting period selected.
Quarterly
Year
Select the reporting year.
Quarter
Select:
- Quarter 1
- Quarter 2
- Quarter 3
- Quarter 4
Monthly
Year
Select the reporting year.
Month
Select the reporting month.
Date Range
From and To
Specify the reporting period manually.
Note: Date Range reporting is not suitable for electronic submission.
Past VAT Returns
Year
Select a year to display previously generated EC Sales List returns.
Include Allocation Transactions (UT Prefix)
If payments have been marked as underpaid or overpaid, adjustment transactions are created and identified with the prefix: UT
These can be viewed within:
Tick this option if you want these allocation transactions included in the ECSL report.
VAT Number
Displays your company's VAT registration number.
Contact Name
Enter the contact name that should be associated with the report.
Branch
Enter your branch reference where applicable.
Export to CSV
Use the export button to create a CSV file containing the report data.
This can be used for further analysis or submission where required.
Understanding the EC Sales List Grid
The results grid displays one line per qualifying customer.
Country
The customer's country code.
This is taken from the Code field in:
Examples:
FR
DE
ES
IE
VAT No
The customer's VAT registration number.
This is taken from the Tax Ref field in:
Reference
The customer's URN.
This is taken from the Code (URN) field in:
Total
The total value of qualifying sales made to the customer during the selected reporting period.
This includes applicable delivery charges.
Context Menu Options
Right-click within the report grid to access additional options.
Go To Customer
Opens the customer's:
screen.
This can be useful when checking VAT registration details or customer information.
Clear Selection
Removes any current row selections from the grid.
Typical Uses
The EC Sales List report can be used to:
- Review sales made to VAT-registered EU customers.
- Verify customer VAT registration details.
- Produce ECSL submission data where required.
- Analyse historic ECSL returns.
- Export ECSL information to CSV format.
Additional Information
- The report focuses on customer VAT registrations and sales values rather than individual products.
- Delivery charges are included in the reported totals.
- Date Range reports are intended for analysis only and are not suitable for electronic submission.
- Customer VAT numbers are taken directly from the customer record.
- Past EC Sales List returns can be reviewed from within the report screen.