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

"Customer type" entered and confirmed on "customer details" page does not show up on exported Excel customer database -- below the column header the column is empty.

 
3 Comments 3
Angelyn_T
QuickBooks Team

"Customer type" entered and confirmed on "customer details" page does not show up on exported Excel customer database -- below the column header the column is empty.

Hi there, @CeramicsGuy.

 

Are you trying to export the Customer Contact List report that is not showing the Customer Type? If so, I'll be right here to help you show the customer type when exporting the report.

 

If you're exporting the report to Excel, you must include the Customer Type column to show the customer type.

 

  1. In the reports page, click on the small Gear icon beside the Export icon.
  2. Put a check-mark on Customer Type.
  3. Click on Run report.a3 customer type.PNG

Once done, try exporting the report again.

 

To learn more about customizing and exporting reports in QuickBooks Online (QBO), you may read these articles:

 

Please let me know if you're referring to something else and if you have any other questions about running/exporting reports in QBO. I'll be glad to help you!

CeramicsGuy
Level 1

"Customer type" entered and confirmed on "customer details" page does not show up on exported Excel customer database -- below the column header the column is empty.

Hi,

 

>Please let me know if you're referring to something else

 

Thanks for trying to help!

 

The problem is not related to exporting the "Customer Contact List" -- rather, it's the Excel sheet that's exported via the main customer page (Sales/Customers/click export icon on right, next to gear icon).

 

On our main customer page, I now see a customer "Aaron" at the top. In the "Customer type" column I see the customer type I created earlier, "CustomerTypeTest". All good.  But when I then click that export link on that page and it opens up in Excel, although I see the "Customer type" column header, Aaron's customer type ("CustomerTypeTest") does not show up in his row. All the column headers on that sheet (Customer, Company, Street Address, City, State, Country, Zip, Phone, Email, Customer Type, Attachments, Open Balance, Notes) show up fine. All the data is there for everyone. Except there is NO data underneath the "Customer Type" header for anyone.

 

 

 

 

Malcolm Ziman
Level 10

"Customer type" entered and confirmed on "customer details" page does not show up on exported Excel customer database -- below the column header the column is empty.


@CeramicsGuy wrote:

 

 

The problem is not related to exporting the "Customer Contact List" -- rather, it's the Excel sheet that's exported via the main customer page (Sales/Customers/click export icon on right, next to gear icon).

 

 


You've found a bug. 

They've done away with bug reporting and anyhow nothing ever came of that for me.

In the meantime Reports>Customer Contact List does show the Customer Type underneath the "Customer Type" header

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us