cancel
Showing results for 
Search instead for 
Did you mean: 
TGHockett
Level 1

List of Vendors with SSN (QBO)

My client has over 100 vendors that will need 1099s and wants to start the preparation by finding out which vendors have not yet provided a social security number.  There are a number of reports/lists in QBO but none that I could find that includes SSNs.  Is there a report or list that I am missing in QBO, or possibly a way to query the vendors to find out which ones do not have a SSN? 

2 Comments 2
Jen_D
Moderator

List of Vendors with SSN (QBO)

I can guide you through the steps of getting the vendor report with SSN in QuickBooks, @TGHockett,

 

The steps are simple and you only need a Vendor Contact List report to get the data. Follow the steps below:

 

  1. Go to the Reports menu and type in Vendor Contact List on the search filed.
  2. Select the report and tap the gear icon below Save Customization.
  3. Once done, tap to mark the Tax ID box.
  4. Click anywhere to close the options and save the changes.

The information under this column is from the vendor's profile under Business ID No. / Social Security No. field. See this:

 

To learn more about reports in QBO and how to use them, see this Resource link: Create and manage reports in QuickBooks Online.

 

If you need anything else, please let me know in the comment below. I'll be right here to guide you with reporting and all other tasks in QBO. Have a nice day!

TerryGH
Level 2

List of Vendors with SSN (QBO)

Thanks for the quick - and easy to follow response, Jen_D.

Just one small point -- when the user gets to the part to select which items to include in the report, its possible (as was in my case) the user needs to click on "show more" in order to see the full list of items that can be included in the report.

In any case, after working with QBO for six+ years its always nice to learn a new feature /trick.

 

Thanks again, Jen!

 

 

Need to get in touch?

Contact us