Skip to main content
S
scboyd99
March 18, 2021
Question

I need a list of accounts and vendors that includes the QBO ID.

  • March 18, 2021
  • 4 replies
  • 0 views
I need a list of accounts and vendors that includes the QBO ID. I have read that QBO does not offer this as a standard report. I've read you can do it in Zapier. Could someone point me to the ZAP that will get this info for me. But why should I use my monthly zaps for this? How can I contact QBO and request this report?

4 replies

MJoy_D
MJoy_D
March 18, 2021

I can help you in generating the reports that you need, @scboyd99.

 

Are you referring to your QuickBooks Online (QBO) Company ID on top of your report? You can generate an Account List and Vendor Contact List report separately for your accounts and vendors in QBO. However, to include that QBO ID in your reports is currently unavailable.  

 

To generate an Account List report:

  1. Go to the Gear icon and select Chart of Accounts.
  2. Choose the Run Report button beside the New button on the Chart of Accounts page. 
  3. From here, you can click on the Customize button at the top to apply multiple filters.

 

To generate a Vendor Contact List report:

  1. Go to the Reports menu and search Vendor Contact List in the search box.
  2. Click to run the report.
  3. Same with the first report, you can click on the Customize button at the top to apply multiple filters.

 

Check this article for more information on how to run reports in QuickBooks Online.

 

The following article will help you customize reports in QuickBooks Online.

 

In case you mean something else or you need further help in generating your reports. Let me know in the Reply section below. Take care and have a wonderful day!

S
scboyd99Author
March 18, 2021

Hi MaryJoyD,

 

This is not what I am looking for specifically.  I am looking for a Customer and Vendor report that includes the QBO nameid for each customer and vendor.   Thank you.

 

Q
qu5
May 11, 2022

Hello, 

 

Can you show us how to find the name ID in QBO. 

I followed the steps to create the chart of accounts, and vendor list, but I cannot see / find the name ID associated to each vendor anywhere. 

 

thanks 

1
11Agz
January 25, 2025

Its frustrating that this isn't easily accessible. I was able to get the ID with a Loop by Zapier. But this wasn't cheap because it creates tasks for each updated row. Someone might have a better Zap, but this worked out for me. You only get 500 rows per action, so you will have to run it multiple times or add a path to run it multiple times in parallel (be sure to adjust the subsequent action's starting row by +500).

 

After I got my list, I turned it off and just used both the New Vendor trigger alongside the Update Bill trigger to create two lower usage Zaps for maintenance (with Update Bill, I used actions to Search/Filter for a blank VendorID column in my Vendor table and then update the Vendor record using Find Vendor if the data was missing).

1
11Agz
January 25, 2025

Its frustrating that this isn't easily accessible.

 

I was able to get the ID with a Loop by Zapier. But this wasn't cheap because it creates tasks for each updated row. Someone might have a better Zap, but this worked out for me. You only get 500 rows per action, so you will have to run it multiple times or add a path to run it multiple times in parallel (be sure to adjust the subsequent action's starting row by +500).

Terms & ConditionsAccessibility statement