---
title: "Average Days Delinquent: Definition, Formula and Example"
description: "Average days delinquent (ADD) explained: the DSO minus best possible DSO formula, a worked quarterly example, and how it differs from days past due."
url: https://emptyspaces.ai/glossary/average-days-delinquent
language: en
---

[Home](https://emptyspaces.ai/) [Glossary](https://emptyspaces.ai/glossary) Average days delinquent (ADD)

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

Updated November 19, 2026[Accounts receivable, billing and collections](https://emptyspaces.ai/glossary#browse)

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.

| 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.

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](https://emptyspaces.ai/product/close) 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

## Related terms

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.

Best possible DSO DSO calculated using only current, not past due, receivables, showing the lowest DSO achievable if every customer paid on time.

Collection effectiveness index (CEI) Percentage measuring how much collectible receivables were actually collected in a period, with 100 percent meaning everything collectible was collected.

Accounts receivable aging report Report listing unpaid customer invoices by how long they have been outstanding, such as current, 1 to 30, 31 to 60 days past due.

Collections KPIs Metrics measuring collections performance, such as DSO, collection effectiveness index, past due percentage, promise-to-pay kept rate, and average days delinquent.

AR KPIs Metrics tracking receivables performance, such as DSO, collection effectiveness index, average days delinquent, past due percentage, and bad debt ratio.

Full guides: [Month-end close KPIs](https://emptyspaces.ai/resources/blog/month-end-close-kpis), [General ledger vs subledger: AP and AR reconciliation](https://emptyspaces.ai/resources/blog/ap-ar-reconciliation), and [FP&A](https://emptyspaces.ai/resources/blog/fpa).

More terms: [Finance and accounting glossary](https://emptyspaces.ai/glossary)

Bring reconciled receivables into your close

Bring one reconciliation to a working session. See how our agents prepare the evidence and your team reviews and approves.

[Book a working session](https://emptyspaces.ai/contact-us)

No implementation commitment.

[All 721 glossary terms](https://emptyspaces.ai/glossary)
