A/R Turnover Ratio: Formula and How to Calculate It

The accounts receivable (A/R) turnover ratio shows how many times a business collects its average receivables during a period. Enter net credit sales and beginning and ending accounts receivable to calculate the ratio, expressed in times per period. Use figures from the same accounting period and keep sales and receivables on a consistent basis.

Formula

A/R turnover ratio = net credit sales ÷ average accounts receivable

• Net credit sales are sales made on credit during the period, after sales returns, allowances, and discounts as applicable. They are measured in the business’s currency, such as dollars or euros.
• Average accounts receivable (average A/R) = (beginning A/R + ending A/R) ÷ 2. Both balances are measured in the same currency and represent receivables at the start and end of the period.
• A/R turnover ratio is stated in times per period. It has no currency unit because the sales and receivables amounts cancel out.

The calculator uses the beginning and ending balances to estimate average receivables. If reliable monthly or quarterly balances are available, averaging those balances can better represent fluctuations across the period. The sales figure should cover exactly the same period as the receivables figures.

Worked Example

Using the calculator’s default values: net credit sales are $500,000, beginning A/R is $40,000, and ending A/R is $60,000.

1. Calculate average A/R: ($40,000 + $60,000) ÷ 2 = $50,000.
2. Divide net credit sales by average A/R: $500,000 ÷ $50,000 = 10.
3. Report the result as an A/R turnover ratio of 10.00 times for the period.

This means sales on credit during the period were ten times the average receivables balance. It does not mean every customer paid exactly ten times or that all invoices were collected evenly.

What You’ll Need

• Net credit sales for the period, preferably from the income statement or sales records.
• Accounts receivable at the beginning and end of that period, from the balance sheet or accounting records.
• A consistent reporting period and currency. For example, compare annual credit sales with receivables measured at the start and end of that year.

If your records show total sales but do not separate cash and credit sales, use a reliable breakdown from the sales ledger. Total sales can be a rough substitute only when credit sales cannot be isolated; label the result as an estimate because cash sales can inflate the ratio.

Step-by-Step

1. Choose a reporting period. Decide whether you are calculating for a month, quarter, or year. Use the same period for net credit sales and the change between beginning and ending A/R. When comparing periods, use matching lengths.
2. Find net credit sales. Start with sales made on credit during that period. Subtract returns, allowances, and discounts if they are included in the sales figure and your accounting records treat them as reductions to sales. Do not include cash sales when you can identify credit sales separately.
3. Record beginning A/R. Use the accounts receivable balance on the first day of the period, typically the closing balance from the preceding period. Check that it represents outstanding customer invoices, not cash or unrelated assets.
4. Record ending A/R. Use the balance on the final day of the same period. Make sure the amount is stated in the same currency and follows the same accounting treatment as beginning A/R.
5. Calculate average A/R. Add beginning and ending receivables, then divide by two. For instance, balances of $40,000 and $60,000 produce average A/R of $50,000.
6. Divide net credit sales by average A/R. The result is the turnover ratio for the period. Keep the period attached to the result, such as “8.4 times per year,” rather than presenting the number without context.
7. Review and compare carefully. Compare the ratio with the business’s own prior periods and, where useful, similar businesses. Check whether credit terms, sales mix, seasonality, or collection policies changed before drawing conclusions.

Common Mistakes

• Using total sales without noting cash sales. Cash sales do not create receivables. Including them can make turnover look higher than credit collection activity suggests.
• Using ending A/R instead of average A/R. A single closing balance may be unusually high or low. The standard basic calculation uses the average of beginning and ending balances.
• Mixing periods. Annual sales divided by monthly or quarterly receivables, or figures from different fiscal periods, produce a misleading result.
• Mixing currencies or accounting bases. Convert amounts to one currency and confirm balances are prepared consistently before calculating.
• Assuming a higher ratio is always better. Faster collection can support cash flow, but a very high ratio may also reflect restrictive credit terms that deter customers. The ratio alone does not explain why it changed.
• Rounding too early. Keep the full amounts through the average and division, then round the final ratio consistently, usually to two decimal places.

Tips

• Use monthly or quarterly average balances for seasonal businesses or businesses with large swings in invoices. The simple two-point average can miss changes that occurred during the period.
• Keep the calculation method consistent across reporting periods so changes are easier to interpret.
• Pair the ratio with an A/R aging report and collection information. These can show overdue invoices and concentration that a single turnover figure cannot.
• For a rough estimate of collection time, divide the number of days in the period by turnover. For example, for a 365-day year and turnover of 10, the estimate is 36.5 days. This is an approximation, not a substitute for invoice-level aging.

Troubleshooting

The result seems unusually high: Confirm that the sales input is credit sales rather than all sales, and check whether average A/R is entered in the same currency and scale. A balance entered as 50 instead of 50,000 can distort the result.

The result seems unusually low: Check for sales returns, credits, or a large ending receivables balance. Review whether old invoices, disputed balances, or a seasonal sales surge explain the number. Do not change inputs merely to make the ratio look typical.

Beginning A/R is zero or unavailable: Use a verified opening balance from the prior period’s records. If it cannot be found, you may calculate using ending A/R as a rough proxy, but disclose that this is not the standard average-balance method.

Credit sales are not reported separately: Look for a credit-versus-cash breakdown in the sales ledger. If unavailable, calculate an explicitly labeled estimate using total sales, or ask the person responsible for the accounting records for the appropriate figure.

Receivables are negative or average A/R is zero: Check for data-entry errors, customer credits, prepayments, or balances recorded in the wrong account. The standard ratio is not meaningful when average A/R is zero, and unusual negative balances need review before calculation.

Frequently Asked Questions

What does the A/R turnover ratio measure?
It measures net credit sales relative to average accounts receivable during a specified period. It is one indicator of how quickly receivables turn into sales and collections.

What is a good A/R turnover ratio?
There is no universal ideal. Compare the result with the business’s history, its credit terms, seasonality, and relevant industry peers, using consistent calculation methods.

Can I use total revenue instead of net credit sales?
Only as a clearly identified estimate when credit sales are unavailable. Revenue may include cash sales or other income that does not create accounts receivable.

Should I use monthly or yearly figures?
Either can work if sales and receivables cover the same period. Monthly calculations can reveal short-term changes; annual calculations give a broader view. State the period with the result.

How is A/R turnover different from days sales outstanding?
A/R turnover is a ratio of credit sales to average receivables. Days sales outstanding estimates the time to collect, often by dividing days in the period by turnover, though exact methods can vary.

Does a high ratio prove customers pay on time?
No. It is an overall measure and can hide overdue accounts or differences among customers. Review invoice aging and payment records for a fuller picture.

Related

• Year to Minutes: Convert a Year Into Minutes
• Angle to Radians Formula and Conversion Examples
• Light Years to Kilometers: Conversion and Examples

in sales | Net credit sales | $ | 500000 | 0
in begin_ar | Beginning accounts receivable | $ | 40000 | 0
in end_ar | Ending accounts receivable | $ | 60000 | 0
out turnover | A/R turnover ratio | times | sales / ((begin_ar + end_ar) / 2) | 2
out avg_ar | Average accounts receivable | $ | (begin_ar + end_ar) / 2 | 2