Getting a Netting Consolidation file from our bank into Oracle

We have a process where we gather up all of our intercompany transactions for a month and we send them all in a single file to our bank (PNC to be precise).  What PNC does is it takes all of those invoices and consolidates them into as few transactions as possible, ensuring that all the money ends up where it needs to be.  PNC moves the money for us, and gives us a file back of all the payments they ended up doing.  The file that PNC gives us includes all of the details necessary to create a payment like