Calculate accounts receivable turnover ratio and days sales outstanding (DSO). Analyze collection efficiency, bad debt rate, and cash flow impact with industry benchmarks.
The Accounts Receivable Turnover ratio measures how efficiently a company collects payment from customers who purchased on credit. A higher ratio means faster collections. If your ratio is 10, you collect receivables about 10 times per year — roughly every 36.5 days (365 ÷ 10 = 36.5 DSO). If it's only 5, you're waiting about 73 days to get paid.
Days Sales Outstanding (DSO) is the inverse expression that most CFOs prefer: it tells you the average number of days between invoicing and payment. DSO below 45 days is generally healthy for most industries, while DSO above 75 days signals collection problems that can create serious cash flow pressures.
This calculator computes both metrics and shows the concrete cash flow impact of improving collections. Reducing DSO by just 5 days frees up working capital equal to 5 days' worth of credit sales — for a $5M/year business, that's nearly $70,000 of additional cash flow. The DSO target analysis shows exactly how much AR reduction is needed to hit specific collection goals, and the industry benchmarks help you understand where you stand relative to peers.
Cash is king, and slow-paying customers drain working capital. This calculator quantifies collection efficiency and shows exactly how much cash you can free by improving DSO — critical for any business extending credit. Use it when you need to compare collection performance across periods, test how much working capital is tied up in receivables, or estimate the effect of a DSO target on cash flow. It is most useful when your sales are split between credit and cash, because the turnover ratio should be based on credit sales rather than total revenue.
Receivables Turnover = Net Credit Sales ÷ Average Accounts Receivable Average AR = (Beginning AR + Ending AR) ÷ 2 Days Sales Outstanding = 365 ÷ Receivables Turnover Bad Debt Rate = Bad Debt Expense ÷ Net Credit Sales × 100 Daily Credit Sales = Net Credit Sales ÷ 365
Result: Turnover: 14.29x — DSO: 25.6 days — Efficient collection
Average AR = ($300,000 + $400,000) ÷ 2 = $350,000. Turnover = $5,000,000 ÷ $350,000 = 14.29. DSO = 365 ÷ 14.29 = 25.5 days. Daily credit sales = $13,699. Reducing DSO by 5 days frees $68,493 in cash.
Receivables turnover is a collection-speed metric, not a profit metric. A higher ratio means invoices are turning into cash faster relative to the average receivable balance. DSO is the same relationship expressed in days, which makes it easier to compare against credit terms such as Net 30 or Net 60.
Use net credit sales when you can separate them from cash sales, card sales, or prepaid revenue. Average accounts receivable should reflect the same period as the sales figure so the ratio is not distorted by a one-time billing spike or a seasonal balance swing.
Industry benchmarks matter. A low turnover ratio can be normal for customers with long contractual payment terms, while a high ratio can still hide a small number of overdue accounts if most invoices are paid quickly and one large customer is late. Check the aging schedule alongside the ratio when payment behavior looks uneven.
Last updated:
This worksheet averages beginning and ending receivables, divides net credit sales by that average to estimate receivables turnover, and converts the ratio into days sales outstanding with `365 / turnover`. It also uses daily credit sales to estimate the cash released or tied up as DSO changes.
The result is a collections-efficiency worksheet, not a full credit-risk system. It assumes the entered sales figure reasonably isolates credit sales, and the benchmark tables on the page are reference ranges rather than official standards.
It depends on industry and payment terms. If you offer Net 30 terms, a turnover of 12+ (DSO ≤ 30) is excellent. For Net 60 terms, 6+ (DSO ≤ 60) is on target. Generally: 12+ is excellent, 8-12 is good, 4-8 needs attention, below 4 is a red flag.
Common causes: (1) Lenient credit policies attracting slow payers, (2) Inadequate collection processes, (3) Disputes or billing errors delaying payment, (4) Customer financial distress, (5) Over-extension of credit to risky customers. Seasonal businesses may also have temporary DSO spikes.
Each day of DSO ties up one day's worth of credit sales in AR. For $5M annual credit sales: daily sales = $13,699. At 60 DSO = $822K tied up. At 30 DSO = $411K tied up. The 30-day reduction frees $411K in working capital — money that can pay suppliers, invest, or reduce borrowing.
The accurate formula uses NET CREDIT SALES (exclude cash, prepaid, and credit card sales — those collect immediately). Using total revenue inflates the ratio. If you can't separate credit from cash sales, total revenue works as an approximation but will show higher turnover than reality.
An estimated reserve for invoices that will never be collected. If you have $400K in AR and expect 10% to go bad, the allowance is $40K and net AR is $360K. This appears on the balance sheet as a contra-asset. Industries with high-risk customers (healthcare, B2B services) typically have higher allowance rates.
Offer early-payment discounts, invoice immediately, automate reminders, tighten credit approval for new customers, and follow up on overdue invoices quickly. The best fix depends on whether the slowdown is caused by loose credit terms, billing delays, or weak collections discipline.