Hi there, @A2Z Computing. I'm here to help you get the report you need.
Being able to run a Customer Balance Summary report with the custom field added to customer profiles would be a great option. The closest way to achieve this is to export and combine it with Customer Contact List.
Here's how:
Go to the Reports menu on the left pane.
Open Customer Balance Summary.
Modify the reporting field.
At the top of the report, select the Export icon and then Export to Excel.
Save the file somewhere you can easily find.
Once done, go back to the report list and pull up Customer Contact List. Then, add the other field column. Follow these steps:
Look for Customer Contact List and select it.
Click on the Customize button.
Click Change columns and pick the other field.
Click Run report.
Select the Export icon and then Export to Excel.
Save the file somewhere you can easily find.
Finally, you can consolidate data from each file in a single worksheet. Having the ability to add the custom field column directly in the report would be awesome. I encourage you to add your vote for this one by sending a feature request in the Feedback section within QuickBooks. Our product development team reviews all the feedback we receive to ensure we’re meeting the needs of our customers.
You can check out this link to learn the reports included in your subscription: Reports List.
Keep us posted if you have other concerns regarding customising reports. We're always here to help.
I appreciate you following up on the availability of this feature, @A2Z Computing.
Please know that being able to add other fields in the Customer Balance Summary report is still unavailable. With this, let's send a feedback request to our developers.
I recognize your desire to populate a report with all the information you need. You'll want to follow the steps below to submit a recommendation for this functionality. This way, it'll be considered for future updates.