I need a report of customers with names, addresses, and amount of sales for a certain time frame, i.e. a year or two years. I will use this for a mail merge.

We're here to help, @redwrangler123. Let me show you how we can generate a report showing the customer's name, billing address, and total sales in a certain period in QuickBooks Online (QBO).

Currently, we're unable to run a single report in QBO to display the information you need. However, we can pull up two separate reports and combine them by exporting them to Excel.

To do that:

1. Go to Reports and search for the Customer Contact List report to view customers and their addresses.
2. Click the Export icon dropdown beside the Gear icon and select Export to Excel.
3. Go back to Reports and search for Sales by Customer Summary.
4. Click Customize.
5. Set the date range under the Report period section.
6. Click Run report.
7. Select the Export icon dropdown and click Export to Excel.

From there, we can combine your reports manually and customize them to our liking.

Furthermore, feel free to check out this article if you're interested in saving the current customization settings of your reports: Memorize reports in QuickBooks Online. This way, we'll have easy access to your frequently used reports and skip the process of customization.

Please don't hesitate to reach out back to us if you need additional assistance running reports in QBO. The Community is available 24/7 to answer your questions. Stay safe, and have a great day ahead!