How to forecast your store's revenue

Forecasting revenue helps you plan purchasing, staffing, cash flow and some of your sales initiatives.

But a useful forecast isn't about taking last month's figure and tacking on a few percent. A revenue forecast is an estimate of future sales built from the store's own data: sales history, recent trends, seasonality and known upcoming events. It doesn't tell you exactly what will happen. It estimates what's likely, based on the information available.

Revenue forecast vs. revenue target

The distinction matters. A forecast estimates what's likely to happen based on the data you have. A target is what the store wants to achieve.

Say your data points to a forecast of €45,000 for next month, while your sales target is €50,000. Both figures can perfectly well coexist. The gap simply shows that you'll probably need to do more to hit the target.

Mixing the two up can lead to poor decisions. For example, ordering inventory based on an ambitious target rather than likely demand increases the risk of overstock.

What data should you use to forecast revenue?

You can draw on several types of information.

Sales history

Past sales are the natural starting point. It helps to look at:

• the last few weeks, to gauge recent momentum
• the last few months, to identify a trend
• the same period last year, to account for seasonality
• several years, if you have enough history

Relying only on last month can be misleading if it was unusually good or bad.

Define the right scope

Before comparing figures, make sure they measure the same thing. A forecast can cover:

• revenue excluding or including VAT
• one store or several locations
• all channels or in-store sales only
• a day, a week or a month
• the whole business or a specific category

Comparing a brick-and-mortar store's revenue with a figure that also includes click & collect and online sales would skew the analysis. A consistent scope is a basic requirement for a good forecast.

Account for seasonality

Many stores have naturally busier and slower periods. Holidays, school vacations, seasonal sales, back-to-school, tourism and local events can all shift sales significantly.

So you need to compare periods that are truly comparable. Ideally, compare December with previous Decembers rather than with November. A week of seasonal sales should be compared with a similar period, not an ordinary week.

Calculate a simple seasonal index

One approach is to calculate:

Seasonal index = revenue for the period ÷ average revenue

If December has historically brought in 1.35 times your average monthly revenue, its seasonal index is 1.35. You can then use that index to adjust an estimate. Treat it as a historical benchmark, though, not a guarantee that next month will behave exactly the same way.

Identify the recent trend

Seasonality isn't enough on its own. A store may have made €40,000 last June but grown steadily since then. Copying last year's figure would probably underestimate sales. Conversely, a decline that has built up over several months needs to be factored in.

So look out for:

• steady growth
• a sustained decline
• flat sales
• price changes
• changes to your product range
• changes in opening hours or location
• events that have had a lasting impact on business

The goal is to separate what's seasonal from what reflects a real change in the store's business.

3 simple revenue forecasting methods

No single method suits every store.

Method 1: Start from the same period last year

This is often a good baseline for seasonal businesses. Take the revenue for the comparable period, then apply the known adjustments. For example:

• revenue for the same month last year: €42,000
• current trend: +6%
• planned sales campaign: estimated impact of +4%

The forecast is:

42,000 × 1.06 × 1.04 ≈ €46,300

This method is easy to explain and adjust.

Method 2: Use a moving average

For a fairly stable business, an average of the last few weeks can be a good baseline. For example, calculate average revenue over the last eight weeks, then adjust it for the season or known events. This method smooths out the effect of an unusually strong or weak week.

Method 3: Break revenue down into its drivers

When the data is available, you can break revenue down into several factors:

Revenue = traffic × conversion rate × average basket

This approach is especially useful for understanding why revenue might change. You can factor in an expected rise in traffic, a better conversion rate or a change in the average basket separately. It does require reliable enough data on foot traffic and conversion, though.

Factor in known events

A forecast shouldn't rely on history alone. Some upcoming events are already known:

• a promotion
• seasonal sales
• a public holiday
• school vacations
• a festival or local event
• a change in opening hours
• a product launch
• construction work
• an unscheduled closure

When a similar event has happened before, its history can help you estimate its impact. On the other hand, arbitrarily assigning “+10%” to a promotion with no reference data is just an assumption. So keep a clear line between effects measured in the past and the assumptions behind your forecast.

Build several scenarios

A single forecast can create a false sense of precision. It's often more useful to build several scenarios:

These scenarios let you plan for different outcomes without pretending to know exactly what the future holds.

Measure your forecast error

A forecast only becomes truly useful when you go back afterward and check what actually happened. Say:

• forecast: €46,300
• actual revenue: €44,800

Forecast: €46,300 / Actual revenue: €44,800

The gap is €1,500. You can then look into why:

• Did the promotion underperform?
• Was traffic lower?
• Did a stockout hold back some sales?
• Was the trend overestimated?

This step helps you steadily improve your next forecasts. Forecasting, measuring the gap and then adjusting your method works better than searching for a so-called perfect formula from day one.

The limits of revenue forecasting

A forecast is still an estimate. It can't precisely anticipate unpredictable events: a local incident, extreme weather, an unexpected closure, a supplier stockout or a sudden market shift.

Its reliability also depends on the quality of the data behind it. A very short history, unusual periods or incomplete data all add uncertainty, and the further out you forecast, the more uncertainty generally grows. That's why a forecast should be updated regularly as new information comes in.

Which metrics should you track for forecasting?

Several metrics help you interpret and improve your forecasts:

• revenue
• number of transactions
• average basket (average transaction value)
• units sold
• sales by product category
• stockout rate
• foot traffic and conversion rate, when available

You can also track gross margin alongside them. It isn't used directly to calculate future revenue, but it keeps you from running the store on sales volume alone. Higher revenue isn't necessarily a financial improvement if it depends on very costly promotions.

Forecast by location

For a multi-location business, an overall forecast can hide very different trends. One store may be growing while another declines. So it's often better to build a forecast for each location before consolidating the results. See multi-store management.

This approach also lets you fine-tune:

• inventory
• orders
• staffing needs
• specific sales initiatives

How AI can help with revenue forecasting

The value of AI isn't to “predict the future.” Its main benefit is making it easier to use the data you already have, building for example on sales analysis and anomaly detection. For example, a store owner can ask:

“Based on my recent sales, what trend is emerging for this month?”

Then dig deeper:

“What explains this trend?”

Or:

“Which product categories contribute most to the current change?”

AI can help compare several periods, identify trends or highlight items worth a closer look. But the quality of the analysis still depends directly on the data it can access and the assumptions used.

How can Gillia help you forecast revenue?

Gillia is an AI agent that lets you query your store's data to analyze how your business is trending. A request can start with:

“Compare my sales for the last three months with the same period last year.”

Then keep going:

“What trend is emerging?”

Or:

“Which product categories account for most of this change?”

When the necessary data is available, this analysis can serve as the basis for estimating upcoming periods and be updated as new sales come in. Above all, the point is to understand the factors that shape the projection, rather than get a single figure with no explanation.

Forecast to make better decisions

A forecast is only useful if it leads to a better decision. It can help you plan:

• restocking ahead of a busy period (see in-store inventory management)
• supplier orders (see supplier order forecasting)
• staffing needs
• cash flow
• a sales campaign
• production, for businesses that make their own products

The goal isn't to guess next month's revenue to the euro. It's to reduce uncertainty enough to make better decisions today.

With Gillia, forecasting is part of a broader approach: understand trends, anticipate changes and adjust what the store does, with day-to-day tracking on your store dashboard. To learn more, explore Gillia's use cases: anticipate upcoming revenue.

To go further, explore the Gillia POS: every sale updates your inventory, customer records and online store.