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 HMRC and UK rules that apply, troubleshooting and FAQs
Make life easy with ONE spreadsheet
Running a restaurant, bar, pub or café means juggling bookings, deposits, rotas, suppliers, stock, invoices and receipts — usually spread across a paper diary, a group chat, a shoebox and a few half-finished spreadsheets.
The Hospitality Command Centre pulls all of it into one organised workbook that does the maths for you — so you spend less time on admin and more time with your customers.
Based in the US? Get the US Edition (Hospitality Command Center), with dollars, US dates, sales tax and US wording.
Sound familiar?
- A table or the function room double-booked because the diary wasn’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 rota scribbled on paper, photographed and sent round the group chat
- Running out of stock mid-service because nobody spotted it was low
- No real idea what last month’s takings, costs and profit were until you sit down with a calculator
None of that is a “you” problem — it’s a missing-system problem. 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 colour themes
- ✔ Comes with a fully filled-in example venue, 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, wages, net profit, outstanding balances, upcoming bookings and tax reserve), your next 10 bookings, colour-coded business health checks (revenue vs target, gross profit %, wage cost %, outstanding balances), staff costs this month vs last — plus 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 booking, party and private function with party size, room/area, status, quoted value and deposit. Balance due and payment status (Paid / Outstanding / Overdue) work themselves out.
DAILY TAKINGS — 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, bill-to, booking details, line items, VAT, amount paid and balance due. Save as a PDF and send.
INVOICE REGISTER — NEW — 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 — ideal for re-sending or chasing payment.
CUSTOMER DATABASE — regulars, corporate accounts and private clients with contact details and a lifetime invoiced total.
MENU & RECIPE COSTING — cost and sell price for every dish and drink, with gross profit £, GP % and a Healthy/Review flag against your target margin.
STOCK CONTROL — par levels and current counts; anything running low is flagged Reorder automatically, with stock value worked out for you.
SUPPLIERS — contacts, account references and total spend per supplier, calculated from your expenses.
EXPENSES — 2,000 ready-to-use rows. Pick a category and totals by category update instantly.
STAFF LIST — your team with roles, hourly rates, and hours and pay to date.
STAFF ROTA — 5,000 rows for shifts. Pick a name and the role, hourly rate, hours and shift cost fill in. Flag sick days and leave.
ROTA VIEW — a clean, printable 2-week rota built automatically — pin it up in the kitchen or behind the bar.
SETTINGS — your business details, targets, payment terms, tax reserve % and your choice of 6 colour themes: Navy & Gold, Forest Green, Burgundy & Cream, Ocean Blue, Charcoal & Copper or Terracotta.
START HERE — a simple step-by-step guide, so you’re up and running in minutes. No spreadsheet skills needed.
Plus a UK Tax Year Summary — revenue, expenses, net profit and an estimated tax reserve, calculated automatically.
What you get
- Hospitality_Command_Centre.xlsx — your blank, ready-to-use workbook
- Hospitality_Command_Centre_DEMO.xlsx — a fully filled-in example venue, so you can see everything working
Format
Instant digital download. Works in Microsoft Excel, Google Sheets and LibreOffice — on Mac, PC, Chromebook or tablet. Nothing to install.
How it works
- Buy and download
- Open in Excel, or upload to Google Sheets
- Follow the Start Here tab to add your business details and pick your colour theme
- Start logging bookings, takings and costs — everything else updates itself
One payment of £29.99. No subscription, ever.
Please note
This is a digital product — nothing will be posted. It’s a business-management template, not accounting or tax advice. For use in your own business only — please don’t resell or share the file.
Questions before you buy? Message me any time — happy to help!
Restaurant & Pub Spreadsheet FAQ
Do I need Microsoft Excel?
No. It works in Microsoft Excel, or free in Google Sheets.
Is it a subscription?
No. It is 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 instructions in the file walk 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 example data, so you can see exactly how it works before adding your own.
Is it Making Tax Digital (MTD) software?
No. It is a record-keeping spreadsheet that keeps your figures organised. If Making Tax Digital for Income Tax applies to you, you will need MTD-compatible software to submit your returns to HMRC.
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 is 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 will put it right or refund you. See the Refund Policy. This doesn’t affect your statutory rights.
How do I get my file?
It is an instant digital download. You will get a download link straight after checkout, and by email.
What if I get stuck?
Message me any time and I will help you get set up.
