Populating rows with values based on another column

Hey guys, so i have a problem in which i need to populate the columns F G and H Based on values in first B C and D columns. in same way as mentioned in attached file automatically with a formula. So that in first column, there are invoices and the next column the receipt values are taken from receipts column until they sum to the invoice value and last receipt may be split into completing current invoice and then remaining adjusted in the next invoice and corresponding successfully to the Receipt dates as well. As for demo, file is attached. I have 30 years of data for like thousands of rows that are being done manually right now which is going to be very time consuming. If someone can help in this regard, it will be really appreciable and helpful.

Don't Exactly know which version it is? Microsoft office 365 most probably? Why? Could you find the solution?

Updated, please can you guide if any solution is possible to my problem.

Thank you so much. that is indeed a very different way of looking at it and a novel approach for me. However, please note that how can it be easily arranged that in one column for receipts against different bill amounts against the receipt dates also. Also in the columns, as per the other sheet, i have written the due dates. Can you please help how can the due dates be matched with those certain receipt amounts and receipt dates as mentioned in updated file. thanking you inanticipation.

Kind Regards,

Well thank you so much. You must be some kind of excel champion and a lot of knowledge and expertise of years. That quite solved the problem a lot. You nailed it although saw and scrutinized it a little late.. but hats off again..

Only however, a small problem occurring upon closer inspection in the column P of sheet 1 for the receipt date, that receipt dates are not matching exactly with the Receipts amounts from the table in Sheet 2. like it is lagging or may be not taking into account the empty rows as well. For instance, for Receipt amount till Rs. 92,054,693.72
, they should be Jun 28th, 2013. However the receipt dates should correspond to the receipt amounts as in sheet 2 table.

I am trying to resolve the problem with Index match, however due to multiple months and multiple receipt dates its creating a problem..

If you can take a look as to what formula can be changed for column P to get exactly right.

PS. thanking you once again for resolving such a major problem.

Well Thanks man. You truly are an excel maestro. That solved the problem pretty well. Thank you for such a nice development as this task required attention and got it done because of you. Well looking forward to posting more problems and getting a gist of them as soon as i get them for more learning purposes as i have a ton of them.

Once again all the credit in this one goes to you and thanking you for this.