Average Collection Period Calculator

What the average collection period tells you

When you make a sale on credit, you have not really been paid yet. You have swapped a product or a service for a promise, and the money only becomes real when the customer settles up. The average collection period measures the gap in between: how many days, on average, it takes to turn a credit sale into cash in your account.

It is a simple idea with a lot riding on it, because a business runs on cash, not on promises. You may also see this number called days sales outstanding, or DSO; it is the same measure under a different name, more common in finance teams than in textbooks. This calculator works it out from three figures: your net credit sales, your average net receivables, and the number of days in the period.

How it is worked out

The calculation takes your average receivables, divides them by your net credit sales, and multiplies by the days in the period. That turns the amount customers owe you into a length of time, the average number of days their money sits with you before it arrives.

Two of the inputs deserve a careful eye. It is net credit sales that belongs on the bottom, not your total sales. Cash sales are already collected the moment they happen, so folding them in would understate how long your credit customers really take, and this is the single most common way people get the number wrong. And it is average receivables, usually the opening and closing balances for the period split down the middle, which smooths out the lumps of a seasonal or growing business rather than letting one day's snapshot distort the picture.

A worked example

Say your net credit sales for the year are 500,000, and your average net receivables over that year are 50,000.

Divide the 50,000 of receivables by the 500,000 of credit sales and you get 0.1; multiply by 365 days and the average collection period is 36.5 days. So across the year, it takes a little over 36 days, on average, to collect payment after a credit sale. On its own that is a fact, not yet a verdict. Whether 36.5 days is good news or bad depends entirely on one thing, which is the subject of the next section.

The benchmark that matters most: your own terms

You could go hunting for industry averages to judge your collection period against, and they have their place, but the sharpest benchmark is sitting in your own invoices: the payment terms you offer. That comparison turns the number from a curiosity into an instruction.

Suppose you offer net 30, meaning payment is due within 30 days. If your average collection period comes out at 36.5 days, your customers are paying about a week late, on average, and that points straight at your credit and collection process: reminders going out too slowly, terms being enforced too loosely, or a few customers dragging the average up. If instead your collection period were sitting at 25 days against those same net 30 terms, your customers would be paying early, and collections would be working nicely. The goal most businesses set themselves is not merely to match their terms but to beat them, because every day you shave off is a day sooner the cash is yours. Hold your collection period up against your stated terms and it tells you, in plain days, whether your credit policy is actually being honoured.

Why the days add up to money

It is easy to treat the collection period as a back-office statistic, but those days have a direct price, and it is worth seeing why. Every day an invoice goes unpaid is a day your cash is locked up inside your customer's business instead of your own. In effect, you are lending your customers money, interest-free, for the length of the collection period.

Stretch that period out and the strain shows up quickly. Cash that should be paying your staff, your rent, and your own suppliers is instead tied up in receivables, so a long collection period can leave a profitable business oddly short of money. Worse, the longer a debt stays unpaid, the greater the chance it never gets paid at all, so a lengthening collection period also quietly raises your exposure to bad debts. A short collection period does the opposite: it keeps cash cycling back into the business fast, which is the healthy state to be in.

Reading it, and shortening it

Read this number as a trend rather than a one-off, because a single reading says little. A collection period creeping upward month after month is an early warning that credit quality is slipping or your collections are losing their grip, and it is far cheaper to catch early than late. A falling one signals tighter invoicing and better follow-up taking hold. Keep the comparison fair by allowing for seasonality, since busy and quiet periods naturally pull the figure around.

If you want to bring it down, the levers are practical: invoice promptly and accurately so the clock starts sooner, chase overdue accounts consistently rather than sporadically, and consider offering a small discount for early payment, the classic two percent off for paying inside ten days, which can be surprisingly persuasive to a cash-rich customer. It is also worth remembering that this collection period is only one leg of a bigger journey. It feeds directly into the cash conversion cycle, which our cash conversion cycle calculator puts together, and it has a mirror image on the inventory side that our inventory period calculator measures.

Questions people ask

What is the average collection period?

It is the average number of days it takes a business to collect payment after making a credit sale. You calculate it by dividing average accounts receivable by net credit sales and multiplying by the number of days in the period. It is also known as days sales outstanding.

What is a good average collection period?

The best benchmark is your own payment terms. If you offer net 30 and collect in around 30 days or fewer, collections are working well; collecting well beyond your terms signals a problem. Most businesses aim to beat their stated terms, and healthy levels also vary by industry.

Should I use total sales or credit sales?

Net credit sales, not total sales. Cash sales are collected immediately, so including them would understate how long your credit customers actually take to pay. Using total revenue by mistake is the most common error in this calculation.

Is the average collection period the same as DSO?

Yes. Days sales outstanding, or DSO, and the average collection period measure the same thing with the same formula. The term average collection period is more common in accounting, while DSO is more common in finance and receivables operations.

References

The average collection period formula, its identity with days sales outstanding, the use of net credit sales and average receivables, and the practice of benchmarking against your own payment terms follow AccountingTools and standard financial statement analysis, as set out by Subramanyam and Wild below.

1. AccountingTools. Accounts receivable collection period, Days sales outstanding. accountingtools.com
2. Subramanyam, K. R., and Wild, J. J. Financial Statement Analysis (receivables turnover and days). McGraw-Hill.