Receivables Turnover Ratio Calculator

How fast the money comes back

Selling on credit means handing over the goods and waiting for the money. Everything about a business's cash position depends on how long that wait is.

The receivables turnover ratio measures it.

Receivables turnover = Net credit sales / Average net receivables

Read the answer as a number of times per year. A ratio of 8 means the business collected its entire receivables balance, and rebuilt it, eight times over the course of the year.

Higher means faster collection. Lower means money is sitting in customers' hands rather than the company's.

Two inputs, one number. What the tool does not give you is the version of that number most people actually want, which is days, so the next section supplies it.

Turning the ratio into days

Eight times a year is a fine answer for an analyst and a useless one for a credit controller, who wants to know how long an invoice takes to get paid.

One division converts it.

Days sales outstanding = 365 / Receivables turnover

At a turnover of 8, that is 45.6 days.

This figure goes by days sales outstanding, the collection period, or debtor days, and it is the one worth quoting, because it can be compared against something concrete: your own payment terms.

If your invoices say 30 days and your collection period is 45.6, customers are on average taking two extra weeks. That gap is the number a business can actually act on. Chase it, tighten terms, offer a settlement discount, or accept it and fund the working capital.

A quick way to see what those extra days cost. Daily sales here are 500,000 over 365, which is about 1,370. Each day of collection period ties up roughly that much cash permanently. Pulling the collection period from 45.6 days down to 35 releases around 14,500 of cash, once, and keeps it released.

For very short periods some analysts use 360 rather than 365 for tidier arithmetic. It makes a difference of about one and a half percent, which is worth knowing if a figure you are checking against is slightly off.

Eight times a year, forty six days

Net credit sales of 500,000 and average net receivables of 62,500.

500,000 divided by 62,500 is 8.00.

Then 365 divided by 8 is 45.6 days.

So the average invoice takes about six and a half weeks to convert into cash, and at any given moment the business is owed roughly a month and a half of sales.

That second reading is worth holding on to, because it makes the balance sheet figure intuitive. Receivables of 62,500 against annual credit sales of 500,000 is one eighth of a year's sales sitting unpaid. If the business wants to grow sales by half without changing its collection behaviour, receivables will grow by half too, and that growth has to be funded from somewhere.

Which is the reason fast growing companies run out of cash while profitable. Our quick ratio calculator is the companion test there, since it asks whether the bills can be paid from what is liquid today.

Net credit sales, not total sales

The numerator says net credit sales, and every word is deliberate. This is the convention that most often gets quietly broken, and it breaks the answer badly.

Credit sales only. Cash sales never create a receivable, so including them puts revenue in the numerator that never spent a day in the denominator. The ratio inflates and the collection period shortens, for no operational reason at all.

How much does it matter? Take our business, and suppose the 500,000 of credit sales sits inside 800,000 of total sales.

Seventeen days of difference on identical books. A business would conclude its collections were excellent when they are two weeks past its own terms.

The practical problem is that published accounts rarely split credit from cash sales, so anyone analysing a company from outside usually has to use total revenue and accept the distortion. That is a defensible compromise as long as it is stated, and as long as the same substitution is made for every company being compared. It is not defensible when you own the books and could have looked up the real figure.

Net, not gross. The other half of the label. Net credit sales means credit sales after returns, allowances and settlement discounts taken. Those never turn into cash, so counting them overstates what the receivables were ever going to deliver.

And which receivables figure

The denominator has two conventions of its own.

Average, not year-end. Sales accumulate over a year while a balance sheet shows one day. Using the closing figure alone measures a full year of sales against whatever happened to be outstanding on the last day, which for a seasonal business can be wildly unrepresentative.

The usual fix is the average of opening and closing balances. On our example, opening receivables of 55,000 and closing of 70,000 give an average of 62,500.

Five and a half days apart, and in a growing business the closing figure will always be the less flattering one, because receivables have been rising all year.

If you have monthly balances, averaging all twelve is better still and removes most of the seasonality.

Net, meaning after the allowance for doubtful accounts. Receivables should be stated net of whatever the company expects not to collect. Using the gross figure counts money nobody believes is coming, which makes collections look slower than they are while quietly admitting a bad debt problem.

What a moving ratio is telling you

A single reading means little without a benchmark. Two benchmarks work.

Your own payment terms. The most useful test, and it needs no outside data. Collection period against stated terms gives you the slippage directly.

Your own history. A collection period drifting from 38 days to 46 over two years is a trend that will show up in the bank balance long after it showed up here.

Industry comparisons are weaker for this ratio than for most, because credit terms are a matter of trade custom. Construction routinely runs on ninety day terms and retail on almost none, so a cross-industry comparison mostly tells you what the industries are.

Interpreting a change:

A very high ratio is not automatically good. It can mean credit terms so restrictive that customers who would have bought on reasonable terms went elsewhere. The ratio measures collection speed, not whether the underlying credit policy is earning its keep.

One caution on averages. This ratio treats every customer as one blended debtor. A business where most invoices are paid in twenty days and one large customer is two hundred days late can show a perfectly respectable average while carrying a serious problem. Age the receivables before trusting the ratio, the same discipline the quick ratio calculator page recommends for the same reason.

Questions people ask

How do I get the collection period in days?

Divide 365 by the ratio. A turnover of 8 is a collection period of 45.6 days.

What if I only have total sales?

Use it and say so. It will overstate the turnover and understate the days, in our example by seventeen days, so the figure is comparable only against others calculated the same way.

Why average receivables rather than the closing balance?

Because sales accrue over a year and a balance sheet shows one day. The average of opening and closing is the usual compromise, and averaging monthly balances is better still.

What is a good ratio?

Whatever is consistent with your payment terms. Thirty day terms imply a collection period near thirty days and a ratio near twelve. Compare against your terms and your own history rather than across industries.

What does net receivables mean?

Receivables after subtracting the allowance for amounts the company does not expect to collect. Using the gross figure counts money nobody believes is coming.

Should I use 365 or 360 days?

Either, as long as you are consistent. The difference is about one and a half percent, which explains most small discrepancies against a published figure.

Can a very high ratio be a problem?

It can. Collecting quickly is good, but terms strict enough to drive customers to competitors are not. The ratio measures collection speed, not whether the credit policy is well judged.

References

A note on the sources. Both inputs are balance sheet and income statement items rather than quantities anyone invents, and the Securities and Exchange Commission's guide for investors explains what receivables are, where revenue sits, and why no single statement tells the whole story, which is the reason this ratio has to be read alongside the cash position. The requirement that current assets be separately presented, which is what makes a receivables figure recoverable from a filing, sits in the Commission's rules for registrants.

1. U.S. Securities and Exchange Commission, Beginners' Guide to Financial Statements, on assets including amounts owed by customers, on revenues and expenses, and on the relationship between the balance sheet and the cash flow statement. https://www.sec.gov/about/reports-publications/investorpubsbegfinstmtguide
2. U.S. Securities and Exchange Commission, Regulation S-X, Rule 5-02, requiring a classified balance sheet and separate presentation of receivables, including the disclosure of notes receivable where they exceed ten percent of total receivables.
3. U.S. Securities and Exchange Commission, Beginners' guide to financial statements, Investor.gov glossary entry. https://www.investor.gov/introduction-investing/investing-basics/glossary/beginners-guide-financial-statement
4. Brealey, R.A., Myers, S.C., and Allen, F., Principles of Corporate Finance, McGraw-Hill Education, chapters on working capital management and financial statement analysis.