AP aging detail from quickbooks

The report populates in excel but does NOT include the open balance. Column R populates with the vendor bill amount and then column R has memo where as the next column in QBs would be the open balance. I need to get the open balance…how can I do this?