Receivable Ageing Report

Hello:

I have attached excel file that contains a column transaction type (Payment/Invoice), Date and Amount. I would like to know how to calculate the ageing report based on a FIFO basis of payments received as well as the invoices. There are two excel worksheets in this file. Can any one help out?

Thank You.

Manoj Kumar