Average Collection Period Formula Calculator Excel template

days it takes

If you are having trouble Average Collection Perioding your bills, it’s essential to look for ways to improve cash flow. This includes analyzing your collection periods for optimization so that you get paid after providing goods or services. Here is why calculating your average collection period can help your business’s financial health. Let’s say you own an electrical contracting business called Light Up Electric. At the beginning of the year, your accounts receivable on your balance sheet was $39,000. Additionally, since construction companies are typically paid per project , they also depend on this calculation. Since payments on these projects can fund other projects, they need to make sure clients are paying on time and in the correct amounts.

  • However, when the average collection period is 40 days, they have to revisit the credit terms provided to the clients.
  • If your company requires invoices to be paid within 30 days, then a lower average than 30 would mean that you collect accounts efficiently.
  • In comparison with previous years, is the business’s ability to collect its receivables increasing or decreasing .
  • Accounts receivable in line with this process and strategically manage both payment sections.
  • If the ACP is higher than the average credit period extended to clients, as seen in the example above, it means the Billing Process is not working as it should.

While most companies figure average collection periods over the entire business year cycle, some also break it down into quarters or other periods. This is why it is important to know how to find average accounts receivable for other collection periods as well.

Autonomous Receivables

The beginning and ending accounts receivables are $20,000 and $30,000, respectively. In 2020, the company’s ending accounts receivable (A/R) balance was $20k, which grew to $24k in the subsequent year. Suppose a company generated $280k and $360k in net credit sales for the fiscal years ending 2020 and 2021, respectively. More specifically, the company’s credit sales should be used, but such specific information is not usually readily available. Calculating the average collection period for any company is important because it helps the company better understand how efficiently it’s collecting the money it needs to cover its expenditures.

If the https://www.bookstime.com/ collection period, for example, is 45 days, but the firm’s credit policy is to collect its receivables in 30 days, that’s a problem. But if the average collection period is 45 days and the announced credit policy is net 10 days, that’s significantly worse; your customers are very far from abiding by the credit agreement terms. This calls for a look at your firm’s credit policy and instituting measures to change the situation, including tightening credit requirements or making the credit terms clearer to your customers. Using this calculation, you can discover how long it takes to collect from the time the invoice is issued to the time you get paid. If the number is on the high side, you could be having trouble collecting your accounts. A high average collection period ratio could indicate trouble with your cash flows. Some businesses, like real estate, for example, rely heavily on their cash flow to perform successfully.

What is the Average Collection Period?

Accounts receivable represent the amount that the company has to receive from the customers for making credit sales to them. To compute the accounts receivable we divide the credit sales with the accounts receivable balance. The receivable turnover indicates the number of times a company collects cash from its receivables during a year. You must first calculate the accounts receivable turnover, which tells you how many times customers pay their account within a year. When one is determined to find out how to find the average collection period, it is often easiest to start with this combined full formula. This allows for learning how to calculate average collection period and how to calculate average accounts receivable.


Once you have the required information, you can use our built-in calculator or the formula given below to understand how to find the average collection period. Another way to optimize the average collection period is to streamline your customer invoicing. This can be done with the help of an automated AR service, like Billtrust, to ensure that your billing stays fast, which frees you to focus on the more significant elements of your business. The ACP is affected by a company’s credit policies and the AAI is not. The ACP is a measure of the company’s liquidity, while the AAI is a measure of the company’s efficiency. Monitoring your average collection period regularly can help you spot problem accounts before they become uncollectible.

Average Collection Period Examples

Many accounts receivable teams often stumble on how to calculate average collection period and what to make of it. This value is based on how quickly you collect payments from your customers. Average collection period analysis can throw light on many takeaways that will help you understand your company more.


Leave a Reply

Your email address will not be published. Required fields are marked *