Is there a report I can pull in sage that will show me what we have paid out to our subs on a job so far vs what we have received so far from our client on this job?

The client is making payments, and we want to make sure that we haven't paid our subs over what we have received yet.

The only way I can figure to do this is to print a transaction report and go down the list one by one checking if the invoice has been paid and then adding them up. This is going to take forever....