Creating a VAT Exempt report with VAT ID's

Send · ‎June 03, 2020

We've set up various VAT rates in QBO. One of the rates is 'VAT Exempt 0%' for our B2B customers in Europe who have a valid VAT ID.

Now I'm trying to create a report with the companies that have used this VAT rate in a certain period. The report should have at least these columns:
- Company Name

- VAT ID

- Sum of total invoices for this company

I found this topic where there is a discussion about the 'VAT 101 report'. I search through QBO but I do not see any possibility to see any VAT 101 Report, neither do I have the option to add a VAT ID column to the Sales by Customer Detail report.

Can anyone help me to create this report?

JessT · ‎June 04, 2020

Thanks for coming back, Send.

As you're using the Global Quickbooks version. You can pull up tax reports on the Reports page. Simply search for VAT and you see the suggested reports related to VAT.

With regard to your question, we're unable to create a report with this info on one report.

Company Name
VAT ID
Sum of total invoices for this company

You need two reports here for the list of company names and total sales. However, you will need to check their individual profiles to get the VAT number since this info is not on reports.

To get the Company name, you can pull up the Customer Contact List report. If you want to add columns, you can click the small Gear icon on the report page, and place a checkmark on the column names you like.

To get the total sales, you can pull up the VAT 21% - Tax Detail Report and export it to Excel. Using the Filter function and Sort function in Excel you can filter the transactions of the customers that use VAT Exempt 0%. Then, sort them by customer name, and get the sum of their sales.

Let us know if you have follow-up questions.

View solution in original post

EmmaM · ‎June 03, 2020

Hi, SendDirect:smiling_face_with_smiling_eyes: We'd love to help you with a report that brings through all that information. The VAT id you mention in your post is not a standard column on an invoice is this a custom field you have created or you putting the id in the description box/message on invoice box? As a side note, the VAT 101 report is in all QuickBooks online packages if you go to reports on the left-hand side in a browser version on a pc> either search VAT 101 in the search box in the top right or scroll on the topics within reports to manage VAT it should be there.

Send · ‎June 03, 2020

Hello Emma

There is no VAT 101 in our reports. Is it possible it's only available if you're using the UK version of Quickbooks Online?

We only have
- Tax liability report
- Tax detail report
- Tax Exception Report
- Tax Summary Report

As for the VAT-Id I'm talking about the "Tax Reg. No." in the "Tax info" tab in the customer information.
Thank you

JessT · ‎June 03, 2020

Hi Send,

Yes, the VAT 101 report is available in the UK version. What version are you using? I mean when you sign up for QBO, what country did you choose so we can create a dummy account and replicate your scenario?

Thanks in advance.

Send · ‎June 04, 2020

Hello,

We are based in the Netherlands so that country was used when we created the account. I'm not sure which version of QBO we're using, is it Global? I can give you access to our account if you wish, there is only test-data for now.

JessT · ‎June 04, 2020

Thanks for coming back, Send.

As you're using the Global Quickbooks version. You can pull up tax reports on the Reports page. Simply search for VAT and you see the suggested reports related to VAT.

With regard to your question, we're unable to create a report with this info on one report.

Company Name
VAT ID
Sum of total invoices for this company

You need two reports here for the list of company names and total sales. However, you will need to check their individual profiles to get the VAT number since this info is not on reports.

To get the Company name, you can pull up the Customer Contact List report. If you want to add columns, you can click the small Gear icon on the report page, and place a checkmark on the column names you like.

To get the total sales, you can pull up the VAT 21% - Tax Detail Report and export it to Excel. Using the Filter function and Sort function in Excel you can filter the transactions of the customers that use VAT Exempt 0%. Then, sort them by customer name, and get the sum of their sales.

Let us know if you have follow-up questions.

Topics

Training

Community

Resources

Creating a VAT Exempt report with VAT ID's