Average Collection Period Calculator

Receivables Collection Period Calculator

Average Collection Period Formula

Formula

\[ \text{Average Collection Period} = \frac{\text{Accounts Receivable}}{\text{Net Credit Sales}} \times \text{Number of Days} \]

Where:

$AR$ — accounts receivable, the total amount customers currently owe the business ($)
$CS$ — net credit sales, total sales made on credit minus returns and allowances ($)
$D$ — number of days in the period, typically 365 for annual or 90 for quarterly analysis

The formula first finds what fraction of a period's credit sales is still uncollected, then converts that fraction into days. The result is the average number of days between making a credit sale and receiving the cash.

Average Collection Period – Calculation Example

Example: a company has $25,000 in accounts receivable and recorded $150,000 in net credit sales over the past year (365 days).

\[ \text{Average Collection Period} = \frac{25{,}000}{150{,}000} \times 365 = 0.1667 \times 365 \approx 60.83 \text{ days} \]

Result: the company takes about 60.83 days on average to collect payment from its customers.

How to Use the Calculator

Enter your Accounts receivable balance — the amount currently owed to you by customers.
Enter your Net credit sales — total credit sales for the period, after subtracting returns and allowances.
Enter the Number of days matching your sales figure: 365 for annual data or 90 for quarterly data.
Read the Average Collection Period in days, along with an interpretation of whether collections are fast, moderate, or slow.

What Is the Average Collection Period?

The average collection period (also called days sales outstanding, or DSO) measures the average number of days a business needs to turn its credit sales into cash. It is a core liquidity and efficiency metric for any company that sells on credit, because receivables only become useful once they are actually collected.

A short collection period means customers pay quickly, cash flows back into the business sooner, and less working capital is tied up in receivables. A long collection period means money sits with customers longer, which can strain cash flow even when sales and profits look healthy on paper.

How you interpret the number depends heavily on context. Many industries operate on 30-day payment terms, so a period of 30–45 days may be perfectly normal, while businesses in construction or wholesale often see 60–90 days as standard. The most useful comparisons are against your own credit terms (if you offer net 30 and collect in 55 days, customers are paying late) and against your results in previous periods, where a rising trend is an early warning sign.

The average collection period is closely related to liquidity ratios and overall asset efficiency — together with metrics like total asset turnover, it shows how productively the business converts its resources into cash.

How to Improve a Slow Collection Period

Tighten credit checks before extending terms to new customers.
Offer early-payment discounts — for example, 2/10 net 30 — to encourage faster payment. You can evaluate the cost of such discounts with the Discount Lost calculator.
Invoice promptly and follow up with reminders before and after the due date.
Track the metric regularly — quarterly calculations catch slowdowns before they become cash crises.

Assumptions and Limitations

The calculator assumes that credit sales occur evenly throughout the period and that the accounts receivable balance is representative of the whole period. For more accuracy with seasonal businesses, use average receivables (beginning plus ending balance divided by two) rather than a single point-in-time balance.

Net credit sales must exclude cash sales — including them will understate the collection period. Also remember that the raw number says little on its own: a period of 60 days is excellent for some industries and alarming for others. Always compare against your stated payment terms, industry benchmarks, and your own historical trend.

If you are analyzing the broader cash conversion cycle, pair this metric with the Days in Inventory calculator to see how long inventory sits before sale as well.

Frequently Asked Questions

What is a good average collection period?

A good value depends on your credit terms and industry. If you offer net 30 terms, collecting within 30–40 days is generally healthy. Wholesale and construction businesses often run 60–90 days as normal. The key test is whether the number is close to or below your stated payment terms, and whether it is stable or improving over time.

How do I calculate the average collection period by hand?

Divide accounts receivable by net credit sales, then multiply by the number of days in the period. For example, $ \frac{20{,}000}{200{,}000} \times 365 = 36.5 $ days. Make sure both figures cover the same period and that the sales figure includes only credit sales, not cash sales, or the result will be too low.

Is the average collection period the same as days sales outstanding (DSO)?

Yes, the two terms refer to essentially the same metric. DSO is the more common name in finance and credit management, while average collection period appears more often in accounting textbooks. Both express the average number of days it takes to collect payment after a credit sale. Minor differences can arise from whether average or ending receivables are used.

What is the difference between average collection period and receivables turnover ratio?

They are inverses of each other. Receivables turnover equals net credit sales divided by accounts receivable, showing how many times per period you collect your receivables. Divide the number of days in the period (usually 365) by the turnover ratio and you get the average collection period in days.

Why is my average collection period higher than my payment terms?

A result above your stated terms, such as 55 days on net 30, means customers are paying late on average. Common causes are weak invoicing practices, no payment reminders, lenient credit checks, or disputes over invoices. It also signals growing credit risk: the longer receivables stay outstanding, the higher the chance they turn into bad debt.

Should I use ending or average accounts receivable?

Average receivables, calculated as beginning balance plus ending balance divided by two, give a more accurate result, especially for seasonal or fast-growing businesses. A single end-of-period balance can be distorted by a holiday sales spike or a large year-end collection. If only the ending balance is available, the calculation still works but should be interpreted with caution.

What number of days should I enter for the period?

Enter the number of days that matches your sales figure: 365 or 366 for annual data, 90 for a quarter, or 30 for a month. The key is consistency — annual net credit sales must be paired with 365 days, not 90. Mixing periods, such as annual sales with a quarterly day count, will give a meaningless result.

Average Collection Period Converter