DSO vs CEI vs ADD: which AR metric tells the truth

DSO, CEI, and ADD answer three different questions about the same collections cycle. DSO is the average number of days to collect a receivable, CEI is the percentage of collectible receivables you actually collected, and ADD is how many days past due invoices run on average. DSO is the headline number but it moves with sales, CEI is the truest read on collections skill, and ADD isolates how late customers are.

Most finance teams default to DSO because it is one number that everyone tracks. The problem is that DSO alone can lie about how well collections are working. Read it next to CEI and ADD and the real story shows up: whether cash is slow because of a sales swing, a struggling team, or accounts quietly aging out.

Defining DSO, CEI, and ADD

Each metric has a simple formula and a distinct job.

Days sales outstanding (DSO) is the average time to collect after a credit sale.

DSO = (Accounts Receivable / Total Credit Sales) x Number of Days

Collection effectiveness index (CEI) is the share of available receivables collected in a period.

CEI = ((Beginning AR + Credit Sales - Ending Total AR) / (Beginning AR + Credit Sales - Ending Current AR)) x 100

Average days delinquent (ADD) is the average number of days an invoice is paid past its due date.

ADD = DSO - Best Possible DSO

Best possible DSO is what DSO would be if every customer paid exactly on terms, current receivables divided by credit sales times the days in the period. The gap between actual DSO and that floor is ADD.

What each metric reveals and hides

DSO converts the whole collections process into one figure, which is its strength and its flaw. It is easy to track and good for spotting a trend, but it reacts to anything that changes the size or timing of sales, so it hides whether a move came from collections or from the sales line.

CEI does the opposite. By comparing what you collected to what was collectible, it cancels out sales-volume swings and reads as close to pure collections performance as any single number gets. What it hides is timing: a team can post a strong CEI while still letting a handful of invoices drift late.

ADD fills that gap. It isolates lateness, so it tells you how far behind customers are running regardless of how much you sold or collected. What it hides is scale, because a small ADD on a book full of disputes can still mean real cash is stuck.

When DSO misleads you

DSO misleads most often during growth. Book a big month of credit sales and DSO climbs, because receivables rise faster than the prior period's sales denominator catches up, even if collections never slowed. A finance leader reading DSO in isolation sees a collections problem that does not exist.

It misleads in the other direction too. In a slow sales month, DSO can fall and flatter the team while older invoices quietly age. The number looks healthy because the denominator shifted, not because anyone collected better. This is why measuring people on DSO is unfair, a point worth weighing whenever you set out to measure collections team performance. CEI and ADD do not have this blind spot, which is exactly why you read them alongside it.

Using the three together

Read in sequence, the three metrics separate symptom from cause.

1. Start with DSO for the headline trend. Is cash arriving faster or slower over the last several periods?
2. Check CEI to ask whether the move came from collections. If DSO rose but CEI held steady, sales timing moved the number, not the team. If CEI fell, the team genuinely collected a smaller share of what was available.
3. Check ADD to locate the lateness. A widening ADD says invoices are drifting past due, which is the early signal behind a DSO that is about to climb for real.

The combination tells you both what happened and why, which is the difference between reacting to a bad month and fixing its cause.

A worked case makes the point. Say DSO jumps from 38 to 44 days over a quarter. Read alone, that looks like a collections failure worth a hard conversation with the team. Now add the other two. CEI held at 86 percent the whole quarter, and ADD barely moved. The team collected just as high a share of what was collectible, and invoices were not running later. The DSO move came from a 30 percent jump in credit sales late in the quarter, which inflated receivables faster than the formula's denominator caught up. The honest read is that collections performed well in a quarter that happened to grow, the opposite of the story DSO told on its own.

Benchmarks for each

Targets depend on your terms and industry, but useful rules of thumb hold across most B2B books.

• DSO: aim to sit well inside your terms. On net-30, under 40 days is healthy and over 45 signals a problem. Compare to your own trend and to industry DSO benchmarks rather than a universal number.
• CEI: runs 0 to 100 percent. Above 80 percent is strong, and consistently high-performing teams hold the high 80s and 90s.
• ADD: smaller and more stable is better. A low, flat ADD means slippage is contained; a rising one means accounts are aging and DSO will follow.

Tracking all three in real time

The three metrics only work as a system if all three are current. Calculate them from a month-old export and they describe last quarter, so by the time CEI dips or ADD widens, the accounts that caused it have already aged past the point where outreach is cheap.

Kept live, the three become an early-warning system. ADD widens first, CEI confirms the team is collecting a smaller share, and DSO trails as the lagging summary, which is the heart of reading leading vs lagging AR indicators. The hard part is keeping all three fresh while invoices age every day.

How Rex keeps all three true

Rex is an agentic AI accounts receivable agent. It works invoices across your whole ledger the moment they age, recalculating DSO, CEI, and ADD live as cash applies, so the three metrics always describe today rather than last month's export. Because Rex acts the instant ADD starts to widen on an account, it catches slippage while outreach is still cheap and before it shows up in DSO.

Rex does the routine collections work continuously, the timely follow-up that holds CEI high and ADD low, and escalates only the accounts that need a human decision. You read the three metrics as a live system and Rex keeps them honest. See how Rex runs collections end to end.