
What is a Credit Memo? | Outsourced Accounting Services
What is a Credit Memo? Small, medium, and large business owners sell their products to a wide variety of customers and clients. Sometimes orders become
A good sales department will always be optimistic in their sales projections. Most sales departments believe that 100% of contacts have the potential to turn into actual sales.
It is their nature to be optimistic about every contact.
However, from an executive standpoint, management needs to be able to calculate with some precision exactly how much revenue is expected.
Too much optimism will leave a business with under-utilized employees or too much inventory.
Too little preparedness and the business may miss out on revenue opportunities.
The sales pipeline report calculates a reasonable range management can use to plan for future work. Planning for new work or possible retraction is necessary for all businesses.
Pipeline reports are valuable tools. However, they are most useful for organizations that sell their products on contract or purchase orders.
This can range from SAAS companies that sell on subscription to manufacturers that sell on purchase orders.
If a company sells a product or service, outside of retail, then the report is an important tool.
In this post, I’ll explain why the sales pipeline report is important, explain how to calculate the report, and provide several suggestions if you’re new to the concept.
A sales pipeline report is a quantitative way to calculate future sales. The report is derived from the concept that future sales are being worked by the sales staff and are in a ‘pipeline’ for future delivery.
The report allows everyone from the sales department, marketing, and management to understand the realizable future income produced from sales in process.
Not all potential sales noted on a pipeline report are going to materialize, so calculating future sales is imperative.
The report is a one to two page document showing all the future customers, future orders, and possible finalization. While some reports include a narrative form, most use a short note for each future customer.
There are two main stages:
These customers are always going to be the hardest to obtain. If they are unfamiliar with the company then they don’t know the services, products, warranties, or customer support offered.
They will often be hesitate to use an organization they know little about or don’t yet trust. Statistically, the realization or conversion rate on these sales is extremely low.
The conversion rate, depending on industry, can range from one to ten percent.
For every 100 sales calls, the company may get a realization of one to ten new customers.
These customers know the brand and products. They have developed a level of trust in the quality or use of the product.
These customers will be more likely to purchase new products or services from the company. The realization or conversion rate on these types of sales is much better and ranges from 20% – 50%.
When setting up the sales pipeline report, the sales department needs to separate these customers into specific columns, buckets, or categories.
This is an imperative step, as it will be used in the overall calculation of future revenue.
Now that we have a general idea as to the stages and conversion factors, let’s see the sales pipeline in practice.
For our template, we’ll assume the sales department has the following in the pipeline:
The total projected realizable revenue would be $335,000 ($250,000 + $85,000). See the calculation below.
Now, we need to know the following:
These two items are important to bring into the calculation. Management needs to be able to understand that even with new sales will the company meet forecast goals.
Does the business have the capacity to meet these new sales goals?
Here is the calculation updated with these specific questions:
In this expanded example, we have first broken out the current revenue under contract and how much revenue the company will need to meet the forecasted revenue. The total revenue not under contract for the next three months is $341,000 ($37,000 + $92,000 + $212,000). The revenue not under contract represents the current capacity.
Next, in the example, we take the total projected realizable revenue and compare to capacity. In this example we can see that the company has another $6,000 in capacity ($341,000 capacity – $335,000 projected).
Even though the sales department might indicate there is $1,350,000 ($850,000 + $500,000) of sales in the pipeline, the projected realization is $335,000.
This difference is important for management to understand so they can pivot to the forecasted revenue.
There are two main stages in a report calculation: current customers and new customers.
There is a third area that doesn’t come into the pipeline report. Yet, it is important to track.
Stay in second place.
For customers who decided to go to a competitor, the sales department will still try to maintain top of mind awareness. If the sales department put resources in winning their business, it makes sense that the company values obtaining them as a future customer.
The effort the sales department shouldn’t go to waste. Instead, they stay in contact with the potential customer.
Helpful hints, emails, updates on company projects, etc. are all part of this step.
If the competitor fails to deliver, your sales department will be next in line to deliver.
Keeping a precise pulse on future sales will afford a company the time to pivot so they can meet forecasted revenue goals
Steven D Hovland is a Certified Public Accountant and a Certified Forensic Accountant. He has 20+ years of experience in CFO, accounting, and forensic investigations. He is the founder of Hovland Forensic and Financial, a virtual CFO service company as well as forensic litigation services.
What is a Credit Memo? Small, medium, and large business owners sell their products to a wide variety of customers and clients. Sometimes orders become
What is Free Cash Flow? Businesses survive and thrive on cash. Cash allows businesses to take risks, seek new opportunities, and to strengthen their financial
Should your company engage a Virtual CFO for hire? Before getting into the nitty gritty of this question you should be asking what is my