Need help in creating Aging report by project based in FIFO method

I would like to make a aging report by project based on the date of transaction using FIFO method.

I have attached a sample data and report format in an excel. Need help in creating either an excel template using formula or a macro.

Thanks in advance for your help.

Regards,
Dhowlath