11 Replies Latest reply: Aug 8, 2012 5:13 AM by Rahul Lakhina RSS

    how to calculate debt aging

      Hi

       

      I have data with debt amount per month and would like to calculate number of days for one 's debt but the problem some of the months will have zero amount meaning that the previous month's debt has been paid ,and the next month after the zero amount month has a debt amount i will have to start calculating my aging from that month

       

      See below sample

       

      Client                     Amount                  Date

      Marais                      600                         01/01/2011

      Marais                      400                         01/02/2011

      Marais                      0                             01/03/2011

      Marais                     200                          01/04/2011

      Marais                     130                          01/05/2011

      Marais                      20                           01/06/2011

      Marais                      0                             01/07/2011

      Marais                      0                             01/08/2011

      Marais                     1000                        01/09/2011

       

      SO in this case my current debt will be 1000,therefore aging calculation will be from 01/09/2011

       

      Any record/amount prior to zero values is not taken into account.

       

      Thanks.