Average Collection Period & Days to Collect Calculator (2024)

Impact Of Average Collection Period On Your Bottom Line

The average collection period is mostly relevant for credit sales, as cash sales receive payments right when goods are delivered. That’s why this metric impacts professional service companies more than others, where payments are typically staggered based on when and how services are completed.

Regardless of your company’s industry, tracking the average collection period is essential. Here’s why: It gives you insight into your organization’s credit policies and allows you to spot potential cash flow crunches before they happen.

Typically, a more extended average collection period puts pressure on your company’s cash flow because your money is tied up in receivables, making it harder for you to pay your vendors, employees or reinvest in the business. A more extended average collection period also increases the chances of growing customer debt or accounts receivable (AR) going unpaid. Plus, the impact is greater for professional service companies, as you don’t have physical assets or products to fall back on to recuperate those losses.

By proactively monitoring this metric, you can quickly address gaps in your credit or collection policies, ensure your business has enough cash for its operations, and improve billing processes to avoid payment delays and unnecessary administrative costs.

How to Calculate Your Average Collection Period

Average collection period, sometimes referred to as days sales outstanding, is the average time that elapses between your company’s completion of services and the collection of payment from your customers.

To calculate this metric, you simply have to divide the total accounts receivable by the net credit sales and multiply that number by the number of days in that period — typically, this is 365 days. That said, whatever timeframe you choose for your calculation, make sure the period is consistent for both the average collection period and your net credit sales, or the numbers will be off.

Here’s a straightforward average collection period formula:

Average Collection Period & Days to Collect Calculator (1)

Average Collection Period = (Accounts Receivable / Net Credit Sales ) x Number of Days in Period

Average Collection Period & Days to Collect Calculator (2)

Average Collection Period Calculator

Your Average Collection Period

Another common way to calculate the average collection period is by dividing the number of days by the accounts receivable turnover ratio.

Example of Average Collection Period Calculation

For instance, let’s say your company offers management consulting services. In 2024, your company reported net credit sales of $2 million; on December 31st, the accounts receivable balance was $500,000. Here’s how you’d find the average collection period:

Average Collection Period for 2024 = ($500,000 / $2,000,000 ) X 365 = 91.25 days

This means that, on average, it takes your company 91.25 days to collect payments from clients once services have been completed.

Benchmarks for Average Collection Period

What do industry benchmarks for the average collection period look like? It depends.

According to the Bank for Canadian Entrepreneurs (BDC), most businesses should have an average collection period of less than 60 days. However, the ideal number depends on the nature of your business, client relationships, and invoice period.

Industries such as banking (specifically, lending) and real estate construction usually aim for a shorter average collection period as their cash flow relies heavily on accounts receivables. On the other end of the spectrum, businesses that offer scientific R&D services can have an average collection period of around 70 days.

Generally, the lower the collection period, the better for business. This means your company’s locking up less of its funds in accounts receivable, so the money can be used for other purposes. Additionally, a lower number reduces the risk of customer defaults and likely reflects that payments are being made on time, depending on your billing cycle.

The Impact of Economic Trends on Collection Periods

As many professional service businesses are aware, economic trends play a role in your collection period. Seasonal fluctuations impact payment behaviors, which in turn affect your average collection period.

For instance, consumers and businesses often face financial constraints during recessions or economic instability. Consequently, this may delay payments or lead to higher defaults on invoices — resulting in longer average collection periods as companies struggle to collect on outstanding receivables. Law firms, for example, reportedly saw an overall increase of 5% in the average collection cycle in 2023. Similarly, inflation also negatively impacts consumers and businesses, often resulting in longer average collection periods.

That’s why it’s important not to take this metric at face value; be mindful of external factors that influence it. If you analyze a peak or slow month in isolation, your insights will be skewed, and you can’t make sound decisions based on those numbers.

Instead, review your average collection period frequently and over a longer duration, such as a year. This way, you’ll understand what the number means and the “why” behind it.

Improve Your Average Collection Period

Sometimes, your company’s average collection period might be high. The good news? There are a few things you can do to speed up your professional service company’s collection period:

  • Bill upfront for set work before it begins. Any overages can be paid on credit terms in arrears.
  • Build in payment due dates at different completion points. Bill clients for 50% of a project at the midway point or schedule incremental payments as different phases are complete to ensure you have enough funds to support operations moving forward — this way you don’t perform 100% of the work without getting paid.
  • Improve your invoicing and collections processes to avoid cash flow crunches. To speed up payments, you might need to adjust your payment terms. Consider switching from net 30 to net 15, for example.
  • Tighten your credit policies. For instance, reduce leniency on late payments and charge penalties when they occur, or don’t provide services on credit for clients with a history of delayed payments.
  • To encourage clients to pay invoices before the due date, offer incentives for early payments, such as a discount on the bill rate for the subsequent services they sign up for.
  • Ensure your team follows up more rigorously to ensure timely collections, like sending frequent reminders to avoid delayed payments.

All these efforts will help you maintain a healthy cash flow, sustain business operations effectively, and reduce your risk of bad debt. But most importantly, try to avoid credit sales altogether by billing upfront whenever possible to avoid cash flow issues.

Role of Mosaic in Optimizing Collection Periods

As we’ve said before, the average collection period offers limited insights when analyzed in isolation.

To get the most out of this metric, tailor it to your business needs. This way, you’ll get more nuanced, actionable insights that can fuel business growth. That’s where a strategic finance platform like Mosaic comes in.

Mosaic lets you automate your average collection period calculation and dig into the data using Metric Builder, including (but not limited to) the following ways:

  • Analyze collection times by customer segments to focus collection efforts.
  • Compare payment collection speeds across different contract lengths, such as three-year versus one-year contracts, to get a thorough view of your company’s financial health. This is particularly important in an industry impacted by seasonal fluctuations.

With Mosaic, you can also get a real-time look into your billings and collections process. Since Mosaic offers an out of the box billings and collections template, you can automatically surface outstanding invoices by due date highlighting exactly where to focus your collection efforts.

With Mosaic you can automatically track your average collection period or days sales outstanding metric to see if your customers are paying according to your benchmarks. This will help your company nail its cash flow targets and ensure you don’t end up in a cash flow crunch.

The average collection period should be used in your financial model to accurately forecast how and when new customers will contribute to your cashflow.

Also, keep in mind that the average collection period only tells part of the story. To really understand your accounts receivables, you need to look at this metric in tandem with related metrics like AR turnover, AR aging, days payable outstanding (DPO), and more. And that’s just ​​a glimpse of what Mosaic has to offer.

To see Mosaic’s firepower firsthand, request a demo.

Average Collection Period & Days to Collect Calculator (2024)

FAQs

How to calculate average collection period in days? ›

Formula for Average Collection Period

Average collection period is calculated by dividing a company's average accounts receivable balance by its net credit sales for a specific period, then multiplying the quotient by 365 days.

What is the formula for the average collection period of 360 days? ›

The formula for calculating the average collection period is as follows. The calculation involves dividing a company's A/R by its net credit sales and then multiplying by the number of days in a year, in which either 360 days or 365 days can be used.

What is a good average collection period for a company? ›

Average collection period (receivables turnover)

A shorter average collection period (60 days or less) is generally preferable and means a business has higher liquidity.

What is the formula for the average collection period in Excel? ›

The average collection period can be found by dividing the average accounts receivables by the sales revenue. This number is then multiplied by 365.

What is the formula for collection days? ›

(average accounts receivable balance ÷ net credit sales ) x 365 = average collection period. You can also essentially reverse the formula to get the same result: 365 ÷ (net credit sales ÷ average accounts receivable balance) = average collection period.

How to calculate average days in inventory? ›

Days in inventory is the average time a company keeps its inventory before it is sold. To calculate days in inventory, divide the cost of average inventory by the cost of goods sold, and multiply that by the period length, which is usually 365 days.

How to calculate average number of days in accounts receivable? ›

To calculate accounts receivable days, divide the accounts receivable by the total credit sales and then multiply the result by the number of days in the period you want to calculate (usually a year).

What is the formula for days in inventory period? ›

Inventory days = 365 x ( Average inventory / COGS )

You can use this average to estimate the time that said product was predicted to sell. The figure resulting from this formula can be easily converted to days by multiplying this data by 365 or by a period.

What is an example of the average collection period? ›

Average example

Remember that you'll need to divide the average accounts receivable balance by the sales revenue and multiply it by the time period. In this case, let's say it's yearly. You'd then do the following: ($100,000 / $1,000,000) x 365. This would give you an average collection period of 36.5 days.

Why is a high average collection period bad? ›

High average collection period: your collections process is inefficient, which might signal impending cash flow challenges as you're unable to collect on receivables promptly.

How much is the average collection period? ›

This means that, on average, it takes your company 91.25 days to collect payments from clients once services have been completed.

What is the formula for average period? ›

The average collection period is calculated by dividing a company's yearly accounts receivable balance by its yearly total net sales; this number is then multiplied by 365 to generate a number in days.

What is the formula for average day collection? ›

The calculation itself is relatively simple. First, multiply the average accounts receivable by the number of days in the period. Divide the sum by the net credit sales. The resulting number is the average number of days it takes you to collect an account.

What is the formula for days to collect in Excel? ›

The DAYS function in Excel is a formula designed to compute the count of days between two given dates. The syntax for the function is “=DAYS(end_date, start_date).” Therefore, the end date is specified as the first argument in the formula, and the start date is specified as the second argument in the formula.

How do you calculate average payment period in days? ›

Average payment period formula is as follows: Average payment period = Average Accounts Payable * Days in Period / Total Credit Purchases. Where, Average payable period ratio is the average money owed by a company to its suppliers as per the balance sheet.

How do you calculate average inventory in days? ›

Days in inventory is the average time a company keeps its inventory before it is sold. To calculate days in inventory, divide the cost of average inventory by the cost of goods sold, and multiply that by the period length, which is usually 365 days.

How is DSO calculated? ›

DSO is often determined on a monthly, quarterly, or annual basis. To compute DSO, divide the average accounts receivable during a given period by the total value of credit sales during the same period, and then multiply the result by the number of days in the period being measured.

Top Articles
Latest Posts
Article information

Author: Lidia Grady

Last Updated:

Views: 6605

Rating: 4.4 / 5 (65 voted)

Reviews: 80% of readers found this page helpful

Author information

Name: Lidia Grady

Birthday: 1992-01-22

Address: Suite 493 356 Dale Fall, New Wanda, RI 52485

Phone: +29914464387516

Job: Customer Engineer

Hobby: Cryptography, Writing, Dowsing, Stand-up comedy, Calligraphy, Web surfing, Ghost hunting

Introduction: My name is Lidia Grady, I am a thankful, fine, glamorous, lucky, lively, pleasant, shiny person who loves writing and wants to share my knowledge and understanding with you.