QuickBooks Invoice Balance

You would likely need to play with the reporting and tracking of it, but I would advise looking at using a connected table to Quickbooks as opposed to going through Pipelines. Quickbase has had a connected table sync to Quickbooks that allows you to pull data like invoices, payments, customers etc to a sync table. It doesn't give you exactly what you need but it should allow you to view the payment data in its raw format and use Quickbase relationships, summaries and misc formulas to get you in the ballpark

Connected Tables