Accounts Receivable Turnover Calculator
Work out how many times a business collects its average receivables in a period, plus the equivalent days sales outstanding. Useful for cash-flow analysis, credit-policy review, and lender ratio checks.
AR turnover ratio
11.76
- Average accounts receivable
- £68,000.00
- Days sales outstanding (DSO)
- 31.03
- Interpretation
- Strong — efficient collections
AR turnover divides net credit sales by the average accounts-receivable balance across the period. The result is the number of times the business collected its receivables. Days Sales Outstanding (DSO) restates the same idea as a collection cycle in days: days-in-period ÷ turnover. A ratio of 12 means the business collected receivables twelve times — customers paid roughly every 30 days on a 365-day year. Compare against the industry benchmark; B2B services often run 6–10, retail above 15.
How to use this calculator
Enter the total net credit sales for the period — gross credit sales less returns, allowances, and trade discounts. Cash sales are excluded because they never enter receivables. If the credit-sales split is not separately disclosed, total revenue from the income statement is the conventional proxy. Enter accounts receivable from the start of the period (last year-end balance sheet) and the end of the period (current balance sheet). Leave the days-in-period field at 365 for a full year, or set it to 90 for a quarter, 30 for a month, and so on. The calculator returns the AR turnover ratio, days sales outstanding (DSO), and a directional read against typical industry ranges.
How the calculation works
Two formulas. Accounts Receivable Turnover = Net Credit Sales ÷ Average Accounts Receivable, where Average AR = (Beginning AR + Ending AR) ÷ 2. The result is dimensionless — the number of times the business collected its receivables during the period. Days Sales Outstanding (DSO) restates the same idea on a calendar basis: Days In Period ÷ AR Turnover. A turnover of 12 on a 365-day year means roughly 30 DSO — customers are paying about every month. The "right" ratio is industry-specific; retail and food service run very high because most sales are cash or card, B2B professional services typically land 6–10, construction and government contracting lower because of long invoice cycles.
Worked example
A company has $800,000 of net credit sales for the year. Beginning AR was $64,000, ending AR was $72,000. Average AR = ($64,000 + $72,000) ÷ 2 = $68,000. AR Turnover = $800,000 ÷ $68,000 ≈ 11.76. DSO = 365 ÷ 11.76 ≈ 31.0 days. The business is collecting from customers roughly every 31 days — strong collections for a credit-terms operation, comfortably inside a Net 30 policy.
Frequently asked questions
What does a high AR turnover ratio mean?
A higher ratio means the business is collecting from customers faster — receivables clear more times per period. That signals strong collections, healthy credit policy, and customers paying on or near terms. The cash-flow benefit is direct: every day shaved off DSO is a day less of working capital tied up in unpaid invoices. The trade-off is that a very high ratio can mean the credit policy is too restrictive — turning away marginal customers who would actually pay, just slower. Compare against the industry benchmark; a number is only meaningful in context.
What does a low AR turnover ratio mean?
A lower ratio means receivables are taking longer to collect — DSO is climbing. That can be a deliberate credit-policy choice (extending Net 60 or Net 90 terms to win larger deals) or a warning sign of weakening collections. The tell is the trend: a falling ratio combined with rising overdue AR aging and growing bad-debt write-offs means customers are slipping, which can lead to a cash crunch even if reported revenue looks fine. Watch DSO month-over-month, not just the headline ratio.
Should I use net credit sales or total revenue?
Use net credit sales if you have the figure — that is the conceptually correct numerator because AR only tracks unpaid credit invoices, not cash sales. Most companies do not separately disclose the credit-versus-cash sales split in published statements, so analysts use total revenue as the proxy. The proxy overstates the numerator slightly because it includes cash sales that never created a receivable, which inflates the apparent turnover. The proxy is acceptable for comparison across companies in the same industry (everyone uses the same proxy), but a company-internal analyst with access to the sales-ledger detail should always use actual net credit sales.
How is AR turnover related to days sales outstanding (DSO)?
They are the same information expressed differently. DSO = Days In Period ÷ AR Turnover, so a turnover of 12 means DSO of about 30 days, a turnover of 6 means about 61 days, a turnover of 4 means about 91 days. Investors and lenders quote both because DSO is more intuitive for cash-flow timing (you can think in terms of collection cycles) while the ratio is easier to compare across companies with different reporting calendars. The cash conversion cycle equation combines DSO with days inventory outstanding (DIO) and days payable outstanding (DPO): CCC = DIO + DSO − DPO.
What is a good AR turnover ratio by industry?
Rough benchmarks: retail and food service 20+ (most sales are card or cash, AR balances are tiny), B2B wholesale 8–12 (about 30–45 days DSO), manufacturing 6–10, B2B professional services 4–8 (Net 30–60 terms), construction 4–6 (progress billing on long contracts), government contracting 3–5 (notoriously slow agency payment cycles). Always compare against direct peers in the same industry and look at the trend over time. The Risk Management Association (RMA) Annual Statement Studies and CSIMarket publish detailed industry comps if you need a precise benchmark.
Can a small business calculate AR turnover from QuickBooks or Xero?
Yes. In QuickBooks Online, run the Profit & Loss for the period to get total sales (or filter to credit-only if you tag cash sales separately), then run the Balance Sheet at the start and end of the period to get the Accounts Receivable figures. In Xero, the same numbers live in the same standard reports. Plug all three into this calculator. For a sharper read, run the AR Aging Summary report alongside — that breaks the ending AR into current, 1–30, 31–60, 61–90, and 90+ buckets so you can see where the slippage is concentrated. Most small businesses calculate this monthly or quarterly to track collection health.