Restaurant Sales Forecast Excel Template

A restaurant sales forecast Excel template helps estimate future revenue using the variables that really drive a restaurant: covers, average ticket, opening days, service shifts, capacity and seasonality.

In a restaurant, sales are not just a monthly number. They are built table by table, service by service, day by day. A good forecast should reflect that reality instead of using a generic sales projection that could apply to any business.

This free Excel template is designed to help restaurant owners, managers and controllers prepare a more realistic revenue forecast.

Restaurant Sales Forecast Excel Template

A restaurant sales forecast Excel template is a spreadsheet used to estimate expected sales based on restaurant activity drivers.

Instead of starting only with a total revenue target, the model can work with practical assumptions such as:

Number of covers per day.
Average ticket or average check.
Lunch and dinner services.
Opening days per week.
Table capacity.
Expected occupancy.
Weekday and weekend demand.
Seasonality and special events.

This makes the forecast easier to understand and easier to challenge.

Why restaurant sales forecasting is different

Forecasting restaurant sales is not the same as forecasting generic product sales.

A restaurant has a physical capacity limit. It has busy days and slow days. It may have strong lunch service but weak dinner service. It may depend on tourism, office workers, local customers, weather, events or delivery channels.

That is why a restaurant forecast should consider:

How many people can be served.
How often tables can turn.
How much each customer spends on average.
Which days are stronger or weaker.
Whether sales come from dine-in, takeaway or delivery.
How seasonality affects demand.

A flat monthly forecast may look clean, but it often hides the operational reality of the restaurant.

Key variables in a restaurant sales forecast

A useful restaurant forecast should be built from drivers that management can understand and review.

1. Covers forecast

Covers represent the number of customers served during a period.

For example:

Covers per lunch service.
Covers per dinner service.
Covers per weekday.
Covers per weekend.
Total covers per week or month.

This is often the most practical starting point because restaurant revenue depends heavily on how many customers are served.

2. Average ticket

The average ticket, also called average check, shows how much each customer spends on average.

Restaurant sales = Covers x Average ticket

For example, if the restaurant expects 80 covers and an average ticket of 28, expected revenue would be:

80 x 28 = 2,240

This simple logic is easier to manage than a forecast based only on a monthly target.

3. Opening days and service shifts

Restaurants do not generate sales equally every day.

The template can separate:

Lunch service.
Dinner service.
Weekdays.
Weekends.
Closed days.
Holiday periods.

This is useful because a restaurant may have very different behavior on Monday lunch, Friday dinner and Sunday service.

4. Capacity and table turnover

A forecast should respect physical capacity.

If a restaurant has 50 seats, the forecast should not assume 200 dine-in customers in one service unless table turnover makes that possible.

Relevant variables include:

Number of seats.
Expected occupancy.
Table turns per service.
Service duration.
Booking limits.

Capacity does not guarantee sales, but it sets a realistic ceiling.

5. Seasonality and special events

Restaurant demand can change significantly during the year.

Examples:

Summer tourism.
Christmas dinners.
Local holidays.
Sports events.
Low season months.
School holidays.
Weather-sensitive periods.

A good forecast should allow adjustments for these patterns instead of assuming that every month behaves the same.

Restaurant sales forecast vs cash flow forecast

This page should not be confused with a cash flow forecast.

A restaurant sales forecast estimates expected revenue from customers, covers and average ticket.

A cash flow forecast estimates the future cash position of the business, including collections, payments, payroll, rent, taxes, suppliers and bank balance.

So the difference is clear:

Sales forecast: how much revenue can the restaurant generate?
Cash flow forecast: will the restaurant have enough cash?

Both are useful, but they answer different questions.

Restaurant sales forecast vs budget control

A forecast estimates what may happen. Budget control compares what actually happened against what was expected.

For example:

Forecast: expected covers and revenue for next month.
Budget control: actual covers and revenue compared with the target.

A restaurant can use this forecast template before the month starts and then use a budget control report to review performance after the month closes.

Restaurant sales forecast vs financial plan

A financial plan is broader than a restaurant sales forecast.

A full financial plan may include:

Investment.
Startup costs.
Funding needs.
Operating expenses.
Cash flow.
Profitability.
Break-even analysis.

This restaurant sales forecast focuses on one key part of that plan: expected revenue.

If the restaurant is preparing a new opening, investment proposal or full business case, the sales forecast can be one block inside a wider financial plan.

Practical example of restaurant revenue forecast

Imagine a restaurant with the following assumptions for Friday dinner:

Expected covers: 95 customers.
Average ticket: 32.

Expected sales would be:

95 x 32 = 3,040

If the same restaurant expects only 45 covers on Tuesday dinner with an average ticket of 27, expected sales would be:

45 x 27 = 1,215

This shows why daily and service-level forecasting is more useful than simply dividing the monthly target by the number of opening days.

What decisions can this template support?

A restaurant sales forecast can help management make better decisions about:

Staff scheduling.
Purchasing and stock preparation.
Menu planning.
Marketing campaigns.
Promotions for slow days.
Booking targets.
Expected monthly revenue.
Break-even sales levels.

The forecast is not only a finance file. It can connect kitchen, dining room, purchasing, marketing and management.

Common mistakes in restaurant sales forecasting

Some restaurant forecasts look precise but are based on weak assumptions.

Common mistakes include:

Using the same average sales for every day.
Ignoring lunch and dinner differences.
Assuming full capacity too often.
Not reviewing average ticket by service or channel.
Ignoring seasonality.
Mixing dine-in, delivery and takeaway without separating margins.
Forecasting revenue without considering operational capacity.
Not updating the forecast with actual results.

A good forecast should be realistic enough to be useful, not optimistic enough to look attractive.

How to make the forecast more useful

The template can become more powerful if it includes different views.

For example:

Sales by day.
Sales by service.
Sales by week.
Covers by day of week.
Average ticket by service.
Seasonality factors.
Forecast vs actual sales.

These views help detect whether the issue is customer volume, average ticket, service mix or seasonality.

When Excel is useful for restaurant forecasting

Excel can be very useful when the restaurant needs a flexible model.

It allows managers to:

Change expected covers quickly.
Test different average ticket assumptions.
Compare weekday and weekend scenarios.
Estimate the impact of special events.
Review different occupancy levels.
Prepare revenue projections before making decisions.

The value of the spreadsheet is not the formula itself. The value is the conversation it creates around capacity, demand and revenue.

When a restaurant needs more than Excel

Excel can be a good planning tool, but it may not be enough when the restaurant needs real-time operational data.

A more integrated system may be required when:

Sales must be connected directly to the POS.
Reservations need to update forecasts automatically.
Inventory and purchasing depend on forecasted demand.
Multiple locations must be consolidated.
Labor planning needs to be linked to expected covers.
Management needs daily dashboards.

In those cases, Excel can still be useful for planning and analysis, but it should be supported by operational systems.

A restaurant sales forecast Excel template helps estimate revenue using the drivers that matter in food service: covers, average ticket, services, capacity, weekdays, weekends and seasonality.

It is not the same as a cash flow forecast, a financial plan or a generic budget control file.

Its role is specific: help restaurant managers understand how sales may be generated and what assumptions are behind the forecast.

A good forecast does not remove uncertainty, but it makes the assumptions visible before decisions are made.

This restaurant sales forecast Excel template can be combined with other financial, pricing and profitability tools depending on whether you need to estimate restaurant revenue, control margins, simulate break-even volume or connect sales forecasts with cash and budget planning:

sales budget control template in Excel when you need to compare actual restaurant sales against budget, instead of preparing the initial sales forecast.

break-even point Excel template when you need to calculate the minimum restaurant sales volume required to cover fixed costs.

direct costing Excel template when restaurant sales forecasts need to be connected with food cost, variable costs, contribution margin and profitability analysis.

cash flow forecast template in Excel when forecasted restaurant sales need to be converted into expected collections, payments and future cash balance.

financial plan template in Excel when the restaurant sales forecast is part of a wider model including costs, investment, financing, profitability and long-term scenarios.

Frequently Asked Questions about Restaurant Sales Forecasts

What is a restaurant sales forecast Excel template?

It is a spreadsheet used to estimate restaurant revenue based on covers, average ticket, opening days, services, capacity and demand assumptions.

How do you forecast restaurant sales?

A simple method is to estimate expected covers and multiply them by the average ticket, then adjust by day, service, seasonality and capacity.

What is the difference between a sales forecast and a cash flow forecast?

A sales forecast estimates revenue. A cash flow forecast estimates the future cash position including collections, payments and bank balance.

Why is average ticket important?

Average ticket shows how much each customer spends on average and is one of the main drivers of restaurant revenue.

Can Excel be used for restaurant forecasting?

Yes. Excel is useful for creating flexible restaurant forecasts, testing assumptions and reviewing different scenarios before making decisions.

Download this Template here

More information about Controlling Tools

ERP ODOO Functional Consultant and Controller (Management Control & Controlling)

Dani Granero

More INFO and contact