FIFO Inventory Age

Hi Excel gurus

I am also interested in finding the age of my Inventory.
I have a list of purchases of securities. A purchase has a unique deal no and becomes a part of the inventory at settlement date.
I have a list of sales where, a sale is recorded for each Item with a unique deal no. there can be multiple sales for a security on the same day.

The output i require should list the remaining list of Purchase transaction with residual balance for a purchase for each security, if a part of it has been sold. The remaining Inventory needs to output on the basis of FIFO , up to a given report date.


Help will be greatly appreciated.

This is great. What if the on hand inventory is in another tab?