Restaurant Cash Flow Forecast Template
Built around daily card settlements, weekly food and beverage purchases, tip payouts and the seasonal swings every restaurant lives with. Pre-built with the cash lines, scenarios and dashboard restaurant owners need.
- Forecast views
- 13-week, 12-month, 3-year
- Works in
- Excel, Google Sheets
- Built for
- Restaurant
$39
This template is in its final checks. Leave your email and we’ll send it the day it’s ready, with a launch discount.
Inside the template
What’s inside
- 13-week weekly forecast linked to a 12-month monthly view and 3-year outlook
- Cash in lines ready to use: Dine-in sales, Takeout and delivery app payouts, Catering and private events, Gift card sales
- Cash out lines ready to use: Food purchases, Beverage and alcohol purchases, Hourly payroll and tips payout, Rent and CAM charges
- Best, expected and worst case scenarios with one switch
- Actual vs forecast tracker with variance highlighting
- Dashboard: lowest balance, runway, buffer alerts and charts
- Loan, tax and one-off payment schedules
- Start-here tab with a filled-in Restaurant example
- Excel (.xlsx) and Google Sheets versions
Why a Restaurant forecast is different
Built around daily card settlements, weekly food and beverage purchases, tip payouts and the seasonal swings every restaurant lives with. A generic template makes you invent these lines yourself and guess at timing. This one starts with them in place.
What you’ll see after 20 minutes
- The week your balance is lowest over the next quarter
- How many months of runway you have at current spending
- What happens to cash if sales drop 20%, or a large customer pays late
- Whether you can afford a hire, an equipment purchase or a slow season
What’s in the file
A start-here tab with instructions, a settings tab for your dates and opening balance, the weekly and monthly forecasts, a scenarios tab, an actuals tracker and a one-page dashboard you can print or send to your bank.
Questions people ask
Do I need accounting experience?
No. You enter numbers in clearly marked cells. The instructions tab walks through a filled-in example first.
Can I change the categories?
Yes. Rename, add or delete lines. Totals and charts update automatically.
What do I receive after buying?
An instant download link by email with the Excel file and a Google Sheets copy link.
Is there a refund?
If the template doesn’t fit your business, email us within 14 days for a refund.