Arriving Due Balance through fifo Kncok off Method

Hi
I sincerely thank the forum. I was able to get this macro this forum for Balancing and interet calculation purpose.

This macro already provides balancing. Positive amounts are due from customers and Negative amount are amount recieved from customers. We get raw data like this in this excel form.

I need a macro for replicating due Amount alone to be incorporated in another sheet.

can you Please help me out for extending this macro to another level.

Example file is attached.

Thanks & Regards
N.Srinivasa

Hi
I hope I have not explained the full logic for working on this
Present Macro already provide balancing.
However I need the balance Due on fifo knocking of method.
Eg a1105 Due total Due 2264514.

12/01/2016 7794.00
31/12/2015 256720.00
15/11/2015 -Rs.2264514 - 7794-256720.= 20,00,000 In this example it is 15/11/2015 40,00,000 Incase 15/11/2015 less than Rs.20,00,000 eg 15,00,000 only 15/11/2015 -Rs.15,00,000 balance Due Rs.5,00,000 will be the due previous due 15/09/2015 like this.
Can any boy will be able to help me out on this.

Thanks & Regards

I can’t promise I can help. But I need explanation.
This is the data you have:

fifo1.jpg

Using the sample above, can you explain what result do you want & how you come up with it.

Originally Posted by srinivasan1965

Hi
However I need the balance Due on fifo knocking of method.
Eg a1105 Due total Due 2264514.

12/01/2016 7794.00
31/12/2015 256720.00
15/11/2015 -Rs.2264514 - 7794-256720.= 20,00,000 In this example it is 15/11/2015 40,00,000 Incase 15/11/2015 less than Rs.20,00,000 eg 15,00,000 only 15/11/2015 -Rs.15,00,000 balance Due Rs.5,00,000 will be the due previous due 15/09/2015 like this.

The number with RED, where are those come from?

Hi
Since this balance has to be done for more than 500 clients I would request a macro
I proved you the relevant link
http://www.excelforum.com/excel-form...n-formula.html
I can arrange the excelu forum as per the attached excel
I am unable to code it and arrive balance on fifo.
If any body help me out I shall be grateful.
Thank you

Hi
Any help on this Otherwise I have to do manually every time. We need to take this report frequently and circulate to the people concerned.
My humble request Please.
Thanks & Regards

Hi
Thanks for your response
Please refer my earlier attached file kncokfifo.xlsm
I have already got macro for getting running balance and Interest calculation.
If you go through a 76 colum you will get this 2264514 etc. Please ref thread created 06022016
From this excel I have bifurcated postive amount and negative amount for finding due balance on fifo method.
referting the above thread on 08/02/2016.
Awaiting your valued reply
Thanks & Regards
N.Srinivasan

I've read your first attachment. Unfortunately, I can’t find a way to solve the problem (mostly because I still can’t understand it) .
Hope someone else here can help you.

Hi
Thank u
This is basically debit credit representing positive amount and Negative amount are receipt from customers
If you total both postive negative amount It will net due amount
I need to take out breakup from which date is us due from from last row to preivous row positive Amount
In the above example A1105 Net due is arrived as Rs.2264514.
Breakup of the amount are matched on fifo receipt method

Due from 12/01/2016 7794
Due from 31/12/2015 Rs.256720
Due from 15/11/2015 2264514-7794 -256720 20,00,000 Since the Due on 15/11/2015 Rs.40,00,000 They have partly paid for this due 20,00,000 Balance Rs.20,00,000 is pendin from 15/11/2015 Onwards
Hence Due Date and amount are given below
Due Date Amount
12/01/2016 Rs.7794
31/12/2015 Rs.256720
15/11/2015 Rs.20,00,000
Hope you understand now.
This is breakup is need for all the clients by running a macro

Can anybody help me out
Thanks & Regards
N.Srinivasan