Imagine your team just closed the biggest deal of the year. The sales team is thrilled, and your top-line revenue looks phenomenal. But a few weeks later, you're scraping together cash to cover operating expenses. The client negotiated ninety-day payment terms, meaning that new revenue isn't actually sitting in your bank account yet.
If your revenue grows but your cash continuously feels tight, check your accounts receivable turnover. This metric shows how efficiently your team collects cash from credit sales. When turnover slips, cash gets trapped in pending invoices. Your working capital shrinks, and your runway shortens. Your business health feels off, even when your profits look fine on paper.
This guide gives finance teams what they need to improve collection efficiency. We cover what accounts receivable turnover means and how to calculate it, including critical formula variants. You will discover what inputs matter most and see how your turnover rate links directly to your cash flow and runway. Finally, we show you how to track and model it all in Runway.
Defining accounts receivable turnover
Accounts receivable turnover is an efficiency ratio. It tells you how many times you collect your average AR balance during a period. A higher number means you’re collecting faster. A lower number means cash sits in unpaid invoices longer than it should.
Use this formula:
AR turnover ratio = net credit sales ÷ average accounts receivable
Net credit sales leaves out cash sales, returns, allowances, and discounts. Average accounts receivable is usually the mean of your starting and ending AR balances for the period.
You can also translate AR turnover into days using days sales outstanding (DSO):
DSO = 365 ÷ AR turnover ratio
DSO shows the average number of days it takes to collect payment after a sale on credit. Both metrics tell the same story. Choose whichever is easier to share with your team or stakeholders.
Why it matters for your business
Slow collections aren’t just an accounting hassle. Slow collections create real cash headaches. When DSO rises, your working capital tightens and your runway shortens. That’s a direct, mechanical relationship. You feel it right away.
Here's how the math plays out:
- Cut one day off DSO, and you add one day’s worth of credit sales to working capital.
- If your credit sales average $10,000 daily, and your DSO drops by 10 days, you've freed up $100,000 in cash without changing anything about revenue.
AR turnover also tells you if your credit policy’s working. If you offer net-30 terms but collect in 55 days, something needs fixing. There could be gaps in your collections process, your customer mix, or billing. AR turnover surfaces these issues quickly. Revenue lines won’t.
Finance teams use AR turnover to check billing operations, improve burn rate forecasting, and show investors real collection health during due diligence. Smart investors look at AR turnover first when they assess working capital quality.
Core methodologies for calculating and tracking AR turnover
No single method suits every company. Your calculation depends on your model, billing patterns, and which question you want to answer. Here are five approaches that cover the basics:
Standard ratio approach
This method is simple and direct. Divide net credit sales by average AR for the period:
AR turnover = net credit sales ÷ average AR
You get one efficiency number. It’s easy to calculate, to trend, to compare. But it smooths over detail. If you need sharper insight, try a method below.
DSO conversion
This turns your turnover ratio into days, which is easier to act on:
DSO = (average AR ÷ net credit sales) × number of days in period
Most finance teams report DSO day-to-day. “We collect in 38 days on average” is clear and actionable. You can easily benchmark against your stated payment terms. Runway’s DSO glossary covers monthly, trailing period, and average AR methods.
Weighted-average DSO method
Weighted average DSO digs deeper by calculating collection days at the invoice level and weighting by amount:
Weighted DSO = sum of (invoice amount × days outstanding) ÷ total receivables
This method cuts distortion from big invoices. For example, one $500,000 invoice at 5 days old plus fifty $10,000 invoices at 60 days old will skew a simple average. Weighted DSO reveals where your cash is actually tied up.
Aging schedule and time bucket segmentation
Aging schedules split your outstanding receivables into buckets: current, 1-30 days past due, 31-60, 61-90, 90+ days. This shows the distribution and health of your AR portfolio.
Instead of one big total, you put them in time buckets, usually in 30-day chunks. For each bucket, you see:
- Dollar amounts
- Percentage of total AR
More than 10-15% of AR in the 90+ day bucket is a red flag. Focus your collections team there.
Countback (exhaustion) method
This method works backward from your ending AR balance through recent months of revenue until the balance hits zero. Do it like this:
- Start with your current AR balance.
- Subtract the current month’s credit sales. If AR exceeds sales, add the full month’s days to DSO.
- Keep going with prior months until AR is less than that month’s sales.
- For the last month, prorate:
(remaining AR ÷ month’s sales) × days in month.
Countback gives an accurate DSO for seasonal or uneven sales, reflecting real invoice aging rather than basic averages. It’s more work but paints a clearer picture.
Key components and considerations
Use net credit sales, not total revenue
This error is common. Cash sales don’t create receivables, so including them inflates your turnover. Use only credit sales. Subtract returns, allowances, and discounts. Cash sales already put money in the bank and drag DSO down artificially.
Calculate average AR carefully
Relying only on beginning and ending balances for long periods misses fluctuations. Monthly averages show the real swings. Make sure sales and AR periods align. If calculating October’s DSO, match October 31 AR and October credit sales.
Segment by customer cohort and payment terms
A blended AR turnover hides problems. If enterprise customers use net-60 but SMBs use net-30, mixing them clouds both groups. Segment turnover by customer type, contract size, billing terms, and region. You’ll see exactly where collections slow down.
Adjust for seasonality and billing cycles
Annual up-front billing looks very different from monthly in arrears. Don’t judge AR turnover on a single month. Use trailing averages, three or twelve months, to manage seasonality and large swings.
Account for credit terms, doubtful accounts, and unbilled revenue
Base your AR turnover on your actual payment terms. A net-60 operation naturally has lower turnover than net-30. The key question: How far beyond your stated terms do you collect?
Handle doubtful accounts carefully. Write-offs shrink your AR denominator, making turnover look better even though nothing changed in real collections. Include unbilled or accrued revenue, exposure there matters for collections, even when it sits outside the ledger.
Broad financial implications
AR turnover doesn’t exist alone. It drives almost every other planning metric your team tracks.
- Cash flow forecasting: Predictable collections make cash flow forecasts reliable. When DSO creeps up, so do your deviations.
- Working capital management: AR is often your largest current asset. Faster conversion means more cash available for growth. Runway’s average collection period guide shows that cutting your collection period by 20% can boost your working capital by 15%.
- Cash conversion cycle: DSO is one piece of the cash conversion cycle (
CCC = DIO + DSO - DPO). Improving AR turnover shortens your CCC, boosting liquidity without outside capital. - Burn rate and runway: For teams modeling burn, slow collections can mask how close you are to a crunch or make burn look worse than it is. Pair AR turnover with burn for a true picture of your runway.
- Audit readiness and investor due diligence: Investors check your AR-to-revenue ratio as a proxy for collection health. See also the billings-to-collections ratio. Best-in-class teams keep less than a 5% gap between billings and collections. If AR grows much faster than revenue, you’ll need clear answers.
- Credit policy effectiveness: Declining turnover may point to looser credit terms, slower payers, or gaps in your process. The metric gives you the alert. Segmentation tells you where to dig in.
Benchmarks and rules of thumb
Benchmarks depend on context. A "low" ratio for SaaS might be "normal" in manufacturing. Use these as reference points:
- B2B SaaS companies with net-30 terms usually show AR turnover ratios between 8 and 12 annually. That translates to about 30 to 45 DSO.
- Companies dealing with $15K to $50K ACV fit right into that range. If you serve larger enterprises on net-45 or net-60 terms, expect turnover ratios between 6 and 8. That aligns perfectly with those longer payment terms.
- Look at your aging schedules. Tech teams keep 60% to 70% of accounts receivable current within the 0 to 30 day window. Seeing more than 10% to 15% of your AR in the 90 day bucket points to a persistent collection issue you need to fix.
- Investors want to see AR sit below half of your trailing three month revenue. When your AR turnover improves alongside revenue growth, you're scaling your collections operation the right way.
Common pitfalls to avoid
- Adding cash sales to your numerator. Only include credit sales. Adding cash sales artificially inflates your ratio and throws off your data.
- Using yearly start and end balances alone. Annual averages mask real swings in your cash flow. Use monthly averages to get a clear and accurate picture when your AR fluctuates.
- Skipping segmentation by customer or terms. Blended ratios average over important details. Your overall numbers look perfect, but one customer group constantly pays 90 days late. Segment your data to unlock true insights and pinpoint the actual delays.
- Ignoring big one-time invoices or prepayments. Massive single invoices spike or mask your true ratio for an entire period. Flag these outliers and review them separately.
- Failing to update your baseline after credit term changes. Granting longer terms mechanically reduces your turnover. Adjust your benchmarks to line up with your new terms and avoid unnecessary confusion.
- Treating write-offs like collection wins. Writing off bad debt shrinks your AR and technically improves your ratio. But you still don't have the cash. Treat this as an accounting move instead of a performance improvement.
- Not reconciling your AR rollforward each period. Your beginning balance plus billings minus collections and write-offs must equal your ending balance. Fix any broken data before you build metrics on top of it.
- Missing unbilled revenue. Accrued but unbilled revenue impacts your timeline. Track and handle it explicitly so you understand your true risk without blurring it into your standard AR metric.
- Benchmarking without context. Comparing your AR turnover straight to a peer misleads your decision making. Adjust for billing frequency, customer mix, and credit terms to build meaningful comparisons.
How to track accounts receivable turnover in Runway
Manual AR tracking drains time. You jump between spreadsheets, chase formulas, and repeat the same checks every month. Here’s how to automate this in Runway:
Step 1: Connect your accounting system
Sync QuickBooks Online, Xero, or NetSuite directly to Runway. Your income statement and balance sheet data update automatically so your numbers are always current.
Step 2: Configure your balance sheet and income statement databases
Add AR accounts to your balance sheet database and revenue accounts to your income statement database. These fuel your receivables and turnover metrics. Make sure only credit sales feed your formula.
Step 3: Build your AR turnover formula
In Runway’s formula editor, pull in AR from your balance sheet and net credit sales from income statement data. Use daysInMonth() so the formula grabs the right days every period. Your DSO formula should look like:
(average AR / net credit sales) × daysInMonth()
For average AR, use beginning and end balances or more detailed monthly values for extra precision.
Step 4: Add trailing-period and average AR variants
Calculate trailing three-month or twelve-month DSO alongside your monthly number. This smooths seasonality and gives you a stable trend. Runway’s date filters make these rolling calculations automatic.
Step 5: Set up aging buckets with conditional logic
If you connect QuickBooks Online, pull in invoice-level detail. Use formulas to sort each invoice into aging buckets (0-30, 31-60, 61-90, 90+ days). Build summary metrics for each bucket: total AR, percentage of total, weighted average aging. You get both turnover and aging schedule in one view.
Step 6: Segment by customer, region, or contract type
Leverage Runway’s dimensions to segment DSO and AR aging by customer, terms, region, or any attribute that matters. Use dynamic "this segment" logic to apply the formula across all groups, without duplicate setup.
Step 7: Separate actuals from forecast
Build one formula for actuals and another for forecast. This lets you see how changes in collection will impact future cash and runway. It’s great for scenario planning before locking in a plan.
Step 8: Build a reporting page for stakeholders
Create a Runway page that brings together your AR turnover, DSO trends, aging buckets, and cash runway. These update as your data syncs, keeping dashboards fresh without manual refresh. Drop your billings-to-collections ratio beside DSO for a full view of collections efficiency.
Take charge of your collections
Accounts receivable turnover gives a clear, early signal about operational health. It reveals if credit policy is on track, billing’s working smoothly, and if the cash you earn lands in the bank on time.
The teams who track and segment AR turnover, and act on what they find, forecast better and avoid cash surprises. With the right setup, you don’t just report on collections. You lead them.
If you want AR turnover tracking that always stays current and gives you real control, request a Runway demo and see it in action.