Selling on credit is only a sale once the money arrives. Days sales outstanding, or DSO, tells you how many days that takes on average. This DSO calculator takes your accounts receivable, your credit sales, the days in the period and your payment terms to give the DSO, the receivables turnover, the days beyond terms and the cash tied up in late payments.
How the calculation works
- DSO = accounts receivable ÷ credit sales × days in the period.
- Receivables turnover = credit sales ÷ accounts receivable, the number of times receivables are collected in the period.
- Days beyond terms = DSO − payment terms, never below zero.
- Cash tied up = days beyond terms × credit sales per day, the money sitting in late invoices.
Example
A company has $180,000 of receivables at year end and $1,460,000 of credit sales over 365 days. DSO = 180,000 ÷ 1,460,000 × 365 = 45.0 days, and receivables turn over 8.11 times a year. With 30-day terms, customers pay 15 days late on average. Sales are $4,000 a day, so $60,000 of cash is tied up by the late payments.
Why it matters
A business can be profitable on paper and still run out of cash because customers pay slowly. DSO shows this problem early, before the bank balance does. Lenders watch it, investors compare it between companies, and a rising DSO is often the first sign of weaker customers or a loosening of credit policy.
Good to know
DSO is an average and hides a long tail: a few very late invoices can raise it while most customers pay on time. Seasonal sales also distort it, because the receivables at year end may not reflect the average level of the year, so use the same period for both numbers. Use the receivables at the end of the period or an average of the beginning and end. Aging reports, which group invoices by how late they are, give the detail the DSO leaves out. A very low DSO may mean credit terms that are too strict and cost sales.
Related tools
The cash conversion cycle calculator adds inventory and payables, the inventory turnover calculator measures how fast stock sells and the current ratio calculator tests short-term liquidity.