If your financial dashboard shows a DSO of 35 days and you breathe easily, this article is for you. That figure \u2014 the one you report to the committee and to the board \u2014 is in all likelihood concealing a deteriorating ledger beneath an average that sounds perfectly reasonable. Average DSO is one of the most widely reported and least well understood metrics in B2B financial management. It is a KPI that misleads by virtue of how we construct and interpret it.<\/p>\n
DSO (Days Sales Outstanding)<\/strong> measures how many days, on average, your business takes to convert a sale into cash. It is useful as a general barometer, but it suffers from a structural flaw: it is an average, and averages conceal the extremes.<\/p>\n Consider a business with two major clients accounting for 60% of turnover, both of which pay promptly at 30 days. The remaining 40% comprises dozens of smaller clients, many paying at 40, 55 or more days. The average DSO settles at a comfortable figure \u2014 say, 48 days \u2014 because those two punctual giants pull the average downwards. The result: a deteriorating ledger is camouflaged behind an indicator that appears healthy.<\/p>\n An average DSO that remains stable month on month can coexist with genuine and growing deterioration in the ledger. What you report as sound is, in reality, a concentration of good payers masking the poor ones.<\/p>\n There are two ways to escape the trap of the mean.<\/p>\n Weighted DSO<\/strong> assigns each client or segment a weighting according to its outstanding balance, rather than its turnover. In this way, a client that owes a great deal and pays late carries the weight it genuinely represents in your treasury position, rather than being diluted within the average. This shift in focus is decisive: you stop measuring \u201chow much I sell\u201d and start measuring \u201chow much cash I genuinely have trapped, and with whom\u201d.<\/p>\n DSO by ageing bucket (ageing)<\/strong> breaks the ledger down by age of debt: current, 1\u201330 days overdue, 31\u201360, 61\u201390, and 90+. Once you perform this breakdown, the comfortable figure collapses and the truth emerges: what percentage of your ledger sits in the risk zone, and what percentage of your future cash depends on invoices that have gone uncollected for months.<\/p>\n The right question is: \u201cWhich part of my ledger is sustaining the company’s DSO, and which part is quietly sabotaging it?\u201d<\/em><\/p>\n The difference between the two perspectives is often stark. Businesses with a \u201cgood\u201d average DSO discover, upon performing the ageing analysis, that between 15% and 25% of their balance sits in buckets more than 60 days overdue: immobilised cash that they are unwittingly financing at the expense of their own liquidity.<\/p>\n This is where the metric that almost nobody reports \u2014 and which reveals the most \u2014 comes in: the Best Possible DSO (BPDSO)<\/strong>.<\/p>\n The BPDSO calculates what your DSO would be if you collected only what falls within terms \u2014 in other words, your ideal scenario with zero late payment. The formula compares the current (non-overdue) ledger against sales for the period. What matters is the gap between your actual DSO and your Best Possible DSO.<\/p>\n That gap is, quite literally, the cash you have trapped avoidably. If your actual DSO is 52 and your BPDSO is 34, those 18 days of difference represent the cost of collections management that could be improved. And with the cost of money where it stands today, each of those days carries a price. As we explained when analysing the true cost of a high DSO in a high-interest-rate environment<\/a>, many businesses borrow at 6% whilst financing their clients at zero cost through a poorly managed DSO.<\/p>\n Metric<\/strong><\/p>\n<\/td>\n What it reveals<\/strong><\/p>\n<\/td>\n<\/tr>\n All of the above is of little use if you calculate it only once a month, tied to the accounting close. By then, the problem has already occurred. The difference between businesses that suffer their ledger and those that govern it lies in frequency: measuring the quality of DSO daily.<\/p>\nWeighted DSO and DSO by Ageing Bucket: What You See When You Break the Number Down<\/h2>\n
Best Possible DSO: The Gap That Measures the Cash You Are Losing Avoidably<\/h2>\n
\n\n
\n \n What it measures<\/strong><\/td>\n \n \n \u00a0 Average DSO<\/strong><\/td>\n \u00a0 Average collection days across the entire ledger<\/td>\n \u00a0 A useful general barometer, but one that conceals the extremes<\/td>\n<\/tr>\n \n \u00a0 Weighted DSO<\/strong><\/td>\n \u00a0 Collection days adjusted by outstanding balance<\/td>\n \u00a0 Where your cash is genuinely trapped<\/td>\n<\/tr>\n \n \u00a0 DSO by ageing bucket\u00a0\u00a0<\/strong><\/td>\n \u00a0 Distribution of the ledger by age of debt<\/td>\n \u00a0 What percentage of the ledger sits in the risk zone<\/td>\n<\/tr>\n \n \u00a0 Best Possible DSO<\/strong><\/td>\n \u00a0 The ideal DSO, collecting only what is not yet overdue<\/td>\n \u00a0 The gap of cash that is avoidably recoverable<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n How to Monitor It Daily (Rather Than Once a Month at the Close)<\/h2>\n