DSO tells you how long cash takes to come in. Best-possible DSO and CEI tell you how much of that is down to your collections team.
Best-possible DSO uses only current (not yet due) receivables, so it shows DSO if every customer paid on time. Actual DSO minus best-possible DSO gives average days delinquent, the part caused by late payment. The collection effectiveness index compares what you collected in a period with what was available to collect. CEI near 100% means almost everything collectable was collected.
DSO = total receivables ÷ credit sales for the period × days in the period
Best-possible DSO = current receivables ÷ credit sales for the period × days in the period
Average days delinquent (ADD) = DSO − best-possible DSO
CEI = (opening receivables + credit sales − closing total receivables) ÷ (opening receivables + credit sales − closing current receivables) × 100
"Current receivables" means invoices that are not yet due at the period end. Use the same receivables figures (before any bad debt provision) in every measure. The basics of DSO itself are in the DSO formula guide.
| Item | Cell | Amount |
|---|---|---|
| Opening receivables | B2 | 400,000 |
| Credit sales for the month | B3 | 300,000 |
| Closing total receivables | B4 | 420,000 |
| Closing current receivables | B5 | 270,000 |
| Days in the month | B6 | 30 |
DSO: =B4/B3*B6 = 42 days
Best-possible DSO: =B5/B3*B6 = 27 days
ADD: =B4/B3*B6-B5/B3*B6 = 15 days
CEI: =(B2+B3-B4)/(B2+B3-B5)*100 = 65.1
Checking the CEI: the business collected 400,000 + 300,000 − 420,000 = 280,000. It could have collected everything except the invoices not yet due: 400,000 + 300,000 − 270,000 = 430,000. 280,000 ÷ 430,000 = 65.1%.
DSO depends on sales: a big sales month makes DSO fall even if nobody chased a single invoice, and a quiet month makes it rise. CEI measures collection against what was collectable, so it is much less affected by sales swings. That makes it a better measure for the credit control team's own performance, while DSO remains the better measure of cash tied up.
Use a rolling three-month version of DSO if sales are lumpy: total receivables divided by the last three months of credit sales, times the days in those three months.
UK teams often say "debtor days" for DSO and "aged debtors" for the ageing report; US teams say DSO and "AR aging". The formulas are the same. Decide whether receivables and sales include VAT or sales tax and use the same basis on both sides of every ratio.
Applies the payments your customers make to the invoices they are paying, including part-payments and one payment for several invoices, and shows what is still owed. Runs in your browser on your own computer: nothing is uploaded.
Work out DSO and the cash tied up in late payers. Free to use online.
The Credit Control & Receivables System calculates ageing, DSO, best-possible DSO and CEI from the ledger, shapes a bad debt provision to IFRS 9 / ASC 326 logic and requires independent approval for credit limits and write-offs. Excel, no macros, one-time price.
The closer to 100, the better, but the useful comparison is with your own trend. A steady fall is a warning sign whatever the level.
No. Current receivables are part of total receivables, so best-possible DSO is always equal to or lower than DSO on the same basis.
Monthly, for managing the team, with a quarterly figure to smooth one-off items.
Last updated 08 November 2026. General guidance for finance teams; check it against your own policies, systems and local rules.