WHAT IS AVERAGE DAYS DELINQUENT
Average days delinquent (ADD) is the average day’s invoices are past due, the amount of time between invoice due date and the date it is paid. The calculation of this figure will help your company evaluate, along with other calculations, the overall performance of your collections department and your ability to convert A/R to cash.
It is important to note that ADD is different from average days to pay because ADD looks at a snapshot in time while average days to pay is based on historical information and closed invoices.
HOW TO CALCULATE AVERAGE DAYS DELINQUENT
Before you can calculate your average days delinquent, you need to first do a few simple calculations.
Calculate average Days sales outstanding (DSO)
DSO = (Average AR / Billed Revenue) x Days
Calculate Best Possible DSO
Best Possible DSO = (Current AR / Billed Revenue) x Days
Calculate Average Days Delinquent
ADD= Days Sales Outstanding – Best Possible Days Sales Outstanding
The result of your ADD calculation should be compared alongside your DSO. This will help create a more complete picture of both calculations and what they mean for your company’s finances and collections processes. A helpful way to visually see the relationship between these figures is to plot them on a line graph, but it is also acceptable to just look at the numbers.
IF BOTH ADD AND DSO TRAVELING UP/DOWN TOGETHER:
This means that you can assume your credit and collections processes, depending on the direction of the line, are driving either the improvement of the downfall of your credit collections. If you see that both these numbers are dropping, you will want to look into ways to improve your processes to turn things around.
IF DSO AND ADD ARE MOVING IN DIFFERENT DIRECTIONS:
This means that there is something else going on and you should absolutely take a closer look. For example, if DSO is rising while ADD is falling, the improvement in DSO was probably not driven by improved collection efficiencies; rather it may have been due to shorter A/R cycles or a change in credit terms.
Armed with these accounts receivable metrics, you can begin to evaluate where your company stands in terms of accounts receivable and begin setting goals for improvement.