Hi @ChrisF_060,
Allow me to join this conversation and provide some insights about this query.
As what @lyndaartesani stated above, as long as a customer had transactions on the date range you selected, even if they're inactive or have a zero balance, they will appear on that report.
Although we don't have an option to exclude inactive customers or those with zero balances in the report, you can manually select the customer you want to see on the report by using Filters.
Let me show you how:
- Go to the Reports tab.
- Choose Customers & Receivables.
- Select Customer Balance Detail.
- Tap the Customize Report tab.
- Go to the Filters tab.
- From the Filters box, select Name.
- From the Name drop-down, click Multiple names.
- Mark the customers with pending balances.
- Click OK twice.
- Update the report Dates.
To give you a more in-depth guide of customizing your customer reports, take a look at this article: Customize customer, job, and sales reports. Examples of customization are taxable customers or sales receipts that show check numbers for payment.
Let me know if you need further assistance by leaving a comment below. I'll get back to you as soon as I can.
