cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get unlimited expert tax help and powerful accounting in one place. Check out QuickBooks Online + Live Expert Tax.
Scooter27
Level 2

Is there anyway in QB Mac Desktop to export or download all of a customer's shipping addresses?

Is there anyway to export all shipping addresses associated with a customer? We have several customers with multiple shipping addresses. The Customer Contact List report only exports the Default shipping address. Same with exporting the Customer IIF list. How can I export all associated shipping addresses? Thanks in advance for the help.

5 Comments 5
MirriamM
Moderator

Is there anyway in QB Mac Desktop to export or download all of a customer's shipping addresses?

Hi there, @Scooter27.

 

I can share some steps on exporting or downloading all customers' shipping addresses in QuickBooks Desktop for Mac.

 

Here's how:

 

  1. Go to the File menu at the top.
  2. Select Export.
  3. Choose Addresses to Text File.
  4. Select All customers/jobs.
  5. Click OK.

 

For more details about the process, see this article: Exporting contact info for Mail Merge. It also contains a video tutorial for your visual reference.

 

In addition, you may want to check out our QuickBooks Desktop Mac User Guide. It offers details to help with effective transaction management using QuickBooks Desktop for Mac.

 

If there is anything else I can do to help you manage your transactions, please let me know. I'll be here to assist you.

Scooter27
Level 2

Is there anyway in QB Mac Desktop to export or download all of a customer's shipping addresses?

Thank you for the quick reply. This solution only exports the default shipping address, not the other shipping addresses associated with a customer. I have a customer with four shipping addresses. Exporting Addresses to Text File has the billing address and the default shipping address, it does not have all four shipping addresses. 

 

Thanks again.  

GlinetteC
Moderator

Is there anyway in QB Mac Desktop to export or download all of a customer's shipping addresses?

Thank you for sharing additional details, Scooter27. I know a workaround to help you obtain the other shipping addresses associated with the customer.

 

The default shipping address is indeed the only one that QuickBooks can export. However, pulling up the Customer Contact List report and customizing it helps add additional address columns to get the data needed. Once done, Export it to Excel. I'll lay out the steps on how to do it:

 

  1. From the Reports menu, select Customers & Receivables.
  2. Choose Customer Contact List.
  3. Click on Customize Report.
  4. In the Display tab, type ship, then checkmark Ship to 2, 3, and 4.
  5. Tap OK.
  6. Click the Excel dropdown and choose to Create New Worksheet.
  7. Hit Export.

Need more help personalizing your report? Here's an article for a detailed guide and reference: Customize report in Quickbooks Desktop.

 

If you require any additional assistance exporting customer shipping addresses, notify me in the comments below. I will be here to help.

Scooter27
Level 2

Is there anyway in QB Mac Desktop to export or download all of a customer's shipping addresses?

Thank you so much for the detailed explanation. And that is exactly what I would do if I was using a Windows version, but I'm using the Mac Desktop version and it does not have those options that you detailed and  I have not found a way export any shipping address except for the default one, which is why I posted the question. Thanks in advance for any further insights!

LeizylM
QuickBooks Team

Is there anyway in QB Mac Desktop to export or download all of a customer's shipping addresses?

Exporting your customer's shipping address is a great functionality in QuickBooks for Mac, Scooter27. 

 

As of now, we're unable to export customers' shipping addresses in QuickBooks Desktop for Mac. I can see how this functionality would be beneficial to your business. I encourage sending feedback directly to our Product Development team. We continue to improve the features, and this option might be available in the future.

 

Here's how:

 

  1. Go to the Help tab.
  2. Next, click the Send Feedback Online option.
  3. Then, choose Product Suggestion. 
  4. From there, input the details of your product comments, suggestions, and requests. 
  5. Click the Send Feedback button to submit.

 

Check out our blog if you want to know more about the updates in QuickBooks Mac: https://www.firmofthefuture.com/product-industry-news/product-updates/.

 

Need to familiarize yourself with the reports to see your sales, items, and account balances? This article can help you out: Create reports in QuickBooks Desktop for Mac

 

Let me know in the comment section if you need more help besides exporting the shipping address. I'm always here to help. Have a good one!

Get answers fast!
Log in and ask our experts your toughest QuickBooks questions today.

Need to get in touch?

Contact us