Restaurant Financial Model Spreadsheet Template for Excel & Google Sheets
An operating model built around the metrics restaurants actually run on - covers, average ticket, food cost percent, labor cost percent, prime cost, and EBITDA. Daily sales, cost lines, labor roster, and daypart mix in one workbook. Dual compatible with Microsoft Excel and Google Sheets.
One-time purchase
Restaurant Operating Model
Everything in This Restaurant Spreadsheet
Your Unit's KPIs at a Glance
Open the dashboard and see where the restaurant stands. Period revenue, covers, average ticket, and EBITDA sit on the top row. Food cost %, labor cost %, prime cost %, and EBITDA % sit beneath. A banner flags whether prime cost is at or above the 60% benchmark.
- 8 KPI cards covering revenue and cost ratios
- Prime cost banner against the 60% benchmark
- Daily sales trend and cost breakdown charts
Log Sales Day by Day
A 30-day register with covers and sales for each day. Average ticket is derived automatically. The total flows to the dashboard and feeds the daily sales trend chart, so you can see the weekend vs weekday pattern at a glance.
- 30-day register of covers and sales
- Average ticket auto-derived per day
- Powers the daily sales trend chart
Variable Costs and Fixed Opex
Set food, paper, and beverage as a percentage of sales - they flex with revenue. Then enter monthly fixed opex: occupancy, utilities, marketing, repairs, and other. Totals feed the dashboard's food cost % and EBITDA math.
- Food, paper, beverage as % of sales
- Occupancy, utilities, marketing, repairs, other
- Drives food cost % and EBITDA
Roster by Position
List every position - manager, chef, line cook, prep, server, bartender, busser, host - with headcount, hours per week, and hourly rate. Weekly cost calculates per row, monthly cost rolls up at 4.33 weeks per month.
- Position, count, hours/week, rate
- Weekly cost per row, monthly roll-up
- Uses a 4.33 weeks-per-month multiplier
Where Revenue Comes From
Split revenue across breakfast, lunch, dinner, and late night. Enter share percent and average ticket per daypart, and the sheet derives period sales and period covers for each one. A diagnostic for menu pricing and shift planning.
- Breakfast, lunch, dinner, late night
- Share % and avg ticket per daypart
- Period sales and covers auto-derived
Spot Pressure Before It Hits Margin
The dashboard surfaces prime cost - food plus labor as a percent of sales - against the 60% benchmark many casual restaurants use. Food cost % typically falls 28-35%, labor 25-32%. A green banner means you are within range, amber means it is time to look at the lines.
- Prime cost % vs 60% benchmark
- Food % and labor % alongside
- EBITDA % across the period
Configure It for Your Unit
Set your business name, currency, seat count, and days open in the period. The rest of the workbook reads these values - subtitles, headers, and the days-open figure that supports cover and revenue math.
- Business name, currency
- Seat count for context
- Days open in the period
Up and Running in 15 Minutes
Start on Settings, fill the labor roster, set cost rates, then log daily sales. Light gray cells are inputs. Average ticket, weekly labor, prime cost, and all KPIs are formulas - they update as you type.
- Settings, Labor, Cost Model, then Daily Sales
- 15-minute initial setup
- Single-unit operating model
Customizable & Flexible
Adapt the workbook to your concept. Rename labor positions, adjust cost rates, tweak the daypart split - the formulas update automatically. Works identically in Excel and Google Sheets.
- Rename positions and cost lines
- Adjust cost rates and daypart mix
- Excel and Google Sheets compatible
Ready to take control of your finances?
Set Up in 15 Minutes
How the Restaurant Model Works
Open in Excel or Google Sheets
Get instant access after purchase. Open in Microsoft Excel directly, or import into Google Sheets - no software to install, no add-ons.
Configure Your Unit
Set your business name, currency, seat count, and days open on the Settings sheet. Takes about 15 minutes.
Set Labor and Cost Rates
Fill the labor roster with position, count, hours, and rate. Set food, paper, and beverage as percent of sales, and enter fixed opex.
Log Daily Sales
Enter covers and sales each day. Prime cost, EBITDA, the dashboard banner, and the daily sales chart update automatically.
Customer Reviews
Used by Restaurant Operators Worldwide
"If I get half as good at handling my finances as you are at customer service, this'll be the best $26 I've spent lately."
"Great tool! Simplifies financial planning without the hassle of complex spreadsheets."
"I recently purchased your super convenient spreadsheet, it really helps me!"
"They're great and super intuitive. Thank you!"
Built for Single-Unit Operators
Why Operators Use This Model
Restaurant-Native KPIs
Built around covers, average ticket, food cost %, labor %, prime cost, and EBITDA - the numbers operators actually use.
No Formulas to Write
Enter numbers in highlighted input cells. Cost percentages, labor totals, prime cost, EBITDA, and all KPIs are pre-built.
Excel and Google Sheets
Works identically in Microsoft Excel and Google Sheets. No macros, no add-ons, no proprietary functions.
Free Lifetime Updates
All future improvements to the restaurant model included at no extra cost.
Your Financial Data Stays Private
Runs entirely in your spreadsheet. Your data stays in your file - we never see or store it.
One-Time Purchase
Pay once, use forever. No subscriptions, no monthly fees, no recurring charges.
Got Questions?
Frequently Asked Questions
Is this template free to use?
This template is not free, but it is available for a one-time purchase. This purchase gives you lifetime access to the template and all future updates.
What do you mean by lifetime access?
Lifetime access means that you will have access to this template for as long as you need it. You will not be required to pay any additional fees for continued access to the template or any future updates.
Do I need to sign up to use this template?
You don't need to create an account with us. The template works in Google Sheets, so you'll need a Google account. If you don't have one, you can create one for free at google.com. After you purchase the template, copy it to your Google Drive, and start using.
What are the benefits of using this template?
This template offers a range of benefits, including: Easy-to-use interface, Customizable to suit your needs, Secure and private, Regular updates and improvements, One-time purchase for lifetime access.
Can I get future updates?
Yes, you will receive all future updates to this template at no additional cost. This ensures that you always have access to the latest features and improvements.
Do you offer any discounts?
At this time, we do not offer any discounts on this template. However, the template is available for a one-time purchase, which provides lifetime access and free updates.
Do you have any access to my financial data?
No, we do not have access to your financial data when you use this template. The template is designed to be used in your own Google Sheets account, ensuring that your financial information remains private and secure.
Is this template financial advice?
Our templates are not financial advice. They are tools designed to help you manage your personal finances more effectively. If you need personalized financial advice, consider consulting with a financial advisor or accountant.
Can I make my own changes and customize this template?
Yes, you can make your own changes and customize this template to suit your needs. The template is designed to be flexible and adaptable, allowing you to add or remove sections, change formulas, and adjust formatting as needed.
Do you offer technical support?
This is a self-service product, and we do not offer technical support. However, if you encounter any issues or have any questions about the template, please contact our team for assistance. Because everyone's financial situation is unique, consider consulting with a financial advisor or accountant if you need personalized financial advice.
Do you offer refunds?
All sales are final. Because these are digital products delivered instantly, we do not offer refunds.
Can't find the answer you're looking for? Contact our team
Highlights:
Run Your Restaurant on the Right Numbers
Get the Restaurant Financial Model and track covers, prime cost, and EBITDA in Excel or Google Sheets.