Days sales outstanding (DSO): formula, example and what a good DSO is
Days sales outstanding (DSO) is the average number of days it takes a business to collect payment after a sale on credit. It turns your accounts receivable into one number you can watch every month: if you sell on Net 30 and your DSO is 45, customers are on average paying two weeks late, and that money is sitting in their bank account instead of yours. Below: the DSO formula in its two common versions, a worked quarterly example with real numbers, the countback method, best possible DSO and average days delinquent, how DSO relates to accounts receivable turnover, average collection period and days payable outstanding, what counts as a good DSO, a six-month trend you can rebuild in a spreadsheet, the cash a lower DSO releases, and practical ways to bring it down — including keeping each customer's balance and due dates in Account Ledger by Ofisx.
Short answer
- DSO meaning: the average number of days between a credit sale and the cash arriving; lower means you get paid faster.
- DSO formula: accounts receivable ÷ credit sales for the period × number of days in the period.
- Example: $76,000 receivable at quarter-end, $240,000 credit sales in a 92-day quarter → 76,000 ÷ 240,000 × 92 = 29.1 days.
- Good DSO: close to your payment terms — under about 30 days if you sell on Net 30. There is no single benchmark; the trend in your own numbers matters most.
- DSO vs AR turnover: turnover = credit sales ÷ average AR; DSO = days in the period ÷ turnover. Same information, one in days and one in times.
- Use credit sales only: cash sales are collected on day zero; including them makes DSO look better than it is.
DSO formula: ending vs average accounts receivable
| Version | Formula | When to use it |
|---|---|---|
| Ending AR (most common) | AR at end of period ÷ credit sales in period × days | Monthly tracking; quick and easy to compare month to month |
| Average AR | (Opening AR + closing AR) ÷ 2 ÷ credit sales × days | Quarterly or yearly figures; smooths a lumpy month-end |
| Annual | AR ÷ annual credit sales × 365 | Comparing years or reading annual reports |
| Countback | Count back through recent months' sales until they add up to AR | Seasonal businesses where sales change a lot month to month |
Accounts receivable here means what customers owe you for goods or services already delivered and invoiced (not loans to staff or tax refunds). Credit sales are sales made on terms — invoiced now, paid later. If you cannot separate credit and cash sales, use total sales but say so, and remember the result understates the real DSO.
DSO calculation example (one quarter)
Northside Building Supply sells materials to contractors on Net 30. Its third quarter of 2026 (July 1 – September 30, 92 days):
| Item | Amount |
|---|---|
| Credit sales July | $76,000 |
| Credit sales August | $78,000 |
| Credit sales September | $86,000 |
| Credit sales Q3 total | $240,000 |
| Accounts receivable June 30 | $68,000 |
| Accounts receivable September 30 | $76,000 |
| Average accounts receivable (68,000 + 76,000) ÷ 2 | $72,000 |
| DSO, ending AR: 76,000 ÷ 240,000 × 92 | 29.1 days |
| DSO, average AR: 72,000 ÷ 240,000 × 92 | 27.6 days |
Both versions say the same thing — Northside collects in about four weeks, in line with Net 30. Pick one version and stick with it; switching between them creates fake improvements or slippages.
Countback method (for seasonal sales)
The standard formula spreads AR across the whole period's sales. When the last month was much bigger than the others, that overstates DSO. The countback method instead walks back from the most recent month:
- Start with AR at September 30: $76,000.
- September credit sales were $86,000 — more than the AR, so all of the AR fits inside September.
- DSO = 76,000 ÷ 86,000 × 30 days = 26.5 days.
- If AR had been larger than September's sales, you would take all 30 days of September, subtract September sales from AR, and continue with August's sales and days for the remainder.
Countback gives 26.5 days against 29.1 with the standard formula, because September was the quarter's busiest month. Seasonal businesses — landscaping, building supply, holiday retail — get a truer picture this way.
Best possible DSO and average days delinquent
DSO mixes two things: your payment terms and how late customers pay. Splitting it shows which one to fix.
| Measure | Formula | Northside Q3 |
|---|---|---|
| Best possible DSO (BPDSO) | Current (not yet due) AR ÷ credit sales × days | 60,000 ÷ 240,000 × 92 = 23.0 days |
| DSO | Total AR ÷ credit sales × days | 29.1 days |
| Average days delinquent (ADD) | DSO − best possible DSO | 29.1 − 23.0 = 6.1 days |
Of Northside's $76,000 receivable, $60,000 was not yet due. So 23 days come from the terms Northside offers, and about 6 days come from customers paying late. Longer terms raise BPDSO; slow payers raise ADD. An accounts receivable aging report gives you the current vs past-due split.
Six-month DSO trend (copy into Excel or Google Sheets)
One quarter is a snapshot. The useful signal is the direction month after month. Columns: month, credit sales, AR at month-end, days in month, DSO = AR ÷ sales × days (in Excel: =C2/B2*D2).
| Month 2026 | Credit sales | AR at month-end | Days | DSO |
|---|---|---|---|---|
| July | $76,000 | $58,000 | 31 | 23.7 |
| August | $78,000 | $64,000 | 31 | 25.4 |
| September | $86,000 | $76,000 | 30 | 26.5 |
| October | $80,000 | $74,000 | 31 | 28.7 |
| November | $72,000 | $71,000 | 30 | 29.6 |
| December | $70,000 | $73,500 | 31 | 32.6 |
Sales fell from October while AR stayed flat — customers were paying more slowly, and DSO crept from 23.7 to 32.6 days, past the Net 30 terms. Nothing alarming happened in any single month, which is exactly why a trend line catches it: the fix (calling the two or three customers behind the growth) is cheap if you start in October, expensive if you notice in March.
DSO vs AR turnover, average collection period, DPO and debtor days
| Metric | Formula | Northside Q3 | Reads as |
|---|---|---|---|
| Days sales outstanding (DSO) | AR ÷ credit sales × days | 27.6 days (average AR) | Days to collect |
| Accounts receivable turnover | Credit sales ÷ average AR | 240,000 ÷ 72,000 = 3.33 per quarter | Times AR is collected per period |
| DSO from turnover | Days ÷ turnover | 92 ÷ 3.33 = 27.6 days | Same as DSO |
| Average collection period | Usually the same as DSO (365 ÷ annual turnover) | — | Another name for DSO |
| Debtor days / receivable days / AR days | Same as DSO | — | UK and accounting-textbook names |
| Days payable outstanding (DPO) | Accounts payable ÷ cost of purchases × days | — | Days you take to pay suppliers |
| Cash conversion cycle | Days inventory + DSO − DPO | — | Days your cash is tied up |
If you collect from customers in 30 days but pay suppliers in 15, you are financing your customers. Watching DSO next to DPO — what you owe on your accounts payable — shows whether your payment terms on both sides fit together.
What is a good DSO?
- Compare with your terms: a DSO at or below your standard terms (30 for Net 30, 60 for Net 60) means customers pay roughly on time.
- Compare with yourself: a rising DSO over three or more months is a warning even if the number still looks fine.
- Industry numbers vary widely: businesses that sell mostly for cash have very low DSO; contractors, wholesalers and B2B services on 30–60 day terms run higher. Use published industry figures only as a rough guide.
- Higher or lower? Lower is better for cash; a DSO far below your terms can also mean terms are stricter than competitors' and may cost sales.
- Small numbers are noisy: with few customers, one large unpaid invoice moves DSO a lot — look at the aging list behind the number.
How much cash a lower DSO frees
Northside sells on average 240,000 ÷ 92 = $2,609 per day on credit. Each day of DSO is roughly that much cash waiting with customers. Cutting DSO from 29 to 24 days — five days — releases about 5 × $2,609 = $13,043 in cash, without selling anything more. That is the practical reason to track DSO: it puts a dollar figure on late payment.
Seven ways to reduce DSO
- Invoice the day you deliver. Every day between delivery and invoice is added to DSO.
- Put the due date on every invoice and sale — not just "Net 30" — and record it on the customer's account.
- Check balances weekly, oldest first, and contact customers a few days before the due date, not weeks after. See payment reminder templates.
- Send a monthly statement so customers see all open invoices together: statement of account template.
- Set credit limits and hold new orders for customers far past due: trade credit.
- Make paying easy — ACH details on the invoice, and ask for a remittance advice so payments are applied to the right invoices the same day.
- Agree a plan for old balances in writing — a partial payment schedule or a promissory note — and write off what will not come back: bad debt.
Tools to track receivables and due dates compared
| Option | Best for | DSO and aging | Due dates and follow-up | Platforms | US App Store ratings (Oct 21, 2026) |
|---|---|---|---|---|---|
| Account Ledger by Ofisx | Small businesses selling on credit that want each customer's balance on the phone | No DSO report — gives the balances and due dates you calculate it from | Due date on each credit sale; due-date alerts; balance by WhatsApp; PDF statement | iPhone (US App Store); Android on Google Play in Turkey only | New in the US store — no ratings yet |
| Intuit QuickBooks | Businesses that invoice and keep their books in QuickBooks | A/R aging reports; check current plans for DSO-style reports | Invoice due dates and reminders | iPhone, Android, web | 273,010 ratings, 4.7 |
| Zoho Books | Small businesses invoicing in Zoho | Receivable aging and summary reports | Payment reminders on invoices | iPhone, Android, web | 5,264 ratings, 4.8 |
| Wave | Very small businesses that invoice in Wave | Aged receivables report | Invoice due dates — check Wave's current reminder options | iPhone, Android, web | 6,665 ratings, 4.4 |
| Spreadsheet | Anyone who wants the number every month | =AR/Sales*Days per month, as in the trend table | Only if you keep due dates per invoice | Any | — |
The options in detail
Account Ledger by Ofisx
Account Ledger keeps a ledger for each customer and supplier — sales and purchases on credit with a due date, payments, partial payments and returns — with running balances and due-date alerts. From the customer's card you can send the balance by WhatsApp or share the ledger as a PDF statement.
It does not calculate DSO, turnover or an aging report; read total receivables and sales from the app and use the spreadsheet formula above.
Intuit QuickBooks
QuickBooks has A/R aging and customer balance reports inside full accounting.
Zoho Books
Zoho Books includes receivable reports and automated invoice reminders, depending on the plan.
Wave
Wave combines invoicing and bookkeeping for very small businesses.
Spreadsheet
The DSO formula is one cell; the hard part is keeping accurate AR and credit sales figures behind it.
DSO rules that keep the number honest
- Use credit sales, not total sales — Cash sales hide slow payers.
- Pick one formula and keep it — Ending AR or average AR — not both.
- Track it monthly — The trend matters more than one number.
- Compare with your terms — DSO above your terms means late payers.
- Split terms from lateness — Best possible DSO vs average days delinquent.
- Look behind the number — A few large past-due customers usually explain most of it.
Limits — what Account Ledger does not do
- Account Ledger does not calculate DSO, AR turnover or an aging report, create invoices, take card or ACH payments, or post journal entries.
- It does not send automatic email reminder sequences; you send the balance by WhatsApp or as a PDF from the customer's card.
- In the US the app is on the App Store for iPhone; the Android version is on Google Play in Turkey only for now.
- It is a paid subscription after the free trial; the App Store shows current plans and prices.
Frequently asked questions
What is days sales outstanding (DSO)?
Days sales outstanding is the average number of days a business takes to collect payment after a credit sale. It is calculated as accounts receivable divided by credit sales for a period, multiplied by the number of days in that period.
How do you calculate DSO?
Divide accounts receivable by credit sales for the period and multiply by the days in the period. For example, $76,000 of receivables and $240,000 of credit sales in a 92-day quarter give 76,000 ÷ 240,000 × 92 = 29.1 days.
What is a good DSO?
A DSO close to or below your payment terms is generally good — for example under about 30 days when you sell on Net 30. There is no universal benchmark; compare with your own terms and your own trend over several months.
Is a higher or lower DSO better?
Lower is better for cash flow because customers pay sooner. A rising DSO means customers are paying more slowly or terms have become longer.
What is the difference between DSO and accounts receivable turnover?
AR turnover is credit sales divided by average accounts receivable and shows how many times receivables are collected in a period. DSO expresses the same thing in days: days in the period divided by turnover.
Is DSO the same as average collection period?
Yes, in most textbooks and reports average collection period, debtor days, receivable days and AR days are other names for DSO, calculated the same way.
Should I use total sales or credit sales for DSO?
Use credit sales. Cash sales are collected immediately, so including them lowers DSO and hides slow-paying customers. If you can only use total sales, note it and compare like with like.
What is the best app to track customer balances and due dates?
Accounting suites such as QuickBooks, Zoho Books and Wave include receivable aging reports. If you mainly need each customer's running balance, due dates and alerts on your phone, Account Ledger by Ofisx keeps customer and supplier ledgers with payments, due-date alerts and PDF statements on iPhone, with a free trial and then a subscription; it does not calculate DSO itself.