Days Sales Outstanding (DSO)
Days sales outstanding (DSO) is the average number of days a company takes to collect payment after a sale, calculated from its receivables balance and its revenue.
How is DSO calculated?
DSO = accounts receivable / revenue × number of days in the period
- Accounts receivable: trade receivables at the measurement date, or an average of the opening and closing balances.
- Revenue: credit sales for the same period. Where cash sales are material, lenders use credit sales only.
- Days in the period: 365 for a year; for a quarter, quarterly revenue and the number of days in that quarter.
What is DSO on a sample C&I deal?
Illustrative figures for Sample Fabrication, Inc. for the most recent fiscal year.
DSO = $1,600,000 / $12,000,000 × 365 = 48.7 days.
The aging behind the balance shows how that average is made up: $960,000 (60.0%) is 0 to 30 days from invoice, $384,000 (24.0%) is 31 to 60 days, $144,000 (9.0%) is 61 to 90 days and $112,000 (7.0%) is over 90 days. An average of 48.7 days can sit on top of a $112,000 tail that will not count in the borrowing base.
DSO is one leg of the cash conversion cycle. With inventory at 60.8 days and payables at 41.3 days, cash is tied up for 68.2 days, as worked through under working capital.
How do lenders use DSO?
A rising DSO is one of the earliest signs that customers are paying more slowly, that the borrower is extending terms to win sales, or that disputed invoices are building up. Each extra day of DSO ties up about $32,877 of cash at this revenue level ($12,000,000 / 365). For a revolver borrower, slower collections raise line usage while reducing eligible collateral at the same time. Lenders compare DSO across periods and against the borrower's stated payment terms rather than against a single benchmark, since normal collection periods differ widely by industry.
Illustrative policy treatment: a DSO rising past the borrower's stated payment terms prompts a request for the aging and an explanation before the next review.
Where does DSO go wrong?
- Comparing a year-end DSO with a quarter-end DSO without annualizing revenue the same way.
- Using a year-end balance for a seasonal business. A low balance after the busy season understates the true collection period.
- Including non-trade receivables, such as amounts due from owners or affiliates, in the numerator.
- Relying on the average without reading the aging. A single large slow account can hide inside an acceptable DSO.
- Mixing revenue that includes cash sales or progress billings with receivables that do not.
Where does DSO appear in the credit memo?
It appears in the working capital and activity ratios with a trend across periods, in the revolver analysis beside the aging summary, and in the annual review when collections slow.
Related terms
Accounts receivable aging, working capital, current ratio, borrowing base, ineligible receivables.
Where LenderBox does this work
On a borrowing base line, LenderBox recalculates each certificate from the agings behind it, so slowing collections show up in eligible collateral in the period they happen.