Hospitality Command Centre — All-in-One Bookings, Rota & Accounts Spreadsheet for Restaurants, Bars & Pubs

Description

Stop running your venue off a paper diary and a shoebox of receipts. This is the problem solver: one spreadsheet that runs bookings, rota, invoicing, stock and accounts for your restaurant, bar or pub, so you save hours of admin every week.

SOUND FAMILIAR?

• Double-booked a table or function room because the diary wasn’t in one place
• Had to scroll through months of bookings just to see who’s actually in today or tomorrow
• Forgotten to chase a deposit or balance until after the event’s already happened
• Priced a dish on a guess because you’ve never actually costed the ingredients
• The staff rota scribbled on paper, photographed and texted round the group chat
• No real idea what last month’s takings, costs and profit actually were until you add it all up

None of that is a “you” problem, it’s a missing system problem. This template fixes it.

THE FIX: ALL IN ONE SHEET

The Hospitality Command Centre puts bookings, a live “who’s in today” view, invoicing, menu costing, stock, staff rota and full accounts all into one spreadsheet that does the maths for you. No formulas to write, no accounting background needed, just fill in the coloured cells.

BONUS: SEE IT IN ACTION

Your download includes a second file too – a fully filled-in example with sample bookings, menu items, stock, staff and a month of takings already entered, so you can see exactly how everything looks and works before you add your own data.

WHAT’S INSIDE

• Dashboard — today’s and this month’s takings, costs and profit at a glance, your next 10 upcoming bookings with times, colour-coded business health checks, staff cost trend and a 12-month revenue/cost/profit chart with a 3-month forecast.
• View Bookings — a clean, always-current list of just today’s and tomorrow’s bookings and events with times, so front of house always knows who’s coming in without scrolling through the full diary.
• Daily Takings — log food, drink and other sales every day, split out automatically for reporting.
• Reservations & Events — every booking with customer name, phone, email, event type, date, time, party size, room/area, status, quoted value, deposit and automatic balance due and payment status (Paid / Outstanding / Overdue), with the header row frozen so it stays visible as you scroll.
• Invoice — a proper letterhead invoice that fills itself in from a single Booking ID, ready to save as a PDF and send.
• Invoice Log — a running record of every invoice sent, so you always know what’s outstanding.
• Menu & Recipe Costing — cost every dish ingredient by ingredient and see your margin and mark-up calculated automatically, with the item name column frozen so it’s always visible.
• Expenses — 2,000 pre-built formula rows logged by category, feeding straight into your accounts.
• Stock Control — track stock levels, reorder points and supplier costs.
• Suppliers — every supplier’s contact details and terms in one place.
• Staff List — your full team with roles, pay rates and contact details.
• Staff Rota — 5,000 rows of scheduling, so you can plan shifts weeks or months ahead without ever running out of room.
• Rota View — a clean, printable weekly view of who’s working each shift, built from your Staff Rota.
• UK Tax Year Summary — revenue, expenses, net profit and an estimated tax reserve, calculated automatically.
• Start Here guide — a plain-English walkthrough of every tab, built into the workbook.

Every number flows automatically from your Bookings, Takings and Expenses tabs – enter it once, and the Dashboard, invoice, tax summary and charts all update themselves. No macros, no add-ons, no subscription.

FORMAT

Instant digital download – works in Microsoft Excel, Google Sheets and LibreOffice, on Mac, PC, Chromebook or tablet. Nothing to install.

HOW IT WORKS

1. Purchase and download the file
2. Open it in Excel or upload it to Google Sheets
3. Follow the Start Here tab to add your business details
4. Start logging bookings and takings – everything else updates itself

PLEASE NOTE

This is a digital product – no physical item will be shipped or posted. For personal/business use only, please don’t resell or share the file.

Questions before you buy? Message me any time, happy to help!