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

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!

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.

This is not exactly what I am looking for.  I am looking for the NameID of each customer and vendor within my QBO.  see the attached example.

I am here to ensure that you're able to generate and view the accurate information that you need in your report in QuickBooks Online, scboyd99. 

Currently, pulling up reports including QBO Name ID doesn't have an option in QuickBooks Online.  

As a workaround, you have to open two separate reports and export it in MS Excel. Let me guide you how. 

1. Click Reports, and choose Reports. 
2. Enter in the search bar Vendor Contact List. 
3. Tap Export icon, and select Export to Excel. 
4. Press Open with Microsoft Excel. Then OK. 
5. In the column field, you can add the Name ID. 

The same goes with the Customer Contact List Report. 

You can also read this article for your reference: Customize reports in QuickBooks Online.

I know the importance of having this kind of feature. I'll make sure to tap this into our developer's team. Our product engineers will continue to make improvements to the product, and this preference might be available in the future.  

Don't hesitate to leave a comment below if you have any other questions. Stay safe!

I'm confused by your suggestion.  I know I can add a column in excel.  How do the values appear in that column?  Are you suggesting I manually add that number to each customer and vendor??  I really REALLY hope not.  If this is not a value that I can export for QBO then I need to request QB Support to provide that list for me.  Thank you.

Thanks for coming back to us, @scboyd99. To clarify, yes. You'll need to manually add the Name ID number to each customer and vendor. 

Together with my peer, we're taking your suggestion and tap our engineers for future consideration. Please note that all our suggested plans are subject for further study. 

For future reference, I'm inviting you to visit our QuickBooks blog site to get updated about the newly added features in QuickBooks. 

You're always welcome to post some more of your concerns here in the Community. I'd be happy to attend your next posts. 

Is there a format in which we can now reflect Name ID from the list of vendors or is it still something that needs to MANUALLY be entered into our spreadsheet?

Thanks for checking this with us, Chubbiepig.

The option to reflect Name ID from the Vendor Contact List is still unavailable in QuickBooks Online (QBO). In the meantime, you can follow AileneA's recommendation which is to open two separate reports in Excel and manually add the Name ID from there. The steps on how to do this can be found in the previous reply.

Here's an article made handy about modifying columns on the report: Customize and modify columns on reports.

I also have some additional articles about managing a wide range of reports in QBO:

• Run reports in QuickBooks Online
• Memorize reports in QuickBooks Online

To help you with future tasks and tips when using QBO, you might want to visit our Help Articles.

As always, feel free to add a comment below if you have any other questions while running reports. I'll be around to help. Have a lovely day ahead.

Is this still not an option?!

It's my pleasure to answer your concern, @blake5. 

This option is still unavailable in QuickBooks. I understand how this functionality is convenient for everyone. I'm going to share this concept with our developers for future consideration. 

Please know that all our suggested plans are subject to further study. Hence, we are unable to determine when this option be added to the program. 

In the meantime, I'm inviting you to submit your suggestion by going to the gear icon and selecting Feedback. 

Come again if you have additional concerns. We're always here to help. 

Hello,

I want to know how to send an API request to get the vendor ID.

Please help me.

Hi there, enzosgarden1-gma.

Let me get you to the right support team that currently handles QBO API concerns.
 

We have Developers Team that is experts to help you get vendor ID.

Here's how you can reach them:

1. Visit this link: https://developer.intuit.com/app/developer/homepage.
2. Scroll down, at the bottom click Contact us under the Intuit column.
3. Select a topic from What do you need help with?
4. Click As a Question and follow on-screen instructions.

Also, let me share these easy-to-access articles, webinars, and video tutorials that will help you in familiarizing the different tasks, features, and functions of QBO. Below are the following:

• All QuickBooks Tutorials.​
• QuickBooks Webinars.
• Help Articles.

If there's anything I can help you with, just let me know by leaving a comment below or posting again. Thank you and have a great day ahead.

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 

I understand that you are saying we need to manually look up and populate the suppliers' name ID's but you're not showing how / where we can even manually look that up in QBO in order to be able to manually populate it. Where do we even find that number?

Are the ID’s of Vendors names, accounts, classes, etc all static? If I’m using the ID to input something into QBO is there any reason it would input it wrong?

Over 3 years later, is there a report to pull to get the Customer NameID? Between my 2 companies we have close to 8,000 customers and manually pulling those numbers from the URL is not acceptable. We have Avalara now and the only way the App can work properly is by accepting the data that QBO is pushing to it. The information that QBO is pushing for the customers is the NameID. Any help/ assistance is greatly appreciated. 

Hello there, @Arice.

I appreciate that you spent the time to post in this thread and let us know what you thought. 

Currently, a report containing a Customer Name ID is unavailable to reproduce in QuickBooks Online (QBO). I acknowledge that having these options would be easier for you and the other users with thousands of customers to extract that information. However, our developers are constantly working to make QuickBooks Online better for our users.

In this, I’d recommend sending this functionality as feedback. Our product development team, doing so will enable us to comprehend what features business owners demand to use the product conveniently. To send your input, here's how:

1. Go to the Gear icon.
2. Select Feedback.
3. Enter a brief description of your product suggestion.
4. Click Next to submit feedback.

Additionally, we frequently update our products while considering your comments. It allows you to monitor the development of your feature request in our Feedback forum.

Please let me know if you have other concerns about QuickBooks. The Community is always available to help.