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

When exporting the vendor list from Quickbooks Online, how do I select additional fields (and have them export into separate columns). For ex., Tax ID, State, City, etc?

I need the following fields to export into separate columns in excel:

Company
Display Name
Address
City
State
Zip
Country
Notes
Attachements
Email
Phone
Mobile
Fax
Other
Website
Terms
Account #
Business ID #

Solved
Best answer October 19, 2018

Best Answers
Highlighted
QuickBooks Team

When exporting the vendor list from Quickbooks Online, how do I select additional fields (and have them export into separate columns). For ex., Tax ID, State, City, etc?

Hi gary.spivey,

I'll help you export additional fields into separate columns in Excel.

Here are the easy steps:

  1. Click Reports.
  2. In the Go to report field, type Vendor Contact List.
  3. Click Customize, and the Rows/Columns arrow.
  4. Check the boxes that you want to include in the report.
  5. Click Run report.
  6. Click the Export icon beside the Gear icon in the report.
  7. Select Export to Excel.

I've added some screeshots underneath that will guide you through the steps.

If you have any more questions about exporting reports, let me know. I'll help you out. Thanks!

View solution in original post

3 Comments
Highlighted
QuickBooks Team

When exporting the vendor list from Quickbooks Online, how do I select additional fields (and have them export into separate columns). For ex., Tax ID, State, City, etc?

Hi gary.spivey,

I'll help you export additional fields into separate columns in Excel.

Here are the easy steps:

  1. Click Reports.
  2. In the Go to report field, type Vendor Contact List.
  3. Click Customize, and the Rows/Columns arrow.
  4. Check the boxes that you want to include in the report.
  5. Click Run report.
  6. Click the Export icon beside the Gear icon in the report.
  7. Select Export to Excel.

I've added some screeshots underneath that will guide you through the steps.

If you have any more questions about exporting reports, let me know. I'll help you out. Thanks!

View solution in original post

Highlighted
Level 1

When exporting the vendor list from Quickbooks Online, how do I select additional fields (and have them export into separate columns). For ex., Tax ID, State, City, etc?

When I attempt this, I don't see the "Display" field as an available checkbox. How can I create a report spreadsheet that includes the "Display" field?

Highlighted
Moderator

When exporting the vendor list from Quickbooks Online, how do I select additional fields (and have them export into separate columns). For ex., Tax ID, State, City, etc?

Hello there, spinsky,

 

The Vendor column shows the Display name of the vendors. You can check that box to add their display name.

 

Here's an example of what it looks like with the Vendor column:

 

 

To know more about report customization, you can view these articles:

Let me know if you need anything else.

Need to get in touch?

Contact us