Skip to content

Sales Forecast Excel Template

4.5 (10 reviews)

Demand planning and sales forecast template. Projection of future revenue based on historical sales data. SKU-level demand forecast. All in Excel.

Download Free Version
One-Time Purchase
Business Subscription

Additional Services



Someka refunds icon

30-Days
Return

Someka one time payment icon

One-Time
Payment

Someka direct download icon

Instant
Download

One-Time Purchase
Business Subscription
SOMEKA BUSINESS 99 $ /m

Redeem 3 Templates

Download 3 premium templates of your choice for free each month.

Continuous Technical Support

We’ll be your one-stop assistant for all your Excel & Google Sheets questions and needs.

Multi-User Environment

You’ll be entitled to multi-user licensing for your templates.

Cancel Anytime | Growing Catalogue | Continuous Updates

Get Sales Bundle
someka-bundle-icon

This template is also included in bundle with special discount! See details >>

TEMPLATE DESCRIPTION

Do you need an all-in-one tool to plan future demand for your products? Then, this Sales Forecast Excel Template will help you forecast your future revenue according to your historical sales data.

Above all, this tool has the advantage to work in the same way as the forecasting module. Because it has the versatility to add new SKUs (Stock Keeping Unit) with their own automatic code number created and calculate Sales Forecast according to Holt-Winter’s Exponential Smoothing Method.

This Sales Forecasting Template will help you to calculate your sales according to the corrected historical data monthly. It’s just like how ERP systems work.

With this tool, you have the chance to calculate and release your sales forecasting. Here is what you can do:

  • You can add or create new products in a simple Sales History Data Worksheet with an automatic code number for each SKU.
  • For mature products, you can also upload your corrected sales history data in the related Worksheet.
  • In Set Forecast Worksheet, you can calculate your sales forecast by changing the statistical constants: Level, Trend, and Seasonality according to your knowledge as a demand planner to reduce MAPE (Mean Average Percentage Error).
  • You can adjust your final forecast on a quarterly basis by watching changes in the dynamic

SALES FORECAST EXCEL TEMPLATE MAIN FEATURES

Basically, this Excel template consists of 3 main parts:

Sales-Forecasting-Template-Someka-S00-1

Now, let’s check the three main sections of our Sales Forecasting Template:

1. Sales History

In this sheet, you can add or create new products by filling the blank fields. In this case, new products must be forecasted under expected sales assumptions according to Min. Expected Sales and Max. Expected Sales which represents our sales history basis.

Sales-Forecasting-Template-Someka-S02

This section works as a simple Master Data setting up an automatic code when you save your new product. As Master Data of this demand planning template, statistical constants for Level, Trend, and Seasonality will take 0.3 as the default value.

You will be able to change these values when you execute the sales forecast for each new product. Other constants for quarter adjustments on the final forecast are going to be set up on 100% as the default value; you can also change these values on forecast execution.

In case you have Mature Products as data coming from another system, you can also import this data by pressing the UNLOCK DATA button and fields will be unlocked to paste your own Sales History Data.

Sales-Forecasting-Template-Someka-S03

We recommend at least 4 years of corrected history in this template for accurate demand planning and sales forecasting. In case you don’t have enough sales history, we recommend you complete missing values with the moving average.

Warning!: Do not input zero values as sales history; in that case, complete the sales history with the moving average. Save your input data by pressing the SAVE CHANGES button.

Finally, for uploaded mature products, you should set up the values of the statistical: Level, Trend, Seasonality, and Quarter Adjustments on 100% in the Final Forecast worksheet.

2. Set Forecast (Winter’s Exponential Smoothing)

In this section, you are going to be able to run and calculate your Sales Forecast. The only thing you have to do is select any product from the object list.

Sales-Forecasting-Template-Someka-S04

After that the default constant values will appear on the Current Constant(s) fields; now you are able to change statistical constant values: Level, Trend, and Seasonality on the right side-scrolling at the object list with values between 0,001 and 1,000.

Sales-Forecasting-Template-Someka-S05

Dynamic Chart will change automatically. On this demand planning template, we recommend lower values to cover corrected history as much as possible and get a more accurate forecast reducing MAPE (Mean Average Percentage Error).

**Take into account the constant values close to 1,000 which will set your calculation as a Naive Forecast.

Furthermore, as a Demand Planning tool, you may know special promotions lead by marketing colleagues or  some fluctuations in market share; in this case, you are able to adjust your calculated forecast on a quarterly basis with the final sales forecast on the right side of “Error Indicators & Adjustments”

Error Indicators-Adjustments-Someka-S06

Finally, do not forget to save your sales forecast by pressing the “SAVE FORECAST” button.

Sales-Forecasting-Template-Someka-S07

3. Final Forecast (Last Estimated Forecast)

In the last section of the Sales Forecasting Template, you will see your forecast values after saving your executed forecast. Your new forecast is now 48 months sales forecast on the planning horizon. And you will be able to change it anytime you want. Just get back Navigation Menu and press the “Set Forecast” button.

Last-Estimated-Forecast-Someka-S08

Finally, do not forget to update your real sales according to section “SALES HISTORY DATA” at the beginning of each month. Updating your real sales history will be your basis to run the next Sales Forecast with your new Sales Forecasting tool.

SALES FORECAST EXCEL TEMPLATE FEATURES SUMMARY:

  • Unique Excel template to perform Sales Forecast by SKU
  • Works on Windows
  • Ready-to-use Sales Forecasting
  • No installations needed
  • Dynamic Charts
  • Compatible with Excel 2007 and later versions

Demand Planning Template is a ready-to-use Excel Template and provided as-is. If you need customization on your reports or need more complex templates, please refer to our custom services.

PRODUCT VIDEO

Watch the video below to see the template in action! Presentation also includes usage notes, explanations and tips & tricks about the template.

FREQUENTLY ASKED QUESTIONS

USER REVIEWS & COMMENTS

10 reviews for Sales Forecast Excel Template

  1. Ramesh Kumar

    meets my expctations, but I’m hoping for more cost-effective options

  2. Rafaela Dijkstra

    The design of this template feels outdated.

  3. Yusuf L

    What are macros, and how do I enable them?

    • Someka

      Macros are programs that automate tasks in documents. Someka’s complex templates may include macros for automation. To enable macros, click “Enable Editing” and “Enable Content” in the yellow message bar. Macros are secure if downloaded from trusted sources.

  4. Dan

    good.
    Need two things
    -see row numbers
    -create new sheet

  5. Wilmer

    We can change overall sales forecast with quarterly basis. Thx for it

  6. Selin

    Hello,
    I would like to purchase the Excel sales forecasting template. However, my organization’s business (e-commerce sales) grew after 2019. We only have two years of solid sales history, that would be most indicative of the sales going forward. Would this template still work with 2 years of sales history?
    Thank you in advance for your time and help!

    • Someka

      Hi Selin,

      First of all, thanks a lot for your interest!

      We recommend our customers filling the previous year’s input with the mean value of the data that you already have. This way, these cells are not left blank and they also do not affect the calculation.

      In addition, the recommended values used for Level Shift and Trend should be between 0,030 – 0,500 and Seasonality values between 0,350 – 0,700 to get accurate predictions.

      We also have a product video that we showed the features of the template. Did you have a look at it also?

      Hope our explanation helps you. For further questions, please do not hesitate to contact us.

      Kindly regards,

    • Selin

      Hi!
      Thank you so much for your response! So is there no way no to build the model off of 2 years of history? The years inputted into the template cannot be deleted, correct?

    • Someka

      Hi Selin,

      The template is created to input the optimal amount of data to get more accurate results. So it would be better to fill all the cells to get more certain results in the existing template.

      However, if you need totally different or customized Sales Forecasting Template which is just to calculate the most accurate results with 2 years of data, our development team can create a customized template for you as well.

      For further questions please do not hesitate to contact us anytime. Thank you!

    • Selin

      Thanks a lot for your response and your time! I will contact them.

  7. Joe Levy

    Hi! I bought the Sales Forecasting template. How do I add more than 200 items? We have like 400.

    I unlocked and tried it, but the set forecast section only recognizes first 200.

    thank you!

    • Someka

      Hi Joe,

      Thanks a lot for your interest!

      For the Sales Forecasting template, we have already left spaces to enter 200 items. If you need to add more, you can also save the file as a different name and reuse it for the other 200 items. However, you can also have a look at our customization process to enlarge row numbers up to 400. Because you won’t be able to use the rows you have added manually without using further formulas and arrangements behind the template.

      Hope that helps!

      Best regards,

  8. stuartsherifson

    Great job! I was looking for something to calculate the future amount of quantity of products that I’ll sell. That works perfectly for me.

  9. Luigi Robin

    Perché non supporti l’italiano? Trasformare il modello in italiano richiede un lavoro manuale letterale!

    • Someka

      Hello Luigi! Thank you for your feedback. Unfortunately, we give support in English at this moment. But our templates are easy-to-customize so everything written in English in the template can be written in Italian either!

  10. claudianowak

    Perfect! can you suggest me something about forcasting models that what model will be better for seasionally forcasting of product on attribute level ?

Leave a customer review

Only verified users who have downloaded and used the template may leave a review.

RELATED TEMPLATES

Search