Forecast next week's restaurant takings from the same weekdays in four comparable weeks. Apply a recent-trading factor, then adjust only for confirmed bookings, bank holidays, local events and the seven-day weather outlook. Produce a base and cautious case. Compare both with actual takings every Monday.
An 8% miss on a £40,275 forecast is £3,222. That gap can distort a stock order, rota or cash decision even when the weekly estimate looked reasonable.
Four comparable weekdays give you a usable starting point
Export daily gross takings from the EPOS or delivery systems. Use one definition every week. Do not mix gross sales, platform settlements and bank receipts.
For each day next week, select the last four comparable occurrences. Exclude a closure, private hire or abnormal trading day unless next week has the same condition.
Four observations are a starting point, not a universal rule. Use eight or more weeks when trading is volatile. Keep the same weekday comparison so a strong Saturday does not lift a quiet Tuesday.
Keep the sheet plain. Make each step easy to check.
Recent trading changes the baseline before events do
Measure whether the whole site has moved up or down. Compare the average total of the latest two complete weeks with the previous two.
Apply that factor once to each weekday baseline. Do not also add the same recent growth as an event adjustment.
Use a median instead of a mean when one exceptional week still dominates the average. Keep a note explaining every excluded week. A clean forecast is reproducible by another manager.
Adjust only for evidence you can name
Scan the seven days ahead for confirmed bookings, bank holidays, school breaks, local fixtures, transport disruption and the Met Office forecast.
Use your own history. If two comparable home fixtures added £1,200 and £1,600, use £1,400. Put a new fixture in a range, not one confident total.
The GOV.UK bank-holiday calendar gives national dates. School dates vary by council. The Met Office provides a seven-day location forecast. Record the source and the time checked because conditions change.
Harbour Kitchen forecasts £40,275 for next week
The figures below are illustrative. Harbour Kitchen calculates these four-week weekday averages:
- Monday: £3,100
- Tuesday: £3,800
- Wednesday: £4,100
- Thursday: £4,600
- Friday: £6,800
- Saturday: £8,900
- Sunday: £4,200
The latest two complete weeks average £36,750. The previous two average £35,000.
The trend-adjusted baseline is:
A confirmed private booking adds £2,200. Two comparable home fixtures support a £1,400 Saturday uplift. Three comparable wet Thursdays averaged £600 below baseline, and the location forecast shows similar conditions.
Harbour Kitchen's typical absolute forecast error over eight reviewed weeks is 8%. Its cautious case is:
The £3,225 gap between base and cautious cases is not failure. It is the amount that needs a named decision before the restaurant commits cash.
A sales forecast becomes useful when it reaches cash and orders
Gross takings do not enter the bank at the same time. Delivery platforms deduct commission. Card receipts clear later. Cash sales clear immediately. Keep the sales forecast and cash-receipt forecast separate.
Put the settlement timing into the 13-week restaurant cash-flow forecast: https://involiqo.com/blog/13-week-cash-flow-forecast-restaurant. Use the slow-January method when next week sits inside a predictable seasonal trough: https://involiqo.com/blog/restaurant-cash-flow-slow-january.
Involiqo places the sales estimate beside cleared cash, approved bills and supplier line items. An 8% miss then becomes a visible headroom gap before the next order.
This forecast does not decide safe staffing on its own. Check the weekly wage affordability method against the complete payroll cost and bills due: https://involiqo.com/blog/afford-wages-this-week.
Monday's error matters more than Monday's explanation
Record actual daily takings beside the forecast. Calculate the error in pounds and as a percentage.
Label the cause: covers, average spend, closure, weather, event, delivery platform or data error. Do not rewrite the old forecast after actuals arrive.
After eight weeks, calculate the typical absolute error. Use that percentage to set the cautious case. If the same cause misses repeatedly, change the method rather than adding another untested adjustment.
Frequently asked questions
How many weeks of sales history should a restaurant use?
Start with four comparable occurrences of each weekday. Use eight or more when trading changes sharply or one-off events are common. For a seasonal business, also compare the same period last year. Exclude closures and private hires unless next week contains the same condition. Keep a written exclusion log.
Should the forecast use gross sales or bank deposits?
Use one consistent sales definition for operating demand, normally gross EPOS takings. Build a separate cash-receipt line using card and platform settlement timing, commission and cash banking. A £5,000 sales day is not automatically £5,000 of cleared cash that day.
How should weather and local events change the forecast?
Use your own comparable days. Measure the average difference between normal trading and similar rain, heat, fixtures or festivals. Add confirmed bookings separately. For a new event, create a range and keep the cautious case near the unadjusted baseline until the site has evidence.
Key takeaways
- Compare the same weekdays across four or more clean weeks
- Apply the recent-trading factor once
- Add only evidenced events and confirmed bookings
- Keep sales timing separate from cleared cash timing
- Record forecast error every Monday and update the cautious case
Put seven numbers beside next week's calendar
Build the Monday-to-Sunday baseline today. Write the source beside every adjustment. On Monday, compare forecast with actual before changing the next week.
See how Involiqo brings cash, approved bills and supplier line items into one weekly view at https://involiqo.com/#bento-overview.
Sources
- British Business Bank — How to create a cash-flow forecast in four steps: https://www.british-business-bank.co.uk/business-guidance/guidance-articles/finance/how-to-create-a-cash-flow-forecast-in-4-steps
- GOV.UK — UK bank holidays: https://www.gov.uk/bank-holidays
- GOV.UK — School term and holiday dates: https://www.gov.uk/school-term-holiday-dates
- Met Office — UK forecast guide: https://weather.metoffice.gov.uk/guides/uk-forecast
See it in practice
See your operational data more clearly.
Explore how Involiqo brings invoices, cash flow and supplier cost information into one practical view.