Custom Image

Average Days Delinquent 

What is Average Days Delinquent?

Average Days Delinquent(ADD) or delinquent days sales outstanding refers to the average number of days the invoices are delinquent or they are past-due. Average Days Delinquent is a crucial metric used to collections teams to analyze their customer’s delinquency trends.

Average Days Delinquent Calculation:

Average Days Delinquent is calculated using the 3-step formula:

Step 1: Calculate Days Sales Outstanding(DSO)

DSO = (Average Accounts Receivable / Total Credit Sales) x Number of Days

Step 2: Enter Best Possible Days Sales Outstanding(BPDSO)

BPDSO = (Current Accounts Receivable / Annual Credit Sales) x 365 Days

Step 3: The formula for Average Days Delinquent is

ADD = DSO – BPDSO

Why Should You Analyze Average Days Delinquent?

Collections teams use Average Days Delinquent as an important indicator to evaluate their overall collections performance. Collectors often analyze DSO and ADD parallely to understand how fast they are able to convert invoice to cash.

High vs Low ADD: How to Interpret Average Days Delinquent?

  • A high ADD indicates that the customers are taking more number of days to make payments. This might indicate a scope of improvement in the dunning efforts. Collectors could identify the various types of delinquent customers and they can send them proactive email reminders to recover the past-dues faster. Here are 6 strategies to handle customer delinquency in b2b collections.
  • A low Average Days Delinquent means that the customers are paying faster.

Since credit and collection teams simultaneously evaluate DSO and ADD, let’s analyze a few instances that they might encounter while looking at the data:

  • If DSO and ADD are both high or low – This means that both of the metrics are aligned. Either there is improvement or degradation of your dunning process.
  • If DSO is low and ADD is high or vice versa – This doesn’t necessarily mean effective collection efforts. The improvement in DSO might be seasonal or because of modified credit terms.

Formula

ADD = Days Sales Outstanding – Best Possible Days Sales Outstanding

There's no time like the present

Get a Demo of Collections Software for Your Business

Learn More
Request a demo

HighRadius Collections Software automates and optimizes the credit & collections management process to improve collector efficiency, minimize bad debt write-offs, improve customer relationships, and reduce DSO. It provides a complete set of tools to optimize and automate the credit collections management process and enable the better prioritization of credit collections activities All the information you need (invoices, dispute information, POD, claims, tracking info, etc.) on each case is automatically presented in a collections work-space and is ready for use. Apart from the wide variety of benefits that it has, it also comes with some amazing features like CADE (Collection Agency Data Exchange), collector's dashboard which has prioritized collections worklist, automated dunning & correspondence, dispute management, centralized tracking of notes, call logs & payment commitments along with cash forecasting functionalities. The result is a more efficient collections team that contributes to enhanced cash flow and reduced DSO.