BLACK FRIDAY SALE 70% OFF QuickBooks for 3 months*   Ends 11/30

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
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? 

5 Comments 5
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!

 

 

Chuck523
Level 1

List of Vendors with SSN (QBO)

I have done the above to get a report of vendors with a tax ID and I get, why will it not show the Vendor Tax ID?

 

 
Vendor Contact List  
   
Vendor Display Name Tax id
1122 [removed] [removed]
154 [removed] [removed]

 

Chuck523
Level 1

List of Vendors with SSN (QBO)

What I get is a link, not the info.  How is that corrected?

Anonymous
Not applicable

List of Vendors with SSN (QBO)

Hopping in on this thread to get you assisted, @Chuck523. I know why the vendor tax ID wasn't displayed on the report in QuickBooks Online (QBO).

 

The vendor tax ID is categorized as personally identifiable information about your vendor, which means it is considered a piece of sensitive data. Although the report provides an option to add this column, we're still compliant with protecting your data, not limited to your vendor's business entity. Thus, customizing your report to display this information will only result in a link displayed in the designated section, and obtaining this will require you to communicate with your vendors.

 

Furthermore, you can also obtain a summary of all payments made to a particular vendor throughout the year and make necessary adjustments to showcase essential information by running a report: Run a report with vendor totals.

 

Stay in touch if you have additional questions concerning personalizing reports. You can always hit the reply button to start posting them. Have a good one!

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us