Calculate average collection period and receivables turnover from A/R and credit sales, then compare collection speed with stated payment terms. Use it to test different inputs quickly, compare outcomes, and understand the main factors behind the result before moving on to related tools or deeper guidance.
Last updated
Estimate the average collection period, also called days sales outstanding, from receivables and credit sales so you can see how quickly invoices are turning into cash.
This worksheet also compares your collection speed with stated credit terms and estimates how much cash is tied up when collections run slower than target.
Receivables basis
Scope note
The ratio is strongest when net credit sales and receivables cover the same period and seasonality is not extreme. If your business has heavy month-end swings, using beginning and ending balances can be more informative than a single ending receivables number.
This is a receivables-efficiency planning tool, not a substitute for a full cash-flow forecast, ageing report, or allowance-for-credit-loss analysis.
Average collection period
36.5 days
Based on average receivables of $50,000.00 and net credit sales of $500,000.00 over 365 days.
10x
Receivables turnover
$1,369.86
Average daily credit sales
10%
Receivables as % of period sales
6.5 days
Against stated credit terms
Receivables sheet
Average receivables used
$50,000.00
Net credit sales
$500,000.00
Period length
365 days
Credit terms benchmark
Net 30
Interpretation
Average collection period
36.5 days
Receivables turnover
10x
Average daily credit sales
$1,369.86
Cash tied up above terms
$8,904.11
Collections are slower than stated terms This scenario runs about 6.5 days slower than a Net 30 benchmark, which leaves roughly $8,904.11 tied up in receivables beyond the target collection window.
Average collection period calculator: days sales outstanding, receivables turnover
An average collection period calculator helps you see how long receivables are sitting unpaid after a credit sale, not just whether revenue looks strong on paper. This page estimates days sales outstanding, receivables turnover, and how much cash may be tied up when collections run slower than your stated payment terms.
What the average collection period actually measures
The average collection period shows how many days, on average, a business takes to turn credit sales into cash. It is closely related to days sales outstanding, or DSO, and it is usually interpreted alongside receivables turnover rather than as a standalone number. A lower result generally means invoices are converting into cash more quickly, while a higher result can signal slow-paying customers, loose credit terms, billing delays, or collections friction.
The metric is most useful when the receivables balance and the sales figure cover the same period. If you compare year-end receivables with only one month of credit sales, the result becomes misleading. That is why many analysts prefer to use an average receivables balance or the average of beginning and ending receivables when seasonality is meaningful.
Receivables turnover = Net credit sales / Average accounts receivable
Shows how many times receivables are collected and replenished during the period under review.
Average collection period = Average accounts receivable / (Net credit sales / Period days)
Converts receivables and sales into an average number of collection days for the period.
Average collection period = Period days / Receivables turnover
Equivalent form of the same ratio when turnover has already been calculated.
Worked example: a 36.5-day collection period on annual credit sales
Suppose a company reports average accounts receivable of 50,000 and annual net credit sales of 500,000 over a 365-day period. Receivables turnover is 500,000 divided by 50,000, which equals 10. The average collection period is then 365 divided by 10, or 36.5 days.
If the business usually invoices on Net 30 terms, that 36.5-day result means collections are running about 6.5 days slower than the stated target. The daily credit-sales pace is roughly 1,369.86, so those extra 6.5 days imply close to 8,900 of cash tied up beyond the intended collection window. This is why finance teams often care as much about the gap versus stated terms as they do about the ratio itself.
A shorter collection period is not automatically better in every context. Industry norms matter, as do customer mix, billing cadence, and contract terms. A business with monthly subscription billing and automatic payments can support a much lower collection period than a business selling to larger customers on negotiated 45-day or 60-day invoice terms.
The most practical comparison is against your own stated credit terms and your own historical trend. If the average collection period is rising while sales are flat, that can point to weakening receivables quality or slower collections. If the ratio improves after you tighten credit approval, invoice faster, or follow up earlier on overdue balances, the change can translate directly into better operating cash flow.
This calculator also estimates cash tied up above target terms. That figure is not an accounting entry, but it can be a useful management signal because it translates a timing problem into the approximate amount of working cash not yet back in the business.
BDC — Average collection period glossary — Business Development Bank of Canada glossary entry explaining what the ratio measures and why it matters for cash management.
What this calculator does not cover
The result does not replace an accounts receivable ageing report. It does not show which specific customers are late, how much of the balance may become doubtful, or whether a concentration of large invoices is distorting the period-end receivables number. Those questions need customer-level analysis, collections notes, and allowance-for-credit-loss review.
The ratio is also sensitive to seasonality and period choice. A business with a large quarter-end push or one-off invoice spike can show an average collection period that looks worse or better than the normal operating pattern. Use this page as a planning and benchmarking tool, then confirm decisions against your billing cycle, credit policy, cash forecast, and detailed receivables ageing.
Is average collection period the same as days sales outstanding?
In most practical business-finance use, yes. Average collection period and days sales outstanding both describe how long receivables remain outstanding before cash is collected. Some teams prefer one label over the other, but the underlying idea is the same: translate receivables and credit sales into an average number of collection days.
Should I use ending receivables or average receivables?
Average receivables are usually better when the business has noticeable seasonality or period-end spikes. Using only ending receivables can overstate or understate the true collection pattern if the reporting date is unusually high or low. If you have reliable beginning and ending balances for the same period, averaging them usually gives a more stable estimate.
Why does the formula use net credit sales instead of total sales?
Because cash sales are already collected at the point of sale and do not create accounts receivable. The purpose of the ratio is to measure how quickly credit sales turn into cash, so using total sales can dilute the result and make collections appear faster than they really are.
What counts as a good average collection period?
A good result is one that fits your actual credit terms, customer mix, and industry norm. A company invoicing on Net 15 or Net 30 terms usually wants a much shorter collection period than a company that commonly extends Net 60 terms to larger customers. The most useful benchmark is whether the result is improving over time and whether it is staying close to your stated payment terms without pushing customer relationships into distress.
