How this instrument works
A single days sales outstanding reading tells you how many days of credit sales are sitting in receivables right now, but it says nothing about direction. A credit analyst reviewing a borrower's covenant compliance, or a controller closing the books each quarter, needs the number to move against a baseline — this instrument runs the DSO formula on two periods at once and reports the gap between them, because a rising gap is one of the earliest signals that collections are slipping, often weeks before the change shows up in cash flow.
The engine computes Current period DSO, days and Prior period DSO, days from four independent inputs — a receivable balance and a credit-sales figure logged separately for each period — then applies the same Period length, days to both before subtracting one from the other. Sharing a single days figure across both calculations matters: comparing a 90-day quarter against a 365-day year inside the same subtraction would make the change figure meaningless, so the instrument only ever measures two periods of identical length against each other.
Change in DSO, days does not by itself say whether customers slowed down or the business did. The identical positive change can come from receivables genuinely growing faster than sales — a real collections problem — or from credit sales cooling while receivables held flat, which is a demand problem wearing a collections number. Reading the two underlying growth rates behind the change, not just the change itself, is what separates a diagnosis from a guess.
- Enter Current period accounts receivable, $ and Current period credit sales, $ for the period you just closed.
- Enter Prior period accounts receivable, $ and Prior period credit sales, $ for the same length of time, one period back.
- Set Period length, days to the number of days both credit-sales figures actually cover — the same value applies to both periods.
- Compare Current period DSO, days against Prior period DSO, days to see the two snapshots side by side.
- Read Change in DSO, days — positive means collections are taking longer, negative means they're speeding up.
Worked example — DSO climbs from 10.66 to 12.38 days
A company closes the current quarter with Current period accounts receivable, $ of 55,000 against Current period credit sales, $ of 400,000, with Period length, days set to 90. Receivables come to 0.1375 of the quarter's credit sales, and stretched across 90 days that ratio becomes a Current period DSO, days of 12.375 days.
The prior quarter carried Prior period accounts receivable, $ of 45,000 against Prior period credit sales, $ of 380,000, run through the identical 90-day Period length, days, for a Prior period DSO, days of 10.6578947368. Subtracting the two leaves a Change in DSO, days of 1.71710526316 — DSO lengthened by about one and three-quarter days. Credit sales rose only 5.3% quarter over quarter while receivables climbed 22.2%, so the widening gap between those two growth rates, not the day-and-three-quarters figure alone, is what marks this as a genuine collections slowdown rather than noise.
Questions
Why compare two periods instead of reading one DSO figure alone?
One DSO reading has no baseline — twelve days could be a fast, disciplined collections cycle or a recent slide from an even faster nine days, and a single number cannot tell you which. Running the same formula on a current and a prior period and subtracting turns one snapshot into the first two points of a trend, which is what Change in DSO, days is built to show.
What does a positive Change in DSO, days actually mean?
It means the current period's DSO is higher than the prior period's — on average, invoices are sitting unpaid longer than they did last time this was measured. The cause could be slower-paying customers, looser credit approval, or a genuine shift in the sales mix, but the sign alone only tells you direction, not the reason behind it.
Can Change in DSO, days rise even though collections practices never changed?
Yes. Because DSO is a ratio, a slowdown in Current period credit sales, $ relative to Current period accounts receivable, $ raises the change figure by exactly as much as genuinely slower payment would. Compare the two sales figures on their own before concluding collections got worse — a shrinking sales denominator produces the identical signal as a growing receivables balance.
Why must Period length, days be the same for both periods?
Period length, days feeds the same value into both the current and prior calculation, so a 90-day quarter measured against a 365-day year inside one subtraction would compare unlike units and make Change in DSO, days meaningless. Set it to the number of days that both credit-sales figures genuinely cover, and keep that figure identical across the two periods.
How many days of change in DSO is worth investigating?
There is no fixed threshold — the right scale depends on the business and its normal credit terms — but a change sustained across two or more consecutive comparisons carries far more weight than a single period's move. A shift of a day or two, like the example above, often sits inside ordinary quarter-to-quarter noise rather than signaling a real change in collections.
Does a negative Change in DSO, days always mean the business is healthier?
Usually, but not automatically — a falling DSO can also come from a stricter credit-approval policy that quietly turns away decent customers who simply need more time to pay, trading collection speed for volume the business no longer books. Read the change alongside what happened to Current period credit sales, $ itself: DSO falling while sales grow tells a different story than DSO falling while sales shrink too.
References
- U.S. Small Business Administration — Manage your business finances
- NYU Stern School of Business — Aswath Damodaran, corporate finance resources
Read this first: This instrument shows arithmetic, not advice. Real offers add fees, taxes and terms that vary by lender and place — verify the figures against your actual paperwork before deciding anything.