DSO, properly: what it measures, how to calculate it, and where it misleads
One formula, four decisions that change the answer, and the cases where a lower DSO means nothing. A working guide to days sales outstanding, with worked examples.
Days sales outstanding is the most quoted number in receivables and one of the most misread. It is easy to compute, which is why it travels so widely, and easy to compute differently in every company, which is why two DSO figures are rarely comparable until someone checks how each was built.
This guide covers the formula, the four choices that change the answer, countback DSO, the two companies that share one number and need opposite fixes, and the cases where a better DSO is not a better business.
The formula
DSO = ending AR ÷ credit sales in the period × days in the period
It converts a balance into time. If your receivables equal 45 days of credit sales, DSO is 45: on average, a rupee of credit sales takes about 45 days to become cash.
Three words carry the weight in that sentence. Average, because DSO blends every customer and every invoice. About, because it divides a snapshot by a flow and assumes sales were even across the period. Credit, because cash sales never enter receivables and must stay out of the denominator.
Four decisions that change the number
Before comparing any two DSO figures, check these four.
1. Which sales go in the denominator. Only credit sales. A business with a large cash or prepaid share and a DSO computed on total revenue will look faster at collecting than it is.
2. Which period. A 30-day window reacts quickly and swings with month-end timing. A 90-day window smooths that and hides a recent change. A 365-day window is stable but nearly useless for operations. Pick one for management and keep it fixed; do not switch windows to improve the story.
3. Which balance. Ending AR is the usual choice and the one in the formula above. Average AR is smoother but needs a second data point. Whichever you choose, use it every period.
4. What counts as AR. Unapplied cash, credit memos, disputed items and written-off balances all move the figure. Agree what is in before the number is reported, not after.
Standard against countback
The standard formula assumes sales were even across the period. When sales are rising or falling, that assumption is wrong, and it is wrong in a predictable direction.
Take a quarter with ending AR of 150 and credit sales of 100 in September, 80 in August and 60 in July (₹ crore, for example).
Standard DSO: 150 ÷ 240 × 92 days = 57.5 days.
Countback DSO asks a different question: working backwards from today, how many days of the most recent sales does the ending balance represent?
- September’s sales of 100 absorb 100 of the 150 balance. That uses all 30 days.
- 50 remains. August’s sales were 80, so 50 ÷ 80 of August’s 31 days is 19.4 days.
Countback DSO: 49.4 days.
The gap, eight days, is not a collections difference. Sales grew through the quarter, so the ending balance is made of recent, large months, and the standard formula spreads it across a quarter whose early months were small. When sales are growing, standard DSO overstates how long customers are taking to pay. When sales are falling, it understates it.
Use countback when sales are seasonal, growing or shrinking quickly. It needs monthly sales history and a bit more work, which is why the calculator on this site does it for you.
Two companies, one number, opposite problems
Take two companies with credit sales of 90 over a 90-day quarter and ending AR of 45. Both report a DSO of 45 days.
| Company A | Company B | |
|---|---|---|
| Terms | Net 30 | Net 45 |
| Total AR | 45 | 45 |
| Not yet due | 30 | 42 |
| Past due | 15 | 3 |
| Best possible DSO | 30 days | 42 days |
| Average days delinquent | 15 days | 3 days |
Company A’s customers are paying roughly two weeks late. The fix is in collections and cash application: reminders, escalation, disputes, unapplied cash. Company B is collecting almost perfectly against terms that are simply long. The only way down is shorter terms, earlier invoicing or a faster order-to-invoice step, and no amount of collector effort will help.
Splitting DSO into best possible DSO (what you would have if everyone paid exactly on the due date) and average days delinquent (the excess) is the habit that turns a single number into a decision. DSO alone cannot tell A from B.
When a lower DSO means nothing
A falling DSO feels like good news. Check these before reporting it.
- Write-offs. Clearing a bad debt removes AR without anyone paying. Writing off 15 from the 150 balance above moves standard DSO from 57.5 to 51.8 days with no improvement in collections at all.
- Credit memos and reclassification. Moving a disputed balance out of AR improves the figure on paper.
- Sales timing. A strong first half of the period grows the denominator and shrinks DSO even if collections are unchanged.
- Tighter credit. Refusing risky customers lowers DSO and may cost more in lost sales than it saves in cash.
- One large early payment. A single customer can move DSO by days. Look at the distribution before you celebrate the average.
The test is simple: can you point to a cash event? If DSO fell because customers paid sooner, yes. If it fell because a number moved, no.
A working checklist
- Fix the denominator: credit sales only.
- Fix the window and the balance (ending or average) and write them down.
- Report standard DSO, and countback DSO whenever sales are moving.
- Split DSO into best possible DSO and average days delinquent.
- Before reporting an improvement, name the cash event behind it.
You can run the standard and countback calculations on your own numbers with the DSO calculator, and the best possible DSO calculator does the split in point 4.
- DSO, properly: what it measures, how to calculate it, and where it misleads
- DSO vs CEI: what each one actually measures
