To solve a matrix of Billing & Payment on FIFO basis

Hiii..

Attached is my query file..

I want a formula in cell D3 such that when I copy it to all months Column Q & Row 15 all should reflect matched..
The Column contains the billing amount & the rows contain the payment amount. They are to be matched on FIFO basis..i.e. payment in april month Rs.42000 should be 1st adjusted against opening balance of 79000 & if balance left (not in this case) should be adjsuted against april bill & so on...

The formula to show blank if in any month no payment or bill is made..

Basically it can be seen as total demand (362000) should equals total supply (362000) & allocations need to be done accordingly..

I think solver can solve this matrix but don't know how to set my data as per the requirements of solver..

Thanks..