What is average days delinquent (ADD)? Definition, formula, and example
Accounts receivable, billing and collections
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.
- 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.
| Measure | Calculation | Result |
|---|---|---|
| DSO | $1,200,000 ÷ $3,680,000 × 92 | 30.0 days |
| Best possible DSO | $880,000 ÷ $3,680,000 × 92 | 22.0 days |
| ADD | 30.0 − 22.0 | 8.0 days |
| Check: past due AR in days | $320,000 ÷ $40,000 | 8.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 bucket | Balance | Average days past due | Balance × days |
|---|---|---|---|
| 1 to 30 days | $200,000 | 15 | 3,000,000 |
| 31 to 60 days | 90,000 | 45 | 4,050,000 |
| 61 to 90 days | 30,000 | 75 | 2,250,000 |
| Total | $320,000 | 9,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.
| Term | What it is | How 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 proxy | Includes the days your terms allow; ADD removes them |
| Best possible DSO | DSO calculated using only current, not past due, receivables, showing the lowest DSO achievable if every customer paid on time | The 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 collected | A percentage of collections, not days |
| PAYDEX score | Business credit score from 1 to 100 reflecting how promptly a company pays its suppliers, where higher means on time or early | A 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.
- Apply cash: Clear unapplied cash so paid invoices don't look overdue
- Tie out the aging: Agree current and past due AR to the general ledger
- Calculate: DSO, best possible DSO, and ADD with the same day count
- 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