Calculate Your Accounts Receivable Turnover Ratio
Your accounts receivable turnover ratio tells you how many times per period your business collects its average outstanding receivables. A higher ratio usually means you're collecting faster. But the number doesn't mean much until you compare it to your own payment terms and your industry's typical range.
We've built this calculator so you can get your ratio, convert it to days, and compare it to industry benchmarks. You won't need a spreadsheet.
Why Listen to Us
Ricky Atkins, Director of Accounting at Revela, collected aged receivables that'd been open for months after switching to Lunos. He reduced some customers' AR to zero days. Johan Strid, VP Finance at Swap, moved collections from constant manual effort to something that runs in the background. The turnover ratio and days figure this calculator produces are the same metrics Lunos tracks per customer automatically.
How to Use the Accounts Receivable Turnover Ratio Calculator
Net credit sales is your total revenue from sales made on credit, minus returns, allowances, and discounts. You'll find it on your income statement. If yours only shows gross sales, subtract returns and allowances first, then remove any cash sales. You need credit sales specifically because cash transactions don't touch your receivables balance.
Opening AR is your accounts receivable balance at the start of the period you're measuring. Pull it from your balance sheet as of that date.
Closing AR is the receivable balance at the end of the same period.
Days in period defaults to 365 for a full year. Use 90 for a quarter or 30 for a month. Shorter periods give you a fresher snapshot, but they'll swing more with seasonal billing.
The calculator averages your opening and closing AR, then divides your net credit sales by that average. It'll also convert the ratio into days and compare you to the benchmark table below.
The Accounts Receivable Turnover Formula
The accounts receivable turnover ratio equals net credit sales divided by average accounts receivable.
AR Turnover Ratio = Net Credit Sales / Average Accounts Receivable
Average accounts receivable is the opening balance plus the closing balance, divided by two.
Average AR = (Opening AR + Closing AR) / 2
This two-step process matters because your receivable balance changes throughout the year. Averaging smooths out those swings. So the ratio reflects your actual collection speed across the full period.
Receivables Turnover Worked Example
Say your company recorded $3,000,000 in net credit sales over the past year. Your accounts receivable opened at $400,000 and closed at $500,000.
First, calculate average AR.
($400,000 + $500,000) / 2 = $450,000
Then divide net credit sales by average AR.
$3,000,000 / $450,000 = 6.67
Your AR turnover ratio is 6.67. That means you've collected your average receivable balance about 6.7 times during the year.
To convert that into days, divide the period by the ratio.
365 / 6.67 = 54.7 days
So on average, it took about 55 days from invoicing to payment. If your standard terms are net 30, that's roughly 25 days past due on average. It's worth digging into which customers are pulling the number up.
Turning the Ratio Into Days (AR Turnover in Days and DSO)
For most B2B companies, a good AR turnover in days falls somewhere between 30 and 60 days, depending on payment terms.
AR Turnover in Days = Days in Period / AR Turnover Ratio
You'll get the same metric as days sales outstanding (DSO), just calculated from a different starting point. Both track how many days it takes, on average, to go from sending an invoice to receiving payment. If your AR turnover ratio is 8, that's about 46 days (365 divided by 8).
It's often easier to act on the days figure because you can hold it against your payment terms directly. A ratio of 7.3 doesn't tell you much by itself. But 50 days against net-30 terms tells you customers are paying about 20 days late on average.
What Is a Good Accounts Receivable Turnover Ratio? Benchmarks by Industry
For most B2B companies, a good accounts receivable turnover ratio falls between 6 and 12. But the number that's "good" shifts depending on what sector you're in and how you've structured your credit terms. A construction firm at 5x is performing well for its sector, while a retailer at 5x would be lagging.
The table below uses median receivables data from ReadyRatios' analysis of SEC filings (2025). We've corroborated those numbers with AR-to-sales percentages from NYU Stern's Damodaran dataset (January 2026).
One thing the table can't show you is direction. A ratio of 6 is fine if it was 5 last quarter. But if it was 8 last year, something's slipping. Track the trend across periods alongside the benchmark, and you'll catch problems while they're still small.
Why AR Turnover Looks Different for SaaS and Subscription Businesses
If you run a SaaS or subscription business, your AR turnover ratio can mislead you.
Annual upfront billing inflates the ratio. A large chunk of revenue arrives in one payment rather than spreading across 12 invoices. You'll see a high turnover that looks healthy, but it doesn't reflect how quickly customers pay individual invoices.
Deferred revenue adds another layer. Under ASC 606, you recognize revenue over the contract term, but the cash may've arrived months ago. So your recognized revenue is lower than what you've actually collected, which pushes the ratio down artificially.
Usage-based billing creates its own distortion. The invoice amount isn't known until the usage period closes, so there's a built-in delay between delivery and invoicing. That'll widen your DSO even if customers pay promptly.
For SaaS finance teams, it's worth tracking AR turnover alongside collection effectiveness index (CEI) and aging buckets. Together they'll give you a much clearer picture than the ratio alone.
What a Healthy Ratio Can Hide
A strong AR turnover ratio can mask serious problems at the account level. You might show an average of 45 days, which looks reasonable. But if two enterprise customers are sitting at 90+ days while everyone else pays in 20, the average won't reveal that.
That's why pairing the ratio with an aging report matters. It breaks your receivables into time buckets (0-30, 31-60, 61-90, 90+ days) so you can spot where the slow payments sit. You can also track average days delinquent per customer to catch problems early.
Lunos catches exactly this kind of problem. It reads each customer's replies, tracks individual payment promises, and adjusts follow-up timing per account. So if one customer says "we'll pay next Friday" and another goes silent at 75 days, each gets a different follow-up.
How to Calculate AR Turnover in Excel
If you'd rather build this in a spreadsheet, you'll only need three cells and two formulas. Put net credit sales in B1, opening AR in B2, and closing AR in B3.
For average AR in B4, enter =(B2+B3)/2
For the turnover ratio in B5, enter =B1/B4
For turnover in days in B6, enter =365/B5
If you're measuring a quarter, replace 365 with 90. For a monthly snapshot, use 30.
One tip for recurring reports. Wrap the ratio formula in an error check so it doesn't break when the AR fields are empty.
=IF(B4=0,"",B1/B4)
That'll return a blank cell instead of a divide-by-zero error.
How to Improve Your Accounts Receivable Turnover Ratio
The biggest lever is shortening the gap between invoicing and payment. The cash collection cycle starts the moment you deliver, so every improvement below targets a different stage of that cycle.
Follow up before invoices are due. A reminder at day 20 on a net-30 invoice lands while the customer still has time to act. Waiting until day 45 turns a nudge into a collections conversation.
Review your aging report weekly. AR problems compound quietly. A weekly look at your 31-60 and 61-90 buckets catches slipping accounts before they hit 90+ and become genuinely hard to collect.
Shorten credit terms where the data supports it. If a customer's been paying at 25 days on net-60 terms for six quarters straight, they can handle net-30. Tighter terms on proven fast payers compress your DSO without adding friction.
Build early-payment discounts into your largest accounts. Offering 2% off for payment within 10 days costs less than financing 50 extra days of outstanding receivables on your biggest invoices.
Close the gap between delivery and invoice. Every day you wait to invoice is a day your collection clock hasn't started. Automated invoicing on the day of delivery is the easiest structural fix.
Lunos handles the follow-up side of this at scale. It reads each customer's replies, tracks individual promises ("we'll pay next Friday"), and adjusts timing per account so your team focuses on exceptions, not chasing.
