Get 50% OFF QuickBooks for 3 months*

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.
gwen26
Level 2

How do I download a full contractor list with addresses and tax info?

 
Solved
Best answer July 17, 2025

Best Answers
CamelleT
Moderator

How do I download a full contractor list with addresses and tax info?

There isn’t a direct option to download a complete contractor list with addresses and tax information, Gwen.

 

As a workaround, you can generate a Vendor Contact List report. By default, this features contractors listed as vendors and their addresses. You'll just need to customize it to include the Track 1099 and Tax ID columns.

 

If you're using QuickBooks Online (QBO), here's how you can proceed:

 

  1. Go to Reports and type Vendor Contact List in the search box.
    Screenshot 2025-07-17 232453.png
  2. Click Columns, then More Columns.
    Screenshot 2025-07-17 234601.png
  3. Under the Vendor Attributes, select Show more.
  4. Scroll down and tick the Track 1099 and Tax ID columns
  5. If the Track 1099 column shows Yes, it indicates that the vendor is classified as a contractor. Once you have all the details you need, click the Print icon and select Download, then Save.
    Screenshot 2025-07-18 003912.png

     

On the other hand, if you're using QBDT, follow the steps below:

 

  1. Go to Reports, Vendors & Payables, and select Vendor Contact List.
    image.png
  2. Click the Customize Report button.
    Clipboard Image 2025-07-18 image_png__1541_207_.png
  3. Select the Display tab.
     
  4. Place a checkmark before the Tax ID and Eligible for 1099 column.
  5. Click OK.
    image.png
  6. If the Eligible for 1099 column shows Yes, it indicates that the vendor is classified as a contractor. Once you have all the details you need, click the Print, then Save as PDF.
    image.png


If you have additional questions, feel free to click the Reply button.

View solution in original post

5 Comments 5
PollNofer
Level 3

How do I download a full contractor list with addresses and tax info?

Go to Expenses -> Vendors and click the gear icon on the right to customize columns. Make sure you’ve got the key fields checked, things like address, email, phone, and most importantly, Tax ID (if you’ve been tracking it). Then click the small export icon (looks like a box with an arrow) at the top right of the vendor list and export to Excel or CSV.

 

If you’ve marked someone as a 1099 contractor, you can also go to Payroll -> Contractors (or Expenses -> Vendors, filtered by 1099) to focus only on that group. That view doesn’t show everything, but it’s handy for tax-time exports. Still, for the most complete info including mailing address, the regular Vendor list works better.

 

One thing to double-check: some versions of QuickBooks hide Tax ID by default for privacy reasons, so if it’s blank in your export, it might not be stored in the system or needs permission tweaking.

CamelleT
Moderator

How do I download a full contractor list with addresses and tax info?

There isn’t a direct option to download a complete contractor list with addresses and tax information, Gwen.

 

As a workaround, you can generate a Vendor Contact List report. By default, this features contractors listed as vendors and their addresses. You'll just need to customize it to include the Track 1099 and Tax ID columns.

 

If you're using QuickBooks Online (QBO), here's how you can proceed:

 

  1. Go to Reports and type Vendor Contact List in the search box.
    Screenshot 2025-07-17 232453.png
  2. Click Columns, then More Columns.
    Screenshot 2025-07-17 234601.png
  3. Under the Vendor Attributes, select Show more.
  4. Scroll down and tick the Track 1099 and Tax ID columns
  5. If the Track 1099 column shows Yes, it indicates that the vendor is classified as a contractor. Once you have all the details you need, click the Print icon and select Download, then Save.
    Screenshot 2025-07-18 003912.png

     

On the other hand, if you're using QBDT, follow the steps below:

 

  1. Go to Reports, Vendors & Payables, and select Vendor Contact List.
    image.png
  2. Click the Customize Report button.
    Clipboard Image 2025-07-18 image_png__1541_207_.png
  3. Select the Display tab.
     
  4. Place a checkmark before the Tax ID and Eligible for 1099 column.
  5. Click OK.
    image.png
  6. If the Eligible for 1099 column shows Yes, it indicates that the vendor is classified as a contractor. Once you have all the details you need, click the Print, then Save as PDF.
    image.png


If you have additional questions, feel free to click the Reply button.

gwen26
Level 2

How do I download a full contractor list with addresses and tax info?

Thank you, I will try this. 

gwen26
Level 2

How do I download a full contractor list with addresses and tax info?

Thank you so much, really helpful.

JamaicaA
QuickBooks Team

How do I download a full contractor list with addresses and tax info?

Good day, gwen26.

 

I appreciate you getting back to us and considering the suggestions shared in this thread. On behalf of my colleague, you're always welcome. Please know that it's our pleasure to address any questions about contractors or reports in the program.

 

If you have any other QuickBooks concerns, comment below. I'll be glad to assist you further.

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

Need to get in touch?

Contact us