Most restaurant owners think cash flow forecasting is just fancy accounting. The reality? It's what separates owners who sleep well from those checking bank balances at 3 AM. A solid six-month forecast means you'll know exactly when money gets tight—and what to do about it.
Why a cash flow forecast is essential
A cash flow forecast isn't paperwork—it's survival planning. Profit and cash flow are two completely different beasts, and mixing them up destroys restaurants. Your P&L might show €5,000 profit while your checking account sits at zero.
💡 Example:
You sell €25,000 in January, but catering clients pay 30 days later. Your staff still expects their wages, and suppliers want payment on delivery.
Paper profit: €5,000. Bank balance: €0.
The basic structure of your cash flow forecast
Your forecast needs three pieces: money in, money out, and what remains. Create a table with six columns (January through June) and break everything into clear categories.
- Income: Revenue, loans, personal investments
- Fixed costs: Rent, insurance, software subscriptions, base salaries
- Variable costs: Food purchases, utilities, temporary staff
- One-time expenses: Equipment, renovations, licensing fees
Creating a realistic revenue forecast
Revenue projections kill most new owners—they're way too optimistic. Start conservative and build scenarios. New restaurants miss their targets by 30-50% regularly. And it's a pattern we see repeatedly in restaurant financials: owners project 70% occupancy from day one, then scramble for cash by month three.
💡 Example calculation month 1:
- Seats: 40
- Operating days: 25
- Occupancy rate: 30% (new restaurant reality)
- Average check: €28
- Monthly revenue: 40 × 0.30 × 25 × €28 = €8,400
Ramp up slowly: 40% month 2, 50% month 3, and so on.
⚠️ Note:
Calculate revenue excluding VAT for accurate cost comparisons. That 9% VAT goes straight to tax authorities.
Mapping out fixed costs
Fixed expenses hit your account each month—10 customers or 200, doesn't matter. List every mandatory monthly payment you'll face.
- Rent: Base rent plus service charges and annual increases
- Payroll: Gross wages plus 25% for employer contributions
- Insurance: Liability, legal coverage, property protection
- Utilities: Based on similar-sized establishments
- Services: Software, communications, waste management
Estimating variable costs
Variable expenses move with your sales volume. Calculate these as revenue percentages—it keeps your projections realistic and grounded in actual restaurant performance.
💡 Common percentages:
- Food costs: 28-35% of revenue
- Additional labor (peak times): 5-10% of revenue
- Marketing spend: 2-5% of revenue
- Repairs and maintenance: 1-3% of revenue
Accounting for seasonal patterns
Revenue swings throughout the year—plan for these cycles. January brings post-holiday slowdowns, while December often delivers your biggest sales months.
- Business lunch spots: Summer vacation periods kill weekday traffic
- Upscale dining: Holiday parties boost December, January crashes
- Outdoor seating: Weather drives everything—summer peaks, winter valleys
Buffer for unexpected costs
Equipment breaks, suppliers raise prices, and you'll need extra staff during busy periods. Build a 10-15% cushion into your expense projections.
⚠️ Note:
Maintain two months of fixed costs as emergency reserves. Cash flow problems kill more restaurants than bad reviews or tough competition.
Monthly review and adjustment
Your forecast isn't carved in stone—it's a living document. Compare actual results against projections every month and adjust future estimates. You'll get better at predicting patterns with experience.
Food cost tracking helps you monitor actual ingredient spending against forecasted percentages. Real-time data shows if you're staying within budget or need to make corrections.
How do you create a cash flow forecast? (step by step)
Create a table with 6 months
Put the months January through June in columns and create rows for income, fixed costs, variable costs, and total. Start with a simple Excel file or use Google Sheets.
Estimate your revenue conservatively
Calculate: seating capacity × occupancy rate × days open × average bill. Start with low occupancy (30%) and build up gradually. Calculate everything excluding VAT.
List all fixed costs
Note rent, salaries, insurance, energy, and subscriptions. You have these costs every month, regardless of your revenue. Don't forget employer contributions (25% on top of gross salary).
Calculate variable costs as a percentage
Calculate ingredients at 30-35% of revenue, extra staff at 5-10%, and marketing at 2-5%. This way these costs automatically increase with your sales.
Add a 15% buffer
Add 15% to your total expenses for unexpected costs. Something always breaks or suppliers raise prices. Better to be cautious than surprised.
Check your bottom line each month
Subtract expenses from income each month. Negative = cash shortage. Make sure you have enough startup capital for the first months of losses.
✨ Pro tip
Create three 6-month scenarios: conservative (60% of projected revenue), realistic (100%), and optimistic (120%). Review monthly performance against all three to spot trends early and adjust operations before cash gets tight.
Calculate this yourself?
In the KitchenNmbrs app you can do this in just a few clicks. 7 days free, no credit card.
Was this article helpful?
Frequently asked questions
How much working capital do I need beyond my initial investment?
Reserve 3-6 months of fixed costs as working capital. Most restaurants operate at a loss for 6-12 months, so you need cash reserves to cover shortfalls. Don't blow every dollar on equipment and renovations.
What happens if my actual revenue falls short of forecasts?
Update your projections immediately and identify cost-cutting opportunities. Variable costs will decrease with lower sales, but fixed expenses remain the same. Focus resources on customer acquisition and retention strategies.
Should VAT be included in my cash flow calculations?
Include VAT as a separate line item—you collect 9% from customers but remit it to tax authorities. Track it for cash flow timing, but don't count it as revenue or profit since it's not your money.
How frequently should I update my cash flow forecast?
Review monthly against actual results and adjust future projections accordingly. During your first year, check weekly if expenses are tracking to plan—early detection prevents major problems.
Is negative cash flow normal in the opening months?
Completely normal for new restaurants. Plan for it by securing adequate funding or credit lines before opening. Know exactly when you expect to reach break-even and have reserves to cover losses until then.
What's the difference between cash flow and profit forecasting?
Profit shows revenue minus expenses on paper. Cash flow tracks when money actually enters and leaves your bank account. You can be profitable but cash-poor if customers pay slowly or you have large upfront expenses.
How do I handle seasonal revenue swings in my forecast?
Research your restaurant type's seasonal patterns and adjust monthly projections accordingly. Build cash reserves during peak months to carry you through slow periods. Many restaurants fail because they don't prepare for predictable downturns.
📚 Sources consulted
- EU Verordening 852/2004 — Levensmiddelenhygiëne (2004) — Official source
- EU Verordening 853/2004 — Hygiënevoorschriften voor levensmiddelen van dierlijke oorsprong (2004) — Official source
- EU Verordening 1169/2011 — Voedselinformatie aan consumenten (2011) — Official source
- NVWA — Hygiënecode voor de horeca (2024) — Official source
- NVWA — Allergenen in voedsel (2024) — Official source
- Codex Alimentarius — International Food Standards (2024) — Official source
- FSA — Safer food, better business (HACCP) (2024) — Official source
- BVL — Lebensmittelhygiene (HACCP) (2024) — Official source
- Warenwetbesluit Bereiding en behandeling van levensmiddelen (2024) — Official source
- WHO — Foodborne diseases estimates (2024) — Official source
Food Standards Agency (FSA) — https://www.food.gov.uk
The HACCP standards shown in this application are for informational purposes only. KitchenNmbrs does not guarantee that displayed values are current or complete. Always consult the FSA or your local authority for the latest regulations.
Written by
Jeffrey Smit
Founder & CEO of KitchenNmbrs
Jeffrey Smit built KitchenNmbrs from 8 years of hands-on experience as kitchen manager at 1NUL8 Group in Rotterdam. His mission: give every restaurant owner control over food cost.
Calculate your break-even point in seconds
Food cost is just one part of the story. KitchenNmbrs also helps you structure labor costs and other expenses for a complete break-even overview. Start free.
Start free trial →