What Is Days Sales Outstanding (DSO)?
Days sales outstanding measures the average number of days it takes a company to collect cash after making a sale on credit. It turns the balance of accounts receivable into a number of days, answering a practical question: once we invoice a customer, how long until we get paid? A lower DSO means customers pay quickly and cash comes back fast; a higher DSO means cash is tied up in unpaid invoices. It is one of the core measures of how well a business manages its receivables.
How to Calculate DSO
DSO = (Accounts Receivable / Total Credit Sales) x Number of Days in the Period
Worked example, for a year:
- Accounts receivable: $600,000
- Annual credit sales: $4,380,000
- Days in period: 365
- DSO: (600,000 / 4,380,000) x 365 = 50 days
On average, it takes this company about 50 days to collect after a sale.
DSO in Power BI (DAX)
Days in period is the number of days the calculation covers. Replace the measures with the ones in your model:
DSO = DIVIDE ( [Accounts Receivable], [Total Revenue] ) * [Days In Period]What Is a Good DSO?
A good DSO depends on the payment terms a company offers. If terms are net 30, a DSO near 30 means customers generally pay on time, while a DSO well above the terms signals slow collection. As with most metrics, the trend matters: a rising DSO is an early warning that cash is taking longer to come in, often before it shows up as a cash flow problem.
DSO and the Cash Conversion Cycle
DSO is one of the three components of the cash conversion cycle, alongside days inventory outstanding and days payable outstanding. It captures the collection side: how long cash sits in receivables after a sale. Reducing DSO, by invoicing faster, tightening terms, or following up on overdue accounts, shortens the overall cash cycle and frees up working capital.
Reporting DSO From Your ERP Data
DSO depends on accurate, current receivables and sales data drawn consistently from the ERP, which gets harder across entities and currencies. A governed data foundation brings receivables and revenue onto one model so DSO is consistent and ties back to the books. QuickLaunch ships pre-built models for JD Edwards, Vista, NetSuite, and OneStream that surface receivables data for collections reporting.
Frequently Asked Questions
How is DSO calculated?
Divide accounts receivable by total credit sales, then multiply by the number of days in the period. A company with $600K in receivables and $4.38M in annual sales has a DSO of about 50 days.
What is a good DSO?
It depends on the payment terms offered. A DSO near the terms (for example, around 30 days on net-30 terms) indicates customers pay on time; a DSO well above the terms signals slow collection. The trend matters as much as the level.
What is the difference between DSO and the cash conversion cycle?
DSO measures only the collection period, how long cash sits in receivables. The cash conversion cycle combines DSO with days inventory outstanding and days payable outstanding to measure the full time cash is tied up in operations.
