Skip to content

What is average days delinquent (ADD)? Definition, formula, and example

Accounts receivable, billing and collections

Definition

Average days delinquent (ADD) is the average number of days customers pay late, calculated as days sales outstanding minus best possible DSO. It shows how much of your DSO comes from overdue invoices rather than from your payment terms.

Formula
DSO − best possible DSO
Unit
Days
Scope
All receivables
Review
Monthly by segment

Average days delinquent formula

ADD is DSO minus best possible DSO, using the same period, day count, and credit sales.

ADD = DSO − best possible DSO
  • DSO: Ending AR ÷ credit sales × days in period
  • Best possible DSO: Current (not past due) AR ÷ credit sales × days in period

Because both share a denominator, ADD also equals past due AR ÷ credit sales × days, which is a useful check.

Average days delinquent example

Example: Kestrel Components closes the third quarter on Wednesday, September 30, 2026. The quarter has 92 days and credit sales of $3,680,000, or $40,000 a day. Ending AR is $1,200,000: $880,000 current and $320,000 past due. All amounts are illustrative.

MeasureCalculationResult
DSO$1,200,000 ÷ $3,680,000 × 9230.0 days
Best possible DSO$880,000 ÷ $3,680,000 × 9222.0 days
ADD30.0 − 22.08.0 days
Check: past due AR in days$320,000 ÷ $40,0008.0 days

Kestrel's net 30 terms and its 22-day best possible DSO look healthy, but 8 of its 30 DSO days come from late payment.

Is ADD the same as average days past due?

No. ADD spreads delinquency across all receivables, while average days past due measures how late the overdue invoices themselves are, weighted by balance.

Kestrel past due bucketBalanceAverage days past dueBalance × days
1 to 30 days$200,000153,000,000
31 to 60 days90,000454,050,000
61 to 90 days30,000752,250,000
Total$320,0009,300,000

Weighted days past due is 9,300,000 ÷ 320,000 = 29.1 days, so the overdue invoices average a month late even though ADD is 8.0.

What is a good ADD?

A good ADD is low and stable; there's no universal target, because it depends on your terms and customers. Track it monthly by segment and collector, and read a rising ADD as a collections problem even when DSO looks flat.

What is ADD confused with?

ADD is most often confused with DSO and with days beyond terms.

TermWhat it isHow it differs from ADD
Days sales outstanding (DSO)Average days to collect receivables: average gross accounts receivable divided by credit sales, times days in the period. Ending AR is a simpler proxyIncludes the days your terms allow; ADD removes them
Best possible DSODSO calculated using only current, not past due, receivables, showing the lowest DSO achievable if every customer paid on timeThe on-time part of DSO
Collection effectiveness index (CEI)Percentage measuring how much collectible receivables were actually collected in a period, with 100 percent meaning everything collectible was collectedA percentage of collections, not days
PAYDEX scoreBusiness credit score from 1 to 100 reflecting how promptly a company pays its suppliers, where higher means on time or earlyA bureau score of how one company pays its suppliers

ADD at month end

Calculate ADD after cash application and the aging tie-out, so past due balances are real.

  1. Apply cash: Clear unapplied cash so paid invoices don't look overdue
  2. Tie out the aging: Agree current and past due AR to the general ledger
  3. Calculate: DSO, best possible DSO, and ADD with the same day count
  4. Explain the change: Name the customers driving the movement

For cash forecasting, a higher ADD means slower collections than your terms imply. our Close Agent ties the AR subledger to the general ledger at close and prepares the entry, and nothing posts until a named approver signs off.

Common ADD mistakes

The most common ADD mistakes mix bases or misread what it measures.

  • Using different denominators: DSO and best possible DSO must use the same credit sales and days
  • Calling ADD the lateness of overdue invoices: That's weighted days past due
  • Reading ADD without CEI: Pair speed with effectiveness
  • Running it before cash application: Unapplied cash inflates past due AR