Skip to content

G.28Receivables

Accounts Receivable Turnover Ratio: Formula, Example, How to Improve

A worked example of a business whose sales grew while its collections quietly slipped, and how the turnover ratio caught it.

By PayLinkPublished 6 min read

On this page7 sections
  1. 01The receivables turnover formula
  2. 02A worked example over two years
  3. 03Turning turnover into days
  4. 04What is a good accounts receivable turnover ratio?
  5. 05The averaging mistake that skews the ratio
  6. 06Find out which customers are dragging the ratio
  7. 07How to improve your accounts receivable turnover

The accounts receivable turnover ratio is net credit sales divided by average accounts receivable for the same period. It tells you how many times a year your business collects its typical receivables balance. With $2,160,000 of credit sales and average receivables of $270,000, turnover is 8.0. A higher ratio means faster collection; divide 365 by the ratio to get days.

Definition

The accounts receivable turnover ratio measures how efficiently a business collects money owed by credit customers, expressed as the number of times average receivables are collected in a period. It is calculated as net credit sales divided by average accounts receivable, and converts directly into days sales outstanding (365 divided by the ratio).

The receivables turnover formula

Accounts receivable turnover = Net credit sales ÷ Average accounts receivable

Average accounts receivable = (Opening receivables + Closing receivables) ÷ 2

Net credit sales are invoiced sales after returns, allowances and credit memos. Leave out sales paid at the time of purchase, because they never become receivables. Including them inflates the ratio and makes collections look better than they are.

A worked example over two years

Take a machine shop that makes custom parts for manufacturers and distributors, all on net 30 terms. Its owner looks at two years side by side.

Year 1Year 2
Net credit sales$2,160,000$2,520,000
Opening receivables$240,000$300,000
Closing receivables$300,000$420,000
Average receivables$270,000$360,000
Turnover8.07.0
Days to collect (365 ÷ turnover)45.652.1

Year 2 looks like a good year: sales rose by $360,000, about 17%. But average receivables rose by a third, from $270,000 to $360,000. Receivables grew faster than sales, so turnover fell from 8.0 to 7.0, and the average customer took about six and a half days longer to pay.

That slowdown has a cash cost you can calculate. Had the shop kept turnover at 8.0 in Year 2, its average receivables would have been $2,520,000 ÷ 8.0 = $315,000. The slower collections tied up an extra $45,000 ($360,000 − $315,000) for the whole year, money the owner may well have been borrowing on a credit line to cover.

Turning turnover into days

Turnover and days sales outstanding are two views of the same thing:

Days to collect = 365 ÷ Accounts receivable turnover

Days are easier to compare with your payment terms. On net 30, a business whose customers all paid exactly on the due date would have turnover of about 12.2 (365 ÷ 30). The machine shop's Year 2 ratio of 7.0 equals about 52 days, so customers are paying three weeks late on average. Many owners find it easiest to track the days figure monthly and use turnover in annual reviews or when a lender asks for it.

What is a good accounts receivable turnover ratio?

A good ratio is one that lines up with your terms and holds steady or rises from year to year. Use your terms to set the benchmark:

Payment termsTurnover if all customers pay on the due date
Net 1524.3
Net 3012.2
Net 458.1
Net 606.1

Real ratios come in below these figures, because some customers always pay late. The size of the shortfall is what matters. A net 30 business at 10 is in reasonable shape; at 7, as the machine shop found, collections need attention.

A very high ratio is not automatically good news. It can mean your credit terms are so tight that you are losing orders from customers who would have paid, just not up front. If your turnover is far above the on-time benchmark for your terms, check that cash or card-at-sale revenue hasn't crept into the credit sales figure.

The averaging mistake that skews the ratio

The two-point average (opening plus closing, divided by two) works only if receivables are roughly level through the year. Many businesses' aren't. The machine shop slows down every December, so its year-end receivables are among its lowest of the year.

Say its Year 1 receivables averaged $315,000 across the 13 month-end balances from one December to the next, compared with $270,000 from the two-point method. The more accurate turnover is $2,160,000 ÷ $315,000 = 6.9, not 8.0, and the days figure is 53 rather than 46. The shop's collection problem started earlier than the simple calculation suggested.

If your business is seasonal, average the month-end balances for the year. Whichever method you choose, use the same one every time, or the trend will move for reasons that have nothing to do with collections.

Monthly and quarterly turnover

You don't have to wait for year-end. For a quarter, divide the quarter's net credit sales by average receivables for the quarter, then convert to days using the days in the quarter. Say Q3 credit sales were $660,000 and average receivables were $350,000. Quarterly turnover is 1.89, which annualizes to about 7.5 (1.89 × 4), and days to collect are 91 ÷ 1.89 = 48. Checking each quarter means a slide shows up within three months instead of at the annual review.

Find out which customers are dragging the ratio

A company-wide ratio averages good payers and bad ones together. Splitting it by customer group shows where the problem lives. Here is the machine shop's Year 2, broken out:

Customer groupNet credit salesAverage receivablesTurnoverDays to collect
Manufacturers (OEMs)$1,400,000$160,0008.842
Distributors$700,000$90,0007.847
Small job shops$420,000$110,0003.896
Total$2,520,000$360,0007.052

The small job shops produce 17% of sales but hold 31% of receivables. They take more than three months to pay on net 30 terms. That is a credit decision as much as a collections one, and it points straight at the fix.

How to improve your accounts receivable turnover

The ratio rises when receivables fall relative to sales. These are the changes that do that, roughly in order of how directly they work.

  1. Change terms for the slowest group. In the example, moving small job shops to a 50% deposit and the balance due on delivery would take most of their $110,000 out of receivables. A clear credit policy sets out who gets net terms and who doesn't.
  2. Bill in stages on long jobs. A part run that takes six weeks to complete shouldn't produce one invoice at the end. Progress billing spreads receivables across the job so no single balance grows large.
  3. Invoice the day goods ship. Receivables count from the invoice date, so a billing delay doesn't show in the ratio, but it does delay cash and push every due date back.
  4. Offer electronic payment on every invoice. A payment link that lets a customer pay by card or ACH removes the wait for a check run.
  5. Follow up on a fixed schedule and call the largest overdue accounts every week. Our plan for how to reduce DSO sets out a cadence.

Writing off old, uncollectible invoices also raises the ratio, because it lowers receivables. That improvement is real in the sense that the balance sheet becomes more accurate, but it doesn't bring in any cash. When you report turnover, note any large write-offs in the period so nobody mistakes cleanup for better collection.

Talk to us

Talk to us about how long you wait to get paid.

Book a free consultation and talk through how this applies to your business. If you have a recent processing statement, bring it along.