cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
NEW Connect to DBS IDEAL direct bank feeds Click here
copier plus
Level 1

Customer detail report with vat number field

Hello, 

 

I m try to find a report where I can export all the current customer registered in my QuickBooks, I m able to export a report with most of the details, but I want the tax number or vat number also to be shown in a field when i export the customer details, 

 

Can some one help me with this

3 Comments 3
ArielI
QuickBooks Team

Customer detail report with vat number field

Hello, @copier plus.

 

I'm here to assist you in adding the VAT number to your detailed report in QuickBooks Online (QBO).

 

To begin, you need to put a check on VAT Registration NO. of Customer, this way the VAT number will show up in exporting your report. Here's how:

 

  1. Go to Customer Contact List and hit Customise.
  2. Click Rows/Column.
  3. Check VAT Registration No. of Customer.

rename.png

 

After you put a check, here's how to add VAT number:

 

  1. Go to Customers & leads and click Customers.
  2. Select the transaction that you want to export.
  3. Hit the Edit.
  4. Scroll down to the Additional Info section and add the VAT Registration Number.
  5. Click Save.

 

To export the transactions with the VAT numbers, here's how: 

 

  1. Go to Reports.
  2. Hit the search bar and look for Customer Contact List.
  3. Click the Switch to classic view.
  4. Then click the export icon above.

Capture uuuuuuuuuuuuu.PNG

You might also want to read these articles to learn more about VAT rates:

 

 

If you have further questions about adding a VAT number to your detailed report, you can comment below, and we'll respond to you as soon as possible.

copier plus
Level 1

Customer detail report with vat number field

Screenshot 2024-02-29 154820.png

this how we see the report. vat registered number still not there

 

DebSheenD
QuickBooks Team

Customer detail report with vat number field

Thank you for coming back to the Community and letting us know the result of the solution shared by my peer, @copier plus. I’m here to help ensure the VAT registered number will show when exporting the report.


To determine the source of the issue, we’ll need to thoroughly check the category type used for the transactions and the tax setup. The process requires special handling because I need to collect personal data to pull up an account. 

 

That said, I recommend you get in touch with our QuickBooks Online (QBO) Care Team. They can perform in-depth troubleshooting in a secure space. Then guide you on how to apply the resolution steps from there. 

 

Here’s how to reach them:

 

  1. Hover your mouse to the Help menu in the upper right to see more options.
  2. Go to the Assistant tab and then enter a brief description of your concern in the Type Something field. For example, missing VAT registered number when exporting report and wants to contact support.
  3. Click the Contact Support menu to display the How would you like to connect with us? Screen.
  4. Press the Chat with us button to start a conversation.


You can go over this article for detailed information about the support hours and types: How and when can I contact Support?


For additional resources, the Tax link contains a breakdown of articles about VAT, GST, and general tax FAQs.  In addition, you can browse the following reference to learn more about different reports available in the online program as well as ways to tailor each one: QBO self-help guide.


If you have any other questions about your running a report and other forms, let me know by adding a comment below. I'm always here to help. Keep safe!