Days Sales Outstanding (DSO) Calculator
Days Sales Outstanding (DSO) measures the average number of days it takes for a business to collect payment from customers following a credit sale. A lower DSO means faster cash collections and fewer bad debt write-offs.
Sensitivity Analysis
Evaluate how variations in key operational drivers impact Days Sales Outstanding (DSO).
| Sensitivity Case | Assumption Shift | Driver Value | Days Sales Outstanding (DSO) | Impact vs Base |
|---|
Formula & Methodology
DSO = (Accounts Receivable / Annual Credit Sales) * 365Accounts ReceivableOutstanding trade credit owed by customers.
Credit SalesTotal revenue generated on payment terms (net of cash sales).
Practical Worked Example
Apex Consulting has $200,000 in unpaid client invoices and $1,800,000 in annual billing.
Interpretation & Industry Benchmarks
Compare DSO against the company’s stated credit terms (e.g., Net 30). If credit terms are Net 30 and DSO is 55 days, collection procedures need tightening.
Excellent credit control.
Typical for Net 30 corporate trade.
Late customer payment tendencies.
Severe collection delays; potential uncollectible write-offs.
Industry Nuance: E-commerce and B2C retail have DSO near 0–5 days (credit cards settle in 48 hours). Enterprise B2B software averages 45–60 days.
Analytical Limitations
- Lumping seasonal sales across an annual period can mask month-to-month collection deterioration.
Frequently Asked Questions
How can a company reduce DSO?
Offer early payment discounts (e.g., 2/10 Net 30), implement automated invoice reminders, require upfront deposits, and enforce strict credit limits.