How to Calculate A/R Days (with Formula)

This guide shows you how to calculate Accounts Receivable (A/R) Days, a key metric that tells you how many days, on average, it takes your customers to pay their invoices. You’ll need your total accounts receivable balance and your total credit sales for the period (usually a year or a quarter). The result is a single number that helps you assess cash flow and the effectiveness of your collections process.

Formula

The formula for A/R Days is:

A/R Days = (Average Accounts Receivable ÷ Total Credit Sales) × Number of Days in the Period

In plain terms: you divide the average amount of money tied up in unpaid invoices by the total credit sales for the period, then multiply by the number of days in that period. This converts the ratio into a “days� figure that is easy to compare month-to-month or against industry benchmarks.

Variables:

• Average Accounts Receivable – the mean of the beginning and ending A/R balances for the period (in your currency, e.g., USD, EUR). If you only have a single balance, use that.
• Total Credit Sales – all sales made on credit during the period, not cash sales (same currency).
• Number of Days – the length of the period: 365 for a year, 90 for a quarter, 30 for a month.

Worked Example

Let’s use the default values from the calculator above:

• Accounts Receivable = $50,000
• Credit Sales = $365,000
• Days in Period = 365

Step 1: Calculate daily credit sales: $365,000 ÷ 365 = $1,000 per day.

Step 2: Divide A/R by daily sales: $50,000 ÷ $1,000 = 50 days.

So, the A/R Days is 50 days. This means, on average, it takes 50 days from the sale to collect the cash.

When to Use A/R Days

Use this metric to monitor the health of your cash flow and credit policies. A rising A/R Days figure suggests customers are taking longer to pay, which could strain your cash reserves. A falling figure indicates faster collections. Compare your number to your payment terms (e.g., net 30) – if your A/R Days is consistently above your terms, you likely have collection issues. It’s also useful for benchmarking against industry averages, but keep in mind that different industries have very different norms (e.g., retail vs. construction).

Common Mistakes

• Using total sales instead of credit sales – Cash sales inflate the denominator, making your A/R Days look artificially low. Always use only credit sales.
• Forgetting to average A/R – Using a single month-end balance can be misleading if your sales are seasonal. Use the average of beginning and ending balances for the period.
• Mismatched periods – If your sales are for a quarter, use 90 days, not 365. Mixing periods gives a meaningless number.
• Ignoring the “daysâ€� multiplier – Some people just divide A/R by sales and get a decimal like 0.137, which is not intuitive. Always multiply by the number of days to get a “daysâ€� figure.
• Rounding too early – Round only at the final step to avoid small errors that can shift the result by a day or two.

Tips

• Calculate A/R Days monthly, even if you only report quarterly, to spot trends early.
• Segment your A/R by customer or by age (current, 30, 60, 90+ days) to see where the delays are coming from.
• Use the result to set collection targets – for example, if your terms are net 30, aim for an A/R Days below 35.
• If your business has significant seasonal swings, compare A/R Days year-over-year for the same month, not just month-over-month.
• Combine A/R Days with the “Aging Scheduleâ€� to identify which specific invoices are overdue.

Troubleshooting

My result seems too high. Check that you used credit sales, not total revenue. Also verify that your A/R balance is not inflated by one-off large invoices – consider removing those if they are not typical.

My result is too low. You might be using a single month-end A/R that is unusually low, or you included cash sales. Recalculate using the average A/R and only credit sales.

The calculator shows “Cannot compute�. This happens if your credit sales are zero or negative. Ensure you entered a positive number for sales.

I don’t have the average A/R. If you only have one balance, that’s fine for a rough estimate, but for accuracy, use (beginning + ending) ÷ 2.

My period is not a full year. Adjust the “Days in Period� input to match your sales period (e.g., 90 for a quarter). The formula will still work.

Frequently Asked Questions

Q: What is a good A/R Days number?
A: It depends on your payment terms and industry. If your terms are net 30, a number around 30–45 is common. Above 60 often signals collection problems.

Q: Should I include cash sales in the denominator?
A: No. Only credit sales should be used, because cash sales are collected immediately and don’t affect A/R.

Q: Can I use this for a single month?
A: Yes, just set the days to the number of days in that month (e.g., 30 or 31) and use that month’s credit sales and average A/R.

Q: Is A/R Days the same as Days Sales Outstanding (DSO)?
A: Yes, they are essentially the same metric. DSO is the more common name, but the calculation is identical.

Q: What if my A/R balance includes taxes or shipping?
A: Include them if they are part of the amount customers owe you. Just be consistent between periods.

Q: How often should I calculate A/R Days?
A: Monthly is typical, but if your business is volatile, weekly can give you a faster warning signal.

Related

• Cubic Feet to Cubic Yards Calculator
• Gallons to Cubic Yards: Formula and Conversion Calculator
• Convert Kg to Gallons: Formula and Examples

in ar | Accounts Receivable | $ | 50000 | 0 | 10000000
in sales | Credit Sales (period) | $ | 365000 | 0 | 100000000
in days | Days in Period | days | 365 | 1 | 366
out ar_days | A/R Days | days | ar / (sales / days) | 1