Free DSO Calculator
DSO (days sales outstanding) is roughly how many days of sales are sitting in accounts receivable. Enter your numbers below to calculate it, with the formula shown.
DSO
-
DSO = (average AR ÷ credit sales) × days
How to calculate DSO
DSO = (average accounts receivable ÷ credit sales for the period) × number of days in the period. Average AR is usually the opening and closing AR balance for the period added together and divided by two. Use credit sales only, not cash sales, and make sure both numbers cover the same dates.
Worked example
Average AR of $240,000 and credit sales of $540,000 over the last 90 days gives DSO = (240,000 ÷ 540,000) × 90 = 40 days. If your terms are Net 30, customers are paying about 10 days late on average. At a 30-day target you'd free roughly $60,000 of cash: 10 days × $6,000 of daily credit sales.
What is a good DSO?
A useful benchmark is your own payment terms. A DSO close to your standard terms means customers pay roughly on time. A DSO well above your terms means collections are slipping. Compare against your own trend month to month rather than a generic industry number.
Three things that make DSO misleading
- Mixing windows: AR from one period against sales from another.
- Using a single month, so one unusual month swings the number.
- Counting cash sales, which makes DSO look better than it is.
Frequently asked questions
What is DSO?
DSO (days sales outstanding) is the average number of days it takes to collect payment after a sale on credit. Lower is better: it means cash comes in sooner.
What is the DSO formula?
DSO = (average accounts receivable ÷ credit sales) × days in the period. For a 90-day period, divide average AR by 90 days of credit sales and multiply by 90.
How often should I calculate DSO?
Monthly at a minimum. A trailing 90-day DSO, recalculated weekly, smooths out one-off months while still showing a real trend.
How do I lower DSO?
Follow up before invoices are late, contact the right accounts first each day, resolve disputes quickly and track promised payment dates. Nectivo.ai shows live DSO from your QuickBooks Online invoices and tells you who to contact next.