Accounts receivable turnover ratio: formula, days sales in receivables and a worked example

The AR turnover ratio, accounts receivable turnover, is net credit sales divided by average accounts receivable: how many times the receivables balance is collected in a period. Quarterly credit sales of $2,400,000 on average receivables of $1,200,000 give a turnover of 2.0 for the quarter, 8.1 a year. Converted to days, that is 45.0 days sales in receivables: customers pay, on average, 45 days after the invoice.

Formula and meaning

AR turnover = Net credit sales / Average accounts receivable

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

Days sales in receivables = Days in period / AR turnover = Average receivables / Net credit sales × Days in period

The Corporate Finance Institute gives the same accounts receivable turnover formula, with average receivables as the start and end balances divided by two, and the annual conversion as 365 / turnover. Receivables turnover and days of sales outstanding are both standard activity ratios in the CFA Institute's reading on financial analysis techniques. Turnover and days say the same thing in two units: a higher turnover is a shorter wait for cash.

The rows you need

Same entity, same period, same tax treatment on both sides: if sales are net of sales tax, receivables must be too. Use trade receivables from customers only, and the same choice every period on the allowance for credit losses under ASC 326, gross or net.

Worked: one quarter

The quarter from days sales outstanding: January 1 to March 31, 2026, 90 days, net 30 terms. Credit sales were $2,400,000, receivables were $1,175,000 at December 31, 2025 and $1,225,000 at March 31, 2026.

In Excel, with sales in B2, opening receivables in C2 and closing in D2:

=B2/((C2+D2)/2)          turnover for the quarter
=B2/((C2+D2)/2)*365/90   annualized turnover
=90/(B2/((C2+D2)/2))     days sales in receivables

Annualize by the days, never by multiplying a quarter's turnover by four without saying so: 2.0 × 4 = 8.0 assumes a 360-day year.

Days sales in receivables, DSO and debtor days

Three names for one idea. Days sales in receivables is the textbook term; DSO, days sales outstanding, is what most US finance teams report; debtor days is the UK name. What differs is the balance:

• Average receivables (this page) smooths the period: 45.0 days.
• Closing receivables, the usual DSO, reflects where the quarter ended: 45.9 days, because the balance grew by $50,000 during the quarter.

Neither is wrong. State which one you report and keep it. When sales are uneven across the months, the countback method in days sales outstanding is better than either.

By customer: where the days sit

The same five customers, with opening balances added. Turnover in E2 is =B2/((C2+D2)/2) and days in F2 are =90/E2, filled down:

The check: weight each customer's days by its credit sales and the result must equal the company figure. Harlow is 900,000 × 41.0, and the five sales × days figures sum to 108,000,000; 108,000,000 / 2,400,000 = 45.0 days. In Excel, =SUMPRODUCT(B2:B6,F2:F6)/SUM(B2:B6) must equal F7. The simple average of the five, 41.5 days, is wrong because it weights Ashby like Harlow. The opening and closing totals must also tie to the AR aging report and the trade receivables balance in the general ledger on each date.

Against payment terms

On net 30, days beyond terms is days in receivables less 30:

Northgate and Brightwell hold $645,000, 53.8% of average receivables, on 43.8% of credit sales. They are the chase list, and before their next order ships, check their credit limit headroom. When two customers hold most of the balance, the risk is also a concentration question: see customer concentration. The same days-beyond-terms test, run on what you pay suppliers, is in payment terms compliance.

Where it goes wrong

• Total sales instead of credit sales. Cash sales never become receivables, so including them overstates turnover.
• Sales tax in receivables but not in sales. Invoices carry tax that sales exclude: at an 8% sales tax rate, 45.0 days reads as 48.6, overstated by 8%.
• A seasonal year-end balance. A balance that is unusually low or high at the period end, used as if typical. Average the month-end balances instead of only opening and closing.
• Credit memos and disputes left in receivables. A reversed sale that still sits in the balance makes collection look slower than it is.
• Write-offs. A write-off lowers receivables, so turnover improves just when collection got worse.

Receivables with the sales data beside them

The company ratio is the sum of what each customer does. Covirage joins your AR aging export to invoices and terms, and its tools compute days in receivables and days beyond terms per customer, reconciled to the ledger balance; the external AI model explains who moved the figure and never does the arithmetic. See Covirage for finance teams. In days, receivables turnover is one leg of the cash conversion cycle, with inventory days and days payable outstanding; together they set working capital.