How to calculate DSO
- 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.
- 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.
- Enter credit sales. Sales invoiced on credit during the same period. Leave out cash and card sales paid at the time of sale.
- 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.
| Step | Working | Result |
|---|---|---|
| DSO | 45,000 ÷ 120,000 × 90 | 33.75 days |
| Average daily credit sales | 120,000 ÷ 90 | 1,333.33 |
| Days beyond Net 30 terms | 33.75 − 30 | 3.75 days |
| Receivables at a 30-day DSO | 1,333.33 × 30 | 40,000 |
| Cash released by reaching 30 days | 45,000 − 40,000 | 5,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 terms | What it usually means |
|---|---|
| Below terms | Deposits, early payment discounts or card payments are pulling it down |
| Within about 10% of terms | Most customers pay on time |
| 10–50% above terms | A group of slow payers; check the oldest invoices |
| More than 50% above terms | Collections 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?
Should DSO use total sales or credit sales?
What is a good DSO for a small business?
Should I use 30, 90 or 365 days?
What is the difference between DSO and receivables turnover?
How can I reduce my DSO?
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