Open Balance Report

Good day, AllysonR24.

I can recommend two reports that would help you get the data that you need.

First, you can run the Sales by Customer Summary report. This will provide you with a list of customers and their total sales amount for the selected time period.

1. Go to the Reports menu and proceed to the Report Center. 
2. Proceed to the Sales tab.
3. Select Sales by Customer Summary.

Second, run the Customer Balance Summary report. However, this will only show the current open balance of each customer. Allow me to provide you with these steps:

1. Go back to the Reports menu and proceed to the Report Center.
2. Proceed to the Customers and Receivables tab.
3. Click Customer Balance Summary.

Let me also share these articles for additional resources when running reports in QuickBooks:

• Resolve Accounts Receivable and Accounts Payable Balances on a Cash Basis Balance Sheet
• Customize Reports in QuickBooks Desktop

The Community is always here if you need anything else.