Thanks for writing all this. As you concluded, even after running these separate reports, I still have to create an Excel spreadsheet with the data from the reports to tie them all together.

I was hoping QBO would have a way to click one report and have everything on there related to the Pre-paid Credit Memo from the Sales Receipt, Credit Memo, Invoices, and applied credit memo Payment.

Suggestion for your development team : I suggest adding Tags to all Transaction types and being able to filter the Transaction List by Customer report using Tags. Tags are only currently available on Invoices, but they should also be available on all Transaction types -- Invoice (already), Payment, Sales Receipt, Credit Memo.

Then add Tags as a filter condition to the Transaction List by Customer report.

In my example, I would be able to enter a tag, say I call it "CM001", on the Sales Receipt when my customer sends me a pre-paid check for $10,000 at the start of the year, and add the "CM001" tag to the $10,000 Credit Memo I create for them, add the "CM001" tag to the $1,000 Invoice that I create each month, and add the "CM001" tag to the Payment where I apply $1,000 credit from the Credit Memo balance.

Then when I run the Transaction List by Customer report, I would filter by Tag = "CM001" and all these items and only these items would show on the report! Tags would link all these transaction types together!