Average Collection Period Calculator
Calculate the average collection period (average debtors collection period) from accounts receivable and net credit sales. Get the exact number of days and receivables turnover instantly.
Average Collection Period = (Average Accounts Receivable ÷ Net Credit Sales) × Days in PeriodAdjust Variables
Interactive Step-by-Step Calculation Proofs
View how variables resolve algebraically down to peer-reviewed standard outputs.
Why Use This Calculator
The average collection period — also called the average debtors collection period in UK and international accounting — measures how many days, on average, a business takes to collect cash from its customers after a credit sale. It's calculated as: Average Collection Period = (Average Accounts Receivable ÷ Net Credit Sales) × Days in Period, where average accounts receivable is typically the mean of the beginning and ending receivable balances for the period. A shorter average collection period means faster cash conversion and generally healthier working capital; a lengthening period can signal looser credit policies or emerging collections problems. This calculator supports both the standard average accounts receivable approach and a simpler ending accounts receivable snapshot for a quick estimate. Note that 'average collection period' and 'A/R days' (also called days sales outstanding, or DSO) are the same underlying metric — different industries and textbooks simply use different names for it. In introductory accounting and finance courses, average collection period is usually taught as one of several efficiency ratios — alongside inventory turnover and the payables period — that together build up to the cash conversion cycle; this calculator defaults to the average-receivables approach because that's the version most textbooks present first, before introducing the ending-balance shortcut as a simplification.
Mathematical Formula Explanation
Calculated standard benchmarks are based on direct functional dependencies. The primary calculation logic follows this formula:
Average Collection Period = (Average Accounts Receivable ÷ Net Credit Sales) × Days in PeriodBy Average Accounts Receivable and By Ending Accounts Receivable apply the identical ratio, differing only in the numerator. The average-balance approach — the mean of beginning and ending receivables — is the version taught first in most introductory accounting and finance courses because it isn't distorted by a single point-in-time snapshot; the ending-balance version is introduced afterward as a faster, simplified shortcut once the underlying concept is established.
Worked Examples (Step-by-Step)
These examples work through the average-balance method as a standalone ratio, and then as one leg of the broader cash conversion cycle alongside inventory and payables days — the way it's typically presented in a ratio-analysis course.
Example 1: Average Collection Period From Average Balance
“A company started the year with $140,000 in accounts receivable and ended with $160,000, on $1,825,000 in net credit sales over 365 days. What is the average collection period?”
- BEGINNINGAR: 140,000
- ENDINGAR: 160,000
- NETCREDITSALESAVG: 1,825,000
- DAYSINPERIODAVG: 365
- AVERAGEAR: 150,000
- COLLECTIONPERIODAVG: 30
- TURNOVERAVG: 12.17
Example 2: Average Collection Period From Ending Balance
“A company has $150,000 in accounts receivable at year-end and generated $1,825,000 in net credit sales over the year. What is the average collection period?”
- ACCOUNTSRECEIVABLE: 150,000
- NETCREDITSALES: 1,825,000
- DAYSINPERIOD: 365
- COLLECTIONPERIOD: 30
- DAILYSALESEND: 5,000
- TURNOVEREND: 12.17
Example 3: ACP Within the Cash Conversion Cycle
“A ratio-analysis exercise gives a retailer $100,000 beginning and $140,000 ending accounts receivable, $1,460,000 in net credit sales, and a 365-day year. The same company's inventory turns over in 40 days (days inventory outstanding) and it pays its own suppliers in 35 days (days payable outstanding). Find the average collection period, then use it to complete the cash conversion cycle: CCC = Days Inventory Outstanding + Average Collection Period − Days Payable Outstanding.”
- BEGINNINGAR: 100,000
- ENDINGAR: 140,000
- NETCREDITSALESAVG: 1,460,000
- DAYSINPERIODAVG: 365
- AVERAGEAR: 120,000
- COLLECTIONPERIODAVG: 30
- TURNOVERAVG: 12.17
Common Mistakes & Edge Cases
- Treating ACP as a standalone number instead of one leg of the cash conversion cycleIn ratio analysis, the average collection period is meant to be read alongside days inventory outstanding and days payable outstanding as the cash conversion cycle (CCC = DIO + ACP − DPO) — the full picture of how long cash is tied up in operations. Reporting ACP alone answers 'how fast do we collect' but misses whether that speed actually matters relative to how fast the business pays its own bills.
- Mixing 360-day and 365-day period conventionsSome textbooks and financial models use a 360-day 'banker's year' for ratio calculations instead of the actual 365 (or 366). Using 360 in one calculation and 365 in a comparison figure introduces a small but real inconsistency — always check which day-count convention a source used before comparing ACP figures across two calculations.
- Computing from a single period's ending balances when the business is seasonalA retailer with a strong holiday season will show a very different receivables balance in December than in July. Computing ACP from just one period's beginning/ending snapshot can produce a misleading figure for a seasonal business — a rolling average across several periods gives a more representative number.