Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
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.
Hi there, @Scooter27.
I can share some steps on exporting or downloading all customers' shipping addresses in QuickBooks Desktop for Mac.
Here's how:
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.
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.
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:
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.
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!
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:
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!
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here