Accounts Receivable Turnover Ratio Calculator

Receivables turnover tells you how many times a year you sell on credit, collect the cash, and lend it out again. Enter net credit sales for the period and the opening and closing receivable balances, and this calculator returns the turnover ratio, the average receivable balance behind it, the average collection period in days, and how far past your stated terms your customers actually pay. It also prices the gap: every day of collection delay has an exact dollar value equal to one day of credit sales.

Calculator

This calculator runs in your browser. Enable JavaScript for live results — the inputs, formula and worked example below remain fully readable without it.

Inputs this calculator takes, with typical values
InputWhat to enterExample
Net credit sales for the periodSales invoiced on terms, after returns and allowances — take revenue from the income statement and remove cash and card sales.9600000 $
Beginning accounts receivableNet trade receivables on the balance sheet at the start of the period, after the allowance for doubtful accounts.980000 $
Ending accounts receivableNet trade receivables at the close of the same period, on the same net-of-allowance basis.1120000 $
Days in the periodMatch this to the period your sales figure covers, or the collection period will be wrong by that ratio.365 — full year
Receivable balance to useAnalysts average the two balances; credit teams often use the closing balance so the ratio reacts this month.Average of beginning and ending
Your stated credit termsThe net terms printed on your invoices, so the calculator can show how far past them you are actually collecting.30 days

It returns

  • Receivables turnover — How many times the average receivable book was collected and rebuilt during the period.
  • Average collection period
  • Average accounts receivable
  • Days collected past terms
  • Cash tied up past terms — Working capital you would release by collecting exactly on terms.

The formula

TAR=Net credit sales(AR0+AR1)/2
Collection period=DTAR=AR¯DNet credit sales

In plain text: AR turnover = Net credit sales ÷ Average accounts receivable

  • TₐᵣReceivables turnover for the period (times)
  • AR₀Net trade receivables at the start of the period ($)
  • AR₁Net trade receivables at the end of the period ($)
  • DDays in the period — 365, 360, 91 or 30 (days)

Both figures must cover the same period and the same reporting entity. Receivables are taken net of the allowance for doubtful accounts, which is how they appear on the face of a US GAAP balance sheet.

Updated Category Activity, Turnover & Cash Conversion Cycle Verified against published test cases Reading time 11 min

What receivables turnover actually measures

Receivables turnover counts how many times you recycle your credit book in a period. If the ratio is 8, the average dollar you invoiced sat unpaid for one-eighth of a year — about 46 days — before it came back as cash and went out again as a new invoice. The ratio is a velocity, not a size: a company with $50m of receivables can turn faster than one with $5m.

That velocity is the price of granting credit. Selling on net-30 means financing your customer's purchase for a month out of your own cash. The receivable is an interest-free loan you make to somebody else's business, funded from your equity or from a revolver you pay interest on. Turnover tells you how efficiently that loan book is run; the collection period converts it into the unit finance people argue in, which is days.

Three groups read the number for different reasons. Credit managers use it as the scoreboard for order-to-cash. Lenders read a book that turns slower each year as aging receivables that will never collect, or revenue booked on invoices customers dispute. Analysts combine it with inventory and payables to build the cash conversion cycle.

The formula explained variable by variable

You divide net credit sales by average accounts receivable. The ratio is a flow over a stock — a year of activity over the balance that activity leaves behind — and each half has a trap in it.

The numerator must be credit sales, not revenue. Only invoiced sales create receivables, so cash, card and cash-on-delivery sales inflate turnover without ever having sat in the AR balance. A distributor with 90% trade and 10% counter sales overstates turnover by about 11% using total revenue. Public filers rarely disclose the credit split, which is why analysts accept total revenue as a consistent proxy — consistently wrong beats inconsistently right. For your own company, pull the real figure from the billing system.

Net means after returns and allowances. A firm with heavy returns that uses gross sales flatters the ratio twice, because credit memos have already reduced the receivable balance too.

The denominator is a stock, so it needs averaging. Sales accrue over 365 days; a receivable balance exists at one instant. Comparing a year of sales to a single December 31 balance is fair only if the business does not move. The convention averages opening and closing balances; a seasonal business needs 13 month-end balances instead, because a toy distributor whose December receivables run four times its June receivables gets a badly misleading two-point average.

Days in the period must match the numerator. Quarterly sales against 365 days produces a collection period four times too long. Use 365 for a year, 91 for a quarter, 30 for a month. The 360-day banker's year survives in loan covenants; it makes the collection period about 1.4% shorter, so read the covenant definition before reporting against it.

Worked example: an industrial distributor on net-30 terms

A distributor closes the year with $9,600,000 of net credit sales. Trade receivables were $980,000 at January 1 and $1,120,000 at December 31. Invoices go out on net-30.

  1. Average the receivables. ($980,000 + $1,120,000) ÷ 2 = $1,050,000.
  2. Divide sales by that average. $9,600,000 ÷ $1,050,000 = 9.14 turns. The book recycled just over nine times.
  3. Convert to days. 365 ÷ 9.142857 = 39.9 days average collection period. The same answer comes the other way round: $1,050,000 ÷ $9,600,000 × 365 = 39.9 days.
  4. Find one day of sales. $9,600,000 ÷ 365 = $26,301 per day. This is the exchange rate between days and dollars for this business, and it is the single most useful number on the page.
  5. Compare to terms. 39.9 − 30 = 9.9 days past terms.
  6. Price the gap. 9.9 × $26,301 = $261,000 of cash sitting in overdue invoices.

That $261,000 is the prize for fixing collections, and it is permanent working capital, not a one-off. If the distributor borrows on a revolver at 8.5%, the delay costs about $22,000 a year in interest alone — before any of it turns into bad debt. Note also what the ratio does not say: it cannot tell you whether the 9.9 days come from every customer paying a week late or from three accounts being 120 days delinquent while everyone else pays on time. For that you need an aging schedule, and the second case is far more dangerous because it feeds straight into the allowance for doubtful accounts.

How to read the number: what counts as good

There is no universal target, because turnover is set mostly by your terms and your customer mix. Judge it against three yardsticks, in this order.

Against your own terms. This comparison needs no industry data. A business selling net-30 should collect in roughly 38 to 45 days once you allow for invoice transit, approval cycles and a payment run. Inside about 1.25 times your terms is tight control. Beyond 1.5 times terms — 45 days on net-30 — something structural is wrong, and it is usually inside your own building: invoices issued late, missing purchase-order numbers, disputed freight, or nobody making the calls.

Against your own trend. Turnover falling for three straight quarters while sales grow is the signature of revenue pushed out on loosened terms, and it is the shape auditors look for when testing for channel stuffing or premature revenue recognition.

Against your industry. The bands below are practitioner rules of thumb rather than measured statistics, so pull real figures from filed peer accounts before you quote them in a covenant or a board pack. Grocery and restaurant chains turn receivables very fast because they barely have any. Utilities and telecoms cluster in the low teens. Industrial distribution, business services and staffing sit in the high single digits, which is roughly 36 to 60 days. Construction and heavy engineering run lower still, because retentions and progress billing legitimately hold cash for months. A construction firm at 5 is not badly run; a staffing agency at 5 is in trouble.

One caution about high numbers: a collapse in sales shrinks the numerator while the book shrinks with a lag, so the ratio often spikes in a recovering quarter and dips during rapid growth. Read it next to the direction of revenue.

Turnover, collection days and receivables per $1m of sales

Each row is one consistent picture of the same business at 365 days. The last column is the receivable balance you must fund for every $1,000,000 of annual credit sales.
TurnoverCollection periodTypical terms it fitsAR per $1m of sales
24.3×15 daysNet 10, or card at point of sale$41,096
18.3×20 daysNet 15$54,795
12.2×30 daysNet 30, collected on time$82,192
9.1×40 daysNet 30, normal slippage$109,589
7.3×50 daysNet 45, or slow net 30$136,986
6.1×60 daysNet 60, collected on time$164,384
4.6×80 daysNet 60 with slippage; public-sector work$219,178
3.0×120 daysProgress billing with retention$328,767

Turnover = 365 ÷ collection days. AR per $1m = collection days × ($1,000,000 ÷ 365). Moving from 60 days to 40 releases about $55,000 of cash for every $1m of sales — permanently.

Where the inputs come from in a GAAP or IFRS filing

Take receivables from the balance sheet line Accounts receivable, net of allowance for doubtful accounts. Under US GAAP this is FASB ASC 310, and under IFRS it is IFRS 9's amortised-cost measurement of trade receivables; both present the net figure on the face of the statement with the allowance disclosed in the notes. Do not add contract assets, unbilled revenue, notes receivable, or amounts due from related parties — none of them are collected through the normal invoice cycle, and mixing them in makes the ratio meaningless. If you want the gross figure, the allowance is disclosed in the receivables note, and you can rebuild it with the bad debt expense calculator.

Mistakes that make this ratio wrong

  • Using total revenue instead of credit sales. Every cash sale in the numerator inflates turnover without ever touching the receivable balance.
  • Mismatching the periods. Quarterly sales against 365 days quadruples the apparent collection period. The sales window and the day count must be the same.
  • Averaging two points in a seasonal business. A December-heavy distributor needs 13 month-end balances, not January 1 and December 31.
  • Including unbilled or contract assets. Work in progress that has not been invoiced cannot be collected, so it does not belong in the denominator.
  • Reading turnover without the aging schedule. The ratio is an average and averages hide the concentration that actually causes write-offs.
  • Ignoring factoring and securitisation. Selling receivables removes them from the balance sheet and makes turnover jump for a financing reason, not an operational one. Check the cash-flow statement and the notes.
  • Benchmarking across industries. A ratio of 5 is healthy in construction and alarming in staffing.

Receivables turnover, days sales outstanding and an aging report are three views of one book, and they answer different questions.

Turnover is the comparison metric. It is dimensionless, it appears in credit-scoring models and covenant packages, and it sits beside inventory turnover and total asset turnover in a DuPont-style decomposition of return on assets.

Days sales outstanding is the same information in days, and days are what operating teams manage against. Use the DSO calculator for a monthly figure, a best-possible-DSO comparison, or the cash value of a one-day improvement.

An aging schedule is the diagnosis. Turnover and DSO tell you the book is slow; only the aging buckets tell you which accounts, how old, and how much will never arrive.

All of it lands in working capital: receivables plus inventory minus payables is the cash your operations consume. Run the working capital calculator for the dollar balance and the days payable outstanding calculator for the other side of the cycle. Do not fix a slow book by stretching suppliers without pricing it: forgoing a 2/10 net 30 discount to keep the cash 20 extra days costs (2 ÷ 98) × (365 ÷ 20) = about 37% a year.

Key terms

Net credit sales
Invoiced sales on terms, after returns, allowances and trade discounts. Excludes cash, card and COD sales because those never create a receivable.
Average accounts receivable
The mean trade receivable balance over the period. Two-point averaging uses opening and closing balances; 13-point averaging uses every month-end and is far better for seasonal firms.
Average collection period
Days in the period divided by turnover. The average age of a dollar of revenue at the moment it becomes cash. Also called days sales outstanding.
Allowance for doubtful accounts
A contra-asset that reduces gross receivables to the amount management expects to collect. Receivables in this ratio are normally net of it.
Days beyond terms
Collection period minus stated terms — the part of the delay you can manage, as opposed to the part you granted contractually.

Frequently asked questions

Should I use total sales or only credit sales in the numerator?

Use credit sales if you can get them, which you can for your own company from the billing system. Only invoiced sales create receivables, so including cash and card sales inflates turnover without touching the denominator. For an outside company you usually have no choice: the credit split is almost never disclosed, so analysts use net revenue and accept the bias. That is defensible as long as you apply the same treatment to every company and every period you compare.

Is a higher receivables turnover always better?

No. Very high turnover can mean credit terms so tight that you are losing sales to competitors who offer net-60, or that a sales slump has shrunk the numerator faster than the book. It can also be an artefact of factoring. Read turnover alongside revenue growth, gross margin and the aging report. The genuinely good pattern is stable or rising turnover while revenue grows and bad-debt expense stays flat.

Why does my turnover differ from the figure in a stock screener?

Screeners almost always use total revenue rather than credit sales, and many use the closing receivable balance rather than a two-point average. Both choices push the ratio up. Some also use gross receivables before the allowance, or a trailing-twelve-month revenue figure against a quarter-end balance. None of these is wrong, but they are different definitions — check which one a covenant or a peer table uses before you argue about the number.

What is a normal receivables turnover ratio?

It depends almost entirely on your terms and sector, and the sector figures analysts quote are rules of thumb rather than published statistics. Businesses paid at the till, such as grocery and food service, run very high because they hold almost no receivables. Utilities and telecoms sit in the low teens. Industrial distribution, business services and staffing typically land in the high single digits, which is 36 to 60 days. Construction and engineering with retentions run lower again. The test that needs no external data is your own terms: collection inside about 1.25 times your stated terms is good control.

How do I turn the ratio into a cash target for my team?

Work in days and multiply. One day of collection is worth one day of credit sales, so divide annual credit sales by 365 and you have the dollar value of every day. At $9.6m of credit sales that is $26,301 per day, so a five-day improvement releases about $131,500 of cash once and keeps it released. Set the target in days, not in ratio points, because days are what a collector can act on.

My business is highly seasonal. How should I average receivables?

Average all 13 month-end balances from the start of the period to its end, then divide by 13. A two-point average of a seasonal book can be off by a third or more. If you only have quarterly data, use the five quarter-end balances. State the method next to the ratio, because a change in averaging method looks exactly like a change in collection performance.

Does the ratio change if I factor or securitise receivables?

Sharply, and for a financing reason rather than an operating one. A true sale removes the receivable from your balance sheet, so the denominator falls and turnover jumps even though your customers pay no faster. If you are comparing periods or peers, read the receivables note and the financing section of the cash-flow statement, and add back sold receivables to get a like-for-like operating figure.

How does receivables turnover connect to the cash conversion cycle?

It is one of the three legs. Convert turnover to days, do the same for inventory and payables, and the cash conversion cycle is inventory days plus receivable days minus payable days. That total is the number of days you must fund operations from your own cash or a revolver. Use the cash conversion cycle calculator to assemble all three legs at once.

References

  • FASB Accounting Standards Codification Topic 310, Receivables — Financial Accounting Standards Board
  • Financial Reporting, Financial Statement Analysis and Valuation, 10th ed. — Cengage (Wahlen, Baginski & Bradshaw)
  • Analysis of Financial Statements, 4th ed. — Wiley (Fridson & Alvarez)
  • Intermediate Accounting, 18th ed. — Chapter 7, Cash and Receivables — Wiley (Kieso, Weygandt & Warfield)