Days Sales Outstanding (DSO) Calculator

Background.

Days sales outstanding measures how long it takes to turn a credit sale into cash. Divide the receivables balance by credit sales for the period and multiply by the number of days in that period. If you have seen the same idea called the average collection period or days' sales in receivables, those are the same measure under different names, and this page covers all three — there is no separate formula behind any of them.

The American Institute of CPAs describes it in the Journal of Accountancy as "the number of days a company takes to collect on sales", and it is the receivables leg of the cash conversion cycle. What it is genuinely good for is turning a collections conversation into a cash number. Because DSO is receivables expressed in days of sales, one day off your DSO releases exactly one day of sales in cash — no modelling required. That is why the calculator asks for a target and tells you what hitting it is worth.

Two choices change the answer and both are yours to make here. The first is the receivables basis. The textbook uses the average of the opening and closing balances; credit teams usually use the closing balance because that is the book in front of them. On US manufacturing's 2026 first quarter the two give 48.63 days and 47.02 days from the same accounts — a 1.6-day gap, which is more than enough to cross a whole-day target. The second is the denominator, and this one is a genuine trap: the correct figure is net credit sales, not total revenue. Cash sales never enter receivables, so including them inflates the denominator and makes collection look faster than it is. Published financial statements only disclose total revenue, so anyone computing DSO from a filing for a business with a retail arm is quietly understating it.

There is no universal target DSO. On Aswath Damodaran's January 2026 dataset covering 5,994 US-listed companies, receivables as a share of sales translate into collection periods ranging from 6.4 days for listed grocery and 12.8 days for general retail up to 57.9 days for semiconductors, 61.5 for enterprise software and 69.5 for machinery. The whole-market figure excluding financial companies is 45.2 days. Those differences are about who the customers are and what the standard terms of the trade are, not about how well anyone chases invoices. Compare yourself against your own history, your stated terms and your closest competitors.

Finally, remember that DSO is an average and averages hide tails. A book of uniformly 45-day payers and a book of 30-day payers with one large 180-day dispute can produce the same DSO. The number tells you the size of the problem; only an ageing report tells you where it is.

What is days sales outstanding (dso) calculator?

Days sales outstanding is the average number of days between making a credit sale and collecting the cash. It is computed as the receivables balance divided by net credit sales for a period, multiplied by the number of days in that period — so it converts a balance-sheet amount into a length of time expressed in days of trading. The receivables figure should be net of the allowance for doubtful accounts; Regulation S-X, 17 CFR 210.5-02, sets receivables at caption 3 and requires the allowance to be shown separately at caption 4. DSO is the reciprocal of receivables turnover through the year: 365 divided by DSO gives the number of times the book turns over annually, and 365 divided by turnover gives DSO back. It is also the middle term of the cash conversion cycle, sitting between days inventory outstanding and days payables outstanding. Like the quick ratio and the cash conversion cycle, DSO is an analytical measure rather than an accounting one: no standard-setter defines it, which is why the ending-versus-average and credit-sales-versus-revenue conventions vary between sources and must always be stated alongside the figure.

How to use this calculator.

1. 01Pick the basis. Use Ending if you are managing the book day to day and want to know where it stands now; use Average if you are comparing periods or reproducing a textbook or analyst figure.
2. 02Enter receivables net of the allowance for doubtful accounts, not the gross balance.
3. 03Enter credit sales for the same period — not total revenue. If some of your sales are collected at the point of sale, subtract them first.
4. 04Set the days in period to the actual calendar length of that sales figure: 90 or 91 for a quarter, 30 or 31 for a month, 365 for a year.
5. 05Set the target DSO to your standard payment terms plus a realistic allowance, or to whatever your board has asked for.
6. 06Read the cash-released figure. That is the working-capital prize from hitting the target, and it is the number that gets a collections project funded.
7. 07Recalculate for the last four to six periods on the same basis. The trend is far more informative than the level, because the level is mostly determined by your industry's payment terms.
8. 08Pull an ageing report before acting. DSO tells you how big the problem is; only the ageing tells you whether it is everyone or one large disputed invoice.

The formula.

The formula divides a stock by a flow and scales the result to days. Receivables divided by credit sales gives the fraction of a period's sales still uncollected; multiplying by the days in the period turns that fraction into a number of days. The units work out cleanly: dollars divided by dollars per period, times days per period, gives days.

The basis select changes which receivables figure sits in the numerator. On the ending basis it is the closing balance. On the average basis it is the mean of opening and closing. Which is higher depends on which way receivables moved. On the worked example receivables grew from $1,033,390M to $1,106,744M during the quarter, so the ending balance is above the average and the ending basis reports the longer period — 48.63 days against 47.02. Had receivables shrunk, the relationship would be the other way round. There is no rule that one basis is always higher, and any source that tells you otherwise has only tested it in one direction.

Rounding happens once, at the end. This matters most for the implied receivables turnover, which is 365 divided by the unrounded DSO. Deriving it from a DSO already rounded to whole days would give 365 ÷ 49 = 7.4490 instead of 365 ÷ 48.6303 = 7.5056 — an error of about 0.75 percent introduced purely by the order of operations. The same applies to the cash-released figure, which multiplies the unrounded gap between DSO and target by credit sales per day.

The cash-released figure is deliberately not floored at zero. If your target is looser than current performance the result is negative, and that is correct information: relaxing collection by five days on $22,758 of credit sales per day consumes about $113,792 of cash. Presenting only the good direction would make the output useless for planning a deliberate terms extension.

Finally, a guard worth knowing about. If the receivables basis works out to zero the DSO is zero and the implied turnover is infinite. Rather than display an infinity, the calculator stops and says that a business with nothing outstanding has no collection period to measure.

A worked example.

Frequently asked questions.

References& sources.

1. [1]U.S. Census Bureau. Quarterly Financial Report for Manufacturing, Mining, Wholesale Trade, and Selected Service Industries, 2026 Quarter 1. Table 1.1 trade accounts and trade notes receivable ($1,106,744M at 1Q 2026, $1,033,390M at 4Q 2025); Table 1.0 net sales, receipts and operating revenues ($2,048,251M). Retrieved 2026-07-29.
2. [2]Damodaran, A. "Working Capital Ratios by Sector (US)." NYU Stern School of Business, data as of January 2026, 5,994 firms. Accounts receivable as a percent of sales by sector: Total Market excluding financials 12.39%, Machinery 19.03%, Software (System & Application) 16.84%, Semiconductor 15.88%, Apparel 12.53%, Retail (General) 3.50%, Retail (Grocery and Food) 1.75%. Retrieved 2026-07-29.
3. [3]Cagle, C.S., Campbell, S.N. and Jones, K.T. (2013). "Analyzing liquidity using the cash conversion cycle." Journal of Accountancy, American Institute of CPAs, 1 May 2013. Days receivables outstanding "measures the number of days a company takes to collect on sales". Retrieved 2026-07-29.
4. [4]U.S. Government Publishing Office. 17 CFR 210.5-02, Regulation S-X — Balance Sheets. Caption 3 accounts and notes receivable, caption 4 allowances for doubtful accounts "to be set forth separately in the balance sheet or in a note thereto". Retrieved 2026-07-29.
5. [5]Financial Accounting Standards Board. FASB Accounting Standards Codification, Topic 210 Balance Sheet, paragraph 210-10-45-1 — classification of receivables as current assets. Free registration required at asc.fasb.org.