DSO vs CEI: what each one actually measures

Finance teams quote DSO and CEI as if they were two views of the same thing. They are not. They answer different questions, and reading one without the other is how teams end up fixing the wrong problem.

DSO: how much of your sales is still sitting in receivables

DSO = ending AR ÷ credit sales in period × days in period

DSO is a ratio of a balance to a flow. That is its strength and its weakness. It is simple, comparable over time and understood by everyone from the CFO to the board. But it blends together everything that makes receivables large: the terms you grant, the timing of your sales, your customer mix, disputes, late payment and cash you have not yet applied.

A rising DSO tells you something changed. It does not tell you what.

CEI: of what was collectible, how much did you collect

CEI = (beginning AR + credit sales − ending total AR)
    ÷ (beginning AR + credit sales − ending current AR) × 100

CEI strips out the part of receivables that is not yet due and asks a narrower question: of the money that could reasonably have been collected this period, what share actually was? It behaves like a measure of collections effort and outcome, and it is much less sensitive to sales swings than DSO.

It has its own traps. “Current” has to be defined the same way every period. Write-offs and credit memos clear AR just as cash does. And longer terms shrink the collectible base, so the same past-due balance weighs more heavily.

The bridge: DSO = best possible DSO + ADD

Split DSO in two. Best possible DSO is what you would have if everyone paid exactly on the due date, which depends on your terms and sales pattern. Average days delinquent is whatever sits above that: lateness.

This split is the single most useful habit in receivables analytics, because it tells you whether to talk to the sales and finance leadership about terms or to talk to collections and cash application about process.

Reading them together

DSO	CEI	Likely story
Rising	Steady or high	Terms, mix or sales timing. Probably not a collections failure.
Rising	Falling	Collections or cash application is slipping.
Flat	Falling	Early warning. Sales growth may be masking deterioration.
Falling	Rising	Genuine improvement, or a one-off such as a large early payment. Check before celebrating.

What actually drives DSO

Whatever the headline number, it moves because of a handful of drivers:

1. Payment terms and how well they are enforced
2. Billing speed and accuracy
3. Disputes and deductions
4. Collections effectiveness
5. Cash application speed and unapplied cash
6. Customer mix and credit policy

Each one has its own maths, its own metrics and its own fixes. We will take them one at a time.

Next in the series: the driver that sits entirely outside collections, and quietly adds days before the payment clock even starts.