How this instrument works
The average collection period converts an accounts receivable balance into a count of days: how long, on average, a credit sale sits unpaid before the cash arrives. A supplier deciding whether to open a new account on credit terms often runs this number from a prospective customer's own published financial statements, comparing the result against the payment terms under consideration to see whether the customer's collection track record matches the risk the supplier is about to take on.
The formula divides receivables by credit sales, producing a fraction of the period's sales still sitting uncollected, then multiplies by the length of that period to turn the fraction into days. This sheet leaves the period length as its own field rather than fixing it at 365, so a quarterly filing can be measured against 90 days, a banker's convention against 360, or a full fiscal year against 365 — the identical receivables balance and sales figure will report a different average collection period depending on which period actually produced the sales.
The result reads best against the credit terms a business itself states, such as net 30 or net 60, because it says nothing about whether any single invoice is early or badly overdue, only the average across all of them. A cluster of slow-paying accounts can drag the figure higher even when most invoices clear right on schedule, and swapping the point-in-time receivables balance used here for an average of the period's opening and closing balances will shift the answer without any change in how customers actually behave.
- Enter Accounts receivable, $ — the balance of customer invoices still open as of the date you're measuring.
- Enter Net credit sales, $ — sales made on credit terms for the period, excluding cash and card-at-checkout revenue.
- Set Days in period to match what Net credit sales covers: 365 for a full year, 90 for a quarter, or 360 for a banker's-year convention.
- Read Average collection period, days — how long, on average, a credit sale stays open before it's paid.
- Compare the result against the payment terms you offer, or the terms a prospective customer is asking for.
Worked example — $50,000 against $400,000 in credit sales
A business carries $50,000 in Accounts receivable, $ against $400,000 in Net credit sales, $ for a 365-day year set in Days in period. Dividing 50,000 by 400,000 gives 0.125, and multiplying by 365 gives an Average collection period, days of 45.625 — a little over forty-five and a half days between issuing a credit sale and collecting the cash for it.
Held against typical net-30 credit terms, this business is running about two weeks past its own stated deadline on average, a signal to check which accounts are dragging the figure up rather than assume every customer is late. The same math also shows why Days in period must match what Net credit sales actually covers: swap the 365 for 90 to treat the $400,000 as one quarter's sales instead of a full year's, and the average collection period recalculates to 11.25 days — a completely different figure from the same receivables balance, driven only by which period the sales number represents.
Questions
What's the difference between average collection period and days sales outstanding?
None, mathematically — both divide accounts receivable by credit sales and multiply by the days in the period; average collection period is the older, ratio-analysis name for the identical result. This sheet differs from a fixed-365 calculation only in leaving the period length as its own field, so the same formula returns a 90-day, 360-day, or 365-day answer depending on what Days in period is set to.
Why does this instrument let me set the days in the period instead of fixing it at 365?
Financial statements aren't always annual — a quarterly filing reports one quarter of credit sales, and some credit-department worksheets standardize on a 360-day banker's year. Locking the days figure at 365 would misstate the average collection period whenever the credit sales entered cover something other than a full calendar year, so this field stays open for you to match it to the period behind your numbers.
How is average collection period used in a decision to extend credit?
A supplier weighing whether to sell to a new customer on open account terms can run that customer's own accounts receivable and credit sales, pulled from a filing or a credit application, through this formula and compare the result against the terms under consideration. A customer whose own average collection period already runs longer than the terms being offered is likely to pay slower than the supplier's other accounts, not a promise that it will.
Does a shorter average collection period always mean healthier receivables?
Not automatically. A very short average collection period can reflect disciplined collections, or it can reflect credit terms so strict that slower-paying but otherwise reliable customers are turned away before a sale happens at all. Read the figure next to the credit terms actually offered — a result close to those terms suggests customers are paying roughly on schedule, while one drifting well past them is the number worth investigating.
Why did the average collection period jump even though customers seem to be paying normally?
One outsized invoice recorded just before the period closes can inflate the receivables balance without reflecting any real change in payment speed, and a quiet month of credit sales shrinks the denominator the same way. Because the formula reads one period's balances rather than tracking individual invoices, compare several periods in a row before concluding collections have actually slowed.
Should the receivables figure be a single balance or an average of two dates?
This instrument treats the receivables figure you enter as a single point-in-time balance, matching the simplest and most common version of the formula. A textbook refinement takes the mean of the opening and closing accounts receivable for the period instead, which softens a result that would otherwise swing on a balance measured right at the cutoff date — a reasonable adjustment, but one that needs two balances rather than the single figure this sheet asks for.
References
- U.S. Small Business Administration — Manage your business finances
- NYU Stern School of Business — Aswath Damodaran, corporate finance resources
Read this first: This instrument shows arithmetic, not advice. Real offers add fees, taxes and terms that vary by lender and place — verify the figures against your actual paperwork before deciding anything.