Free DSO Calculator
Calculate your Days Sales Outstanding in seconds. See how you compare to industry benchmarks and how much cash is trapped in your receivables.
Jump to the free 5-tab Excel template ↓What is DSO?
Days Sales Outstanding is the average number of days it takes your company to collect payment after a sale is made. Lower is better. A DSO 10 days above your industry average means roughly 10 times (annual revenue / 365) in cash is trapped in receivables instead of in your bank.
The calculator above uses the standard formula — (AR / Revenue) × Period — and compares your result to median DSO by industry.
Read the full guide: How to calculate DSO →A 5-tab DSO Excel with benchmarks, formulas, and a 90-day playbook
Charts, benchmarks, aging breakdown, and a 90-day playbook — editable, share-ready, no pitch.
Get your full DSO breakdown as an Excel
Editable formulas, industry benchmarks, and a 90-day action playbook — branded to share with your CFO.
How to actually reduce your DSO
Frequently asked questions
How do I calculate DSO?
DSO = (Accounts Receivable / Credit Sales) × Days in period. For annual DSO use 365; for monthly use the days in that month. Example: AR of €1.8M on €10M annual credit sales gives DSO = (1,800,000 / 10,000,000) × 365 = 66 days. Use ending AR for simplicity, average AR for precision, and always exclude cash sales from the denominator — only count credit sales.
What are DSO industry benchmarks?
Hackett Group's 2024 S&P 1500 data puts the all-industries median at 46 days, with top-quartile at 28. By segment: retail B2C (card-settled) 1–3 days; retail B2B wholesale 30–45; manufacturing industrial 45–60, automotive 75+; SaaS 38–52 depending on SMB vs enterprise; construction 80–100 due to retainage; healthcare hospital systems 47 (HFMA). Benchmark to your industry median minus 5–10 days if you're aiming at best-in-class.
What's the difference between DSO and Cash Conversion Cycle?
DSO measures only the AR side — days from sale to cash. The Cash Conversion Cycle (CCC) is the broader CFO view: CCC = DSO + DIO − DPO, where DIO is days of inventory outstanding and DPO is days you take to pay suppliers. High DSO extends CCC and ties up working capital. Optimizing CCC usually means shortening DSO and extending DPO while right-sizing inventory.
What drives a high DSO?
Most common causes: unmatched cash sitting in the suspense account (often 3–5 days' worth), deduction backlog blocking clearance on otherwise-paid invoices, lenient or poorly enforced payment terms, disputed invoices with no active follow-up, and slow invoice issuance after delivery. A DSO 15+ days above your industry median usually points to an AR execution gap — customers pay when asked clearly and early, not when invoices arrive late or matching breaks.
How do I interpret my DSO number?
Compare against your own trend (YoY, QoQ) and your specific industry median, not a generic benchmark — a DSO of 55 is great for construction and terrible for retail. Sustained increases signal dispute backlogs, payment-term creep, or customer credit deterioration. Every day of DSO reduction on a €500M revenue book frees roughly €1.37M from working capital, which is why finance teams treat DSO as a primary operational KPI.
