Accounts Receivable Turnover Ratio, Explained
By Newtown Analytics · · 7 min read
For finance, fp&a & accounting managers
The accounts receivable turnover ratio measures how many times a year a company collects its average receivables balance. A higher ratio means customers pay faster and less cash sits in unpaid invoices. It is the mirror image of days sales outstanding, and it is a quick way to see whether your collections match your stated payment terms. This guide gives the formula, worked examples, ways to compare the result with your terms and the common mistakes. It supports cash flow management and relates closely to how to speed up accounts receivable collections.
The formula
Accounts receivable turnover = Net credit sales / Average accounts receivable
Average accounts receivable = (Opening receivables + Closing receivables) / 2
Use credit sales, not total sales, if you also make cash sales, since only credit sales create receivables. Use net sales (after returns and discounts). Use the same period for sales and the average balance.
The turnover ratio converts easily into days:
Days to collect = Days in period / Turnover
That is the same idea as DSO. See days sales outstanding.
A worked example
A hypothetical company has net credit sales of $3,600,000 for the year. Receivables were $380,000 at the start of the year and $420,000 at the end.
- Average receivables = ($380,000 + $420,000) / 2 = $400,000
- Turnover = $3,600,000 / $400,000 = 9.0 times
- Average days to collect = 365 / 9.0 = 40.6 days
The company collects its receivables about nine times a year, or about once every 41 days.
Working with quarterly figures
For a quarter, sales and average receivables must cover the same period. Suppose quarterly credit sales are $1,050,000 and the average receivables are $395,000.
- Quarterly turnover = $1,050,000 / $395,000 = 2.66 times
- Days to collect = 90 / 2.66 = 33.9 days
- Annualized turnover = 2.66 × 4 = 10.6 times (approximate, since seasonality may distort it)
Quarterly figures often show more movement than the annual number because they pick up trends and seasonality.
Compare the result with your terms
The ratio becomes more useful when you compare it with what it would be if every customer paid exactly on terms.
If the standard terms are net 30, perfect collection would give a turnover of 365 / 30 = 12.2 times, and average receivables of $3,600,000 × 30 / 365 = $295,890.
| Measure | Actual | If paid on terms | Gap |
|---|---|---|---|
| Turnover | 9.0 | 12.2 | 3.2 turns |
| Days to collect | 40.6 | 30.0 | 10.6 days |
| Average receivables | $400,000 | $295,890 | $104,110 |
The gap of $104,110 is cash trapped by late payment relative to terms. That sets the upper limit of what better collection could release in this example. In practice, some lateness is unavoidable, so a realistic target might be a turnover of 10.5 to 11, meaning 33 to 35 days. Reaching a turnover of 10.5 (34.8 days) would reduce average receivables to $342,857 and release about $57,143.
Check: $3,600,000 / 10.5 = $342,857; $400,000 - $342,857 = $57,143.
What the ratio tells you
| Observation | Possible interpretation | Next step |
|---|---|---|
| Turnover is high and stable | Efficient collection or tight terms | Check that credit policy is not turning away good sales |
| Turnover is falling | Customers paying more slowly, looser credit, disputes or growth in older balances | Review the aging report and the top overdue accounts |
| Turnover is low compared with terms | Large past-due balances | Strengthen collections and review credit |
| Turnover is much higher than terms imply | Many cash or prepaid sales, or an error in the calculation | Confirm credit sales and balances |
| Turnover differs sharply by customer group | Some segments are the problem | Segment the analysis |
A rising ratio may not always be good: if it results from refusing credit to customers who would have paid, you may be sacrificing profitable sales.
Segment the ratio
Company-wide numbers conceal differences. Calculate turnover by customer group, channel or region.
| Segment | Credit sales | Average receivables | Turnover | Days |
|---|---|---|---|---|
| Retail accounts | $1,800,000 | $240,000 | 7.5 | 48.7 |
| Distributors | $1,200,000 | $110,000 | 10.9 | 33.5 |
| Direct business customers | $600,000 | $50,000 | 12.0 | 30.4 |
| Total | $3,600,000 | $400,000 | 9.0 | 40.6 |
The segment view shows that retail accounts account for half of sales but 60 percent of receivables ($240,000 of $400,000), and take about 49 days to pay. That is where collection effort or terms discussions should focus. See net 30 vs. net 60 for pricing longer terms and how to read the accounts receivable aging report for finding the specific invoices behind the number.
How it connects to other ratios
| Ratio | Formula | Relationship |
|---|---|---|
| DSO | Receivables / credit sales × days | Equals days in period divided by turnover |
| Inventory turnover | COGS / average inventory | Similar logic for stock. See days inventory outstanding |
| Payables turnover | COGS / average payables | Speed of paying suppliers. See days payable outstanding |
| Working capital turnover | Sales / average working capital | Overall efficiency. See working capital turnover ratio |
| Cash conversion cycle | DIO + DSO - DPO | Combines the days. See the cash conversion cycle |
Limits of the ratio
- It is an average. A few large late payers can hide behind many prompt ones.
- Seasonality distorts it. A year-end balance after a quiet quarter will flatter the ratio; a balance after a peak will hurt it. Use monthly or quarterly averages.
- Growth can lower it temporarily. When sales jump late in the period, receivables rise before cash arrives.
- Mixed cash and credit sales. Using total sales instead of credit sales overstates turnover.
- Allowance and write-offs. Using net receivables after a large allowance can overstate collection speed. Use gross receivables for a collection metric.
- It does not explain why. Use the aging report and the dispute log.
Improving the ratio
The levers are the same as for DSO:
- Invoice quickly and accurately.
- Set clear terms and credit limits.
- Remind customers before the due date and follow up systematically.
- Resolve disputes quickly.
- Make payment easy.
- Review terms and incentives, paying attention to cost. See 2/10 net 30 explained.
Set targets by segment, track the ratio monthly and link it to a cash release estimate so the benefit is visible. In the example, each additional turn of 0.5 (from 9.0 to 9.5) reduces average receivables by about $21,053 ($400,000 less $3,600,000 / 9.5 = $378,947).
A monthly tracking table
Keep a short table that you update monthly so you see the trend, not just a single figure.
| Month | Trailing 12-month credit sales | Average receivables | Turnover | Days to collect | Target days |
|---|---|---|---|---|---|
| Jan | $3,500,000 | $385,000 | 9.1 | 40.1 | 36 |
| Jun | $3,600,000 | $400,000 | 9.0 | 40.6 | 36 |
| Dec | $3,750,000 | $430,000 | 8.7 | 41.9 | 36 |
In this illustrative table, turnover is slowing even as sales grow, so receivables are rising faster than sales. The next step is to see which segment or customer caused the change, using the aging report.
Use in forecasting
Turnover assumptions feed driver-based forecasts. If you project sales of $4,200,000 and assume turnover of 10.0, average receivables will be $420,000, and you can see how much working capital growth will need. See cash flow forecasting methods. For product companies, accurate demand forecasts and inventory plans keep growth in receivables and stock in balance, a topic covered in demand planning and inventory optimization.
Common mistakes
- Using total sales instead of credit sales.
- Mixing annual sales with a quarterly average balance.
- Using year-end balances only.
- Ignoring segments.
- Treating a rising ratio as always good.
- Using net receivables after write-offs for a collections metric.
FAQs
What is the accounts receivable turnover ratio?
It is net credit sales divided by average accounts receivable. It shows how many times a year the company collects its average receivables.
What is a good accounts receivable turnover ratio?
It depends on your terms and industry. A good result is close to the turnover implied by your terms (for net 30, about 12) and improving. Compare with your own trend and peers.
How is accounts receivable turnover related to DSO?
DSO equals the days in the period divided by turnover. A turnover of 9.0 corresponds to a DSO of about 41 days.
Is a low turnover ratio bad?
It indicates slow collection relative to sales, which ties up cash. Check the aging report and investigate causes such as disputes, weak follow-up or loose terms.
Can the ratio be too high?
Yes. A very high ratio may mean credit terms are too tight and you are losing sales, or that most sales are prepaid. Compare with your growth and competitors.
Keep reading
- Complete guide: Cash Flow Management: The Complete Guide for Growing Businesses
- How to Speed Up Accounts Receivable Collections
- Accounts Receivable Aging Report: How to Read It and Act on It
- Net 30 vs. Net 60: Choosing Customer Payment Terms
- Related topic: Demand Planning and Inventory Optimization: The Complete Guide
This article is for general information. It is not accounting, tax, legal or investment advice, and examples use illustrative numbers rather than client data. Confirm decisions that carry financial or legal consequences with a qualified professional.