Days in A/R: Formula & How to Calculate

This calculator works out the average number of days it takes a business to collect payment from its credit sales, known as Days Sales Outstanding (DSO) or days in accounts receivable. You enter the average accounts receivable balance and total credit sales for a period, and the calculator returns the average collection period in days. The formula divides average receivables by net credit sales, then multiplies by the number of days in the period.

Formula

The standard formula for days in accounts receivable is:

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

Where:

• Average Accounts Receivable = (Beginning A/R + Ending A/R) ÷ 2, in dollars
• Net Credit Sales = total sales on credit minus returns and allowances, in dollars
• Number of Days = 365 for a year, 90 for a quarter, 30 for a month

The result is expressed in days. A lower number generally means faster collection; a higher number means customers are taking longer to pay.

Worked Example

Using the calculator defaults: a 365-day period, average accounts receivable of $50,000, and net credit sales of $600,000.

1. Divide average A/R by net credit sales: $50,000 ÷ $600,000 = 0.08333
2. Multiply by the number of days: 0.08333 × 365 = 30.4 days

The calculator shows 30.4 days (rounded to one decimal). This means it takes about 30 days on average to collect a sale on credit.

Why Days in A/R Matters

Days in A/R is a key liquidity metric. It tells you how quickly a company converts credit sales into cash, which directly affects cash flow. A company with 60 days in A/R has to fund its operations for two months before seeing payment, while a company with 15 days can reinvest cash sooner. Lenders and investors watch this number because a rising trend may signal collection problems, overly generous credit terms, or customers in financial distress. Comparing it to your stated payment terms (e.g., net 30) shows how well you enforce those terms.

How to Calculate Average Accounts Receivable

Most companies use the simple average of the beginning and ending A/R balances for the period. For example, if a company starts the year with $40,000 in A/R and ends with $60,000, the average is ($40,000 + $60,000) ÷ 2 = $50,000. For more accuracy, especially if sales are seasonal, you can average monthly balances: add each month-end balance and divide by 12. The choice matters because a single beginning and ending balance can skew the result if one is unusually high or low.

Common Mistakes and How to Avoid Them

• Using total sales instead of credit sales – Cash sales are not receivables. Including them inflates the denominator and understates days in A/R.
• Mismatching periods – If you use annual sales, use 365 days. If you use quarterly sales, use 90 days. Mixing a month of sales with 365 days gives a meaningless number.
• Ignoring the average – Using the ending A/R balance alone can be misleading if the balance fluctuates. The average smooths out peaks and valleys.
• Rounding too early – Keep at least four decimal places in the division step to avoid a skewed final answer.
• Forgetting returns and allowances – Net credit sales means after deducting returns, not gross sales.

Interpreting the Result

Once you have your days in A/R, compare it to your credit terms. If your terms are net 30 and your days in A/R is 45, customers are paying 15 days late on average. If it’s 25, they’re paying early. A result significantly above your terms suggests you may need stricter collection efforts, credit checks, or late fees. However, the metric varies by industry: a construction company may have 60+ days, while a grocery store selling on credit might have 10. Always benchmark against your own historical trend and industry norms, not a universal number.

Limitations of the Formula

The formula assumes a steady rate of sales throughout the period. If sales are highly seasonal, the average A/R may not reflect the true collection speed. It also treats all receivables equally, even though some customers pay in 10 days and others in 90. The metric is an average, so it can hide collection problems in specific accounts. Additionally, the formula uses net credit sales, which may be difficult to extract from financial statements that report total revenue. In such cases, you may need to estimate the credit portion. Finally, the formula does not account for the time value of money – a dollar collected in 60 days is worth less than one collected in 30, but the formula treats them the same.

Alternatives and Related Metrics

• Accounts Receivable Turnover – Net credit sales divided by average A/R. This gives the number of times receivables are collected in a year. Days in A/R is 365 divided by this turnover.
• Aging Schedule – A report that breaks down receivables by how long they’ve been outstanding (e.g., 0-30, 31-60, 61-90 days). This shows which accounts are overdue, unlike the single average.
• Best Possible DSO – Uses only current receivables (not overdue) in the numerator. It shows the minimum possible collection period if all overdue accounts were paid immediately.
• Collection Effectiveness Index – Measures how much of the beginning A/R plus credit sales was collected during the period, expressed as a percentage.

Frequently Asked Questions

What is a good days in A/R number? There is no universal good number. It depends on your industry, credit terms, and customer base. Generally, a number close to or below your stated payment terms is considered healthy. For example, if you offer net 30, a days in A/R of 30 or less is good. If it exceeds 45, you may have collection issues.

Should I use 365 or 360 days? Many companies use 365 for calendar years, but some use 360 for simplicity or to match banking conventions. The key is consistency. If you compare your result to industry benchmarks, use the same day count they use. The calculator lets you adjust the period length.

What if my sales are all cash? Then days in A/R is zero or not applicable, because there are no receivables. The formula only makes sense when you sell on credit. If you have a mix of cash and credit, use only the credit sales in the denominator.

Can days in A/R be negative? No. A negative value would imply negative receivables, which is impossible in normal accounting. If your calculation produces a negative number, you likely entered a negative average A/R or sales figure. The calculator’s minimum inputs prevent this.

How often should I calculate days in A/R? Monthly is common for monitoring trends. A monthly calculation lets you spot seasonal patterns and the impact of new credit policies quickly. Annual calculation is useful for year-over-year comparisons but can hide short-term problems.

Does days in A/R include cash sales? No. The formula specifically uses net credit sales. Including cash sales would make the denominator larger and the days in A/R artificially lower, which would mislead you about collection performance.

Related

• Age Calculator: Time Duration in Years
• Age Calculator Online by Date of Birth: How It Works
• Age Calculator Online by Year: How It Works

in t | Period length | days | 365 | 1
in a | Average accounts receivable | $ | 50000 | 0
in s | Net credit sales | $ | 600000 | 0
out dso | Days in A/R | days | a / s * t | 1
out dso_month | Days in A/R (30-day month) | days | a / s * 30 | 1