Need help choosing a plan?
Created with Sketch. 1800 917 771 Schedule a call
Need help?
We're here for you.
Schedule call
Created with Sketch.
Image Alt Text
Running a business

What is sales forecasting and how to create a sales forecast

How much will your business sell next month? What about next quarter? Or next year?

If you’re scratching your head right now, we get it. It’s tough to predict the future, but a sales forecast can help you get a handle on your upcoming sales revenue so that you can make informed and strategic decisions.

Sounds too good to be true? It’s not. Here’s what you need to know to estimate your future salesβ€”without throwing a dart at a board.


What is a sales forecast?

A sales forecast is an estimate of your business’s future sales. You’ll use sales data or other methods to make educated guesses about your future sales revenue over a certain period. This allows you to plan for demand and effectively manage cash flow, resources and inventory. Sales forecasting can happen on a monthly, quarterly, biannual or annual basis.

Why are sales forecasts essential?

Planning for the future is crucial for any business. Sales forecasts help you understand what your future sales will look like so you can create a budget accordingly and set reasonable goals. Depending on the type of business you run, sales forecasts can assist in resource-planning or ordering inventory so you’re prepared to meet customer demand.Β 

Through sales forecasting, you can also identify any potential issues in your sales pipeline or supply chain ahead of time and make necessary adjustments to keep your business performance on track.

In short, accurate sales forecasts support a successful business today and in the future. Externally, they help you provide a great customer experience and maintain a good reputation. Internally, they inform sales targets and support operational planning, so your business is a well-oiled machine year-round.

When should I create a sales forecast?

Sales forecasts are typically created on a monthly, quarterly, biannual or annual basis. That said, there’s no right or wrong answer as to when you should create a sales forecast. It all depends on what’s most relevant and useful to your business.Β 

For example, if your business has very predictable sales on a yearly cycle, you may only need to create a sales forecast annually. If your sales tend to fluctuate seasonally, it may be more appropriate to forecast sales quarterly or biannually.Β 

In general, the more often you forecast, the more likely it is that your predictions will accurately reflect your current business. Regularly refreshing your sales forecasts accounts for external influences such as changing market conditions.

How far ahead should you forecast sales?

Generally, it’s a good idea to forecast for up to 12 months ahead. The further ahead you forecast, the less accurate your predictions will be. After all, things are constantly changing and so will your business. You want your sales forecast to reflect those changes.

Keep in mind your sales forecast is a living document. It’s a good idea to update it regularly to account for your changing business conditions and the broader market.Β 

Who is responsible for sales forecasts?

In large organisations, sales forecasts are usually handled by sales managers or analysts. For small businesses, sales forecasting often falls in the hands of the business owner.Β 

If you run a small business, the good news is you can take some of the effort out of sales forecasts with accounting software like QuickBooks Online. With all your financial data available in QuickBooks, you can quickly and easily create forecasts and use them to create budgets. You can also use QuickBooks’ Cash Flow Planner to automatically predict cash flow for up to 90 days ahead.Β 

What factors can impact your sales forecast?

Several internal and external factors can impact your projected sales. These include:

  • Changed product or service offering: Introducing or removing products or services will naturally affect your sales and customer base.
  • Supply chain issues: Problems with inventory or fulfilment or other kinks in the supply chain can negatively impact your sales.
  • Staffing changes: Expanding or reducing your team will impact your ability to earn revenue, and in turn your sales forecast.
  • Economic conditions: Weaker economic conditions can negatively impact sales, while a strong economy can give your business a revenue boost.
  • Consumer trends: Customers’ changing preferences can have an effect on your sales revenue.
  • Legislative changes: New laws and policy changes can either help or hinder your sales, depending on whether they increase demand for your products/services or create challenges for your business.

Where can a sales forecast be used?

Sales forecasts can be used to guide virtually every area of a business. For example, as a small business owner, you can use sales forecasts to:

  • Set sales targets
  • Plan sales and marketing strategies
  • Decide when and how much stock to order
  • Figure out how much to invest in your business
  • Allocate staffing and other resources
  • Inform decisions about your product or service offering
  • Plan your growth strategy

How accurate are sales forecasts?

Sales forecasts are a useful tool for predicting future sales but they’re not the be-all and end-all. Things change constantly and even small shifts in your business or the wider industry can have a material impact on your revenues.

Think of a sales forecast as an educated guess about what’s going to happen. While it provides guidance, it’s not set in stone. You can revise and adjust your forecast to account for changes to your business, your customers and the broader market.

Objectives of sales forecasting

If a sales forecast is nothing more than a best guess, why bother? Understanding your sales cycle, sales process and sales pipeline will help you make smarter business decisions when it comes to:

  • Managing yourΒ inventoryΒ and supply chain
  • Planning for growth or shrinkage
  • MonitoringΒ cash flow.

The overall objective ofΒ sales forecastingΒ is to keep your business operations running smoothly, which is tough to do if you don’t know where you’re headed.

For example, if your sales forecast tells you that your custom pottery shop is going to hit a slow period after the festive season, you might want to cut back on some nonessential expenses. Conversely, if you forecast a big uptick in growth, you’ll want to be proactive about inventory and consider bringing on additional help.

Basically, your sales forecast is your business’s guiding star as you make decisions about your next steps.

Laptop screen showcasing QuickBooks FREE Business Health Check
NEW!

FREE Business Health Check

Find out how your business is performing. Complete this short questionnaire to receive a free personalised Business Health Check report!

Why is sales forecasting important?


1. Set better sales targets

You want to grow your business, which means you set sales targets for yourself or your salespeople (or maybe both). But, if you aren’t using sales forecasting to inform your sales targets, you run the risk of setting unrealistic goals.

Sales forecasts use past performance and other data to predict future sales. That’s information you can use to set sales targets that motivate you and your sales teamβ€”rather than discourage them.

2. Make strategic decisions

We mentioned this above, but it’s worth reiterating. Your sales forecast will help you make informed decisions about everything from staffing and inventory to new product lines and your marketing efforts.

For example, if your sales forecast projects numbers that are significantly lower than what you hoped, you might decide to explore new revenue streams or reevaluate your pricing.


3. Prepare your business for the future

You don’t have a crystal ball, but your sales forecast is the next best thing. TheseΒ sales projectionsΒ can give you at least a rough idea of what’s to come, so you can prepare your business plan and approach budgeting with that in mind.

If you see that major growth is on your horizon, you can direct your team to order supplies, stock appropriate inventory and get all hands on deck.

Of course, if the global pandemic has taught us anything, it’s that you can’t always predict the future. However, a sales forecast will help you understand your sales pipeline and plan for both best- and worst-case scenarios using realistic and accurate numbers.

Benefits of sales forecasting

A sales forecast is critical for a solid business foundation. Here are a few other convincing benefits that anΒ accurate sales forecastΒ can lead to:

  • Additional funding:Β if your business has investors or needs investments, a positive sales forecasting model demonstrates the potential for success and growth, which is appealing to investors. Remember to include cash reserves and allowances to cover you during slower months.
  • Quick action:Β your sales forecast will help you fend off any unpleasant surprises by correcting course immediately. For example, if you see that your actual sales are trending 25% below your forecast, you can dig down to the root cause and get things back on trackβ€”rather than being surprised by disappointing numbers when it’s too late.
  • Streamlined hiring:Β most business owners know that hiring can be stressful and time-consuming. Your sales forecast will help you see when you might need additional staff on your team, particularly if your business has some seasonality.

Sales forecasting methods

You understand the merits of a sales forecast, but how do you actually build one? There are a number of differentΒ sales forecasting methodsΒ you can use. Let’s look at some of the most common ones here.

1. Historical sales forecasting

If you’ve been in business for a while, you have someΒ historical dataΒ that you can rely on to predict future sales.

If your future sales stay true to your past sales over the last year, what’s likely to happen in your business? That’s the root of this sales forecasting method. You use past metrics to estimate your future sales.

  • Pro:Β you’re basing your forecast on existing, actual sales figures from your business.
  • Con:Β things change quickly, which can lead to an inaccurate sales forecast. Anything from environmental factors to new competitors can mean your existing sales data no longer holds true for the future.

2. Intuitive sales forecasting

An intuitive sales forecasting model relies mostly on your gut feelings and those of any of your sales reps. You have your finger on the pulse of how your business is doing, and you’ll use your intuition to create your sales forecast.

For example, if you’ve seen increasing demand for your product or service and are hearing a lot of buzz about it, you’d likely predict growth.

  • Pro:Β it’s helpful for newer businesses that don’t have a lot of historical data to use.
  • Con:Β the future is tough to predict, which means this method can lead to inaccurate sales forecasts.

3. Sales per square metre forecasting

Commonly used for bricks-and-mortar businesses, aΒ sales per square metreΒ sales forecasting method uses the following calculation:

Total sales / square metres = sales per square meter

Physical retail stores will compare this number to similar stores in their area to use as an indication of how efficient their location is. It also gives them an idea of what they can expect for sales numbers moving forward.

  • Pro:Β helps you understand how a retail store is performing and how you can improve efficiency by displaying or marketing different products.
  • Con:Β it fails to account for any online or e-commerce sales.

4. Opportunity stage forecasting

Who’s more likely to buy from you: Customer A, who just learned about your business, or Customer B, who has engaged with your business for a while and even purchased a few of your products before?

Probably Customer B, right? That’s at the heart of opportunity stage sales forecasting. With this forecasting method, you look at a customer’s stage in your sales pipeline. Generally, the further along they are, the more likely they are to buy.

You’ll look back at your conversion rate data, and then uncover how likely a customer is to purchase at each stage of your sales process. That will help you predict your future sales based on real data.

  • Pro:Β you’re gaining a deep understanding of customer behaviour, which can be enlightening.
  • Con:Β forecasts can be inaccurate, because this method relies a lot on historical data and doesn’t account for a number of other factors like how long a customer has been in your sales pipeline.

5. Gross sales forecasting

This isΒ another methodΒ that’s based on real numbers. Choose a specific product or service, and look at your daily sales for that specific item.

Crunch the numbers to determine your average daily sales of that item for each month, which you can use to make an estimate about your sales of that product or service for the entire year. Repeat that process with the other items your business offers to get a grasp on your total sales.

  • Pro:Β helps you uncover which of your products or services are top sellers.
  • Con:Β it can be time-consuming to get the data you need and run the numbers.

That’s by no means an exhaustive list of sales forecasting methods and modelsβ€”there are plenty of others you could use, depending on what information you have available.

Grow Your Business with QuickBooks

How to forecast sales

We’ve covered some of the most popular forecasting methods. But when it comes to actually digging into the numbers and pulling together your own sales forecast, here are the steps you need to take.


1. Know your timeline

Your sales forecast predicts your future sales. But how far into the future? Are you trying to figure out what your sales will be for the next month? The next quarter? The next year?

Before you dig into the numbers, you’ll need to know what sort of time period you’re looking at.

If you’re including your sales forecast in your business plan, it’s smart to predict sales for each month over the course of the next year. Then you can estimate sales per year for the next three to five years.

EXAMPLE:Β we’re forecasting sales for the next month.Β 

2. Choose a sales forecasting model

Next up, you’ll need to pick the sales forecasting method you want to use. When choosing a method for your business, consider:

  • Your business type:Β do you have a bricks-and-mortar location?
  • TheΒ age of your business:Β do you have historical data to reference?
  • Access to data:Β what sales data or market research can you get your hands on?
  • Sales process:Β do you have an established sales flow or pipeline to monitor?

Still not sure which forecasting model is right for you? Don’t be afraid to test out a few different ones to figure out which one works best.

EXAMPLE:Β we’ll use a historical sales forecasting model as a predictive indicator of our future sales for the next month.Β 

3. Run the numbers

Once you’ve landed on a model, you’re ready to run the numbers. Make sure you get the data you need. In the case of our example, you’ll need to pull reports from your accounting software to understand your historical sales performance.

Imagine that you made $25,000 in revenue last month and sales have consistently been growing 2% over the prior month every month.

Using that information, you’d use this formula to project sales for the next month:

Monthly revenue x (1 + % growth) = forecasted salesΒ 

In the case of our example, that would look like:

$25,000 x 1.02% = $25,500

EXAMPLE:Β we’re forecasting $25,500 in revenue over the course of the next month.Β 

4. Set your sales quotas

Now that you have a better handle on what’s possible for your business, it’s important that you set a benchmark for success. Use your sales forecast to establish sales quotas to work towards.

You could set a monthly quota, quarterly quota or even an annual quota. In addition, you could set an overall quota or individual quotas for each of your team members. It’s wise to set a quota a little beyond your forecast so you give your team something to work towards.

EXAMPLE:Β the sales team should achieve $26,000 in sales by the end of next month.Β 

5. Prioritise transparency and accountability

Keep in mind that a forecast is an educated guess, which means it’s your job to monitor your sales performance and see how close to your forecast and goals you come.

You should also include your team members in those updates so they understand their progress toward their own sales quotas.

It can be helpful to invest in a customer relationship management (CRM) platform to track all of your customer data and keep your team on the same page about how you’re doing.


6. Learn and evolve

You might surpass your forecast and quotas, or you might fall short. Keep in mind that this is a learning process.

Take the time to reflect to see how accurate your predictions and goals were. If they were way too aggressive, then maybe you want to try a different forecasting method.

Remember that making improvements and adjustments over time is all part of the forecasting process.

What if you don’t have historical data?

This example we outlined used the historical forecasting model. But new businesses that don’t have a baseline will find it impossible to forecast sales that way. They’ll need to use one of the other methods we discussed.

Not having any existing data to lean on can be frustrating. In those cases, your best bet is to use existing data and market research from other sourcesβ€”such as the department of revenue for your state/territory or theΒ Australian Bureau of Statistics.

How do I design a sales forecasting plan?

A good sales forecasting plan should be a flexible working document that can be updated as your business needs change. With this in mind, focus on three key areas:


Calculating number and time period

Your sales forecast plan should detail the financial figures you’ll be estimating and the time period you’re forecasting for. Financial figures can be broad, such as total revenues for a certain timeframe, or more granular, such as projected cash flow over the upcoming quarter. The time period can be a month, quarter, year or whichever amount of time makes most sense for your business.


Reviewing and revising

Plan to review your forecast at regular intervals, such as once a month or quarter, and make adjustments as necessary. It’s also a good idea to review your forecast any time a significant change impacts your business. For example, you might want to revise your financial estimates if your business has expanded or you’ve introduced new products or services.


Breaking the mould

Don’t assume that your current sales forecast format will work for you forever. Think creatively and try to find different ways of analysing your sales data so your forecasts are as accurate as possible. Consider what factors you might not have accounted for that could impact your future revenues. If possible, have a financial adviser or trusted contact review your numbers and see if they can find any gaps or identify better ways of estimating your sales.

Sales forecast example

Sales forecasts can include a lot of different information, from moving averages to seasonality. The details your sales forecast incorporates depends on your business and what data is most helpful to you.

At a bare minimum, you’ll want to include:

  • Year
  • Quarter
  • Prior quarter sales
  • Percent growth
  • Forecasted sales

Let’s look at a simple example. Imagine that your sales in Q4 of 2020 were $50,000, and you’ve been growing steadily by 5% each quarter. Here’s what your sales forecast could look like:

quarterly sales forecast example for the year 2021, using a 5% growth rate over 2020 quarterly sales.

This is a simplified example, and you might want to get more into the nitty-gritty by spelling out different units, costs per unit and more. However, this example will help you understand what your sales forecast can look like when it’s all pulled together.

Sales forecasting with QuickBooks Online Cash Flow Planner

If you’d prefer to take some of the work out of manual sales forecasting, accounting software like QuickBooks Online can help.

TheΒ Cash Flow PlannerΒ in QuickBooks Online uses historical data and artificial intelligence to forecast cash flow 90 days in advance. Using more than 60 billion anonymised data points, the Cash Flow Planner predicts future cash inflows and outflows 30 and 90 days in advance. The interactive tool also gives you the option to adjust future transactions to see how those changes would affect cash flow, helping you plan ahead and make informed decisions about your money.

Keys to accurate sales forecasting

A sales forecast is most helpful to you when it’s accurate, but that’s easier said than done. Here are a few best practices to keep in mind to achieve more accurate sales forecasts:

  • Maintain sales data so you have information you can use to inform future forecasts.
  • Define a clear sales process that details the typical steps taken to complete a sale.
  • Create benchmarks for average sales, such as the time it takes to close a sale or your number of new vs returning customers.
  • Set up a CRM so you always have a handle on who’s in your pipeline and might complete a purchase.

There’s no foolproof method for sales forecastingβ€”it’s a prediction and not a guarantee. But these tips can help you ground your forecast in reality rather than optimism.

Business insights gained through sales forecasting

Forecasting your business sales can feel like one big guessing game. However, it’s an important business tactic for a variety of reasons, including the fact that it helps you:

  • Plan your inventory
  • Mitigate supply chain problems
  • Hire effectively
  • Manage risks
  • Monitor your cash flow

And there is so much more. If you’ve previously thought of sales forecasting as nothing more than throwing a dart at a board, think again.

Forecasting is a valuable exercise that can help you build a thriving and resilient business. Use this as your guide, and you’ll have a more accurate idea of where your business is headedβ€”as well as what you need to do to get there.


Related Articles

Looking for something else?

Get QuickBooks

Smart features made for your business. We've got you covered.

Help Me Choose

Use our product selector to find the best accounting software for you.

QuickBooks Support

Get help with QuickBooks. Find articles, video tutorials, and more.

Stay up-to-date with the latest small business insights and trends!


Sign up for our quarterly newsletter and receive educational and interesting content straight to your inbox.

Want more? Visit our tools and templates!

By signing up you are agreeing to our terms and privacy policy.

A happy small business owner signing up for the QuickBooks newsletter on laptop