Last reviewed 13 August 2026
Work out how many times a year you collect your receivables balance, see the same result in days, and compare it against your sector.
The accounts receivable turnover ratio counts how many times you collect your average receivables balance in a period. Divide net credit sales by average accounts receivable.
Example: $400,000 of net credit sales against average receivables of $50,000. 400,000 / 50,000 = 8.0 times a year, which is an average collection period of 365 / 8 = 46 days.
Start with your opening and closing receivables. Two other ways to measure the receivables side are below. The sales side is the same in all three.
Enter a receivables balance above zero.
Enter a receivables balance above zero.
Averaging twelve month-end balances removes seasonality. Pair it with twelve months of credit sales, and leave the period set to annual.
| Month end | Receivables balance |
|---|
Enter at least one balance above zero.
Enter net credit sales above zero.
Key takeaways
AR turnover ratio
8.0 times
Typical. In line with the Paidnice customer data figure of 7.9 for wholesale and distribution.
Paidnice chases your overdue invoices automatically in Xero and QuickBooks.
No card required.
The ratio answers one question: how many times over did you collect the money owed to you during the period.
A ratio of 8 means the receivables balance emptied and refilled eight times in the year. A ratio of 4 means it emptied four times, so each invoice sat unpaid twice as long.
Nothing about the size of your business is in the number, which is what makes it comparable. A $2m business and a $200m business with the same collection discipline land on the same ratio.
Three groups read it, for three different reasons:
The quick version. If you billed $400,000 on credit and the average amount owed to you was $50,000, you collected that balance eight times. Eight turns a year is one turn every 46 days.
AR Turnover = Net Credit Sales / Average Accounts Receivable
Every input is a place the number goes wrong if you feed it the wrong figure. The order below is the order to work in.
Start with sales made on credit, then take off returns and allowances. Cash sales never touched receivables, so including them reports a ratio better than reality. This is the most common error on this metric, and it always flatters.
Opening balance plus closing balance, divided by two. The average exists to stop one large invoice raised on the last day of the period from rewriting the answer. Where sales are seasonal, average the twelve month-end balances instead.
Quarterly sales belong with quarterly balances, annual with annual. Mixing them is the fastest way to a ratio that is out by a factor of four, and it usually shows up as a suspiciously excellent quarter.
Sales divided by average receivables gives the ratio. Days in the period divided by the ratio gives the average collection period, which is the version most people outside finance can act on.
A distribution business opens the year with $45,000 in receivables and closes with $55,000. Net credit sales for the year are $400,000.
Now the useful part. Push the ratio to 9.0 and average receivables become 400,000 / 9 = $44,444, which releases $5,556 without selling anything extra. Push it to 10.0 and receivables fall to $40,000, releasing $10,000. That cash stays in your account for as long as the faster collection holds.
The ratio and the average collection period are one measurement in two units. Divide the days in the period by the ratio and you have the number of days an average invoice waits to be paid.
Average Collection Period = 365 / AR Turnover
Average collection period is the accounting textbook name for what credit teams call days sales outstanding. Same arithmetic, same answer, different vocabulary.
Use the ratio when you are reading receivables next to inventory turnover and payables turnover, because ratios sit together on a page. Use days when you are setting a collections target. No team is motivated by a request to raise a ratio by 1.4, and every team understands getting paid a week sooner.
Converting either way. A ratio of 8 is 46 days. A collection period of 60 days is a ratio of 6.1. For the days version with four calculation methods and a per day cash figure, use the DSO calculator.
There is no universal good ratio. Read yours against your own payment terms first, because terms set the ceiling.
A business invoicing on net 30 cannot realistically beat about 12 turns a year, because 365 / 30 is 12.2. On net 30 and turning over 6 times, your invoices are running roughly a month past due.
These bands track the calculator above. Change your figures and the band your annualized ratio falls into is marked.
Stalled
Under 4 times
Over 90 days to collect. Bad debt risk is already building.
Your result
Slow
4 to 8 times
45 to 90 days. Normal in construction, a problem in services.
Your result
Typical
8 to 15 times
24 to 46 days. The band most B2B businesses on net 30 land in.
Your result
Fast
Above 15 times
Under 24 days. Usual where sales settle at the point of sale.
Your result
Direction beats level. A ratio of 6.5 rising for three periods is a healthier signal than 9.0 falling for three, because the first says your process is working and the second says something changed that nobody has explained yet.
Two sets of figures sit below, and they are kept apart because they describe different businesses. The first is our own customer data, from small businesses running Xero and QuickBooks. The second is published data on listed companies. Every row says which set it belongs to. Your bar moves with the calculator, and the sector you selected is picked out alongside it.
| Sector | Turnover ratio | Typical range | Same as | Why |
|---|---|---|---|---|
| Your business | 8.0 | From the calculator | 46 days | Annualized so it lines up with the figures below |
| Retail and ecommerce | 20.3 | 13.0 to 40.6 | 18 days | Most sales settle at the point of sale |
| Software and SaaS | 10.7 | 8.1 to 14.0 | 34 days | Card and direct debit shorten the tail |
| Business services | 9.6 | 7.4 to 12.2 | 38 days | Mostly net 30, monthly billing cycles |
| Professional services | 8.7 | 6.6 to 11.4 | 42 days | Milestone billing, slow client approvals |
| Wholesale and distribution | 7.9 | 6.3 to 9.6 | 46 days | Trade credit is part of the offer |
| Manufacturing | 7.0 | 5.4 to 8.7 | 52 days | Long supply agreements, larger invoices |
| Construction and trades | 5.9 | 4.6 to 7.6 | 62 days | Retentions and progress claims stretch terms |
| Not listed, mixed B2B | 9.1 | Not published | 40 days | The row to use if none of the sectors above fits |
Source: Paidnice customer data, August 2026.
| Industry | Turnover ratio | Same as | Why |
|---|---|---|---|
| Retail (general) | 28.1 | 13 days | Largely paid at the point of sale |
| Food processing | 13.0 | 28 days | Short terms, perishable goods move fast |
| Trucking | 8.1 | 45 days | High invoice volume, frequent short pays |
| Retail (distributors) | 7.8 | 47 days | Trade credit is part of the offer |
| Software (system and application) | 5.9 | 62 days | Enterprise contracts, annual billing on terms |
| Business and consumer services | 5.4 | 67 days | Milestone billing, slow client approvals |
| Machinery | 5.3 | 69 days | Long supply agreements, larger invoices |
| Electronics (general) | 5.2 | 70 days | Large contract values, negotiated terms |
| Engineering and construction | 3.7 | 100 days | Retentions and progress claims stretch terms |
| Not listed, whole market excluding financials | 8.1 | 45 days | The row to use if none of the industries above fits |
Source. Each ratio is 365 divided by the collection period for the same industry on our DSO calculator, so the two pages cannot contradict each other. Those collection periods are derived from Working Capital Requirements by Industry Sector, Aswath Damodaran, NYU Stern School of Business, data as of January 2026, which publishes accounts receivable as a percent of revenue for each industry. Industry names and sample sizes are his.
Read these as large company figures. The sample is listed companies, which sell to bigger buyers on longer terms than a typical small business ledger does. The same calculation on the whole market excluding financials gives 8.1 turns a year, and the Credit Research Foundation National Summary of Domestic Trade Receivables reported DSO of 40.12 days for the first quarter of 2026, which is 9.1 turns. Reviewed 15 August 2026.
Only the Paidnice table carries a typical range. The NYU dataset publishes one aggregate figure per industry rather than quartiles, so a range for those rows would have been invented.
The two sets disagree, and that is the useful part. Software turns 10.7 times a year in our customer data and 5.9 times in the listed company data, which is 34 days against 62. Listed companies sell to large buyers who dictate long terms. Paidnice customers invoice smaller buyers on shorter terms and chase sooner. If you run a small business on Xero or QuickBooks, compare yourself against the Paidnice row. If you file public accounts, use the NYU row.
The sales side of the formula never changes. The receivables side has three defensible versions, and they answer slightly different questions.
| Method | Receivables figure | Best for | Weakness |
|---|---|---|---|
| Average balance | (Opening + closing) / 2 | The default. Annual reporting, lender packs, textbook comparisons | Two data points cannot see what happened in between |
| Ending balance | Closing balance only | A quick read when you have no opening figure | One large late invoice swings the whole ratio |
| 12 month-end | Average of twelve month-end balances | Seasonal businesses and anyone whose sales are lumpy | Needs a year of history, slow to show a recent gain |
Whichever you pick, keep it the same every period. A trend assembled from mixed methods is not a trend, and switching method is the easiest way to accidentally report an improvement that never happened.
Benchmarks are quoted annually. If your figures cover a quarter, multiply the ratio by 365 divided by the days in your period before you compare: a quarterly ratio of 2.0 becomes 2.0 x (365 / 91) = 8.0.
The calculator above does this and shows both. Comparing a raw quarterly ratio against an annual benchmark makes healthy collections look four times worse than they are.
Before you treat a falling ratio as a collections failure, work out which of these is driving it. Two of the five are not collections problems at all.
Check the denominator before you act. If receivables grew because sales grew, the ratio can hold steady while the cash gap widens in absolute dollars. Read the ratio next to the balance, never on its own.
The ratio rises when the gap between issuing an invoice and collecting it narrows. It rises fastest when the chasing stops depending on anyone remembering to do it.
Paidnice tracks receivables turnover and collection days from your Xero or QuickBooks data, and updates them as payments land.
See AR reportingPut net credit sales in A1, opening receivables in B1 and closing receivables in C1.
=AVERAGE(B1:C1)=A1/AVERAGE(B1:C1)=365/D1=A1/AVERAGE(B2:B13)=D1*(365/E1)=IF(AVERAGE(B1:C1)=0,"",A1/AVERAGE(B1:C1))Watch the export. If your accounting system gives you total revenue rather than credit sales, the spreadsheet will report a ratio better than reality, and the error grows with your cash sales. Filter those rows out before you divide.
Turnover answers how often. The related measures answer how long, how much and how well, and they are far more useful read together than alone.
| Metric | Question it answers | Unit |
|---|---|---|
| AR turnover | How many times receivables convert per period | Ratio |
| DSO, average collection period | How many days until we get paid | Days |
| AR aging analysis | Which balances are late, and by how far | Buckets |
| Collection efficiency | How much of what was collectable we collected | Percent |
| Bad debt expense | How much of the balance we expect to lose | Dollars |
| Cash conversion cycle | Total days from paying suppliers to banking cash | Days |
Read them as a sequence. Turnover tells you the speed changed. Aging tells you which balances changed. Collection efficiency tells you whether the change was your team or your terms.
If the ratio falls while collection efficiency holds, your terms or customer mix moved. If both fall together, collections did. Keeping that picture current without rebuilding a spreadsheet every month is what AR reporting is for.
Sources are cited for the benchmark figures only. Everything else on this page is computed from the figures you enter. Reviewed 15 August 2026.
Divide net credit sales for the period by average accounts receivable. Average accounts receivable is the opening balance plus the closing balance, divided by two. The formula is AR Turnover = Net Credit Sales / Average Accounts Receivable. If you billed 400,000 on credit and held 50,000 in receivables on average, the ratio is 8.0, meaning you collected the balance eight times in the year.
AR Turnover Ratio = Net Credit Sales / Average Accounts Receivable. Net credit sales are credit sales less returns and allowances, with cash sales excluded. Average accounts receivable is (beginning AR + ending AR) / 2. Both figures have to cover the same period. The result is a count of times rather than a percentage, so a ratio of 9 means the receivables balance turned over nine times.
Use the same formula with figures from that period only: quarterly credit sales over quarterly average receivables. The answer is a quarterly ratio. To compare it against annual benchmarks, multiply by 365 divided by the days in the period, so a quarterly ratio of 2.0 is roughly 8.0 annualized. Comparing a quarterly ratio directly against an annual one makes collections look four times worse than they are.
Divide the days in the period by the turnover ratio. On an annual basis that is 365 / AR Turnover, and the answer is your average collection period, the same measure finance teams call days sales outstanding. A ratio of 8.0 gives 365 / 8 = 46 days. It is the identical information expressed in days rather than as a count of turns.
There is no single number. Read it against your payment terms first and your sector second. As orientation, below 4 usually means collections have stalled, 4 to 8 is slow for most B2B, 8 to 15 is typical, and above 15 is fast and common in retail. A business on net 30 terms should expect roughly 8 to 12. The direction over three periods matters more than the level.
They are the same measurement in different units. AR turnover counts how many times you collect the receivables balance in a period. DSO, also called the average collection period, converts that into days: 365 divided by the ratio. Turnover suits ratio analysis alongside inventory and payables turnover. Days suit collections targets, because a team can act on the sentence "we get paid in 46 days".
Add the opening receivables balance to the closing balance and divide by two. If sales are seasonal, or a large invoice landed near period end, average the twelve month-end balances instead, which removes most of the distortion. Using the closing balance on its own is acceptable when you have nothing else, but the ratio will then jump every time one big invoice lands late.
Most accounting systems will not split credit and cash sales for you. Run a sales report and remove point of sale takings, card at checkout and prepaid revenue, because none of those ever sat in receivables. If you genuinely cannot split them, use total revenue, label the result clearly, and never compare it against a period you calculated on credit sales only.
Put net credit sales in A1, opening receivables in B1 and closing receivables in C1, then enter =A1/AVERAGE(B1:C1) in D1. Add =365/D1 for the average collection period in days. For a twelve month average with month-end balances in B2:B13, use =A1/AVERAGE(B2:B13). Wrap it to survive an empty ledger: =IF(AVERAGE(B1:C1)=0,"",A1/AVERAGE(B1:C1)).
It can. A ratio far above your sector usually means credit terms are tight, deposits are large, or most sales are settled in cash. That is a good outcome when it is deliberate and a problem when it is quietly costing you customers who would have paid. Check whether sales growth slowed in the same period before you treat a high ratio as a win.
Three causes account for most of it: invoices raised later than the work finished, chasing that happens when someone remembers rather than on a schedule, and a shift toward larger customers who pay on longer terms. The third is a commercial choice rather than a collections failure. Read the aging profile before you change anything, because it separates the three in about a minute.
Paidnice takes the pain out of getting paid for thousands of businesses using Xero and QuickBooks.
INV-434
Acme Inc Ltd
Request an AI summary of Paidnice
