The Cocktail and Wine Bar Business Management System is an all-in-one cocktail and wine bar business spreadsheet. Log every sale, chase unpaid invoices, run your stock take, keep on top of daily checks, certificates and risk assessments, and see your profit on a live dashboard. It costs £15 once, with no subscription and no app.
Why a spreadsheet instead of an app
- One-off £15, not a monthly fee
- Works offline in Excel you already own, or in Excel online with your team
- Your data stays in your file
- Fully editable: add your own checks, stock items, hazards and categories
Built for bar owners
- Daily, weekly and monthly checks: fridges, ice machine and glass washer working, garnishes and syrups prepped and dated, recipe specs and measures followed, challenge 25 briefed and refusals logged, licence summary displayed and more, each showing Up to date, Due soon or Overdue.
- Compliance register with renewal reminders: premises licence under the Licensing Act 2003, designated premises supervisor with a personal licence, licence conditions and opening hours followed, music licence (PPL PRS) if playing music, food business registration if serving food, plus fire risk assessment, public and employers’ liability insurance, national Living Wage and right to work checks, data protection and VAT.
- Risk assessment template: 7 pre-filled hazards with likelihood × severity scoring and 12-month review dates.
- Stock take: pre-loaded with spirits, wine by the glass and bottle, liqueurs and vermouth, mixers and soft drinks and more, with usage, stock value and reorder alerts.
- Operations tracker: drink or product, category, customers or units sold, revenue, costs and gross profit on every line, with "delivery or stock take due" reminders.
- Key figures for your trade: customers, average spend per head, drinks cost % of revenue and gross margin.
Money and admin, done for you
- Sales and VAT: net, tax and gross on every sale
- Invoice tracker and debtors report with aged debt and a "chase these first" list
- 12-week cash flow forecast with shortfall warnings
- Quarterly VAT summary, profit and loss by month, budget vs actual and a pricing calculator
- Expenses, staff hours, rota, customers, suppliers, assets and maintenance logs
Works wherever you are
- 5 languages: English, Spanish, French, German and Portuguese
- 25 countries and currencies
- Excel 2016+, Microsoft 365, Excel for Mac and Excel online. No macros.
What you get
- Cocktail and Wine Bar Business Management System (.xlsx), 24 working sheets, with example data that's easy to delete and a Start Here guide
Read: How to start a cocktail and wine bar business in the UK · How much a bar owner earns · The KPIs to track · Free startup cost calculator
Often used alongside: Pub Operations Management System · Mobile Bar Business Management System · Restaurant Business Management System · Microbrewery Management System
Need a business plan too? Cocktail and Wine Bar Business Plan Template: £10 · Or get everything: Full Business Pack: £20 (save £5)









