Description
What’s in your download
- Your blank spreadsheet – ready for your own details (Excel and Google Sheets)
- A filled-in DEMO copy – the same sheet with sample data, so you can see every tab working
- A full PDF user guide – set-up, every tab explained, a simple routine, the IRS rules that apply, troubleshooting and FAQs
Based in the UK? Get the UK edition here.
Make running your restaurant easier with ONE spreadsheet. Reservations, deposits, invoices, menu costing, inventory, staff schedule, expenses and a live dashboard for your restaurant, bar or café, all in one workbook that does the math for you. Built for US venues, with dollars, US dates, 12-hour times and sales tax.
Sound Familiar?
- A table or the private room double-booked because the reservations weren’t in one place
- Deposits and balances chased late, or forgotten altogether
- Dishes priced on a guess, with no idea of the real profit per plate
- The staff schedule scribbled on paper, photographed and texted round the team
- Running out of something mid-service because nobody spotted it was low
- No real idea what last month’s sales, labor cost and profit were until you sit down with a calculator
None of that is a “you” problem. It’s a missing-system problem, and this fixes it.
Why You’ll Love It
- Enter things once. Your dashboard, invoices, charts and tax reserve all update themselves.
- See your whole business at a glance the moment you open it.
- Invoices fill themselves in, and every one is saved so you can pull it back up in seconds.
- Works in Excel and Google Sheets. No macros, no add-ons, no monthly subscription.
- Make it yours with 6 color themes.
- Comes with a fully filled-in demo restaurant, so you can see exactly how it all works before adding your own data.
What’s Inside: 16 Tabs
DASHBOARD: eight headline cards (revenue, cost of sales, gross profit, labor, net profit, outstanding balances, upcoming bookings and tax reserve), your next 10 bookings, color-coded business health checks (revenue vs target, gross profit %, labor cost %, outstanding balances), staff costs this month vs last, and charts that build themselves: revenue vs costs by month, cost breakdown by category, booking status, and your food / drink / other sales split.
VIEW BOOKINGS: just today’s and tomorrow’s bookings, with times. Perfect for the host stand or the pass.
RESERVATIONS & EVENTS: every table reservation, party and private function with party size, room/area, status, quoted price and deposit. Balance due and payment status (Paid / Outstanding / Overdue) work themselves out.
DAILY SALES: food, drink and other sales each day, covers, average spend per cover and the cash/card split.
INVOICE: pick a Booking ID or a customer and a professional invoice fills itself in: your business details and EIN, bill-to, booking details, line items, sales tax, amount paid and balance due. Save as a PDF and send.
INVOICE REGISTER: every invoice is logged with up to five line items. Type or pick an invoice number on the Invoice tab and the whole invoice reloads exactly as it was sent.
CUSTOMER DATABASE: regulars, corporate accounts and private clients with contact details (City, State & ZIP) and a lifetime invoiced total.
MENU & RECIPE COSTING: cost and menu price for every appetizer, entrée, dessert and drink, with profit $, margin % and a Healthy/Review flag against your target.
INVENTORY: par levels and on-hand counts. Anything running low is flagged Reorder automatically, with inventory value worked out for you.
SUPPLIERS: contacts, account numbers and total spend per supplier, calculated from your expenses.
EXPENSES: 2,000 ready-to-use rows with restaurant categories (food & drink purchases, rent & occupancy, utilities, licenses & permits, software & POS and more). Totals by category update instantly.
STAFF LIST: your team with roles, hourly rates, and hours and pay to date.
STAFF SCHEDULE: 5,000 rows for shifts. Pick a name and the role, hourly rate, hours and shift cost fill in. Flag sick days and PTO.
SCHEDULE VIEW: a clean, printable two-week schedule built automatically, showing shifts like “11a–9p”. Pin it up in the kitchen or behind the bar.
SETTINGS: your business details, targets, payment terms, tax reserve % and your choice of 6 color themes.
START HERE: a simple step-by-step guide, so you’re up and running in minutes. No spreadsheet skills needed.
Plus a calendar-year Tax Year Summary: revenue, expenses, net profit and an estimated tax reserve, calculated automatically.
What You Get
- Hospitality_Command_Center_US_v1.0.xlsx: your blank, ready-to-use workbook
- Hospitality_Command_Center_US_DEMO_v1.0.xlsx: a fully filled-in demo restaurant, so you can see everything working
Format
Instant digital download. Works in Microsoft Excel and Google Sheets, on Mac, PC, Chromebook or tablet. Nothing to install.
US customers see prices and pay in US dollars ($) at checkout.
How It Works
- Buy and download the files
- Open the main file in Excel, or upload it to Google Sheets
- Follow the Start Here tab to add your business details and pick your color theme
- Start logging reservations, sales and costs. Everything else updates itself.
Please Note
This is a digital product. Nothing will be shipped. For your own business use only; please don’t resell or share the file. This is a business-management template, not accounting or tax advice. Check current IRS and state rules, or ask a CPA, about sales tax, payroll and your own situation.
Questions before you buy? Message me any time. I’m happy to help!
Based in the UK? Get the UK edition of the Hospitality Command Centre instead.
Restaurant Spreadsheet FAQ
Do I need Microsoft Excel?
No. It works in Microsoft Excel, or free in Google Sheets.
Is it a subscription?
No. It’s a one-off payment and the file is yours to keep. There are no monthly fees.
I’m not good with spreadsheets. Is this for me?
Yes. You just type into the input cells and the totals, charts and dashboard update themselves. There are no formulas to write, and the Start Here tab walks you through it.
Can I see it before I buy?
Yes. Look through the screenshots above. Your download also includes a second copy filled in with a demo restaurant, so you can see exactly how it works before adding your own.
Does it handle sales tax?
Yes. Invoices have a sales tax line you can fill in, and Daily Sales is set up for your sales before tax. Rates and rules vary by state, so check what applies to you.
Does it do payroll?
No. It tracks shifts, hours and wage cost so you can see your labor cost %. Use your payroll provider for paychecks, withholding and payroll taxes.
Does it work on a Mac, iPad or phone?
Yes on a Mac: use Excel for Mac, or open it free in Google Sheets in your web browser. On an iPad or phone you can open it in the free Excel or Google Sheets app to check and update it, but a computer is easier for setting it up.
Can I get a refund?
Because it’s an instant digital download, I can’t offer a refund once the file has been downloaded. If the file is faulty and I can’t fix it, you were charged twice, or you received the wrong product, I’ll put it right or refund you. See the Refund Policy.
How do I get my file?
It’s an instant digital download. You’ll get a download link straight after checkout, and by email.
What if I get stuck?
Message me any time and I’ll help you get set up.