How To Calculate Days Sales Outstanding

Days sales outstanding measures how long, on average, money owed by customers stays unpaid before it reaches the bank. The calculation is accounts receivable divided by revenue, multiplied by the number of days in the period. With 150,000 of receivables against 1,800,000 of revenue across 365 days, the ratio is 0.08333333333333333 and the DSO is 30.416666666666664 days. That one number compresses an entire collections process into a single figure, which is why it appears on every working capital dashboard and in every cash-flow forecast. It answers a blunt question: how much of what we have sold have we actually been paid for?

A DSO of 30.42 days means the average invoice is settled roughly a month after it is raised. Read another way, the receivables balance turns over 365 divided by 30.416666666666664, which is 12.000000000000002 times a year — effectively once a month. At 1,800,000 of annual revenue the business books 4931.506849315068 of sales every day, so a month of uncollected sales represents roughly 150,000 of cash sitting outside the bank. The figure is a weighted average rather than a promise: some customers settle in ten days and others in ninety, and DSO blends them all into one number.

The revenue in the denominator must be credit sales for the same period as the receivables, and getting that wrong is the most reliable way to produce a meaningless DSO. Cash sales never create a receivable, so including them inflates the denominator and flatters the ratio: add 600,000 of cash sales to the 1,800,000 above and the ratio falls to 0.0625, implying a DSO of 22.8125 days that no customer actually experiences. The period must match as well, because dividing a year-end receivables balance by quarterly revenue overstates DSO roughly fourfold. Consistency between numerator and denominator matters far more than the precise definition a company chooses.

DSO is the mirror image of days payable outstanding, which measures how long a business takes to pay its own suppliers. Collecting in 30.42 days while paying in 45 days gives roughly 15 days of free financing on every transaction, and that gap — the cash conversion cycle — is where working capital is genuinely won or lost. On this revenue base each day of DSO is worth 4931.506849315068 of cash, so cutting DSO by five days releases 24,657.53 and adding a week ties up 34,520.55. That arithmetic is why treasury teams treat DSO as a first-class metric rather than an accounting footnote.

A rising DSO quietly consumes cash even while the income statement reports growth. If revenue climbs from 1,800,000 to 2,160,000 — a healthy 20% increase — but DSO drifts from 30.42 to 45 days, receivables grow from 150,000 to roughly 266,301, an extra 116,301 locked inside unpaid invoices. The profit and loss account then shows more sales while the bank account shows less money, which is the classic trap of the fast-growing business that runs out of cash. Growth with deteriorating collections is not automatically good news, and DSO is the number that exposes the difference.

DSO only means something alongside the payment terms the business actually grants. A DSO of 30.42 days against terms of net 30 is close to perfect; the identical figure against terms of net 15 is alarming, because customers are taking twice as long as they agreed. A workable rule is to compare DSO with the standard term and to treat any gap beyond a few days as a collections question rather than a billing one. Measuring against terms also reveals whether generous terms are being quietly abused or whether the terms themselves are simply too long for the sector.

Because DSO is a ratio of a balance to a flow, it is sensitive to seasonality and to the exact point in the cycle at which it is measured. A retailer that books 40% of its 1,800,000 of revenue in the final quarter will show a distorted year-end DSO unless the receivables figure is averaged. The cleaner approach averages receivables across the period — for instance (120,000 + 180,000) / 2 = 150,000 — and divides that by daily revenue of 4931.506849315068, which returns the same 30.416666666666664 days when the underlying pace is steady. Annualising a short period compounds any timing error, so quarterly figures should always be flagged as such.

DSO is best read as a trend and against peers rather than against an absolute target. A distributor selling on net 60 terms may run a perfectly healthy DSO of 55 days, while a software business billing monthly should expect something nearer to 30.4. Comparing 30.42 days with a sector median of 45 suggests efficient collection, whereas comparing it with 20 suggests either unusually strong terms or customers paying early for a discount. The metric also ignores the ageing of the balance, so the same DSO can conceal one customer at 300 days while everyone else is current — which is why it belongs next to an ageing schedule, never on its own.

DSO sits at the centre of a small family of working capital measures that are best read together. Receivables turnover, at 12.000000000000002 times a year here, is the same information expressed as a frequency, while days payable and inventory days complete the picture of how long cash stays trapped inside the operating cycle. Improving DSO without damaging sales is one of the few genuinely free wins in finance, because it releases cash that has already been earned. The discipline is to track it monthly, hold the definition constant, and never let a strong revenue quarter hide a deteriorating collection period.