how to prepare the accounts payables ageing wise analysis for 30 Days

[vasanth]

How to prepare Accounts payables ageing wise


if i take a1-due date

b2 invoice amount

c1-30days

d1-60days

e1-90 days

f1- Above 90 days..

 

[Luke M]

Can you give us some more info? I'm not sure what your question really is. (not all of us are into accounting, so you may need to explain things)

 

[Montrey]

You could just add 30 to A1 for each cell if you are trying to find the dates

 

[SirJB7]

Hi, vasanth!


Assuming this is the scenario:

-----

[pre]

DocID	Amount		Due date	0		30		60		90		360
1	10.000,00	01/05/2012	10.000,00
2	150.000,00	01/06/2012			150.000,00
3	2.000,00	01/07/2012					2.000,00

[/pre]
-----


The formula for D:E columns are:

=SI(Y($C2-HOY()<=D$1;$C2-HOY()>SI(ESNUMERO(C$1);C$1;-360));$B2;"") -----> in english: =IF(AND($C2-TODAY()<=D$1,$C2-TODAY()>IF(ISNUMBER(C$1),C$1,-360)),$B2,"")


Regards!