Skip to content
Menu
Finabase Learn

Fundamentals · Ratios

Days sales outstanding (DSO): how long customers take to pay

How to calculate DSO from receivables and revenue, why Cisco waits 43 days and Walmart 6, and what receivables growing faster than revenue can signal.

On this page
  1. The idea
  2. The formula
  3. Seven companies: who pays at the till
  4. Receivables growing faster than revenue
  5. Where it misleads
  6. Compared with its neighbours
  7. Where to find it in Finabase
  8. Frequently asked questions
  9. Summary
  10. Check your understanding

Days sales outstanding (DSO) is the number of days of revenue a company has billed and not yet collected. It is the receivables on the balance sheet divided by revenue, multiplied by 365.

A sale on credit is recorded as revenue on the day the goods ship or the service is delivered. The cash arrives later, and until it does the amount sits in accounts receivable. DSO measures that wait. It matters for two reasons. Money owed by customers is money the company cannot spend, so a longer wait means more cash tied up. And a wait that grows without explanation is one of the oldest warning signs in accounts: it can mean customers are struggling to pay, or that the company is booking sales on easier terms to make its numbers.

This page computes Cisco's DSO from its latest annual report, compares it with six other companies, and sets out what makes the figure move. The overview of how DSO fits with inventory and payables is in Working capital and the cash conversion cycle, with Apple’s numbers.

The idea

A wholesaler sells $365,000 of goods a year, an even $1,000 a day, and gives every customer 30 days to pay. On any given day the last 30 days of sales are still unpaid, so its receivables stand at about $30,000. Divide that by the daily sales of $1,000 and you get 30 days back.

DSO runs this sum in reverse. You cannot see a company's payment terms or its ledger of invoices from outside. You can see the total it is owed and its revenue for the year. Dividing one by the other tells you roughly how many days of sales are waiting to be paid, and so how long the average customer takes.

If the wholesaler's customers begin paying in 45 days, receivables climb to $45,000 with no change in sales. Profit is untouched. But $15,000 that used to be in the bank is now in customers' hands, and the wholesaler has to find that money somewhere else.

The formula

The simplest version uses the receivables balance at the end of the year. A second version uses the average of the opening and closing balances. The year-end version answers "how many days of sales are outstanding today". The average version is steadier and less affected by one unusual closing date. Strictly, only credit sales belong in the denominator, but companies do not report credit sales separately, so total revenue is used.

Receivables turnover is the same information the other way up: how many times a year the receivables balance is collected and replaced.

Cisco FY2026: 43 days of sales waiting to be collected ($ billions) Revenue for the year $63.3B Accounts receivable, year end $7.5B Revenue per day × 30 $5.2B (one month of sales) Receivables ÷ revenue × 365 = 43 days; the year before, 43 days. Source: Cisco Form 10-K for 2026-07-25.
Cisco, fiscal year ended July 25, 2026: year-end accounts receivable against revenue. Receivables ÷ revenue × 365 = 43 days, the same as a year earlier. Source: Cisco’s Form 10-K (SEC EDGAR).

Each day of DSO is worth one day of revenue. For Cisco that is about $173 million. If its customers took five days longer to pay, roughly $865 million more would sit in receivables instead of in its bank account. That is the practical meaning of the figure, and it is why finance departments track it weekly.

Seven companies: who pays at the till

Each row uses the latest Form 10-K and the year-end receivables balance. Fiscal 2026 ended on January 31, 2026 for Walmart, August 30, 2026 for Costco, May 31, 2026 for Nike, June 30, 2026 for Microsoft and July 25, 2026 for Cisco. Coca-Cola and Caterpillar report on the calendar year, here 2025.

Company DSO (days) Prior year Receivables change Revenue change
Costco 5 4 +23.6% +10.1%
Walmart 6 5 +12.0% +4.7%
Coca-Cola 23 28 −14.9% +1.9%
Cisco 43 43 +11.5% +11.8%
Nike 47 37 +25.7% +0.2%
Caterpillar 59 52 +17.6% +4.3%
Microsoft 89 91 +15.7% +17.8%
Days sales outstanding by kind of business, latest fiscal year Walmart FY2026 6 days Costco FY2026 5 days Nike FY2026 47 days Coca-Cola FY2025 23 days Microsoft FY2026 89 days Cisco FY2026 43 days Caterpillar FY2025 59 days Year-end accounts receivable ÷ revenue × 365. Shoppers pay at the till; businesses pay on invoice terms.
Days sales outstanding on year-end receivables, latest fiscal year (fiscal 2026 for Walmart, Costco, Nike, Microsoft and Cisco; 2025 for Coca-Cola and Caterpillar). Sources: each company’s Form 10-K (SEC EDGAR).

The level of DSO is set mainly by who the customer is.

  • Costco and Walmart sell to shoppers who pay by card or cash before they leave. A retailer's receivables are typically amounts due from card processors, insurers and suppliers, not from shoppers, and they are small next to revenue. Costco's receivables grew 23.6%, more than twice as fast as revenue, yet its DSO moved only from 4 days to 5. Growth rates mean little when the balance is this small.
  • Coca-Cola sells to bottlers, distributors and retailers that buy continuously and pay on short terms: 23 days, down from 28.
  • Cisco, Nike and Caterpillar sell to other businesses on invoice. Terms of 30 to 60 days are ordinary in business-to-business trade, and the three sit between 43 and 59 days.
  • Microsoft has the longest wait at 89 days. Its DSO on average receivables is 83 days, six days lower. A year-end balance well above the average is what you see when a business is growing quickly or bills more heavily late in its year. Either way the closing balance overstates the typical wait.

Comparing Walmart's 6 days with Microsoft's 89 says nothing about which collects better. The comparison that carries information is each company against its own earlier years and against competitors that sell the same things to the same kind of customer.

Receivables growing faster than revenue

DSO rises when receivables grow faster than revenue. Nike is the clearest case in the table: receivables up 25.7% in a year when revenue rose 0.2%, and DSO up from 37 days to 47. Caterpillar's receivables rose 17.6% against revenue growth of 4.3%, and its DSO went from 52 days to 59.

The numbers alone do not say why. The possible causes range from harmless to serious:

  • Timing. More of the year's shipments fell in the final weeks than the year before, so more invoices were still open on the balance sheet date.
  • Mix. A larger share of sales went to customers with longer terms, such as wholesale partners or buyers abroad.
  • Easier terms. The company gave customers longer to pay in order to win orders. Revenue is recorded now, and the sale was worth less than it looks.
  • Pulling sales forward. Shipping more than customers need before the period closes, often with generous terms, lifts this year's revenue at the expense of the next.
  • Customers in difficulty. Buyers are paying late because they are short of cash, and some invoices may never be collected.

The last three are why DSO sits on every checklist for quality of earnings. Revenue that outruns cash collection for several periods deserves a close reading of the company's revenue recognition note. One year of higher DSO is a question, and the answer is usually in the filing.

The allowance for credit losses

Receivables are reported net of an allowance for credit losses, which is management's estimate of the invoices that will not be paid. Under US GAAP the estimate covers losses expected over the life of the receivable, and the company sets it. Cisco's allowance was $78 million against net receivables of $7,470 million, about 1% of the gross amount. Microsoft's was $1,040 million against $80,876 million, a little over 1%.

Read the allowance beside DSO. If customers are taking longer to pay and the allowance is shrinking as a share of receivables, management is assuming better collection at a time when the evidence points the other way. A smaller allowance also raises reported profit, because additions to it are an expense.

Where it misleads

  • The balance sheet is one day. DSO compares a year of revenue with receivables on a single date. A seasonal business that sells most in its final quarter shows a high year-end DSO even if every customer pays on time. Dividing year-end receivables by the last quarter's revenue, times about 91, gives a fairer reading for such companies.
  • Quarter-end timing can be managed. A company can press customers to pay a few days early before the period closes, or hold back invoices until just after it. Both lower DSO on the reporting date and reverse in the following weeks.
  • Factoring removes receivables. A company can sell its receivables to a bank for cash, an arrangement called factoring, or package them into securities. Sold receivables leave the balance sheet, so DSO falls even though customers pay no faster. The notes disclose such programs. A drop in DSO that coincides with a new or larger program is financing, not better collection.
  • Billing in advance inflates it. A company that invoices a year of service up front records a receivable for the whole amount while recognizing the revenue month by month. Its DSO looks long, and the receivable is matched by deferred revenue on the other side of the balance sheet.
  • Not every receivable is in the line. Loans and leases that a company extends to finance its customers' purchases are often reported on separate lines. Other amounts, such as tax refunds due, may be mixed into a broader receivables figure. Check which line you are using.
  • Acquisitions distort one year. A business bought late in the year adds all of its receivables and only a few weeks of its revenue.

Compared with its neighbours

Measure Formula What it tells you
Days sales outstanding Receivables ÷ revenue × 365 How long customers take to pay
Receivables turnover Revenue ÷ average receivables How many times a year receivables cycle
Days of inventory Inventory ÷ cost of sales × 365 How long stock waits to be sold
Days payable outstanding Payables ÷ cost of sales × 365 How long the company takes to pay
Cash conversion cycle DSO + days of inventory − DPO Days cash is tied up in operations

Cisco's fiscal 2026 figures for the first two rows are 43 days and 8.9 times. The other rows have their own pages: Inventory turnover: how fast stock sells, and days of inventory, Days payable outstanding (DPO): how long a company takes to pay and Cash conversion cycle: days of cash tied up, and when it is negative.

Where to find it in Finabase

Finabase does not show DSO. It gives you the two rows to compute it.

Open Cisco's balance sheet and read the row Trade and Non-Trade Receivables. As its name says, this row can include receivables that did not come from sales, so it may be larger than the accounts receivable line in the company's own 10-K, and a DSO built on it can come out higher than the figures on this page. Then open the income statement and read Total Revenue for the same fiscal year. Divide receivables by revenue and multiply by 365. For a seasonal business, repeat the sum on quarter-end balances, which the company's quarterly reports give.

On the Valuation tab, the Financial position card shows the balance sheet as shares of total assets, with Receivables as one slice. It tells you at a glance whether collection is a large part of the company's finances or a small one.

Frequently asked questions

What is a good DSO?

A good DSO is one that is stable and close to the payment terms the company offers, because the normal level depends on the customer. Retailers run under 10 days, and sellers to other businesses commonly run from 40 to 60 days or more. A DSO far above the stated terms means customers are paying late.

Is a lower DSO always better?

Usually, because cash arrives sooner. It is not better when it comes from selling receivables to a bank, from pressing customers at quarter end in a way that reverses the next month, or from credit terms so strict that the company loses orders.

What does it mean when DSO increases?

It means receivables grew faster than revenue. The cause can be timing, a change in customer mix, longer credit terms, sales pulled forward from the next period or customers who cannot pay. The first two are harmless and the last three reduce the quality of the reported revenue.

What is the difference between DSO and receivables turnover?

They are the same measure in two forms. Receivables turnover is revenue divided by receivables, and DSO is 365 divided by that turnover. A turnover of 8.9 on average receivables is a DSO of 41 days.

Why do retailers have almost no DSO?

Retailers have almost none because shoppers pay at the moment of sale. The card company settles within days, so the retailer never carries a balance owed by its customers of the kind a manufacturer or software company does.

Summary

Days sales outstanding divides receivables by revenue and multiplies by 365 to give the average wait between a sale and its cash. Cisco's was 43 days in the fiscal year ended July 25, 2026, the same as the year before, against 6 days at Walmart and 89 at Microsoft. The level reflects who the customers are, so the signal is in the change: receivables growing faster than revenue, as at Nike and Caterpillar in their latest years, call for an explanation from the filing. Before drawing a conclusion, check the balance sheet date, whether receivables were sold, how the company bills, and whether the allowance for credit losses moved in step.

Check your understanding

5 questions on this lesson. Each answer comes with the reason, and nothing is scored.

  1. A company had revenue of $730 for the year and accounts receivable of $100 at year end. What is its DSO?

    1. 50 days
    2. 7.3 days
    3. 100 days
    Show the answer

    A. 50 days Revenue per day is 730 ÷ 365 = 2, and 100 ÷ 2 = 50 days. The same sum in one line: 100 ÷ 730 × 365 = 50.

  2. Revenue grew 3% and receivables grew 25% in the same year. What happened to DSO, and what should a reader do?

    1. DSO fell; nothing needs checking
    2. DSO was unchanged, because both grew
    3. DSO rose; the reader should look in the filing for timing, longer credit terms or customers paying late
    Show the answer

    C. DSO rose; the reader should look in the filing for timing, longer credit terms or customers paying late Receivables growing faster than revenue raise DSO. The cause may be harmless timing or mix, or it may be easier terms, sales pulled forward or late payers, and only the filing can tell them apart.

  3. A company’s DSO drops from 60 days to 45 in the year it starts selling receivables to a bank. What is the best reading?

    1. Customers are paying 15 days sooner
    2. The drop is at least partly financing: sold receivables leave the balance sheet whether or not customers pay faster
    3. Revenue must have fallen
    Show the answer

    B. The drop is at least partly financing: sold receivables leave the balance sheet whether or not customers pay faster Factoring turns receivables into cash and removes them from the balance sheet. DSO falls without any change in customer behaviour, so the notes on such programs have to be read with the ratio.

  4. Why does comparing Walmart’s DSO of 6 days with Microsoft’s 89 days say little about which company collects better?

    1. Because shoppers pay a retailer at the till while business customers are invoiced on terms, so the levels reflect the customer, not the collection effort
    2. Because DSO cannot be calculated for retailers
    3. Because Microsoft’s fiscal year is longer
    Show the answer

    A. Because shoppers pay a retailer at the till while business customers are invoiced on terms, so the levels reflect the customer, not the collection effort DSO depends first on how customers pay. The useful comparisons are a company against its own past and against competitors with the same kind of customer.

  5. Customers are taking longer to pay, and the allowance for credit losses has fallen as a share of receivables. What does that combination suggest?

    1. Collection has certainly improved
    2. The allowance has no effect on profit
    3. Management is assuming fewer losses while payment is getting slower, which also lifts reported profit
    Show the answer

    C. Management is assuming fewer losses while payment is getting slower, which also lifts reported profit The allowance is management’s estimate of invoices that will not be paid, and additions to it are an expense. Lowering it while DSO rises supports profit at the moment the evidence points to more risk.

Sources and further reading

  1. Cisco Systems, Inc. — Form 10-K for the fiscal year ended July 25, 2026, filed September 2, 2026 (SEC EDGAR)
  2. Walmart Inc. — Form 10-K for the fiscal year ended January 31, 2026, filed March 13, 2026 (SEC EDGAR)
  3. Costco Wholesale Corporation — Form 10-K for the fiscal year ended August 30, 2026, filed October 7, 2026 (SEC EDGAR)
  4. NIKE, Inc. — Form 10-K for the fiscal year ended May 31, 2026, filed July 15, 2026 (SEC EDGAR)
  5. The Coca-Cola Company — Form 10-K for the fiscal year ended December 31, 2025, filed February 20, 2026 (SEC EDGAR)
  6. Microsoft Corporation — Form 10-K for the fiscal year ended June 30, 2026, filed July 29, 2026 (SEC EDGAR)
  7. Caterpillar Inc. — Form 10-K for the fiscal year ended December 31, 2025, filed February 13, 2026 (SEC EDGAR)
  8. SEC EDGAR — XBRL company facts (revenue, accounts receivable, allowance for credit losses) for Cisco, Walmart, Costco, Nike, Coca-Cola, Microsoft and Caterpillar, read November 18, 2026