Skip to content

Days sales outstanding calculator

By Jude Wallis

Days sales outstanding is receivables divided by sales, multiplied by the days in the period. $50,000 of receivables against $400,000 of annual sales is 45.625 days, the average wait between invoicing and being paid.

Days sales outstanding

45.6 days

$50,000.00 of receivables on $400,000.00 of sales.

DSO
45.625
$
$

Put this on a class page: one iframe, free, for Google Sites, Canvas, WordPress or Notion.

The formula

DSO=receivablessales×daysDSO=\frac{\text{receivables}}{\text{sales}}\times \text{days}

Receivables is the balance owed by customers, sales is credit sales for the period, and days is the length of that period. All three must describe the same window.

It turns a balance into a wait

$50,000 of receivables means nothing on its own; it depends entirely on how large the business is. Dividing by $400,000 of annual sales and multiplying by 365 turns it into 45.625 days, which is comparable to any other business and to the company's own terms.

That conversion is the point. A balance is a stock, sales are a flow, and days is the unit that makes the two speak to each other.

Match the period on both sides

Annual sales go with 365 days. A quarter's sales go with about 90. Mixing them is the standard error here, and it scales the answer by four in one direction or the other, which is large enough to change every conclusion drawn from it.

Seasonality is the subtler version of the same problem. A business that sells most of its year in one quarter will show a very different DSO depending on when the balance is measured, which is why an average receivables figure is often used instead of the closing one.

Compare it to the terms you offered

On 30 day terms, 45.625 days means customers are on average paying about two weeks late. On 60 day terms, the same figure means they are paying early. The number only becomes information next to the terms that were agreed.

The second example, $40,000 of receivables on $365,000 of sales, gives exactly 40 days. Smaller balance, smaller sales, and a genuinely faster collection cycle than the first business.

Where DSO fits

It is one of the three legs of the cash conversion cycle, alongside inventory days and payable days, and it is the leg a business can most directly influence. Cutting days here releases cash without any change in sales, which is why it shows up in every working capital discussion. This is educational material, not financial advice.

Worked examples

\$50,000 of receivables on \$400,000 of sales

Receivables are $50,000, annual sales are $400,000, and the period is 365 days. What is DSO?

  1. Receivables as a share of sales: 50000/400000=0.12550000 / 400000 = 0.125.
  2. Multiply by the days in the period: 0.125×365=45.6250.125 \times 365 = 45.625 days.

DSO is 45.625 days, from $50,000 of receivables against $400,000 of annual sales.

A faster collecting business

Receivables are $40,000 and annual sales are $365,000, again over 365 days.

  1. Share of sales: 40000/365000=0.1095940000 / 365000 = 0.10959.
  2. Times 365 days: exactly 40 days.

DSO is 40 days on $40,000 of receivables and $365,000 of sales, nearly six days faster than the first business.

Using annual sales with a quarterly balance

Dividing a quarter end receivables balance by annual sales and multiplying by 365 is arithmetically fine, and it answers a question nobody asked if the quarter was unrepresentative. Keep the sales figure and the days count on the same window, and use average receivables when the business is seasonal.

Common questions

Should cash sales be in the denominator?

No. Only credit sales create receivables, so including cash sales understates the figure.

Is a lower DSO always better?

Usually, though extremely tight terms can cost sales. It is a speed measure, not a quality measure.

Is this financial advice?

No. It is educational material for the collection period identity.

This page is educational material, not financial advice. The figures come from the formula shown and assume the inputs you enter hold for the whole term. Your own rate, fees, taxes and timing will differ, so treat the output as arithmetic to check a decision against, not as a recommendation.