I'd be happy to assist you in creating the report and finding the information you need, @delwyn.
To generate a report sorted by a custom field, specifically Open Balances, and filtered to display only active customers, please follow these steps:
- Navigate to the Reports menu in QuickBooks Online Advanced.
- Select Custom Reports and click on +New Report.
- Under the Columns section, customize the report to include the desired fields, including the custom field for Open Balances under the More Columns
- Save and run the report to view the customized data set based on your specified criteria.
Currently, the specific option for selecting active customers in the current customization settings is unavailable. However, you can use an alternative approach by utilizing the Balance for the Customer option to achieve a similar outcome.
Furthermore, QuickBooks provides different options to personalise your reports for clear presentation by checking out this guide: Customise reports in QuickBooks Online.
You might also find these links helpful when customising reports in QuickBooks Online:
Keep us posted if you need additional assistance in customizing the report. We'll be right here to get the data you need. Have a great day!
