Skip to content

EC Sales List

Being able to create an EC Sales List is great news for all of Xero’s UK users; it’s nice to be able to tick off another highly requested Xero Community feature

If you’re not a UK user, don’t leave! I’ve listed a couple of other updates at the bottom of the post that may be of interest to you.

For the rest of you, below is a quick overview of what we’ve done (and what’s still to come).

There are three primary features of the EC Sales List:

  • EC Sales List – the main report itself, including custom validation to ensure the necessary information is present and in the correct format to be submitted to HMRC Online Services.

  • Audit report  – an accompanying report that lists all the transactions that make up the main report.

  • HMRC export  – as well as standard export formats for PDF, Excel and Google Sheets, there is a custom HMRC format that can be easily submitted via the HMRC portal.

EC Sales List

The main report looks as you’d expect  – for each contact, we provide the total amount of EC sales split by goods and services. The transactions that appear are determined by the use of the tax types EC Sales Goods or EC Sales Services. These are generally linked to the tax rates you use for EC Sales such as Zero rated EC Goods Income or Zero rated EC Services.

You can run the report for any period and for convenience we have added date selection options for this month, last month, this quarter, last quarter or a financial year.

EC Sales list in Xero accounting software

We’ve also tightened up the way VAT numbers are recorded against your contact records. For EC Sales reporting, all VAT numbers must include a two character country prefix. If you haven’t entered the prefix or have included an invalid VAT number, we’ll warn you (in red on the EC Sales List report) and you can drill through to the contact record to update.

Audit report

The audit report contains the full list of all the individual transactions that were used to derive to totals on the main report. This is great for tracking down miscoded transactions and confirming the results.

EC Audit report in Xero accounting software

HMRC export

And finally, once you’re happy with the numbers, you can export the report to a format that can be easily uploaded to the HMRC.

What’s left to do?

In a future release, you’ll be able to save and publish the report. This work is being completed as part of a wider re-write of all our reports, the first of which should be out over the next few months.

We’ve also got a few other UK VAT related updates to work on – top of the list is a better way to handle VAT Reverse Charges and EC Acquisitions. We’ll let you know when these are on their way.

What else has been released?

We’ve included a couple of smaller updates:

  • Including files with online invoices  – when you attach files to invoices, you can optionally flag which files should also be made available, via a link, on the invoice when viewed online.

  • Attaching files to pay runs and payslips (note this has not yet been included in Payroll)
  • Embedding your profile into your own website  – grab the HTML snippet from your profile page and copy it into your blog or website.

  • Editing invoice themes on paid invoices  – we have had a few requests on Xero Community and elsewhere to let you change the invoice theme on paid invoices…and now you can!

As always, full details on these and other features can be found in our release notes.

 

Read more about Company News, HMRC

 

9 comments

James
10 March 2014 #

‘include files with online invoices’ feature will be great for us. Can you load the file and mark as ‘include with invoice’ through the API?

Sonya Jones
10 March 2014 #

Hi James, this functionality is not available via the API yet but certainly something we’re looking to offer in the future. To be kept up to date with API improvements vote on our API suggestion site.

Donna Dicks
11 March 2014 #

10 days ago one of my Xero clients asked if she could attach an extra file to her invoices from Xero & I said no…today I told her yes! So nice to be working with software that is always improving :) happy client happy me!!

Susanna Russell-Smith
11 March 2014 #

So pleased to have this EC Sales List – it was such a palaver to produce before!

Paul Horner
22 March 2014 #

I have a question on the HMRC submission file which is exported from Xero. It doesn’t seem to export with any filename suffix?? I assume this is CSV, so do I first need to rename the file and add a .csv suffix beofre i can submit to HMRC?

Andrew Tokeley
24 March 2014 #

@Paul – yep, well spotted, it should have the .csv suffix. Was actually fixed this in today’s release so check again. Thanks for raising.

Paul Horner
24 March 2014 #

Well done guys.

Carl Partridge
8 May 2014 #

This is long overdue – I’m delighted to see it finally included in Xero. The implementation is great too, thanks guys.

All we need now is proper support for Reverse Charging of purchases and Xero will finally be a solution I can recommend to UK companies that are VAT registered!

Andrew Tokeley
8 May 2014 #

@Carl – thanks for the thanks. You’ll be glad to hear we’ve started work on Reverse Charges (and EC Acquisitions) and progressing well – can’t give a timeframe yet but, we know it’s important…

Add your comment





We welcome all feedback but prefer a real name and email address.