Days Sales Outstanding: What Your DSO Is Telling You

What is days sales outstanding?

Days sales outstanding, almost always shortened to DSO, is a ratio that answers one question: once you invoice a client, how long do you wait to be paid? It looks at the money sitting on the accounts receivable side of your books and expresses it as a number of days of sales.

If your DSO is 36, then across your whole client base you are financing roughly 36 days of work before the cash lands. That gap is real money. It is the reason a profitable business can still struggle to cover payroll on the fifteenth of the month.

DSO meaning in plain English

The phrase is easier to read backwards. "Sales outstanding" is revenue you have earned and billed but not collected. "Days" converts that pile of unpaid invoices into a unit you can act on. One number, comparable month to month, that tells you whether collection is getting faster or slower.

It is a trend indicator, not a verdict. A single quarter's DSO on its own says very little. Four quarters in a row, moving in one direction, tells you something you can act on. Investopedia's reference entry on DSO is a good short primer on how analysts read it.

What is the DSO formula?

The standard DSO formula has three inputs and one multiplication:

How to calculate DSO step by step

Five steps, once per period. Pick a period and stick with it, because the number only means something in a series.

1. Choose the period and count its actual days.
2. Find your receivables balance on the first day of the period.
3. Find the balance on the last day, then average the two.
4. Add up everything you invoiced on terms during the period.
5. Divide the average balance by that total and multiply by the day count.

In a spreadsheet it is one line. Put the four inputs in a column and reference them:

B2  Receivables at the start of the period
B3  Receivables at the end of the period
B4  Credit sales invoiced during the period
B5  Number of days in the period

=(AVERAGE(B2,B3)/B4)*B5

A worked DSO calculation example

A two-person design studio bills entirely on net 30 terms. Here is the first quarter of the year, 90 days:

The arithmetic: 24,000 divided by 60,000 is 0.4, and 0.4 multiplied by 90 gives 36. The studio sells on net 30 and collects in 36, so clients are running about six days past the deadline on average. That is a nudge, not a crisis. If the same calculation in the next quarter returns 48, the studio has a collection problem that started somewhere in April.

What is a good DSO number?

There is no single good number, because DSO inherits whatever terms you granted. A business on net 60 will always post a higher DSO than one on net 7, and neither is better at collecting. The useful comparison is against the payment terms you set.

A widely used rule of thumb is that DSO above roughly one and a half times your stated terms points to a collection problem rather than a terms problem. Applied to common terms, that gives you a line to watch:

Terms are not entirely your choice either. Businesses selling inside the EU work under the Late Payment Directive, which caps standard B2B terms at 60 days unless both parties expressly agree otherwise and the longer term is not grossly unfair to the creditor. The text is on EUR-Lex as Directive 2011/7/EU.

Why is your DSO high?

When the number climbs, the cause is rarely that your clients suddenly became worse people. Work through the boring explanations first:

• You invoiced late. A bill sent nine days after delivery adds nine days to DSO before the client has done anything wrong.
• The due date is implied, not stated. "Net 30" in a footer is weaker than an explicit calendar date on the face of the document.
• The invoice went to the wrong inbox. Accounts payable teams pay what reaches their queue. A bill sitting in a project manager's mail is not in the queue.
• Something on the invoice is disputable. A missing purchase order reference or a vague line item parks the whole amount until someone chases it.
• Nobody follows up. A past due invoice that gets no reminder teaches the client that the deadline is decorative.
• One large client pays slowly. A single big account on 75 days can drag the average past your line while everyone else pays on time.

When does DSO mislead you?

DSO is an average, and averages hide things. Four situations where the number lies to you:

• Seasonal billing. A heavy invoicing month inflates the denominator and pushes DSO down just when your receivables are at their worst. Compare the same quarter year over year, not to the previous quarter.
• Few, large invoices. With twelve invoices a quarter, one slow payer moves the average dramatically. Below roughly twenty invoices in a period, read the aging list instead of the ratio.
• Mixed currencies. Adding a euro balance to a dirham balance produces a number with no meaning. Calculate DSO separately per currency.
• Write-offs. Clearing a bad debt off the books drops receivables and improves DSO, while the cash position got worse, not better.

Because of this, most finance teams read DSO next to a second ratio. The accounts receivable turnover ratio uses the same two inputs arranged as a frequency rather than a duration, and an aging report shows the distribution the average flattened out.

How can you lower your DSO?

Almost every reliable improvement happens before the invoice is sent, not during the chasing afterwards.

• Invoice the same day you deliver. This is the cheapest day you will ever cut from the cycle.
• Print an actual due date. Set realistic invoice due dates as calendar dates so there is nothing to interpret.
• Make one line item match one deliverable. Descriptions that match what the client approved remove the most common reason for a payment to stall.
• Put the payment details on the document. Bank details and reference on the invoice itself, not in the covering message.
• Ask for a deposit on large jobs. Splitting a project into a deposit and a balance halves the exposure without renegotiating terms.
• Send the first reminder early and politely. Two or three days after the due date, before the balance ages into the awkward bracket.
• Know what you are owed for lateness. UK sellers, for instance, have a statutory right to interest and recovery costs on late commercial payments, set out on GOV.UK. Knowing the entitlement changes how a follow-up reads even when you never invoke it.

Which invoice data do you need to track DSO?

Three fields per invoice, and that is all: the issue date, the total, and the date the payment actually cleared. The first two come off the invoice. The third comes from your bank, and it is the one most small businesses never write down.

The BlueInvoice invoice generator gives you the first two by default. Every invoice carries an issue date and a due date, and the due date is pre-filled 30 days ahead for an invoice and 14 days ahead for a quotation, both editable directly on the document. Totals and tax are calculated as you type, and you can preview, download a PDF or create a share link without an account.

Save invoices to an account and the My Invoices workspace adds an overview panel on top of them. It reports total invoiced, invoice count, distinct clients, average invoice value and tax collected for this month, this quarter, this year or all time, with a revenue chart for the last twelve months and totals split by currency and by folder. A payment due dates card groups your invoices into overdue, due soon within seven days, and upcoming beyond that, built from the due date on each one. An insights strip shows your average payment terms in days, taken from the gap between issue date and due date across your invoices.

The export panel is built for exactly that handover. Filter by folder, by month, by year or by a date range, then download the matching invoices as one ZIP of JSON files or as individual JSON files. From there you add a "paid on" column, and the formula from earlier in this article does the rest.

Free invoice generator

A clear due date is the first day off your DSO

Build the invoice in your browser, set the due date on the document itself, and download a clean PDF. Save it to an account and the overview panel starts tracking what is overdue, due soon and upcoming.

Create an invoiceFree, no sign-up, no watermark

Frequently asked questions