DSO vs CEI: Why a Better DSO Doesn't Always Mean Better Collections
Explore the differences between DSO and CEI, and understand why a lower DSO doesn't always indicate better collections performance.
Improving DSO does not always mean improving collections.
For AR managers, the direct answer is: neither DSO nor CEI is universally more important. They answer different questions, and reading only one can leave you with an incomplete, or even misleading, picture of how collections are actually performing.
- DSO is a days-based view of ending receivables relative to sales.
- CEI is a percentage-based measure of collection effectiveness over a period.
A shift in either can be driven by receivables, sales growth, payment terms, aging, disputes, promise-to-pay activity, or account-level exceptions, which means the two metrics can genuinely disagree about how well collections is doing.
What DSO Measures
The National Association of Credit Management (NACM) defines DSO as:
DSO = Ending Total Receivables × Number of Days / Sales
DSO expresses ending total receivables relative to sales as a number of days. Before trending it, lock down your reporting period, sales basis, ending-receivables population, and treatment of adjustments, and keep them consistent period over period.
Credit sales are a component of DSO that collections teams often have little control over, as NACM notes. A lower DSO isn't automatic proof collections improved, and a higher one doesn't automatically indict the team. Sales volume alone can move it.
Methodology also varies by company. SEC filings show real-world differences, from receivables divided by a 90-day average revenue figure to receivables divided by net revenue multiplied by days in the quarter (example, example). At Flowwiz we standardize on Count Back DSO specifically because it holds up better for trend analysis across periods. Decide on a single method before you start comparing DSO over time.
What CEI Measures
NACM's CEI formula:
CEI = (Beginning Receivables + Monthly Sales − Ending Total Receivables) / (Beginning Receivables + Monthly Sales − Ending Current Receivables) × 100
Using sales in both the numerator and denominator neutralizes sales bias, which is what makes CEI a better read on the quality of collection efforts than DSO alone (source).
It has its own blind spot, though: CEI doesn't account for differing terms of sale or dating. When it moves, check payment terms and dating practices before drawing conclusions from the percentage by itself. As a rough benchmark, we generally consider a CEI above 85% healthy for a SaaS AR team, though the right number depends on your terms and industry. (For a fuller walkthrough of the formula and worked examples, see our CEI explainer.)
A Worked Example: DSO Improves, CEI Declines
The numbers below are an illustrative calculation using the NACM formulas above (not benchmark or customer data), built to show how the two metrics can move in opposite directions in the same period.
Assumptions: each period is 30 days, DSO uses monthly sales as its basis, and adjustments are excluded consistently in both periods.
Input | Period 1 | Period 2 |
|---|---|---|
| Beginning receivables | $1.0M | $1.0M |
| Monthly sales | $1.0M | $1.5M |
| Ending total receivables | $1.2M | $1.3M |
| Ending current receivables | $0.8M | $0.4M |
| Number of days | 30 | 30 |
DSO
- Period 1: $1.2M × 30 / $1.0M = 36 days
- Period 2: $1.3M × 30 / $1.5M = 26 days
CEI
- Period 1: ($1.0M + $1.0M − $1.2M) / ($1.0M + $1.0M − $0.8M) × 100 = $0.8M / $1.2M = 66.7%
- Period 2: ($1.0M + $1.5M − $1.3M) / ($1.0M + $1.5M − $0.4M) × 100 = $1.2M / $2.1M = 57.1%
DSO improves from 36 to 26 days. CEI drops from 66.7% to 57.1%. Same company, same period, two opposite signals. Sales growth pulled DSO down mechanically, while a larger share of the new receivables ended up in non-current buckets, which CEI picked up and DSO didn't. Neither metric is "wrong" here; they're measuring different things, and only looking at both tells you what's actually happening.
Reading DSO and CEI Together
Treat the two as complementary questions, then dig into the operating context behind any movement:
- Aging: which balances are current vs. past due, and in which segments?
- Payment terms and dating: did terms or billing timing shift what counts as "due"?
- Disputes: are unresolved disputes delaying payment or ownership of next steps?
- Promises to pay: which commitments are upcoming, missed, or need follow-up? (See Promise-to-Pay Best Practices for a full workflow.)
- Remittance and cash application: is exception handling delaying application?
- Account-level exceptions: is a small number of accounts or invoices driving the whole trend?
- Collector capacity: does the team have a prioritized, context-aware follow-up queue? (See Prioritize the Next Best Collection Action.)
Why This Gets Harder at Scale
Running that seven-point checklist by hand is manageable at a hundred open invoices. It stops being manageable at a thousand, which is usually exactly when DSO and CEI start disagreeing the most. This is the gap Flowwiz's AR agents are built to close: they track aging, disputes, and promise-to-pay status continuously and flag account-level exceptions as they happen, so a DSO/CEI divergence shows up as a specific, actionable list of accounts, not a mystery to investigate at month-end.
The Bottom Line
Neither DSO nor CEI is universally more important. Use DSO as a days-based view of receivables relative to sales, and CEI as a percentage-based view of collection effectiveness. Define your inputs consistently, and don't treat either one as a stand-alone verdict on collections performance. Read them together with aging, terms, disputes, promises to pay, and account-level exceptions, and you have a grounded basis for what to do next.