cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

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 10-19-2018

Accepted Solutions
QuickBooks Team

Hi gary.spivey, I'll help you export additional fields in...

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!

3 Comments
QuickBooks Team

Hi gary.spivey, I'll help you export additional fields in...

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!

Experienced Member

Re: Hi gary.spivey, I'll help you export additional fields in...

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?

Moderator

Re: Hi gary.spivey, I'll help you export additional fields in...

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