What Is Accounts Receivable Turnover?
Accounts receivable turnover measures how many times a company collects its average accounts receivable during a period. It compares credit sales to the average receivables balance, showing how efficiently the business turns credit sales into cash. A high turnover means the company collects quickly and customers pay on time; a low turnover means collections are slow and cash is tied up in unpaid invoices. It is one of the main measures of how well a business manages credit and collections.
How to Calculate Accounts Receivable Turnover
Accounts Receivable Turnover = Net Credit Sales / Average Accounts Receivable
Worked example:
- Net credit sales: $4,380,000
- Average accounts receivable: $600,000
- AR turnover: 4,380,000 / 600,000 = 7.3
The company collects its receivables about 7.3 times a year.
AR Turnover in Power BI (DAX)
Replace the measures with the ones in your model; many teams use credit sales rather than total revenue when the split is available:
Average AR = DIVIDE ( [Beginning AR] + [Ending AR], 2 )
AR Turnover = DIVIDE ( [Total Revenue], [Average AR] )AR Turnover and Days Sales Outstanding
Accounts receivable turnover and days sales outstanding are two angles on the same thing. Turnover counts how many times receivables are collected in a period; days sales outstanding converts that into the average days to collect, roughly 365 divided by turnover. A turnover of 7.3 corresponds to a DSO of about 50 days.
What Is a Good AR Turnover?
A good turnover depends on the payment terms a company offers. If terms are net 30, customers should turn over receivables about twelve times a year; far fewer suggests slow collection. As with most efficiency metrics, the trend matters: a falling turnover is an early sign that cash is taking longer to come in.
Reporting AR Turnover From Your ERP Data
AR turnover depends on receivables and sales drawn consistently from the ERP, which is harder across entities and currencies. A governed data foundation brings receivables and revenue onto one model so turnover is consistent and ties back to the books. QuickLaunch ships pre-built models for JD Edwards, Vista, NetSuite, and OneStream that surface receivables data for collections reporting.
Frequently Asked Questions
How is accounts receivable turnover calculated?
Divide net credit sales by average accounts receivable. A company with $4.38M in credit sales and $600K average receivables has an AR turnover of about 7.3.
What is the difference between AR turnover and DSO?
They describe the same collection efficiency from opposite directions. AR turnover counts how many times receivables are collected in a period; days sales outstanding converts that into the average days to collect, roughly 365 divided by turnover.
What is a good accounts receivable turnover?
It depends on the payment terms offered. On net-30 terms, around twelve turns a year indicates customers pay on time; far fewer suggests slow collection. The trend matters as much as the level.
About the Author
