← Read

When a great month raises your DSO

September sales ran 13% above trend and DSO went up. Part 3 of The DSO Bridge: how sales timing and one terms change add 3.5 days, and why none of it is a collections problem.

The DSO Bridge · Ep 322 Oct 20264 min read

Part 2 showed that 3.7 of the 6.1 extra days sit in best possible DSO: invoices that are not yet due. This part explains where they came from. Two causes are at work: the timing of sales, and one change in terms.

September in numbers

Month Jun Jul Aug Sep
Credit sales ($m) 9.0 9.0 9.0 10.2

September came in 13% above a flat trend. On any sales dashboard, that is good news. On the DSO report, it shows up as a problem.

Why a strong month raises standard DSO

Standard DSO divides month-end AR by the last three months of sales. Two things happen when the last month is strong.

First, every September invoice is still open on 30 September. On Net 30 or Net 60 terms, nothing billed in September is due yet. AR takes the full $1.2m increase.

Second, the denominator only partly catches up. The three-month window now holds 28.2 instead of 27.0, so each $1m of AR is worth fewer days:

Days per $1m of AR = 90 ÷ credit sales in the window
August:    90 ÷ 27.0 = 3.33
September: 90 ÷ 28.2 = 3.19

To isolate timing, hold terms where they were. On August’s terms, current AR at the end of September is all of September’s sales plus the Net 60 share of August’s:

August September, old terms
Current AR ($m) 9.0 + 2.0 = 11.00 10.2 + 2.0 = 12.20
Days of current AR 11.00 × 3.33 = 36.67 12.20 × 3.19 = 38.94

That is +2.3 days on current AR. There is a small offset: the bigger denominator also makes August’s $1.30m of past-due balances count for slightly fewer days, which takes off 0.2. Net, timing adds +2.1 days.

Nothing about customer behaviour changed. This is the arithmetic of a strong month.

The countback check

If timing is really inflating standard DSO, a method that is less sensitive to timing should rise by less. Countback DSO does exactly that: it uses up the AR balance against the most recent months first.

August September Change
Standard DSO 41.0 47.1 +6.1
Countback DSO 41.0 45.2 +4.2

September’s countback: the first $10.2m of AR is September’s sales, 30 days. The remaining $4.55m is part of August’s $9.0m, so 4.55 ÷ 9.0 × 30 = 15.2 days. Total 45.2.

Countback rises about 2 days less than the standard method. That gap is the strong month, and it is a useful sanity check whenever sales are uneven. The two methods do not attribute timing in the same way, so do not expect the gap to match the bridge step exactly. Expect them to point the same way.

Terms: +1.4 days

In August, one customer billing about $0.45m a month moved from Net 30 to Net 60. Under the old terms, its August invoices would have fallen due in September. Under the new terms, they are still current on 30 September.

0.45 × 3.19 = 1.4 days

A shift in mix works the same way. Sell a bigger share to customers who already have longer terms and best possible DSO rises with no terms changing at all. In the bridge, terms and mix sit in one step: anything that changes how long invoices stay current.

Two causes, two owners

Timing, +2.1 days. No owner. It needs explaining, not fixing. Put countback DSO next to standard DSO in the month-end pack and the explanation writes itself.

Terms, +1.4 days. Sales and credit. This one is a decision, and it has a price. Net 60 instead of Net 30 means about $0.45m of cash waits an extra month. At a 10% annual cost of capital, that is roughly $3,750 a month for as long as the terms stand. The question for sales is not “why did DSO go up?” but “did this deal earn more than that?”

Together, timing and terms explain 3.5 of the 6.1 days. None of it is collections.

Next, Part 4: the 2.4 days of ADD, and the two causes collections gets blamed for but does not own.

About the author

Abhishek Sahu

Order to Cash Product Manager

Senior product manager with more than six years in order-to-cash, across HighRadius, Deloitte and EXL. He has built products for collections, cash application, deductions and O2C analytics, and holds three US patents in AI-driven financial automation.