Sales Forecast Template for Amazon FBA, Ecommerce and Beyond
If you have been struggling with any of the following:
- figuring out how to calculate sales forecasts
- understanding the ebbs and flows of your business sales
- knowing when to restock inventory
- how to account for seasonal changes
- using clunky spreadsheets…
you will walk away as the yoda of sales forecasting.
Today is the day where the dust settles on sales forecasting.
Whether you run an Amazon FBA business, Shopify or woocommerce store or traditional brick and mortar, projecting your sales and revenue along with inventory will be a lot easier.
I’m also going to give you a Google Sheets sales forecast template you can take with you.
Why Big Sellers Forecast
Losing money sucks.
One of the hidden ways of losing money is by going out of stock.
It’s one of the worst things because you don’t see it. You may not feel it, but it severely impacts the bottom line.
Especially with an Amazon business because if you run out of stock:
- your rank goes down
- your momentum drops
- you need to spend more on PPC to regain your position
- competitors will sell their products while you are out of stock
- competitor ranks could go up
Our business in this area has improved exponentially after utilizing the check in/out spreadsheet (also in the PRO Spreadsheet package) as well as the inventory tracking spreadsheet.
But the missing piece was not being able to forecast based on seasonality.
Our products are fairly consistent all year round, but end of year sales obviously increase.
So how much and how early do I prepare for shipment so that I won’t go out of stock?
Enter seasonally adjusted forecasting.
- The blue line is the actual sales data with peaks and valleys.
- Purple line is the forecasted data which does a good job of mimicing the demand.
- Orange line is a linear forecast. The bigger the swings between peak and valley, the bigger the trouble linear forecasting will get you into.
If a product is seasonal, you don’t want to be over-ordering or over-sending.
Do what the big sellers do and start forecasting with seasonally adjusted number to better manage and control your business.
Sales Forecast Dashboard
Let’s start with the end product so that you know what you are looking at.
There’s a lot of tutorials on how to seasonally adjust numbers. This is the best youtube video I found on the topic.
Click the image or this link to see the live preview.
With the spreadsheet, it uses the last 23 months of data to analyze. I don’t include the current month as it’s not complete.
So if this is November, I’m going back to Dec 2016 to Oct 2018.
After you do all the math, the main pieces of information you want to see is:
- actual sales data
- forecasted data for the next 12 months
- seasonailty weighting
With this information, you can create the chart you see above.
Green = past actual sales
Purple = forecasted sales
You can see how the connection lines up very well and it’s not simply a straight line going up and to the right.
This way, I can see that a big month is coming in January followed by the Feb dip. And then the next big month is in October of 2019.
Precautions with Forecasting
The biggest problem with any forecast is that no one knows the future.
It’s an educated guess and it simply follows the trend of what happened in the past.
Here’s a few examples of what I mean.
This next example is one of our products that has been losing ground and in a decline.
At this rate, it will be dead in 12 months.
So that’s another way to make use of forecasts for products that aren’t doing so well.
If it’s worth the effort, it signals the product needs a jumpstart.
Here’s another one.
This one is for a new product with 3 months of history.
In such a case, a forecast doesn’t tell you anything.
No Gorilla Sheets Add-On?
Go to your reports and get the SKU you want to analyze.
Get the total units sold by month. And then enter the values into the yellow column only.
All other calculations have been done for you.
Get this Sales Forecast Calculator
If you don’t have the PRO Spreadsheet package, consider getting it before prices go up.
We’ll also be retiring the current special pricing for the add-on, so if you like the way the add-on is making your life easier, you can lock in current discounted rate by going with the annual pricing which saves you an additional 25%.
What is Gorilla ROI?
Gorilla ROI automatically pulls Amazon data into Google sheets for you to make sense of the data without the inconvenience of manually downloading, sorting and updating spreadsheets.
Learn how you can centralize your data and use it to increase your ROI.