Accurate forecasting is the foundation of effective sales planning.
When your sales team can predict future performance based on accurate data, they’re more likely to better allocate resources and set more realistic targets.
But according to Gartner, more than half of sales leaders lack confidence in the accuracy of their forecasts, with poor data quality being the main reason.
Creating a sales plan based on this type of uncertainty—where actions become based on intuition rather than evidence, Gartner writes—can mean missing the mark on revenue growth. And when stakeholders realize the data on which they're basing their forecasts is unreliable, they’ll lose trust in the forecasting process.
To avoid this, it’s important for finance teams to get involved in the process from the get-go.
Below, we explain exactly how finance teams can collaborate with sales to create a sales plan and share a sales forecasting and planning template you can use to speed up the process.
Forecast future revenue using inputs such as unit sales and unit prices from prior years to help plan for business operations.
A sales plan is an internal playbook that outlines your company’s strategy for growing revenue, covering which segments and territories your business will focus on, goals, tactics and resources needed to hit targets within a timeframe.
It empowers your sales team to:
In order for your sales plan to be successful, Finance needs to play a pivotal role in its development.
As part of the finance team, you understand your business's financial health (revenue goals, profit margins, and budget constraints) better than other departments. Finance may also have the best view of all the systems where sales and revenue data lives and the right technical skills and cross-functional collaboration to bring these data sources together. This knowledge positions you to provide useful insights for the sales plan.
For example, you can analyze your company's historical sales performance to spot insights (trends, opportunities and potential risks) that you can pass on to sales.
Sales, on the other hand, can use these insights to identify what targets are feasible, given your company's financial situation, and allocate resources in that direction.
This critical partnership between finance and sales helps with:
This ongoing process of optimizing the business’s sales strategy is known as sales planning.
From finance teams’ standpoint, an effective sales plan should cover the following key elements to drive revenue growth and ensure financial sustainability and profitability:
The process of sales planning focuses on allocating the business’s resources and salespeople effectively.
As your finance team works to supply Sales with the right data and insights to fuel their strategy, here are the six steps you should follow.
Reviewing historical sales data lets you see:
These insights reveal (normal and seasonal) trends in customer behavior.
For example, say you notice certain products sell better at specific times of the year (if your business sells winter coats, for instance, you’ll see a bump in sales in the colder months). This helps you predict when they’ll be in demand, so your sales team can plan accordingly.
Collect sales data from your CRM, spreadsheets, or other relevant sources. Some examples include total sales volume, customer acquisition cost and revenue growth.
To make the process easier, use sales planning software, as it can help you gather relevant sales data from multiple sources and consolidate it in one central location to power your planning.
This way, you’ll have access to all relevant sales data in one central location.
Consider how you’ll visually represent your sales data through charts, graphs, and dashboards to more easily spot any recurring patterns or trends over time.
For example, you can view a detailed breakdown of sales performance for a specific period (year, quarter, or month) or region and look for seasonal fluctuations, sales spikes, long-term growth or decline and any other significant patterns.
You can also look out for which products or services have been popular among customers, as well as any trends in purchasing frequency or volume. This lets you deeply understand the impact of your previous sales plans to identify what worked and what didn’t.
Reviewing all sales-related expenses, such as commission and incentive compensation, reveals how much money your team spends (or has to spend) to generate sales revenue.
By digging into your sales costs, you can:
Get granular in outlining the different components of your sales team's compensation, as this is one of the most significant expenses associated with sales operations. It includes base salary, commissions, and bonuses.
Break down the commission structure to ensure it aligns with your business goals and motivates your sales team to give their best. For example, you can calculate commissions based on revenue, profit margins or other key performance indicators.
To automate commission and incentive planning, consider using incentive compensation management software. A tool like Vena can provide pre-built templates and source systems integrations to automate your compensation calculations, payouts and reports.
The software also helps you:
Setting your sales targets for the year involves looking at your historical sales data to set a benchmark that’s achievable.
For example, if historical sales data shows that certain products have taken six months to gain traction in a new market, a realistic sales target could be setting incremental goals for each month leading up to the six-month mark.
Use historical sales data as a starting point for setting your sales targets.
Review how your sales have performed over a period (say, the last few quarters or years) to:
Also, based on your business type, it’s important to consider the company’s current production capacity — available resources, machinery, manpower and production processes.
For example, if your proposed sales targets exceed production capacity, it could lead to bottlenecks, delays or even customer dissatisfaction due to inability to fulfill orders.
This analysis helps your sales team adjust expectations and create realistic sales plans. It also ensures sales targets align with company-wide goals.
A walkthrough of how to use Vena to set sales targets based on historical data, in this case for franchise businesses with unique needs for planning sales by location.
Here, you break down sales targets into specific periods, such as monthly, quarterly, or annually, to understand how sales will likely perform over time.
Creating accurate sales forecasts—with the right data, updated in real time—ensures your team plans ahead, allocates resources in the right direction and hits revenue and growth goals.
First, determine the time frame for your sales forecast, whether it's monthly, quarterly, annually, or any other relevant period based on your business needs and industry.
Different industries and businesses experience seasonal fluctuations in sales.
For example, retail businesses see increased sales during the holiday seasons. So, aligning the forecast period with these seasonal patterns lets you better anticipate fluctuations in sales volume and adjust your strategies accordingly.
Next, choose your sales forecasting method. There are three to choose from:
To speed up the process and develop more accurate forecasts, use this sales forecasting and planning template.
Now that you have an insight into your expected revenue streams, you can help allocate resources to areas that will likely yield the highest returns.
The budgeting process can help with allocating resources such as funds and salespeople efficiently. It also helps your team set spending limits and allocate resources based on priorities.
Another focus of the budgeting process should be aligning resources with strategic objectives, to ensure they’re directed toward activities that support the overall mission and vision of your organization.
Assess all available resources, including financial resources, human capital, equipment, technology, and any other assets your company has.
Then map out your sales territories to ensure you're targeting the right prospects. Look at your current sales team and the territories they represent to identify:
This helps you see where your highest ranking sales reps will have the most impact or where you might be able to open up a new growth segment.
Identify territories that show high growth potential or have a large customer base that remains untapped. Then, allocate additional resources such as salespeople, marketing budget, and promotional activities to these territories to maximize returns on investment.
Also, consider how you’ll design your incentive compensation structure to align with your company’s objectives and motivate sales teams to perform at their best.
For example, offer a commission structure where salespeople earn a percentage of the revenue generated from their sales. You can apply graduated commission rates (where sales reps earn higher commission rates for achieving certain goals, such as surpassing sales targets or selling high-margin products/services).
KPIs provide quantifiable metrics that allow you to measure the success of your sales team’s efforts, so you can track progress towards the company’s financial goals.
Determine which sales metrics directly contribute to the business’s core financial goals—this will vary from business to business.
Some examples include:
Determine specific targets and benchmarks for each KPI based on the business’s financial goals, historical performance, industry benchmarks and sales forecasts.
Consider incorporating your priority sales KPIs into a dashboard (made in PowerBI or your analytics platform of choice) to make it easy for anyone in the organization to get a holistic view of the financial impact of sales activities and in turn guide strategic decision-making.
There are many reasons why sales planning can be quite difficult from a financial standpoint. Here are the top six reasons:
Sales planning software offers a centralized platform to store and manage sales data (such as customer information, sales pipelines, performance by sales rep and historical performance).
Being able to access this critical data in one place eliminates silos between sales and finance teams, letting each easily access the information they need to make decisions. Vena makes it even easier for sales and finance teams to collaborate by letting you:
Learn how Vena can help you maximize territory coverage and performance, increase sales capacity, get a handle on sales quota planning and ultimately grow revenue.
Shaun Jansen is Vice President, Mid-Market Sales at Vena. An ardent champion of empowering organizations to embrace agility, resilience and readiness in today's constantly evolving business landscape, Shaun is a true visionary. He possesses a deep-seated commitment to elevating the office of finance by replacing outdated, inefficient and manual processes with streamlined, data-driven workflows that help them reach their fullest potential. With an impressive track record of success, Shaun has consistently delivered remarkable results, securing his reputation as a trusted advisor to countless businesses. His unwavering passion and expertise make him a driving force in shaping the future of the finance industry.
