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.
jbaenziger
Level 1

Extract shipping addresses into Excel for Mac

Hello community

 

In QB desktop for Mac, I try to extract the shipping addresses from hundreds of drop ship orders. I can go into 

each specific order and copy/paste, but that's a never ending story. Is there a more efficient way?

 

Thanks!

Jurg

1 Comment 1
JanbonN
QuickBooks Team

Extract shipping addresses into Excel for Mac

Hello there, Jurg. You can customize and export your Sales by Ship to Address report to get the shipping address data. I'm here to provide the steps to do it.

 

Here's how to generate the report:

 

  1. Navigate to Reports and select Report Center.
  2. In the search field, type in Sales by Ship to Address and open the report.
  3. Click the Customize button.
  4. Make the desired modifications to ensure the report includes the data you need.
  5. Then, click the Export button and follow the on-screen prompts.

 

For more detailed information about creating, customizing, and exporting reports, please refer to these articles:

 

 

Additionally, you can memorize your reports to save your current changes for future use.

 

Should you have other questions or need further assistance extracting data in QuickBooks Desktop for Mac, please don't hesitate to return to this thread, Jurg. We're here to help. Have a great day ahead.

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

Need to get in touch?

Contact us