About the DSO Calculator
The Days Sales Outstanding (DSO) Calculator shows how many days, on average, it takes a business to collect payment after making a credit sale, based on the accounts receivable balance and total credit sales for a chosen period. It's a standard measure finance teams use to monitor how quickly invoices are turning into actual cash, rather than just sitting on the books as a promise to pay.
How It Works
Enter accounts receivable, total credit sales for the period, and the number of days in that period, which defaults to 90 for a quarter. The calculator divides accounts receivable by credit sales and multiplies the result by the day count, producing the average collection period in days. A rising trend across periods signals collections are slowing down even if total sales look healthy.
Formula & Methodology
To calculate DSO by hand, divide accounts receivable by total credit sales for the same period, since cash sales are typically excluded because they carry no collection lag. Multiply that ratio by the number of days in the period. An $85,000 receivable balance against $620,000 in credit sales over a 90-day quarter, for example, produces a ratio of about 0.137, which scales to roughly 12.3 days once multiplied by 90.
Examples
B2B Wholesaler, Quarterly
A wholesaler with $85,000 in accounts receivable and $620,000 in credit sales over a 90-day quarter has a DSO of 12.3 days.
Slow-Paying Client Base
A professional services firm with $150,000 in receivables against $450,000 in credit sales over the same 90-day period gets a DSO of 30.0 days, more than double the wholesaler's collection period.
Advantages
- Converts a receivables balance into a plain-language number of days that's easy to compare against stated invoice terms
- Highlights whether collections are speeding up or slowing down when tracked across consecutive periods
- Combines with DIO and DPO to build the full Cash Conversion Cycle for working capital analysis
Common Mistakes
- Including cash sales in the credit sales figure, which artificially lowers DSO since cash sales carry no collection period
- Using a receivables snapshot taken right after a large customer payment came in, which understates the typical collection lag
- Comparing DSO across companies with very different payment terms, such as net 15 versus net 60, without adjusting for that context
Edge Cases to Watch For
- Credit sales of zero or less returns an error, since the ratio has no valid denominator.
- The calculator does not separate current from overdue receivables, so a large balance of long-overdue invoices raises DSO the same way a large balance of recent, healthy invoices would; it cannot distinguish collection risk from normal timing on its own.
- Mismatching the period for credit sales and the days figure, such as entering annual sales alongside a 30-day period, will skew the result, since both need to describe the same timeframe.
Common Use Cases
- Accounts receivable and collections teams monitoring how fast invoices are actually being paid
- CFOs assessing whether a growing receivables balance reflects healthy sales growth or a slowing collections process
- Analysts computing the Cash Conversion Cycle to evaluate a company's overall liquidity and cash efficiency