Business calculator

DSO calculator (days sales outstanding)

Find out how many days, on average, your customers take to pay. Enter what you are owed at the end of a period and your credit sales for that period. The calculator shows your DSO, how far it runs past your payment terms, and how much cash would come in if you collected faster.

  • ✓ DSO in days
  • ✓ Days beyond terms
  • ✓ Cash tied up
  • ✓ Monthly, quarterly or yearly

Your numbers

If entered, DSO uses average receivables: (opening + closing) ÷ 2.

Result

Days sales outstanding

–

DSO is an average. Check which invoices are actually overdue and send reminders with a statement of account.

How to calculate DSO

  1. Pick a period. A month (30 days), a quarter (90 days), a year (365 days) or a custom number of days. Use the same period every time you compare.
  2. Enter accounts receivable. The total of unpaid customer invoices at the end of the period. Add the opening balance too if you want to use average receivables.
  3. Enter credit sales. Sales invoiced on credit during the same period. Leave out cash and card sales paid at the time of sale.
  4. Add your terms and a target. Optional: your usual payment terms show how far DSO runs past them, and a target DSO shows how much cash a faster collection rate would release.

DSO formula

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

Accounts receivable is what customers owe you at the end of the period. Credit sales are the sales you invoiced (rather than were paid for on the spot) during the same period. The result is the number of days of sales sitting unpaid in your receivables. Some businesses use average receivables, (opening + closing) ÷ 2, which smooths out a single large invoice at the period end; enter an opening balance in the calculator to use that version.

  • Average daily credit sales = credit sales ÷ days.
  • Days beyond terms = DSO − your standard payment terms (an approximation of how late customers pay on average).
  • Receivables at a target DSO = average daily credit sales × target days.
  • Receivables turnover = credit sales ÷ receivables for the same period (365 ÷ DSO on a yearly basis).

Worked example

A small agency invoices 120,000 on credit in a quarter (90 days) and is owed 45,000 at the end of the quarter. Its standard terms are Net 30.

StepWorkingResult
DSO45,000 ÷ 120,000 × 9033.75 days
Average daily credit sales120,000 ÷ 901,333.33
Days beyond Net 30 terms33.75 − 303.75 days
Receivables at a 30-day DSO1,333.33 × 3040,000
Cash released by reaching 30 days45,000 − 40,0005,000

A second check: 250,000 of receivables against 1,000,000 of quarterly credit sales gives 250,000 ÷ 1,000,000 × 90 = 22.5 days. On a yearly basis, 60,000 owed against 500,000 of annual credit sales is 60,000 ÷ 500,000 × 365 = 43.8 days, or a turnover of about 8.3 times a year.

What is a good DSO?

Compare DSO with your own payment terms first, and with your own past results second. If you invoice on Net 30, a DSO in the low 30s means customers mostly pay on time; a DSO of 50 means many pay three weeks late. Industry averages vary widely because terms do: construction and wholesale often run long, while businesses that take deposits or card payments run short. A rising DSO over several months is the useful warning sign, even when the number looks normal for your sector.

DSO vs your termsWhat it usually means
Below termsDeposits, early payment discounts or card payments are pulling it down
Within about 10% of termsMost customers pay on time
10–50% above termsA group of slow payers; check the oldest invoices
More than 50% above termsCollections need attention; some invoices may be disputed or uncollectable

How to lower your DSO

  • Invoice the day the work is done. Every day between finishing and invoicing adds a day to DSO. The free invoice generator makes a PDF in a couple of minutes.
  • Set clear terms and due dates. Print the actual due date, not just “Net 30”; see invoice payment terms.
  • Ask for deposits on larger jobs with a deposit invoice, or bill progress stages.
  • Offer an early payment discount only if it is worth it; the early payment discount calculator shows the annual cost of 2/10 net 30.
  • Follow up on a schedule and use the statutory or contractual right to charge interest where you have it, worked out with the late payment interest calculator.
  • Send statements to customers with several open invoices using the statement generator.

Limits of DSO

DSO is an average across all customers, so one large unpaid invoice can hide many prompt payers, and a big sale at the end of the period can push DSO up even if nobody is late. Seasonal businesses see DSO swing for the same reason. Use the same period length each time, use credit sales rather than total sales if you can (cash sales never create receivables, so including them makes DSO look better than it is), and look at an aged receivables list alongside it to see which invoices are actually overdue.

Glossary

Accounts receivable
Money customers owe you for invoices that have not been paid yet.
Credit sales
Sales invoiced for later payment, as opposed to paid at the time of sale.
Days beyond terms
How many days DSO runs past your standard payment terms.
Receivables turnover
Credit sales divided by receivables: how many times a period you collect your average balance.

Frequently asked questions

How do you calculate days sales outstanding?
Divide accounts receivable at the end of the period by credit sales for the period and multiply by the number of days in the period. 45,000 ÷ 120,000 × 90 = 33.75 days.
Should DSO use total sales or credit sales?
Credit sales, because cash and card sales paid at the time never become receivables. If you cannot separate them, total sales gives a rough figure that understates DSO; use the same method every time.
What is a good DSO for a small business?
One close to your payment terms. With Net 30 terms, a DSO of around 30 to 35 days means customers mostly pay on time. A DSO well above your terms means a share of customers are paying late.
Should I use 30, 90 or 365 days?
Match the days to the period of the sales figure: 30 for a month of sales, 90 for a quarter, 365 for a year. Monthly DSO reacts faster; yearly DSO is smoother.
What is the difference between DSO and receivables turnover?
They measure the same thing in different units. Turnover is credit sales ÷ receivables (how many times a year you collect your receivables); on a yearly basis DSO = 365 ÷ turnover.
How can I reduce my DSO?
Invoice immediately, show a clear due date, take deposits on big jobs, make paying easy, follow up the day an invoice becomes overdue, and charge late payment interest where your contract or the law allows.

Related topics

  • dso calculator
  • days sales outstanding calculator
  • dso formula
  • how to calculate dso
  • average collection period
  • accounts receivable days
  • receivables turnover
  • collection period calculator