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.

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.

About receivables turnover and DSO

Receivables turnover shows how many times a business converts credit sales into cash during a reporting period. Days sales outstanding (DSO) restates that ratio as the average number of days invoices stay outstanding. Together they are core working-capital metrics: a higher turnover and a lower DSO usually mean tighter collections, while a falling turnover can signal slower customers, weaker credit policy, or revenue that is growing faster than cash collection. The receivables turnover calculator uses the textbook identities. Average accounts receivable = (opening AR + closing AR) / 2. Turnover = net credit sales / average AR. DSO = period days / turnover, which is equivalent to period days × average AR / net credit sales. Net credit sales means sales on account after returns and allowances, not total revenue that mixes cash sales. Using total sales inflates turnover and understates DSO. Opening and closing balances should come from the same AR gross or net definition used in the statements. Credit managers watch DSO against stated terms. If invoices say net-30 and DSO sits near 30, collections match policy. If DSO drifts to 45 while terms are unchanged, cash is trapped in AR. Lenders and analysts compare turnover with industry peers; grocery distributors turn receivables quickly, while capital-equipment makers often do not. Seasonal firms should use a period that matches the season or a 365-day year with average AR that is not just two possibly unrepresentative period-end snapshots. These ratios are diagnostic, not a cash forecast. Write-offs, factored invoices, unbilled receivables, and large one-off contracts can move the numbers without a true collections change. A falling AR balance can raise turnover even if sales quality is worse. Use the general ledger and aging report for operational decisions, and ask an accountant when the ratio feeds a covenant, audit, or credit-limit review.

Receivables turnover examples

Turnover is credit sales divided by average AR; DSO is period days divided by that turnover.

InputsResultWhat it shows
Credit sales $1,200,000; AR $90,000 to $110,000; 365 daysAverage AR $100,000.00; turnover 12.00; DSO 30.4A 12× turn implies about a month to collect.
Credit sales $480,000; AR $50,000 to $70,000; 90 daysTurnover 8.00; DSO 11.3A quarterly window still uses the same identities.
Credit sales $2,400,000; AR $200,000 to $160,000; 365 daysAverage AR $180,000.00; turnover 13.33; DSO 27.4Lower ending AR raises turnover and shortens DSO.

How to calculate receivables turnover

  1. Enter net credit sales for the same period as the AR balances.
  2. Enter accounts receivable at the start and end of that period.
  3. Enter period length in days (365 for a year, 90 for a quarter).
  4. 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.