QuickBooks Team

Account management

Hello there, austinwalls2,


We're unable to customize a report to lists the street address, city, state, and zip code in separate cells.


However, you have the option to manually edit the table once you've exported the report to Excel.To customize a report and export to Excel:


  1. From the left menu, select Reports.
  2. Search for Customer Contact List.
  3. Click Customize.
  4. Change the settings in the Customize Report window.
  5. Click Run Report to save the changes.
  6. Once done, click the Export icon, then select Export to Excel.

If you need to save, share, and access a customized report, you can read through this article for the detailed steps:  How to customize reports.


That's it. You now customize the report.  Stay in touch if you have follow-up questions. I’m here anytime you need help.