cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Everything you need to know about banking in QuickBooks Online - Discover more
kevin32
Level 1

Is there a VIES report on Quickbooks UK? This is the report that lists who the business sold to during the VIES period and that customers foreign vat number?

 
Solved
Best answer December 23, 2020

Accepted Solutions
John C
QuickBooks Team

Is there a VIES report on Quickbooks UK? This is the report that lists who the business sold to during the VIES period and that customers foreign vat number?

Hi Kevin32 The report may contain no data if you haven't included the country within the customers address details. It could also be that transactions don't have an EC VAT code or the transactions are in a different date period than the period you're running the 101 report for.

View solution in original post

3 REPLIES 3
Jovychris_A
Moderator

Is there a VIES report on Quickbooks UK? This is the report that lists who the business sold to during the VIES period and that customers foreign vat number?

Yes, there's a VIES report on QuickBooks UK, @kevin32.

 

This report is called the EC Sales List (VAT 101) report, which shows you the summary information for all the goods your business has supplied to a customer in another European Union (EU) country. It will help you run your report in QuickBooks and then complete and submit it manually to HMRC.

 

You can run the VAT 101 Report to see the amount of net sales 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.

 

You can get this done in QuickBooks Online UK.

 

I'll add this article as your reference for more details about VAT and EC VAT codes and rates: Common VAT Codes.

 

If there's anything else I can help you with running reports, feel free to tag me. I'm here ready to help. Take care and happy holidays!

kevin32
Level 1

Is there a VIES report on Quickbooks UK? This is the report that lists who the business sold to during the VIES period and that customers foreign vat number?

Thanks Joy, 

 

That was really helpful. I had tried that , but for some reason, even in the sample company, that report is coming up empty, in that "it doesnt contain any data".

 

This is coming up for all my Quickbooks UK clients. Any idea what would be causing this?

John C
QuickBooks Team

Is there a VIES report on Quickbooks UK? This is the report that lists who the business sold to during the VIES period and that customers foreign vat number?

Hi Kevin32 The report may contain no data if you haven't included the country within the customers address details. It could also be that transactions don't have an EC VAT code or the transactions are in a different date period than the period you're running the 101 report for.

Need to get in touch?

Contact us