cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Hello - How do I get an EC Sales List which shows each customer's EU Vat# ? Thanks in advance!

 
Solved
Best answer 05-01-2019

Accepted Solutions
QuickBooks Team

Re: Hello - How do I get an EC Sales List which shows each customer's EU Vat# ? Thanks in advance!

Welcome back to the Online Community, chris80.


Thanks for sharing to me the specific information you need in order to file the VAT form.


You can run the VAT 101 Report to see the amount of net sale and customers with EU VAT number.

 

  1. On the left panel, select Reports.
  2. Enter the VAT 101 Report in the search field.
  3. Under Report period, click on the drop-down and select the correct date range.
  4. Go to the CUSTOMER'S VAT REGISTRATION NUMBER section to get the EU VAT number.
  5. Under TOTAL VALUE OF SUPPLIES IN POUNDS STERLING, you’ll see the net sales.
    101.png


These steps should get you pointed in the right direction.


Let me know about your success in submitting the return. I want to make sure everything is taken care of and you're all set with this concern.

 

Frequent Explorer *

Re: Hello - How do I get an EC Sales List which shows each customer's EU Vat# ? Thanks in advance!

Ok thanks. Tested that. Yes to confirm:
For a transaction to show in the VAT101 report all four fields for the Customer Information details have to be accurate and complete.
1. Country field: QB lets you enter any string BUT only the ones in the drop down work. Italy not Italia for example. You HAVE to use the drop down list.

and

2. Customers Vat No including Country Code (QB term is Tax Reg No) - in the TAX info tab.

and

3. EC codes in the transaction.

 

Why is QBO so backward compared to my very old desktop version? Your really need to fix these problems if you hope us the users to recommend others to sign up to QBO.

15 REPLIES 15
QuickBooks Team

Re: Hello - How do I get an EC Sales List which shows each customer's EU Vat# ? Thanks in advance!

Hey Chris,

 

The EC Sales List - is very specific, and matches a format required from HMRC for this. You may not be able to show the information you're looking for per customer on that report. The EC Sales List, or VAT 101 report - only shows the value per country for the period chosen.

 

You'd likely be better to select either a VAT Detail report, and then customize and filter by customer.

Or, perhaps even clearer, would be to run a "Sales by Customer Detail" report, customize and add columns for VAT Code, Tax amount and Net amount. (or just Tax Amount)

 

What kind of format do you want to have the information shown in? - are you just looking for a summary of the amount of VAT per customer or a detail as above?

Not applicable

Re: Hello - How do I get an EC Sales List which shows each customer's EU Vat# ? Thanks in advance!

Hello James,

 

Thanks for your prompt answer.

 

The VAT form that we complete (on the HMRC website) each quarter, asks for the following (for each sale to a customer who is in the EU and has an EU VAT#):

- a) EU VAT number

- b) Net amount of sale

 

... but the EC Sales report in QuickBooks doesn't seem to give me a).   The Desktop version of QuickBooks did, but the online version doesn't; EU VAT number doesn't seem to be one of the fields we can choose to show on the report.  Seems an odd omission, as this is what HMRC require?

Thanks for your help.

QuickBooks Team

Re: Hello - How do I get an EC Sales List which shows each customer's EU Vat# ? Thanks in advance!

Welcome back to the Online Community, chris80.


Thanks for sharing to me the specific information you need in order to file the VAT form.


You can run the VAT 101 Report to see the amount of net sale and customers with EU VAT number.

 

  1. On the left panel, select Reports.
  2. Enter the VAT 101 Report in the search field.
  3. Under Report period, click on the drop-down and select the correct date range.
  4. Go to the CUSTOMER'S VAT REGISTRATION NUMBER section to get the EU VAT number.
  5. Under TOTAL VALUE OF SUPPLIES IN POUNDS STERLING, you’ll see the net sales.
    101.png


These steps should get you pointed in the right direction.


Let me know about your success in submitting the return. I want to make sure everything is taken care of and you're all set with this concern.

 

Not applicable

Re: Hello - How do I get an EC Sales List which shows each customer's EU Vat# ? Thanks in advance!

Dear Rasa,

 

Thank you for your quick response.   When I run that report, I get 'This report does not contain any data.'.

I think this means that I have not set-up my EU customers properly ?   What does a customer or invoice need to do, to appear in the "VAT 101" report ?

 

Thanks in advance.

 

Chris

QuickBooks Team

Re: Hello - How do I get an EC Sales List which shows each customer's EU Vat# ? Thanks in advance!

Hi Chris

 

The main reasons why the data may not be appearing in the VAT 101 report are, you are not running the correct date range to include the relevant transactions, you have not not included the country within the address section in your customers details, or entered an EC VAT code on the invoices.

Not applicable

Re: Hello - How do I get an EC Sales List which shows each customer's EU Vat# ? Thanks in advance!

Thanks, John - will check those things and hopefully all will then be well.

Will let you know if still have a problem thereafter.

Thanks to everyone for their swift help on this.

 

Chris

Frequent Explorer *

Re: Hello - How do I get an EC Sales List which shows each customer's EU Vat# ? Thanks in advance!

This does not work  for me on two counts:

1. It does not report every EC customer, it misses some. Your can see the full list of EC customers by expanding your last VAT report. Go to Reports / VAT100 / Last financial quarter and expanding Box 8 Supplier to EC states for the definitive list. This is the figure HMRC are expecting you to provide detail on.

 

2. This method also only reports the Gross Value. If  you have Discounted the invoice using the optional Discount box it will not report the Final Invoice values after the discount.

 

Setting (cog) / Accounts and settings / Sales / Sales Form Content / Discount Tick box.

Not applicable

Re: Hello - How do I get an EC Sales List which shows each customer's EU Vat# ? Thanks in advance!

Thanks for your reply, AWUK.

Expanding Box8 will show the customers - thanks - but I still have my original problem; that the report does not show the EU VAT# for these customers ... which is what I need to enter on the EC Sales List that the government requires from me.

QuickBooks Team

Re: Hello - How do I get an EC Sales List which shows each customer's EU Vat# ? Thanks in advance!

Hi chris80

 

The only details that HMRC require  in relation to an EC Sales List are the details of each of your customers (the VAT registration number), the sterling value of the supplies you have made to them and the customers country code, all of these are listed on the VAT 101 report.

 

Please refer to the Overview section within the link below.

 

https://www.gov.uk/guidance/vat-how-to-report-your-eu-sales

Not applicable

Re: Hello - How do I get an EC Sales List which shows each customer's EU Vat# ? Thanks in advance!

Yes, the VAT101 should work, but we are now back at the conversation I had with Rasa above - namely that when I run that report, I get 'This report does not contain any data.'.

QuickBooks Team

Re: Hello - How do I get an EC Sales List which shows each customer's EU Vat# ? Thanks in advance!

Hi chris80

 

For any of your customers information to be populated in the VAT 101 report you will have to ensure that within the customer detail you have included the country they are from in the address section, the Tax Reg No. in the Tax info section and you have selected an EC code in the VAT column with any transactions you have created. You will also have to ensure that the date of the transaction corresponds to the dates of the VAT 101 report you are running.

Frequent Explorer *

Re: Hello - How do I get an EC Sales List which shows each customer's EU Vat# ? Thanks in advance!

Ok thanks. Tested that. Yes to confirm:
For a transaction to show in the VAT101 report all four fields for the Customer Information details have to be accurate and complete.
1. Country field: QB lets you enter any string BUT only the ones in the drop down work. Italy not Italia for example. You HAVE to use the drop down list.

and

2. Customers Vat No including Country Code (QB term is Tax Reg No) - in the TAX info tab.

and

3. EC codes in the transaction.

 

Why is QBO so backward compared to my very old desktop version? Your really need to fix these problems if you hope us the users to recommend others to sign up to QBO.

QuickBooks Team

Re: Hello - How do I get an EC Sales List which shows each customer's EU Vat# ? Thanks in advance!

Hi AWUK

 

The product has been designed to enable you to input the data relevant to your EC customers so you can run the VAT 101 report in accordance with the requirements of the EC Sales List/HMRC.

Frequent Explorer *

Re: Hello - How do I get an EC Sales List which shows each customer's EU Vat# ? Thanks in advance!

Sadly it does it worse than your product from 9 years ago.

Not applicable

Re: Hello - How do I get an EC Sales List which shows each customer's EU Vat# ? Thanks in advance!

Thanks, AWUK & John.

Your advice on the Country field is good ... for one of our customers, I have just selected "Germany" from the set drop-down list, and that customer has now magically appeared in our VAT101 report ... so I think that is the answer.   Thanks !

PS: Looks like we have found the answer just in time for the UK to leave Europe (!)  so not sure if we will need this report in future (who knows, when it comes to Brexit ?) ... but many thanks for finding the answer.