Receivables Turnover Ratio and DSO Calculator
Measure collection efficiency with credit sales, opening and closing receivables, and the reporting period. Get turnover and days-sales-outstanding estimates.
Enter net credit sales, opening and closing receivables, and period days to get average AR, turnover, and days sales outstanding.
About receivables turnover and DSO
Receivables turnover examples
Turnover is credit sales divided by average AR; DSO is period days divided by that turnover.
| Inputs | Result | What it shows |
|---|---|---|
| Credit sales $1,200,000; AR $90,000 to $110,000; 365 days | Average AR $100,000.00; turnover 12.00; DSO 30.4 | A 12× turn implies about a month to collect. |
| Credit sales $480,000; AR $50,000 to $70,000; 90 days | Turnover 8.00; DSO 11.3 | A quarterly window still uses the same identities. |
| Credit sales $2,400,000; AR $200,000 to $160,000; 365 days | Average AR $180,000.00; turnover 13.33; DSO 27.4 | Lower ending AR raises turnover and shortens DSO. |
How to calculate receivables turnover
- Enter net credit sales for the same period as the AR balances.
- Enter accounts receivable at the start and end of that period.
- Enter period length in days (365 for a year, 90 for a quarter).
- Select Calculate to view average AR, turnover, and DSO, then compare against invoice terms.
Receivables turnover FAQ
Should I use total sales or credit sales?
Use net credit sales. Cash sales never sit in receivables, so including them overstates turnover and understates DSO.
How is days sales outstanding related to turnover?
DSO = period days / receivables turnover. If turnover is 12 on a 365-day year, DSO is about 30.4 days.
Why average opening and closing receivables?
A single period-end balance can be distorted by a large invoice or a seasonal trough. The two-point average is the standard textbook denominator.
What period length should I enter?
Match the sales window. Use 365 (or 360 if your policy uses a bank year) for annual statements and 90 for a quarter so DSO stays in days.
Is a higher turnover always better?
Usually it means faster collections, but extremely high turnover can also mean overly tight credit that refuses profitable customers. Compare with terms and peers.