Details of amounts in AP Aging

Is there a way (BAQ, etc) to create a report or spreadsheet that would agree to my open AP balance but also include the offset of those invoices that are open? For example, I have $2,000,000 of open AP, what expenses or balance sheet items were the offset to those open invoices? That is the question I need to answer and I don't want to go one by one!