Accounts Receivable Turnover Ratio Calculator
Calculate the accounts receivable turnover ratio from net credit sales and average receivables, with the days equivalent and industry context.
Accounts Receivable Turnover Calculator
Background.
The accounts receivable turnover ratio counts how many times a year a business collects and rebuilds its receivables book. Divide net credit sales for the period by the receivables balance and you get a multiple: a turnover of 8 means the book was emptied and refilled about eight times, which is another way of saying customers paid in roughly 46 days.
That last sentence is the whole relationship between this page and days sales outstanding. Turnover and DSO are the same information in different units — turnover equals the days in the period divided by DSO, and vice versa. This page is set up the way financial-statement analysis uses the ratio: annual, with average receivables as the denominator, alongside receivables as a share of sales. The DSO calculator is set up the way a credit team uses it: quarterly, on the closing balance, with a calculation of what hitting a target collection period would release in cash. Use whichever framing matches the decision you are making, and expect the two pages to give different numbers unless you align the window and the denominator, because they default differently on purpose.
Two conventions change the answer and both are yours here. The denominator is the first: the textbook uses the average of opening and closing receivables, while management reporting and lenders often use the closing balance. On US manufacturing's trailing four quarters to March 2026 the two give 7.83 times and 7.43 times from identical accounts — a 5 percent difference, entirely because receivables grew $113,609 million over the year and the closing balance therefore sits above the average. Had receivables shrunk, the ending basis would have reported the faster turnover instead. There is no rule that one is always higher.
The second convention is the numerator, and it is the one that quietly breaks most published comparisons: it should be net credit sales, not total revenue. Cash sales never enter receivables, so including them inflates the numerator and overstates turnover. Financial statements only disclose total revenue, which means any turnover ratio computed from a filing for a business with a retail channel is flattering.
There is no universal good turnover, and the range is not subtle. Applying the January 2026 receivables-to-sales data that Aswath Damodaran publishes for 5,994 US-listed companies: listed grocery turns its book about 57 times a year, general retail about 29 times, the whole market excluding financial companies about 8.1 times, semiconductors about 6.3 times and machinery about 5.3 times. That is an eleven-fold spread driven by who the customers are and what terms are standard in the trade, not by how hard anyone chases invoices. Compare against your own history and your closest competitors, on the same basis, over the same window.
One last caveat worth carrying to the answer: the ratio is an average across the whole book. A portfolio of consistent 45-day payers and a portfolio of 30-day payers containing one large, long-overdue dispute can produce an identical turnover. The ratio sizes the problem; an ageing report locates it.
What is accounts receivable turnover calculator?
The accounts receivable turnover ratio measures how efficiently a business converts credit sales into cash. It divides net credit sales for a period by the receivables balance carried during that period, producing a dimensionless multiple: the number of times the receivables book was collected. The textbook denominator is average receivables, computed as the opening balance plus the closing balance divided by two, because a single period-end balance may not represent the level carried through the period. Receivables should be taken net of the allowance for doubtful accounts; Regulation S-X, 17 CFR 210.5-02, sets receivables at caption 3 and requires the allowance at caption 4 to be "set forth separately in the balance sheet or in a note thereto", so both figures are available and the wrong one is easy to pick up. Dividing the days in the period by the turnover ratio converts it into days sales in receivables, which is the same measure DSO reports. Receivables turnover is classed as an activity or efficiency ratio rather than a liquidity ratio, and like DSO, the quick ratio and the cash conversion cycle it is an analytical construct: no accounting standard-setter defines it, which is why the average-versus-ending and credit-sales-versus-revenue conventions differ between sources and should always be stated with the figure.
How to use this calculator.
- Choose the denominator. Average is right for period-to-period comparison and for reproducing a textbook or analyst figure; Ending is right when a lender or a credit decision is looking at the book as it stands.
- Enter net credit sales for the period, net of returns and allowances, and excluding any sales collected at the point of sale.
- Enter the opening and closing receivables balances, both net of the allowance for doubtful accounts.
- Set the days in period to match the sales figure — 365 for a year is the usual choice for this ratio. It affects only the days conversion, never the turnover itself.
- Read the turnover alongside the days figure. Most people find days easier to reason about, and the two are strictly equivalent.
- If your business is seasonal, a two-point average is a poor estimate. Work out a monthly average of receivables, enter it in the ending-receivables field and switch the basis to Ending.
- Compare against your own last four to eight periods on the identical basis. Then compare against direct competitors, checking that they use the same denominator before drawing any conclusion.
- Pull an ageing report before acting. The ratio tells you the size of the receivables position, not which customers are causing it.
The formula.
The ratio divides a flow by a stock. Credit sales are what passed through the receivables account over the period; the receivables balance is what was sitting in it. The quotient is how many times the balance was turned over to produce that flow, so it is dimensionless — a turnover of 7.83 means the book was collected and rebuilt 7.83 times.
The basis select changes the denominator. On the average basis it is the mean of the opening and closing balances, which is the standard textbook treatment. On the ending basis it is the closing balance alone. Which produces the higher turnover depends on which way receivables moved: on the worked example receivables grew from $993,135M to $1,106,744M over the year, so the closing balance sits above the average and the ending basis reports the slower turnover, 7.43 against 7.83. If receivables had fallen, the ending basis would report the faster turnover. Any source that states this relationship in one direction only has tested it in one direction only.
Converting to days divides the days in the period by the turnover. This is where the order of operations matters. The days figure is computed from the unrounded turnover, not from the 7.83 that gets displayed: 365 ÷ 7.8308807317 is 46.6103 days, while 365 ÷ 7.83 is 46.6156 days. The difference is small but it is a pure artefact, and it grows when the days figure is used to set a collection target. Every output on this page is rounded exactly once, at the end.
Receivables as a percentage of sales is the exact inverse of the turnover ratio, multiplied by 100. It is included because that is the form most published sector datasets use — Damodaran's January 2026 tables report accounts receivable over sales rather than a turnover multiple — so having it makes external comparison a lookup rather than a conversion. On the worked example, average receivables of $1,049,939.5M against credit sales of $8,221,951M is 12.7700 percent, and 100 divided by 12.7700 gives back the 7.8309 turnover.
There is one guard worth knowing about. If the receivables denominator works out to zero the turnover is mathematically infinite. Rather than render an infinity, the calculator stops and explains that a book with nothing in it cannot be said to turn over a number of times.
A worked example.
The figures cover every US manufacturing corporation, taken from the Census Bureau's Quarterly Financial Report for 2026 Quarter 1, in millions of dollars, over the trailing four quarters. Net sales for the four quarters to March 2026 were $2,034,630M + $2,057,270M + $2,081,800M + $2,048,251M = $8,221,951M. Trade receivables net of allowances stood at $993,135M at the start of that window and $1,106,744M at the end. One caveat that applies to nearly every turnover ratio computed from a public filing: the QFR line is "net sales, receipts, and operating revenues" — total sales, not net credit sales, which no published statement separates out. Manufacturing sells overwhelmingly on trade credit, so the approximation is close here; for a business with a meaningful cash-sales channel it would overstate turnover. Average receivables are ($993,135M + $1,106,744M) ÷ 2 = $1,049,939.5M. Turnover is $8,221,951M ÷ $1,049,939.5M = 7.8309 times. Dividing 365 by that gives 46.6103 days sales in receivables. Credit sales per day are $8,221,951M ÷ 365 = $22,525.89M, and average receivables represent 12.7700 percent of credit sales — which, inverted, gives the 7.8309 turnover back. Switching to the ending basis uses $1,106,744M instead, giving a turnover of 7.4290 times and 49.1321 days. The gap of 0.40 turns, or 2.5 days, exists purely because receivables grew $113,609M over the twelve months, so the closing balance is above the average. Neither figure is wrong; they answer slightly different questions, and a turnover ratio quoted without its denominator is ambiguous by about that much. An entirely separate dataset confirms the method. Aswath Damodaran publishes accounts receivable as a share of sales for 5,994 US-listed firms as of January 2026 — the inverse of this ratio. Machinery's 19.03 percent inverts to 5.2549 turns and 69.4595 days; semiconductors' 15.88 percent to 6.2972 turns and 57.9620 days; the whole market excluding financials, 12.39 percent, to 8.0710 turns and 45.2235 days; general retail's 3.50 percent to 28.5714 turns; and listed grocery's 1.75 percent to 57.1429 turns and just 6.3875 days. Two different universes, two different constructions, one identity — and an eleven-fold spread that makes the case against any universal target.
Frequently asked questions.
What is a good accounts receivable turnover ratio?
Should I use average or ending receivables?
How is this different from days sales outstanding?
Why must the numerator be credit sales rather than total revenue?
Is a two-point average good enough?
My turnover fell but nothing changed in collections. Why?
Does a high turnover ratio always mean good management?
References& sources.
- [1]U.S. Census Bureau. Quarterly Financial Report for Manufacturing, Mining, Wholesale Trade, and Selected Service Industries, 2026 Quarter 1. Table 1.1 trade accounts and trade notes receivable net of allowance ($993,135M at 1Q 2025, $1,106,744M at 1Q 2026); Table 1.0 quarterly net sales, receipts and operating revenues. Retrieved 2026-07-29.
- [2]Damodaran, A. "Working Capital Ratios by Sector (US)." NYU Stern School of Business, data as of January 2026, 5,994 firms. Accounts receivable as a percent of sales — the inverse of this ratio: Machinery 19.03%, Semiconductor 15.88%, Total Market excluding financials 12.39%, Retail (General) 3.50%, Retail (Grocery and Food) 1.75%. Retrieved 2026-07-29.
- [3]Cagle, C.S., Campbell, S.N. and Jones, K.T. (2013). "Analyzing liquidity using the cash conversion cycle." Journal of Accountancy, American Institute of CPAs, 1 May 2013. Days receivables outstanding "measures the number of days a company takes to collect on sales" — the days form of this ratio. Retrieved 2026-07-29.
- [4]U.S. Government Publishing Office. 17 CFR 210.5-02, Regulation S-X — Balance Sheets. Caption 3 accounts and notes receivable, with sub-classification by source; caption 4 allowances for doubtful accounts "to be set forth separately in the balance sheet or in a note thereto". Retrieved 2026-07-29.
- [5]Financial Accounting Standards Board. FASB Accounting Standards Codification, Topic 210 Balance Sheet, paragraph 210-10-45-1 — classification of receivables as current assets. Free registration required at asc.fasb.org.
In this category
Embed
Quanta Pro
Paid features are coming later.
- All 762 calculators remain free
- No billing is enabled