Accounts Receivable Turnover Ratio

Accounts receivable turnover is net credit sales divided by average receivables. See the formula, which balances belong in it, and the days conversion.

Written by AccountablyReviewed by Jugal Thacker, CPA8 minute readUpdated

The accounts receivable turnover ratio is net credit sales for a period divided by the average accounts receivable balance for that same period. The answer is a count of times rather than a percentage or a dollar figure: it says how many times over the period the average balance owed by customers was collected. Receivables turnover ratio, AR turnover ratio and debtor’s turnover ratio all name this same measure.

The Formula

accounts receivable turnover  =  net credit sales / average accounts receivable

average accounts receivable   =  (opening receivables + closing receivables) / 2

Net credit sales is the period’s sales made on terms, after the returns, allowances and discounts recorded against them, which is the subtraction set out in net sales. Average accounts receivable is what customers owed, measured across the period rather than read at a single date.

Nothing fixes the wording of that formula. A ratio of this kind is calculated from information on financial statements rather than presented on them, and the SEC’s own list of the ratios investors calculate that way runs to debt-to-equity, inventory turnover, operating margin, P/E and working capital (SEC, Beginners’ Guide to Financial Statements). No accounting standard supplies a receivables turnover formula, so the version used has to travel with the answer.

Why the Numerator Is Credit Sales and Not Total Sales

A sale settled at the point of sale never enters receivables at all. Counting it in the numerator measures collection speed against a balance that never carried it, and the larger the cash-paid share of a book, the further the answer drifts from what customers on terms actually did.

No filed statement separates credit sales from cash sales. The income statement caption requires net sales of tangible products, operating revenues of public utilities or others, income from rentals, revenues from services, and other revenues to be stated separately (17 CFR 210.5-03), and none of those subcaptions splits sales made on credit from sales collected on the spot. An outside reader substitutes revenue or net sales and is then computing something looser than the named ratio. A business reading its own ledger has the split in the billing system and does not have to substitute anything.

For a professional services firm the gap is usually small, because work is invoiced on terms and collected later as a matter of course.

Which Receivables Belong in the Denominator

Trade receivables are what the ratio is about. On a filed balance sheet, amounts receivable from customers (trade) are stated separately from the other receivable categories (17 CFR 210.5-02), a split accounts receivable works through. Build the denominator on the combined total and the ratio stops measuring how fast customers pay.

Long-term contract balances are the case that gets missed. Where receivables include amounts due under long-term contracts, balances billed but not paid under retainage provisions, and amounts representing the recognized sales value of performance that had not been billed and were not billable at the balance sheet date, are stated separately (17 CFR 210.5-02). Retainage is withheld by agreement rather than owed late, and work that is not yet billable has no invoice for anyone to pay.

Where a federal rule needs a receivables figure to mean what customers will actually pay, it strips the same items out. Turnover of receivables is the velocity at which receivables are collected, and in bank lending against receivables the balances that must be treated as ineligible include accounts arising from sources other than trade, notes receivable, progress billings, affiliate and intercompany accounts, and foreign accounts receivable (12 CFR part 327, Appendix C to Subpart A). That list is a lender protecting an advance rather than an accounting rule, and it is the same edit a useful turnover denominator needs.

Whether the denominator runs gross or net of the allowance for doubtful accounts is a further choice, since that allowance is reported on its own rather than folded into the receivable balance. State which one was used.

The Averaging Convention Is a Stated Choice

Every numerator here covers a period and every denominator is read off a balance sheet at a date, so pairing them takes a convention, and the convention is a choice rather than a rule. The two-point average the SEC walks through for inventory turnover is the common one, and cash conversion cycle sets that walkthrough out. A book with a seasonal peak is measured differently by two dates than by a monthly average, so the choice belongs next to the answer.

A Worked Example

Say a firm’s records for the year carry the figures below.

Fees billed on terms, net of credits             2,400,000
Trade receivables, opening                         380,000
Trade receivables, closing                         420,000

average trade receivables  (380,000 + 420,000) / 2  =  400,000
turnover                   2,400,000 / 400,000      =  6.00
days                       365 / 6.00               =  60.8

Now the same year, with a note receivable from an officer sitting in the closing balance.

Note receivable from an officer, closing            60,000

average receivables        (380,000 + 480,000) / 2  =  430,000
turnover                   2,400,000 / 430,000      =  5.58
days                       365 / 5.58               =  65.4

Same fees, same customers, and the collection period stretched because a balance no customer will pay on invoice terms was sitting in the denominator.

Turnover in Days, and Where the Computation Is Written Down

Dividing the turnover rate into the days in the year converts the count of times into an average number of days, and that conversion is written into federal tax regulation. For one interest-free-period election, open to a group member that buys property from an affiliate for resale in a particular foreign country, the rule works out that buyer’s own collection period on its resales to unrelated customers there: total sales less returns and allowances, then the average month-end accounts receivable balance for the year, then a receivables turnover rate by dividing total sales by that average balance, then divides the turnover rate into 365 and rounds to the nearest whole number to get the days in the average collection period (26 CFR 1.482-2(a)(1)(iii)(E)).

Two departures from the version that circulates are worth naming. That numerator is total sales less returns and allowances rather than credit sales, and that denominator averages month-end balances across the year rather than two dates, which tracks a seasonal book far more closely (26 CFR 1.482-2(a)(1)(iii)(E)).

Turnover and Days Sales Outstanding Are Not Two Measures

They are two renderings of the same relationship, one counted in times and one counted in days, which is why dividing the turnover into the days in the year produces the second from the first. The same reciprocal runs on the inventory side, where days inventory outstanding is the days form of inventory turnover. What separates the receivables pair in practice is the input each is usually built on. One common days sales outstanding method divides the closing receivable balance by the period’s credit sales and multiplies by the days in the period, where the turnover ratio is normally built on an average balance, so two figures taken off the same statements will not reconcile exactly. How a move in days sales outstanding should be read, and the countback alternative to that method, sit in accounts receivable best practices.

Common Questions

There is no universal figure. A desirable ratio depends on the industry, which is the qualification net profit margin sets out and sources. What the number can honestly be measured against is the same business in earlier periods, the credit terms it actually grants, or another business whose figure was built on the same numerator, the same denominator and the same averaging convention.

Federal programs that fix a level do it in days and for one purpose. HUD’s hospital mortgage insurance rules define surplus cash as the cash left only after eleven conditions are all met, one of which is that days in accounts receivable are less than or equal to 80 in the most recent audited financial statements and as of the date of distribution (24 CFR 242.1). That definition sets the level rather than the formula behind it.

A turnover at that level means the average balance was collected about once a month.

365 / 12  =  30.4 days

Whether that is good depends on the terms the business grants. Against net thirty terms it is roughly on schedule. Against shorter terms it is not, and the same figure would be comfortable for a business that bills quarterly.

No. A lower count means the average balance was collected fewer times, so cash sat longer in receivables. Higher is not automatically better either, because the same rise comes from collecting faster and from granting less credit, and tightening terms to lift the ratio can cost the sales those terms were buying. Read the direction of a move against the accounts receivable aging report before treating it as a verdict.

Take the period’s net credit sales, divide by the average trade receivables balance for the same period, and state the averaging convention and which receivables sat in the denominator alongside the answer.

Accountably places trained offshore accountants and tax preparers inside US CPA and EA firms, and a firm can put a real block of its own invoice-to-cash work through a trial task before anything client facing depends on it.

Related Terms

View All Terms

See how to evaluate an offshore accounting partner before you sign. Download the free guide now.