Days Sales Outstanding Calculator

What is days sales outstanding (DSO)?

Days sales outstanding (DSO) is the average number of days it takes a business to collect cash after a sale on credit. It divides accounts receivable by credit sales and multiplies by the days in the period, so a DSO of 36.5 days means the receivables on the balance sheet equal 36.5 days of credit sales.

DSO matters because receivables are cash the business has earned but cannot spend. The longer customers take, the more of the business’s own money funds their purchases. Comparing DSO with your payment terms turns it into a question you can act on: are customers, on average, paying when they agreed to?

How do you calculate days sales outstanding?

Divide the accounts receivable balance by net credit sales for the period and multiply by the number of days in that period. With $90,000 of receivables, $900,000 of credit sales and a 365-day year: $90,000 ÷ $900,000 × 365 = 36.5 days. Against Net 30 terms, customers take 6.5 days longer than agreed on average. Those are the calculator’s defaults.

The period must match: a quarter’s receivables against a quarter’s credit sales and 90 or 91 days; a month’s against the month and 30 or 31 days. Dividing a quarter-end balance by a year of sales mixes periods and makes DSO meaningless. For a monthly DSO with $60,000 of receivables and $75,000 of credit sales in a 30-day month, DSO is 24.0 days.

Should DSO use ending or average accounts receivable?

Ending (period-end) receivables are the default because they come straight off the balance sheet. When the balance swings during the year, for a seasonal business or one that is growing fast, the closing figure can be unusually high or low; the average of the opening and closing balances smooths that.

With $80,000 at the start and $90,000 at the end, average receivables are $85,000 and DSO falls from 36.5 to 34.5 days.

Use the same choice every period, and say which one you used. The calculator prints it beside the result, and the cash conversion cycle page offers the same two options so the figures agree.

Credit sales or total sales?

DSO measures how long credit sales take to collect, so the denominator is net credit sales. Cash and card sales are collected at once and never become receivables; adding them makes the denominator larger and DSO shorter than the true collection time.

If your income statement only gives total sales, the calculator will still compute, and labels the result so the reader knows it understates DSO.

What are best-possible DSO and the count-back method?

Best-possible DSO counts only receivables that are not yet due. It shows the DSO your terms would give if every customer paid on time; the rest of DSO is the average days delinquent. With $25,000 of the $90,000 past due, best-possible DSO is $65,000 ÷ $900,000 × 365 = 26.4 days and the delinquent part is 10.1 days.

Both measures come from the Credit Research Foundation. The count-back method explains the period-end balance with the most recent months’ sales instead of a period average. It walks back from the latest month: with receivables of $180,000 and credit sales of $100,000 last month and $90,000 the month before, the first month covers $100,000 (30 days) and the remaining $80,000 is 80/90 of the month before (26.7 days), a count-back DSO of 56.7 days. Because it uses recent sales, a seasonal spike earlier in the year does not distort it.

How do DSO, the collection period and receivables turnover relate?

The average collection period is another name for DSO: the same formula and the same answer. Receivables turnover is its reciprocal in times per period: credit sales ÷ receivables = $900,000 ÷ $90,000 = 10.00 times, and 365 ÷ 10.00 = 36.5 days. The accounts receivable turnover calculator on this site uses the same engine with turnover as its headline.

This page does not say what a good DSO is for your industry, because published averages rarely state the terms behind them. Compare DSO with your own terms and with your own earlier periods; the default trend shows 42.9, 39.4 and 36.5 days, a business collecting faster each period. It is an estimate from the figures you enter, not accounting advice.