Accounts Receivable Turnover Ratio: Formula, Examples, Benchmarks

The accounts receivable turnover ratio tells you how many times a year you collect your average receivables balance. Divide net credit sales by average accounts receivable: a higher number usually means customers pay faster.

Invoices travelling round a loop from credit sale to cash, a turnover gauge reading 6 times, and a finance lead comparing collection days with credit terms
Published 9 min read
AR turnover formula
Credit sales ÷ avg AR
AR turnover in days
365 ÷ ratio
Median collection, US listed companies, 2024
48 days
Name of the ratio in ERPNext
Debtor Turnover

The basics

What does the accounts receivable turnover ratio measure?

In one line

It measures how quickly credit sales turn into cash. A ratio of 8 means you collected your average receivables balance about eight times during the year. If it drops to 5, the same sales are sitting longer in customer accounts.

That one number answers the question every owner asks at month end: "We sold well, so where is the cash?" The rest of this guide covers the formula, two worked examples, accounts receivable turnover in days, industry benchmarks from US public company filings, the traps that make the ratio lie, and how to track it in ERPNext without a spreadsheet.

1

A high ratio usually signals

A conservative credit policy, an active collections team and good customers, according to AccountingTools.

2

A low ratio can point to

Loose credit, weak follow-up, customers in trouble, or bad debt that hasn't been written off yet.

People call the same number by several names. ERPNext's own report labels it "Debtor Turnover Ratio".

  • Receivables turnover ratio
  • Debtors turnover ratio (India, UK)
  • AR turnover
  • Debtor Turnover Ratio (ERPNext)

Formula

What is the accounts receivable turnover formula?

CFI defines net credit sales as credit sales minus sales returns and allowances. Average accounts receivable is the opening and closing balances added together and halved.

AccountingTools adds that a 12-month average gives a truer picture if your balances swing during the year. Pick a method and use it every period, or the trend means nothing.

Net credit sales ÷ Average AR

The accounts receivable turnover ratio, as CFI and AccountingTools both define it.

PartWhat goes in itCommon mistake
Net credit salesSales made on credit, minus returns and allowancesUsing total sales, including cash and card sales
Average accounts receivable(Opening AR + Closing AR) ÷ 2 for the periodUsing only the closing balance
PeriodUsually a year; a quarter or month works if you scale the daysMixing a quarter's sales with a year's day count

Worked examples

How do you calculate it? Two worked examples

These are illustrative numbers in any currency, not client data.

Example 1: a distributor with 45-day credit terms

  1. 1Net credit sales for the year6,000,000, after 200,000 of returns.
  2. 2Opening and closing AR800,000 on 1 April, 1,200,000 on 31 March.
  3. 3Average AR(800,000 + 1,200,000) ÷ 2 = 1,000,000.
  4. 4AR turnover6,000,000 ÷ 1,000,000 = 6.0 times.
  5. 5AR turnover in days365 ÷ 6.0 = about 61 days.

The distributor offers 45 days. Customers are taking about 61. That 16-day gap is cash the business is lending to its customers for free.

Example 2: same sales, tighter collections

A competitor sells the same 6,000,000 on credit, but its average AR is 650,000. On the same revenue it has 350,000 less tied up in receivables. That's money it doesn't need to borrow.

Distributor ACompetitor B
Net credit sales6,000,0006,000,000
Average AR1,000,000650,000
AR turnover6.0 timesabout 9.2 times
AR turnover in daysabout 61roughly 40

CFI's own worked example, a small bike shop, runs the same way and lands at about 7.2 times (CFI).

Turnover in days

How do you calculate accounts receivable turnover in days?

AR turnover in days = 365 ÷ AR turnover ratio. Divide the days in the period by the turnover ratio. Don't divide a quarterly ratio into 365.

The days figure is easier to explain to a sales team than the ratio. "Customers pay us in 61 days, our terms are 45" lands better than "our turnover is 6".

It's close to days sales outstanding (DSO), which many teams calculate as closing AR ÷ credit sales × days. The two differ mainly in whether you use the closing or the average balance, so pick one and stick with it.

365 ÷ ratio
Full year, with the year's sales and average AR
91 or 92 ÷ ratio
A quarter, with that quarter's sales and average AR
Days in month ÷ ratio
A single month, with that month's figures

Reading it

Is a higher or lower AR turnover ratio better?

Short answer

Higher is usually better. It means faster collection and less working capital stuck with customers. CFI calls a high ratio desirable and a low or falling ratio harmful (CFI).

There's a ceiling, though. AccountingTools warns that a very high ratio can mean credit terms are so tight that you lose sales, which hurts most when margins are high. The useful comparison is your days figure against your own credit terms, then against your industry.

Days close to your credit terms

Collections are on track. Nothing to fix; keep watching the trend.

Days well above terms

Customers pay late or terms aren't enforced. Check the overdue buckets in the AR ageing report first.

Ratio falling quarter after quarter

Collections are slipping. Check which customers moved into older buckets.

Ratio far above peers

Terms may be too tight, or most sales are cash. Check lost deals, and whether cash sales are in the formula.

Benchmarks

What is a good AR turnover ratio by industry?

There's no single good number. It depends on how your industry sells. The table uses ReadyRatios' median receivables turnover in days for US listed companies, calculated from SEC filings, for 2024 (2,851 companies in the all-industries figure). We converted days to an approximate ratio with 365 ÷ days.

Industry (SIC group)Median days, 2024Approx. turnover
All industries487.6
General merchandise stores3122
Wholesale, non-durable goods2514.6
Food and kindred products3012.2
Wholesale, durable goods448.3
Health services477.8
Fabricated metal products517.2
Business services576.4
Chemicals and allied products606.1
Engineering, accounting, research, management606.1
Industrial machinery and computers635.8
Special trade contractors744.9
Legal services814.5

Retailers collect almost at once because shoppers pay at the till. Machinery makers, chemical companies and professional firms wait two months or more. These are US public companies, so treat them as a rough guide. A mid-sized Indian manufacturer selling to dealers can sit well outside these figures. Your own trend over eight quarters matters more than any benchmark.

Watch out

Why can the ratio mislead you?

We've seen finance teams act on a turnover number that was wrong before anyone looked at a single customer. Watch for these five things:

Cash sales in the numerator

Total sales instead of credit sales makes turnover look better than it is. ERPNext's built-in report uses total direct income, so a business with a lot of counter sales should adjust for it.

Two-point averages

If March is your biggest billing month, closing AR is inflated and the ratio looks worse. A 12-month average fixes this.

Seasonality

Compare Q3 with last year's Q3, not with Q2 (AccountingTools).

Your own billing errors

Wrong prices, short shipments and missing PO numbers delay payment. A low ratio isn't always a collections problem.

One big customer

A single large account paying late can drag the whole ratio. Look at the ageing by customer before you change policy for everyone.

Improve it

How do you improve the accounts receivable turnover ratio?

Most improvements come from a few habits, not a new tool. Here's the order we usually follow in ERPNext projects:

  1. 1Set credit limits per customerIn ERPNext, the Credit Limit table on the Customer blocks new orders above the limit unless someone with the right role approves them.
  2. 2Put payment terms on every invoiceA Payment Terms Template sets due dates on each Sales Invoice, so ageing runs on the real due date.
  3. 3Invoice the day you deliver, and get it rightLate or wrong invoices push the whole collection cycle back.
  4. 4Offer an early-payment discount where margins allowERPNext payment terms have discount fields (type, amount and validity), so the discount is calculated, not negotiated by email.
  5. 5Make paying easyA Payment Request sends the customer a payment link with the invoice.
  6. 6Follow up on a fixed scheduleDunning in ERPNext creates reminder letters for overdue invoices, with a dunning fee and interest rate you set per dunning type.
  7. 7Review ageing every weekThe Accounts Receivable report ages by due date by default, in 30, 60, 90 and 120-day buckets you can change.

AI can take over the routine part of steps 6 and 7: drafting the reminder, matching incoming payments to invoices and flagging customers whose payment pattern is changing. We cover that in our guide to accounts receivable and how AI automates it in ERPNext. The rule we follow is simple: AI drafts, a person approves anything that goes to a customer.

In ERPNext

How do you track AR turnover in ERPNext?

ERPNext has a Financial Ratios report under Accounting (listed in the accounting reports). In the version 16 source code, its "Debtor Turnover Ratio" divides net sales (the Direct Income accounts) by the average of the opening and closing balances of all Receivable-type accounts for each period. It also shows creditor and inventory turnover beside it.

For a monthly view, a number card or dashboard chart on the receivables workspace, built from the same data, lets the finance head see the trend without running a report.

Direct Income ÷ avg Receivable

How ERPNext's Financial Ratios report works out the Debtor Turnover Ratio for each period, per the version 16 source code.

Three practical points from setting this up

  • Keep Receivable accounts clean. Advances parked in the debtors account, or customer balances posted to a general ledger account without the Receivable type, distort the average.
  • Map income accounts correctly. Only accounts under Direct Income count as sales in this report.
  • Pair the ratio with the Accounts Receivable report. The ratio tells you whether things are getting better or worse. The ageing tells you which customers to call.

Limits

When is AR turnover the wrong metric?

Mostly cash, card or prepaid sales

If almost all your sales are paid up front, the ratio has little to say. Track overdue amount and the oldest unpaid invoice instead.

A few large milestone invoices

If you bill a few big milestones a year, one invoice can swing the ratio wildly. Look at each contract's collection instead.

Next step

What should you do next?

  1. 1Work out four quartersCalculate your ratio and your days for the last four quarters, using credit sales and a monthly average.
  2. 2Put the days next to your termsCompare collection days with the credit terms you actually offer.
  3. 3Start with the biggest gapsIf the gap is more than a couple of weeks, open the ageing report and begin with the five biggest overdue customers.

If you run ERPNext and the Financial Ratios report gives numbers you don't trust, the cause is usually account mapping, not the formula. FinByz has worked on ERPNext since 2016, across 200+ projects in 15+ countries, and this clean-up is a common first step for us. Our ERPNext accounting transaction audit checks exactly this, and if you need hands on the ledger every month, you can hire an ERPNext accountant. On the payables side, the accounts payable payment management report gives the same kind of view of what you owe.

Talk to our Experts

Ready to Scale with Smart Tech? Let's Talk.

Transform your business processes with AI-powered automation and expert implementation.

Trusted by 100+ businesses
Questions buyers ask

Frequently Asked Questions

Find answers to common questions about our services