Hello @SteveBSME,
Thank you for posting here in the Community. I'm here to help you with your concern about running reports in QuickBooks.
Currently, a specific report that can show all the details you need is unavailable. For now, I recommend using the existing workaround you're using by exporting the reports to Excel and customizing them based on your needs.
Though, it would be beneficial to have the ability to pull up this information in an easier way. Our engineers might be working to bring this feature over to this platform in the future. You can click the Help tab at the top menu bar and select New Features to view the product updates.
For more information, as well as how to configure the Display and Filters tab, I recommend the following article: Customize reports in QuickBooks Desktop.
Leave a comment below if you have other concerns about running the reports in QuickBooks. The Community and I will be around to help you.