Free Sales Forecast Template
in Excel

The free sales forecast template is built using google sheets and focuses on using the sales pipeline to help leaders build a sales forecast. With an accurate sales forecast, leaders have time to make changes to their sales model to have a higher chance of hitting goals.

This Sales forecast excel template focuses on forecasting sales based on the future pipeline by individual sales reps and teams. Drop in a pipeline report from Salesforce or another CRM then follow the instructions to accurately forecast your business sales.

Includes

  • Pipeline Reporting
  • Team Forecast
  • Individual Sales Rep Forecast
  • Sales Data Connector
  • Instructions on how to use

Fill in the form to get free access to this forecast template!

How to use this template?

We have published a blog post on the pipeline forecast methodology so we won’t go into the methodology used in the forecast template but will provide instructions for using the template. The forecast can be broken out into 3 parts. The first is getting your pipeline data into the forecast. The second is calculating your sales cycles and close rates. The third is reviewing the forecast on the manager tab.

Sales Forecast

First, add in the current opportunity pipeline from your CRM and make sure to include the pipeline stages. If you don’t have a CRM then just go and input this information manually on the Pipeline Data tab.

Add in the close rate and sales cycle data into the Stage Data tab. Close rates are the number of deals won divided by (the number of deals won plus the number of deals lost) over the passed x timeframe. We like to look at two sales cycles, so 12 months. Sales cycles are how long it takes to close out a deal, either won or lost. For best results break out the sales cycles and close rates by sales teams.

When done, go ahead and:

  • Review forecast on the Manager tab. Update the manager name to the manager you would like to review.
  • Update the date in cell C3 if not correct. Make sure the date is the end of the month. i.e. 7/30/2019.
  • In the pivot table filter down to just the manager, you would like to be reviewing.
  • Copy out the manager tab by right-clicking on the tab and clicking copy for as many other managers as you have. Update name in cell B1 and the pivot table.

The manager tab is broken up into two sections. The first section is a summary view of the total forecast with won deals needing to be added in manually.

The second section is a pivot table that pulls from the Pipeline Data Tab to provide detail into what stage deals are in. Here is where the forecast pulls in the close rates and sales cycles.

Ready to try?

That’s all the inputs needed to get you the forecast. It should take you no more than an hour to get to a decent, initial forecast. You can always go back to the assumptions, tweak and re-visit them. It’s really important to keep your forecast up to date, as the market and your organization changes.

Download the Free Sales Template

This Sales forecast excel template focuses on forecasting sales based on the future pipeline by individual sales reps and teams. Drop in a pipeline report from Salesforce or another CRM then follow the instructions to accurately forecast your business sales.

More templates

Give this free template a try! If you’ll need more templates later, check out the other Free Forecast Templates to download.

 

A template is not enough?

With 4-5 sales representatives, your organization will grow beyond simple Excel templates. See what benefits you can get from Sales Forecasting Platform powered by Machine Learning.

 

Reach out to us!

Please reach out to us with any questions. We have over 30 years of combined forecasting expertise at TwelveZeros.