cancel
Showing results for 
Search instead for 
Did you mean: 
Established Member

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
Highlighted
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.

 

6 REPLIES 6
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?

Established Member

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.

Highlighted
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.

 

Established Member

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.

Established Member

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