Back to Tips

How to Calculate DSO (Days Sales Outstanding), and Three Things That Break It

Short answer: DSO (days sales outstanding) = (average accounts receivable ÷ credit sales for the period) × days in the period. Use AR and sales from the same window, use credit sales only, and prefer a trailing 90 days over a single month. Try it with your own numbers in the free DSO calculator.

A DSO number you can't recompute isn't worth managing to.

DSO (days sales outstanding) is roughly how many days of sales are sitting in receivables. A common version: average AR over a period, divided by credit sales over that same period, times the number of days in it.

Three things quietly break it:

  1. Mixing windows. AR from the last 90 days against year-to-date sales gives a number that drifts all year without anyone noticing.
  2. Using a single month. One slow or unusually strong month swings the whole figure.
  3. Trusting a report blindly. Check that the sales figure actually covers the dates you asked for.

A trailing 90 days, with AR and sales from the same window, smooths most of this out without hiding a real trend.

A worked example

Say AR was $180,000 at the start of the quarter and $220,000 at the end, so average AR is $200,000. Credit sales for the same 90 days were $600,000. DSO = $200,000 / $600,000 x 90 = 30 days. If you had used year-to-date sales of $1,800,000 over 270 days instead, the result would still be 30 days, but only by coincidence: as soon as one quarter is busier than the others, the two methods diverge.

Pulling the numbers from your accounting system

  • QuickBooks Online: AR balances come from the A/R Aging Summary or the balance sheet, and credit sales from Sales by Customer Summary for the same date range.
  • NetSuite: use the A/R Aging Summary as of each date and a saved search or income statement for sales over the matching window.
  • Xero: the Aged Receivables Summary gives AR at each date, and the Profit and Loss or Sales by Contact report gives sales for the same period.
  • Sage: run the aged receivables report at the start and end of the window, and a sales or customer activity report for the same dates.
  • Microsoft Dynamics 365 Business Central: Aged Accounts Receivable for the balances and customer sales statistics for the period.

The rule is the same everywhere: AR and sales must cover the same window, and the sales figure should be credit sales, not cash sales.

It's how Nectivo calculates DSO, and the DSO card shows its formula next to the number so you can check it yourself. Nectivo.ai syncs directly with QuickBooks Online. Teams on NetSuite, Xero, Sage, Microsoft Dynamics or another accounting system can upload an AR aging report export as a CSV or Excel file and work from the same daily list.

Frequently asked questions

What is a good DSO?

A DSO close to your standard payment terms means customers pay roughly on time. If your terms are Net 30 and DSO is 45, customers are paying about 15 days late on average. Your own month-to-month trend matters more than a generic industry benchmark.

Should I use average AR or ending AR to calculate DSO?

Average AR, usually the opening plus closing balance divided by two, is more stable. Ending AR alone can swing with a single large invoice issued or paid at period end.

Why does my DSO change so much month to month?

Usually because it is calculated over a single month, or because AR and sales come from different date ranges. A trailing 90-day DSO with matching windows smooths out one-off months.

Related: QuickBooks collections software · Free DSO calculator · Pricing