Accounts Receivable Turnover Calculator

Accounts receivable turnover formulas, with Excel and Google Sheets versions

Each result above comes from one of these formulas. The examples use the calculator's default numbers, which describe an illustrative B2B SaaS company over one year. The cell formulas work the same in Excel and Google Sheets.

B2 is beginning accounts receivable, B3 ending accounts receivable, B4 net credit sales or billings for the period and B5 the days in the period. C2 is recognized revenue, C3 beginning deferred revenue and C4 ending deferred revenue. Format the turnover cells as numbers with two decimals and the days cells with one.

The formulas are the standard textbook ones. OpenStax's Principles of Financial Accounting defines the ratio as net credit sales over average accounts receivable and the number of days' sales in receivables as 365 divided by the ratio. Its worked example turns $400,000 of credit sales over $80,000 of average receivables into a ratio of 5 and 73 days.

How to calculate the accounts receivable turnover ratio, step by step

1. Pick the period. A full year is the standard. A quarter or a month gives a faster signal, as long as you annualize it before comparing.
2. Pull net credit sales. Take sales made on terms, less returns, credits and allowances. Leave out cash and card sales that never sat in receivables. In SaaS, take billings: every invoice sent in the period, including annual renewals invoiced upfront.
3. Pull receivables for both ends of the period. Use gross open invoices from the balance sheet or the AR aging, with the same treatment of the allowance for doubtful accounts each time.
4. Average them. Add beginning and ending receivables and divide by two. If the business is seasonal, average more points, such as the five quarter-end balances from the start of the year to its end.
5. Divide. Credit sales over average receivables is the turnover. Days in the period divided by the turnover is the average collection period.
6. Compare with terms. On net 30, customers who all pay on the due date produce a turnover of about 12 (365 / 30). Everything below that is late payment, billing timing, or both.

Worked example with the calculator's defaults

The numbers are illustrative. A B2B SaaS company on net 30 terms closes its fiscal year.

• It bills $14,400,000 in the year, about $39,452 a day. Recognized revenue is $12,000,000, and deferred revenue rose from $4,000,000 to $6,400,000 as more customers moved to annual invoices.
• Receivables were $1,600,000 at the start of the year and $2,000,000 at the end, so average receivables are $1,800,000.
• Turnover is $14,400,000 / $1,800,000 = 8.00 times, and the average collection period is 365 / 8 = 45.6 days, 15.6 days past net 30.
• On ending receivables alone the ratio is 7.20 and the collection period 50.7 days. Year-end balances run high when the fourth quarter is the biggest billing quarter.
• On recognized revenue the ratio would be 6.67 and the collection period 54.8 days: 9.1 days worse, with the same customers paying the same way.

The same receivables give three different ratios depending on the numerator and the balance used. Pick one definition, write it on the report, and keep it. For the days view, best possible DSO and the countback method, use the DSO calculator.

Why SaaS companies should use billings, not revenue

Receivables come from invoices, so the numerator should be invoices too. In a product business, invoices and revenue land in the same period, which is why the textbook says "sales." In SaaS they split apart. A $120,000 annual contract billed upfront puts $120,000 in receivables on the invoice date, while revenue is recognized at $10,000 a month. Divide receivables into revenue and the turnover understates how fast customers pay.

Billings is revenue plus the change in deferred revenue. Slack's 2019 SEC filing defined calculated billings as "revenue plus the change in our deferred revenue". ORM's entry on billings covers the variants, and billings vs revenue walks one contract through both. The gap grows with the share of annual and multi-year invoices, so a company that moves customers from monthly to annual billing sees its revenue-based turnover fall even if every customer pays on time.

Quarterly and monthly AR turnover, and the seasonality trap

A quarterly ratio is not comparable with an annual one until you annualize it. A quarter with $3,600,000 of billings and average receivables of $1,850,000 turns 1.95 times. Multiply by 365 and divide by 90, and it is 7.9 times a year. The calculator does this when you change the days.

Seasonality changes the averages. Pete Furseth, ORM's COO, sees the same pattern across ORM's customers: the fourth quarter is typically the largest, followed by the second, third and first, and within a quarter the third month is always the largest. A year-end receivables balance therefore holds a big share of December invoices that are not due yet. Two points, January 1 and December 31, both sit at a seasonal high or low. Five quarter-end balances average it out better, and monthly balances better still.

What is a good accounts receivable turnover ratio?

A good ratio is one close to what your payment terms allow. Terms set the ceiling: if every customer paid on the due date, net 30 would give a turnover of about 12 and net 60 about 6. Published benchmarks are usually stated in days, so convert them with 365 / days.

Upflow does not say whether each company measured DSO on revenue or billings, so treat the conversions as a market reference. For larger companies, The Hackett Group's 2025 Working Capital Survey of the top 1,000 US public nonfinancial companies found an 18-day DSO gap between top and median performers and put the receivables opportunity at $600 billion. Your own trend, on one definition, matters more than any of these.

AR turnover next to the other cash metrics

What Pete Furseth sees in SaaS receivables

• The calendar moves the ratio. Most SaaS businesses close and bill the most in the last month of a quarter and the last quarter of the year. Compare a period with the same period last year, not with the one before it.
• Sales owns part of the number. In his guide to billings vs cash collections, Pete notes that a rep near quarter end will trade longer payment terms for a signature, because the booking counts either way. Longer terms lower the turnover for a full year.
• A renewal invoice is a retention moment. "If you send them an invoice 30 days before their renewal and never talk to them, you are putting that renewal at more risk." An unpaid renewal invoice is often a churn signal before it is a collections problem.
• The same number on every slide. "If you show one number on one slide, that number better show up on the next, or there should be a clear explanation for why it changed." Label which numerator and which balances the ratio uses.

How to improve your accounts receivable turnover

• Invoice on the contract start date. Every day between signature and invoice is a day you added yourself.
• Collect the PO number and the AP contact at signing. Missing purchase order numbers and invoices sent to the wrong person are two of the most common reasons an invoice sits unpaid past its terms.
• Put payment terms on the deal record. Report terms concessions by rep and by quarter, so longer terms are a decision, not a habit.
• Offer ACH and card on smaller accounts. A small invoice costs as much to chase as a large one.
• Apply cash the day it arrives. Unmatched payments still show as open receivables and pull the ratio down.
• Forecast collections from billings. The cash flow forecast template turns billings and a payment curve into monthly cash.

Common AR turnover mistakes

• Using total sales instead of credit sales. Cash and card sales never sat in receivables, so they inflate the ratio.
• Using recognized revenue in a SaaS company. With annual upfront billing it understates turnover.
• Comparing a quarterly ratio with an annual one. Annualize first, or the quarter looks four times worse.
• Averaging two seasonal balances. Use quarter-end or month-end balances when billings bunch.
• Changing the definition quietly. Gross or net of the allowance, billings or revenue, average or ending receivables: choose once and say so on the report.

ORM's take on AR turnover and the bookings forecast

AR turnover tells finance how fast a billed dollar becomes cash. The larger uncertainty sits earlier, in which deals close, in which week, at what size and on what terms. A collections forecast built on a bookings forecast that is wrong will be wrong by the same amount.

That is what ORM forecasts. We build bookings and ARR forecasts from your own CRM data, with a low case, an on-target case and an upper bound, and with the week-by-week seasonality of your quarter built in. ORM targets 95% accuracy on the forecasts it builds.

Common questions

How do you calculate the accounts receivable turnover ratio?

Divide net credit sales for the period by average accounts receivable, which is beginning plus ending receivables divided by two. With $14,400,000 of credit sales and receivables of $1,600,000 at the start of the year and $2,000,000 at the end, average receivables are $1,800,000 and turnover is 8.0 times. In SaaS, use billings as credit sales.

What is a good accounts receivable turnover ratio?

There is no single good number, because payment terms set the ceiling. Net 30 terms paid on time give about 12 turns a year, and net 60 about 6. For a reference point, Upflow's 2024 data put median SaaS DSO at about 59 days, which converts to a turnover of about 6.2. Compare yourself with your own terms and your own trend first.

What is the average collection period?

The average collection period is the number of days it takes, on average, to collect a receivable. It is 365 divided by the annual accounts receivable turnover ratio, so a turnover of 8.0 is an average collection period of about 45.6 days. On the same inputs it equals DSO measured on average receivables, which is why the two terms are often used for the same number.

Is a high accounts receivable turnover ratio good?

Usually, yes. A higher ratio means customers pay faster and less cash sits in receivables. A ratio far above what your terms allow can also mean credit terms are tighter than buyers accept, or that most customers pay by card upfront and the ratio says little. A falling ratio with steady sales is the signal to act on, because it means collections are slowing.

How do you calculate AR turnover for a quarter or a month?

Use the credit sales for that quarter or month and the average receivables for the same period, then annualize the result so it compares with yearly figures. Multiply a quarterly turnover by 365 and divide by the days in the quarter. A quarter with $3,600,000 of billings and $1,850,000 of average receivables turns 1.95 times, about 7.9 times a year.

What is the difference between accounts receivable turnover and accounts payable turnover?

They measure opposite sides of the same cash cycle. Accounts receivable turnover is credit sales divided by average receivables and shows how fast customers pay you. Accounts payable turnover is purchases (or cost of goods sold) divided by average payables and shows how fast you pay suppliers. The days versions, DSO and DPO, feed the cash conversion cycle.

More free tools

DSO CalculatorDays sales outstanding from AR and billings, best possible DSO, the countback method and a SaaS billings vs revenue check.Open the tool →Cash Conversion Cycle CalculatorCCC = DIO + DSO - DPO from your statements or from days, with DPO on COGS vs purchases for SaaS.Open the tool →Working Capital CalculatorWorking capital, the working capital and quick ratios, operating working capital with and without deferred revenue, and the change in working capital.Open the tool →