Illustration of an hourglass beside a calendar and a downward-trending line chart.

DSO Explained: How to Calculate and Reduce Days Sales Outstanding

By the Credit Control Club Editorial Team

·

Days sales outstanding (DSO) is the average number of days it takes you to turn a credit sale into cash. It is the most widely used measure in credit control and accounts receivable, and the one your finance director or CFO is most likely to ask about. This guide shows you how to calculate it, how to judge whether yours is good, where it can mislead you, and what actually brings it down.

The DSO formula

The standard calculation is:

DSO = (accounts receivable ÷ total credit sales) × number of days in the period

  • Accounts receivable is the total owed to you by customers at the end of the period (the closing balance on your aged debt report or AR aging report).
  • Total credit sales is the value of sales made on credit during the period. Leave out cash sales, because they never sit in receivables.
  • Number of days matches the period: roughly 30 for a month, 90 for a quarter, 365 for a year.

Be consistent. Use the same period length, the same treatment of sales tax (VAT in the UK, sales tax in the US, GST/HST in Canada) and the same cut-off every time, or your trend will move for reasons that have nothing to do with collections.

A worked example

Say a business closes the quarter with $150,000 (or £150,000) in receivables. Its credit sales for the 90-day quarter were $270,000.

DSO = ($150,000 ÷ $270,000) × 90 = 50 days

On its own, 50 days means little. You need something to compare it with.

What “good” looks like

The most useful benchmark is your own payment terms. If you sell on 30-day terms and every customer paid exactly on the due date, your DSO would be close to 30. Anything above that reflects late payment, disputes or unapplied cash.

You can make this comparison precise with best possible DSO, which uses only the receivables that are not yet due:

Best possible DSO = (current, not-yet-due receivables ÷ total credit sales) × number of days

In the example, say $90,000 of the $150,000 is not yet due.

Best possible DSO = ($90,000 ÷ $270,000) × 90 = 30 days

The gap between actual DSO (50) and best possible DSO (30) is 20 days. That is roughly the average delay caused by overdue invoices, and it is the part your collections work can influence. Tracking the gap over time tells you more than the headline number does.

Comparing your DSO with other businesses is less helpful. Industries, customer types and standard terms vary so widely that a “typical” figure from elsewhere rarely tells you much about your own performance.

Where DSO can mislead you

DSO is simple, which is both its strength and its weakness. Watch for these traps:

  • Seasonality. If you invoice heavily in the last weeks of a period, receivables jump at period-end while the period’s sales are spread across all of it. DSO rises even if every customer pays on time.
  • Sales spikes and drops. A strong month inflates receivables; a weak month shrinks the sales figure. Either can move DSO without any change in payment behavior.
  • Mixed terms. If some customers are on 30 days and others on 60 or 90, a shift in your sales mix changes DSO even if collections performance stays the same.
  • Averages hide problems. A good overall DSO can conceal one large customer who is badly overdue.

For these reasons, read DSO alongside your aged debt report and other measures such as overdue percentage and collection effectiveness. Our guide to credit control KPIs covers how they fit together.

The countback method

If your sales are lumpy, the countback method gives a steadier figure. Instead of averaging, you work backward through recent months, subtracting each month’s credit sales from the closing receivables balance until it is used up.

Say receivables are $150,000, March sales were $100,000 and February sales were $80,000. March absorbs $100,000, which counts as March’s 31 days. The remaining $50,000 is 62.5% of February’s $80,000, so add 62.5% of February’s 28 days, which is 17.5 days. Countback DSO is 31 + 17.5 = 48.5 days.

It takes a little more work, but it reflects your most recent sales rather than an average across the period.

Practical levers to reduce DSO

DSO comes down when invoices go out faster, get approved faster and get paid closer to the due date. These are the levers that move it:

  1. Invoice promptly. Every day between delivery and invoice is a day added to DSO. Aim to invoice on the day of delivery or completion.
  2. Get invoices right first time. Correct PO numbers, prices, quantities and billing entities mean fewer invoices stuck in a customer’s approval process.
  3. Agree terms clearly at the start. Put them in the contract, on the credit application and on every invoice.
  4. Remind before the due date. A courtesy reminder a few days early catches problems while there is still time to fix them. Our payment reminder email templates give you a full sequence.
  5. Resolve disputes quickly. Log every dispute, assign an owner and set a target resolution time.
  6. Make paying easy. Offer the methods your customers prefer (bank transfer, ACH or EFT, card) and include payment details on every invoice and reminder.
  7. Prioritize by value and age. Spend your phone time on the largest and oldest balances first.
  8. Set and review credit limits. Limits stop exposure growing faster than a customer’s ability to pay. Assess customer creditworthiness before you set them.
  9. Apply cash promptly. Unapplied payments inflate receivables and make DSO look worse than it is.

Early payment discounts can also lower DSO, but they have a real cost. Work out what the discount costs you in annual terms before you offer one.

Key takeaways

  • DSO = (accounts receivable ÷ total credit sales) × days in the period. Calculate it the same way every time.
  • Compare DSO with your payment terms, and track the gap between actual and best possible DSO.
  • Seasonality, sales spikes and mixed terms can move DSO without any change in how customers pay.
  • Use the countback method if your sales are uneven from month to month.
  • The biggest levers are fast, accurate invoicing, early reminders and quick dispute resolution.

Discover more from Credit Control Club

Subscribe to get the latest posts sent to your email.


Posted

in

Tags:

Comments

Leave a comment