I'm glad to see you here posting in QuickBooks Community. Can you please provide additional details with your concern on what are you referring to? I'd thank you for any information so I can give precise solutions.
If you want to generate a report and export this to Excel showing the address, I'd suggest pulling up the Invoice List report. From there, you can customize the report and view the details before exporting the data.
Here's how:
Click Reports at the left panel.
Enter the Invoice List reportin the search box.
Choose the Customise button. Then, go to the Rows/Columns.
Click the Change columns link. Put a checkmark on the Billing and Shipping address.
Customise the other options.
Hit the Run report button.
Click the Export drop-down icon. Then, choose Export to Excel.
For additional information on how to customise a report to focus on the details that you want to view, you can click this article: Customise reports in QuickBooks Online.
Please refer to the articles below to see steps on how to import multiple invoices to QuickBooks Online at once. Then, export non-posting transactions and attachments.