Average Collection Period Calculator

How to use this average collection period calculator

What this calculator does

This calculator estimates the average number of days between a credit sale and collection of the related receivable. It can use either average accounts receivable together with total credit sales, or a known accounts receivable turnover ratio. The result is an operating-efficiency measure: it describes collection timing for the accounting period you supply. It does not forecast which individual invoices will be paid, estimate bad-debt losses, or determine whether a particular customer is creditworthy.

A common accounting form of the relationship is average collection period = average accounts receivable ÷ net credit sales × days in the period. For background on the measure, the Investopedia guide to average collection period explains the formula, the role of net credit sales, and why the receivables and sales figures should cover the same time frame.

When to use it

Use the calculator when reviewing month-end or year-end receivables, comparing collection speed with stated customer payment terms, monitoring whether collections are lengthening over time, or translating an accounts receivable turnover ratio into an easier-to-read number of days. It is also useful when preparing a cash-flow discussion because a change in collection timing can affect how long revenue remains tied up in receivables.

How to calculate

1. The calculator opens with a complete demonstration set: annual duration, $25,000 average accounts receivable, $100,000 total credit sales, 30-day credit terms, and opening/closing receivables of $20,000 and $30,000. The first result and a validated example Excel workbook are available immediately.
2. Choose Calculation method. Keep “Average receivables and credit sales” when you have balance-sheet receivables and credit-sales data, or switch to “Accounts receivable turnover ratio” when that ratio is already known.
3. Set Duration to Daily, Weekly, Monthly, Quarterly, or Annual. The calculator uses 1, 7, 30, 90, or 365 days respectively, so the selected duration must match the period represented by the other figures.
4. Replace the demonstration values with your own data. Results update live. Read Average collection period first, then use Difference vs credit terms and Collection status as a direct comparison with the optional payment terms you entered.
5. Select Download Excel to export the current validated model. Reset clears the demonstration data rather than restoring it; after Reset, Excel export is disabled until a complete valid calculation is entered again.

Input guide

Calculation method is a required select control. The direct method expects receivables and sales; the turnover method expects a positive turnover ratio. Switching methods changes which required numeric field set is active but does not change the meaning of the final collection-period result.

Duration is required and represents the accounting period in days. Annual means 365 days, Quarterly 90, Monthly 30, Weekly 7, and Daily 1. A frequent mistake is mixing annual credit sales with a monthly receivables figure; use figures from the same period.

Average accounts receivable is required in the direct method and is entered in U.S. dollars. Plain decimals, U.S. thousands separators, and an optional dollar sign are accepted; negative values are rejected. The startup value is $25,000. A higher average receivable balance, with sales unchanged, increases the collection period.

Total credit sales is required in the direct method and is also a U.S.-dollar amount. It must be greater than zero. The example uses $100,000. Higher credit sales, with average receivables unchanged, reduce the calculated days because the same receivable balance represents a smaller share of period credit sales. Do not substitute cash sales if they are outside your credit-sales measure.

Accounts receivable turnover ratio is required only in the turnover-ratio method. Enter a positive plain number such as 4, meaning four receivables collection cycles during the selected period. A larger turnover ratio produces a shorter collection period because days are divided by turnover.

Terms of credit is optional and entered in days. The startup value is 30. It does not change the average collection period itself; it adds a comparison. Zero is allowed for immediate-payment terms, while negative values are rejected. The comparison is descriptive rather than a recommendation because appropriate terms vary by business and industry.

Opening accounts receivable and Closing accounts receivable are optional helper inputs in the “Calculate average accounts receivable” panel. Enter both as nonnegative dollar amounts, such as $20,000 and $30,000. Their arithmetic mean appears as Calculated average accounts receivable. Select Use calculated average to copy that figure into the direct-method Average accounts receivable field. Entering only one of the pair is treated as incomplete helper data.

Output guide

Average collection period is the primary result in days. Lower and higher values simply mean faster and slower collection relative to the supplied sales and receivables; interpretation is strongest when compared with your own historical trend, customer terms, and peer context. Accounts receivable turnover shows how many times the average receivable balance turns over during the selected period. When average receivables are zero in the direct method, the collection period is exactly zero but turnover is shown as unavailable rather than as infinity.

Daily credit sales converts direct-method total credit sales to a per-day amount using the selected duration. It is unavailable in turnover-ratio mode because no sales amount is supplied. Difference vs credit terms is average collection period minus Terms of credit; zero means the two match, a positive value means collections take longer than the stated terms, and a negative value means collections are faster. Collection status expresses that same comparison as “Matches credit terms,” “Within credit terms,” or “Beyond credit terms.” The header pills labeled Duration, Turnover, and Vs credit terms are compact mirrors of those same current-state values.

The Calculation detail table has three columns: Metric, Value, and Interpretation. It lists the active formula inputs, the days in the period, the turnover and daily-sales intermediates when available, the average collection period, and the credit-term comparison. Every row is generated from the same canonical model used for the result cards and workbook.

Worked example

With the startup annual values, average accounts receivable is $25,000 and total credit sales are $100,000. The direct formula is $25,000 × 365 ÷ $100,000, which equals 91.25 days. Receivables turnover is $100,000 ÷ $25,000 = 4.00×, and 365 ÷ 4 also equals 91.25 days. Daily credit sales are $100,000 ÷ 365 = $273.97. Compared with 30-day terms, the collection period is 61.25 days longer, so the displayed Collection status is “Beyond credit terms.”

Learn more

The Corporate Finance Institute explanation of accounts receivable turnover shows the related turnover formula and its conversion into collection days. For a closely related view of collection timing, CFI's days sales outstanding guide discusses how receivables days can be used as an operational indicator. These measures are most useful as consistent comparisons rather than as stand-alone judgments.