Skip to content

Days Sales Outstanding (DSO): How to Calculate and Improve It

By Newtown Analytics · · 6 min read

For finance, fp&a & accounting managers

Days sales outstanding (DSO) measures the average number of days it takes a company to collect payment after a sale made on credit. A lower DSO means cash arrives sooner. A rising DSO is an early sign of collection problems, loosening terms or customer disputes. This guide gives the formula, worked examples, ways to dig deeper, and a practical improvement plan. DSO is one of the three days metrics behind the cash conversion cycle and a staple of cash flow management.

The DSO formula

DSO = (Accounts receivable / Credit sales) × Days in period

Use credit sales, not total sales, when cash sales are significant, since cash sales do not create receivables. Use the same period for sales and the day count: 365 for a year, 90 for a quarter, 30 for a month.

Worked example

A hypothetical company has accounts receivable of $400,000 at quarter-end and credit sales of $1,050,000 over the 90-day quarter.

DSO = ($400,000 / $1,050,000) × 90 = 34.3 days

On average, the company takes just over 34 days to collect. If its standard terms are net 30, customers are paying a few days late on average.

What each day is worth

Daily credit sales are $1,050,000 / 90 = $11,667. Each day of DSO therefore represents $11,667 of cash tied up in receivables.

DSO improvementCash released
1 day$11,667
3 days$35,000
5 days$58,333
10 days$116,667

Reducing DSO from 34.3 to 29.3 days frees about $58,000 of working capital. For a company that borrows at 9 percent, that is about $5,250 a year in avoided interest ($58,333 × 0.09), in addition to the improved liquidity. Convert any DSO target to dollars before you commit effort to it.

Beyond the average: best possible DSO and average days delinquent

A single DSO figure blends customers who pay on time with those who pay very late. Two supporting metrics separate the two.

Best possible DSO (BPDSO) uses only receivables that are not yet past due:

BPDSO = (Current receivables / Credit sales) × Days in period

Average days delinquent (ADD) is the difference:

ADD = DSO - BPDSO

Continue the example. Of the $400,000 receivable balance, $310,000 is current and $90,000 is past due.

  • BPDSO = ($310,000 / $1,050,000) × 90 = 26.6 days
  • ADD = 34.3 - 26.6 = 7.7 days

The company collects current invoices in about 27 days, but delinquent accounts add nearly 8 days to the average. The improvement opportunity lies in the $90,000 of past-due accounts. Bringing them current would reduce DSO toward 26.6 days and release up to $90,000 of cash.

Variations of the calculation

MethodHow it worksWhen to use
Simple (ending balance)Ending receivables / credit sales × daysQuick monthly check
Average balanceAverage of opening and closing receivablesSmoother, better for growth
CountbackCounts back through monthly sales until the receivable balance is used upSeasonal or fast-growing businesses
Weighted by customerCalculates DSO for each customer or segmentDiagnosing problem accounts

The countback method is useful when sales are uneven. Suppose receivables are $400,000, and monthly credit sales are $350,000 (current month), $330,000 (prior month), and $370,000 (the month before). The current month's sales cover the first $350,000 of receivables. The remaining $50,000 comes from the prior month's $330,000, which is 15.2 percent of that month (50 / 330). If the months are 30 days long, DSO is 30 + (0.152 × 30) = 34.5 days. The method reflects the timing of sales better than a single division.

What drives DSO

DriverEffect
Stated termsNet 60 produces a higher DSO than net 30
Invoice accuracy and timelinessErrors and late invoices delay payment
Customer mixLarge retailers and government buyers may pay slowly
Disputes and deductionsShort payments and chargebacks extend collection
Collections disciplineRegular reminders shorten DSO
SeasonalityPeak sales months inflate receivables
GrowthQuick growth raises receivables ahead of cash

DSO is therefore not just a finance number. Sales terms, billing quality, customer service and operations all influence it.

How to improve DSO

1. Tighten the process before the invoice

  • Confirm terms and purchase order details at order entry.
  • Check credit limits and payment history before shipping.
  • Capture the right billing contact and invoice delivery method.

2. Invoice quickly and correctly

  • Send the invoice on the day of shipment or completion.
  • Include all references customers need to process it, such as purchase order numbers.
  • Track invoice rejections by cause and fix the root cause.

3. Follow up with a rhythm

  • Send a courtesy reminder a few days before the due date.
  • Call on the due date for large invoices.
  • Escalate at fixed intervals, with clear ownership.

4. Resolve disputes fast

Many late payments are disputes in disguise. Track disputed amounts and the reasons, and assign someone to resolve each one. A dispute log with ages helps.

5. Offer easier ways to pay

Electronic payments, payment links on invoices and automatic payment plans reduce friction.

6. Review terms and incentives

Test whether shorter terms, deposits for new customers or early-payment discounts make sense. Compare the cost of a discount with the cost of capital. See 2/10 net 30 explained and net 30 vs. net 60.

7. Segment and prioritize

Focus on the largest balances and the oldest invoices. Review the aging report weekly. A guide to reading it is in the accounts receivable aging report.

8. Report DSO regularly

Show DSO, BPDSO and ADD monthly, by segment and for the top 10 customers. Set a target and tie it to specific actions.

DSO and the cash forecast

DSO assumptions feed directly into the cash forecast. If you project receipts using a standard 30 days but actual DSO is 41, the forecast will be wrong every week. Use observed DSO by customer or segment to place receipts. The links between metrics and forecasts are explained in how to build a cash flow forecast.

Limits of DSO

  • It is an average. A few large late payers can hide behind good performers.
  • It is sensitive to timing. A large sale at month-end inflates receivables.
  • It depends on the mix of cash and credit sales. Use credit sales for accuracy.
  • It rises with growth. Rapid sales increases can raise DSO temporarily without a change in behavior. Compare to the aging profile.
  • It does not show quality. A low DSO with a few uncollectible accounts still hides losses. Combine with bad debt tracking.

Common mistakes

  • Including cash sales in the denominator, which understates DSO.
  • Mixing periods, such as annual sales with a 30-day multiplier.
  • Looking at DSO only at the company level and missing problems in particular segments.
  • Setting an aggressive target without addressing root causes.
  • Ignoring the customer relationship when pushing collections.

Where to go next

Pair DSO with days payable outstanding and days inventory outstanding to see the full cycle. If you sell physical products and want to shorten the whole cycle, connect receivables work with inventory planning, as described in demand planning and inventory optimization.

FAQs

What is days sales outstanding?

DSO is the average number of days it takes to collect payment on credit sales. It is calculated as accounts receivable divided by credit sales, multiplied by the number of days in the period.

What is a good DSO?

A good DSO is close to your stated payment terms and improving over time. A DSO of 35 days on net 30 terms is typical for many businesses, but acceptable levels vary by industry and customer mix.

How do I lower my DSO?

Invoice promptly and accurately, follow up before and after due dates, resolve disputes quickly, offer easy payment methods and review credit terms. Focus on past-due balances and your largest customers.

What is the difference between DSO and BPDSO?

DSO uses total receivables. Best possible DSO uses only current (not past due) receivables and shows the lowest DSO you could achieve if every customer paid on time. The difference is average days delinquent.

Should I use total sales or credit sales for DSO?

Use credit sales. Cash sales do not create receivables, and including them understates DSO.

This article is for general information. It is not accounting, tax, legal or investment advice, and examples use illustrative numbers rather than client data. Confirm decisions that carry financial or legal consequences with a qualified professional.

Better forecasts. Healthier inventory. More working capital.

Newtown Analytics advises growing consumer-product companies on demand planning and inventory optimization.