Average Days Delinquent

ADD

Average Days Delinquent (ADD) is the average number of days invoices are paid past their due date, calculated as Days Sales Outstanding minus Best Possible DSO. It isolates the portion of receivables drift caused by late payment behaviour, making it a cleaner measure of collections team performance than raw DSO.

Key Takeaways

  • ADD equals DSO minus Best Possible DSO, isolating the late-payment drift from receivables and stripping out the noise from selling-terms changes.
  • Healthy B2B ADD typically sits between 5 and 20 days, with sub-10 days indicating a high-performing collections function.
  • ADD is the operational partner KPI to Collections Effectiveness Index (CEI), where one measures speed while the other measures completeness.
  • Rising ADD trends are an early warning of deteriorating customer credit quality, often appearing two to three months before bad-debt write-offs spike.
  • Agentic collections workflows that prioritise outreach by predicted-pay date can compress ADD by 30 to 50 percent without adding headcount.

Why ADD matters

Days Sales Outstanding gets all the boardroom attention, but it is a blunt instrument. DSO blends together two very different forces: the payment terms you grant customers at the point of sale, and the slippage that happens after the invoice is issued. When credit policy loosens, DSO rises even if collections is performing perfectly. When credit policy tightens, DSO falls even if collections is asleep at the wheel. Average Days Delinquent strips that noise away and tells you exactly how many days, on average, your invoices are paid late.

Because ADD measures only the post-due-date behaviour of your customers, it is the cleanest single number for evaluating a collections team. Two finance leaders running identical collections operations on different books of business will have very different DSO numbers, but their ADD should look similar. That is what makes ADD such a useful internal benchmark and such a powerful KPI for collector performance reviews.

How to calculate ADD with a worked example

The formula is simple:

ADD = DSO minus Best Possible DSO (BPDSO)

Best Possible DSO is the DSO you would have if every single invoice were paid exactly on its due date, with zero days of delinquency. It is calculated as current receivables divided by total credit sales, multiplied by the number of days in the period.

Consider a business with the following numbers for a 90-day quarter:

  • Total credit sales: 9 million euros
  • Total accounts receivable at quarter-end: 4.5 million euros
  • Current (not-yet-due) receivables: 2.7 million euros

DSO = (4.5M / 9M) x 90 = 45 days

BPDSO = (2.7M / 9M) x 90 = 27 days

ADD = 45 - 27 = 18 days

In other words, on average customers pay 18 days after the due date. If standard terms are Net 30, the effective payment behaviour is closer to Net 48. That 18-day gap is what collections owns, and it is what should be tracked month over month.

Healthy benchmarks by industry

What counts as a good ADD varies by sector, customer mix, and standard payment terms, but useful reference points exist for most B2B environments:

  • Below 5 days: world-class. Usually only achievable in industries with strong contractual penalties or recurring-subscription models where auto-pay is common.
  • 5 to 10 days: high-performing. Typical of well-run software, professional services, and distribution businesses with disciplined collections.
  • 10 to 20 days: healthy mid-market range. Most manufacturers, wholesalers, and B2B service companies live here.
  • 20 to 30 days: warning zone. Indicates either weak collections cadence, customer credit quality issues, or invoicing-disputes friction.
  • Above 30 days: red flag. Working capital is being eroded and the cost of collections is likely outstripping the margin recovered.

The single most useful benchmark is your own trailing 12-month ADD trend. A team that holds ADD steady through a recession is doing genuinely good work, even if the absolute number looks unflattering.

ADD versus DSO versus DBT

Three metrics are often confused, and the distinctions matter:

  • DSO measures the average age of all receivables, including invoices that are not yet due. It reflects both selling terms and collections performance.
  • Days Beyond Terms (DBT) measures, for invoices that have been paid, the average number of days between due date and actual payment. DBT is backward-looking and only counts settled invoices.
  • ADD sits between the two. It uses the DSO calculation logic, so it captures the full receivables book including open delinquent invoices, but it subtracts out the structural component, leaving only the slippage.

For collections performance reviews, ADD is usually the right primary KPI because it includes the impact of unpaid delinquent invoices still sitting on the ledger. DBT can flatter performance by ignoring the invoices customers have not yet paid at all.

Common mistakes when using ADD

ADD is a powerful KPI, but it is easy to misread. Watch for these pitfalls:

  • Comparing ADD across business units with different payment terms. A division selling on Net 60 will mechanically have different BPDSO and therefore different ADD dynamics than one selling on Net 30.
  • Ignoring seasonality. Many B2B businesses see ADD spike in Q1 as customers reset budgets. Always compare against the same quarter prior year.
  • Treating ADD as a collector productivity measure in isolation. Pair it with CEI. ADD without CEI rewards collectors for chasing the easiest invoices first.
  • Failing to segment by customer tier. A 5-day rise in ADD driven entirely by your top 10 customers is a credit-quality crisis. The same 5-day rise spread across the long tail is a process problem.

How agentic AI reduces ADD

Reducing ADD has traditionally meant hiring more collectors and sending more dunning emails. AI-native collections platforms change the economics. Agentic systems predict which invoices are most likely to slip, prioritise outreach by predicted-pay date rather than invoice age, and personalise contact channel and tone for each customer.

The compounding effect is significant. By focusing collector time on the invoices where intervention actually changes the payment date, agentic workflows typically compress ADD by 30 to 50 percent in the first 12 months. The DSO improvement that follows flows straight to working capital, often releasing one to two weeks of revenue in cash. That is the kind of return that turns a collections team from a cost centre into a strategic finance function.

Frequently asked questions

What is a good Average Days Delinquent for a B2B company?

Most healthy B2B businesses see ADD between 5 and 20 days. Sub-10 days indicates a high-performing collections function, while anything above 20 days typically signals weak collections cadence or deteriorating customer credit quality. The most meaningful benchmark, however, is your own trailing 12-month trend rather than an industry average.

How is Average Days Delinquent different from DSO?

DSO measures the average age of all receivables and blends two effects: the payment terms you grant and the slippage after the due date. ADD strips out the terms component by subtracting Best Possible DSO, leaving only the late-payment drift. That makes ADD a cleaner measure of collections team performance, while DSO is the broader working-capital indicator.

Is ADD the same as Days Beyond Terms?

No. Days Beyond Terms (DBT) only counts invoices that have already been paid and measures how many days late they settled. ADD uses the DSO calculation method, so it includes open delinquent invoices still on the ledger. ADD is usually the more honest collections KPI because it cannot be flattered by ignoring invoices customers have not paid yet.

How often should I report ADD?

Most finance teams report ADD monthly alongside DSO and CEI. Weekly tracking is useful for collections team huddles, especially when running improvement initiatives. Quarterly board reporting should always include the trailing 12-month ADD trend rather than a single point estimate, because month-to-month volatility can mask the underlying direction.

Can ADD predict bad debt write-offs?

Yes, ADD trends are one of the strongest early-warning indicators for credit quality. A sustained rise in ADD over two to three consecutive months, particularly when concentrated in specific customer segments, often precedes write-off spikes by a full quarter. Segmenting ADD by customer tier amplifies the signal and gives credit teams time to tighten exposure limits.

How quickly can AI reduce our ADD?

Agentic collections platforms that prioritise outreach by predicted-pay date typically compress ADD by 30 to 50 percent in the first 12 months. Early gains appear within 60 to 90 days as the system learns customer payment patterns and routes collector attention to the invoices where intervention actually changes settlement timing. The DSO improvement that follows flows directly to working capital.

Continue learning