The qb team really needs to stop giving this as an answer.  It is just not the right answer.  We need a simple payment reconciliation report that we can give our customers when check application gets off.

ie customers records and our records don't match and we need to hunt down what checks were applied to what invoices.

This should be a single report, or a way to make a custom report that does this in a well broken out format.

I suggest customer name, then a inset for each invoice, and an inset for each check/credit applied to that invoice.  It should look quite a bit like the customer reconciliation report, but have invoices and payments that have been applied.

This is a very basic report, run monthly by every company out there.  Make it happen.  Don't tell us it can't be done, or give us a work around, just get us the report.