Reports and accounting
A pleasant day to you, @dmills1. I'll gladly walk you through the process of generating a report that will show you the actual ship-to address of your customer. I believe this will efficiently help perform your task smoothly.
To produce a page that reflects the delivery addresses of your customers, you can run the Transaction List by Customer report. Luckily, In QuickBooks Online Advanced, you'll be able to customize this and choose the correct columns that will reveal the information you want to see when pulling it up.
Here's how:
- On the left panel page, select Reports.
- Pick Standard Reports. Enter the Transaction List By Customer in the search field and click it once shown.
- Go to the Columns section. Then, hover your cursor in the More Columns tab and search Ship.
- Choose the Transaction dropdown below. After that, checkmark the Ship Street to show the customer's shipping addresses.
- If you want to have a separate column for the street, city, state, zip, and country, move forward to the Customer option and tick all the options.
- To ensure that only customer invoices will show, transfer to the Filter section. The three boxes should contain Transaction type, Equals, and Invoice.
- Once perfectly done, the details you need will automatically generate.
Additionally, you can visit this article if you wish to save this report outside QuickBooks: Export your reports to Excel from QuickBooks Online.
Moreover, to help you streamline your reports and arrange data according to your company needs, feel free to interact with QuickBooks Live Expert Assisted.
Rest assured, this will help you achieve your goal, @dmills1. Have your way back in the comment section if you have additional questions about pulling up a report containing specified information. I'm always here. Keep safe and have a wonderful day!
