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.

Analyzing Average Days Delinquent can help a company identify potential cash flow issues, as well as areas where it may need to tighten credit policies or improve collections processes. For example, a high average days delinquent could indicate that a company is extending credit to customers who are not creditworthy, or that its collections efforts are not effective.

Analyzing average days delinquent can also provide insights into industry trends and benchmarking against competitors. By comparing its average days delinquent to industry averages or to its competitors, a company can identify areas where it may be underperforming and take steps to improve its accounts receivable function.

You can Improve your Credit and Collections Operational Efficiency with our free toolkits built for finance professionals

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.

Achieve faster recovery to reduce DSO through AI-based worklist prioritization and automated dunning capabilities with HighRadius AI-based Collections Software.


ADD = Days Sales Outstanding – Best Possible Days Sales Outstanding


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. Improve your efficiency with our order-to-cash templates such as - A/R Aging Report, DSO calculation excel template, A/R Dashboard excel template, credit scoring model for new customers, 21 Credit-collections email template, and Our Ebooks.