The Bubble Tea Shop Business Management System is an all-in-one bubble tea shop 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 bubble tea shop owners
- Daily, weekly and monthly checks: tapioca pearls cooked in small batches and timed, cooked pearls discarded after holding time, tea brewed, dated and held cold, sealer, shaker and boiler cleaned, fridge and freezer temperatures logged and more, each showing Up to date, Due soon or Overdue.
- Compliance register with renewal reminders: food business registration at least 28 days before opening, written food safety management procedures, allergen information for all 14 allergens, full ingredient labels on prepacked for direct sale items, late night refreshment licence if serving hot food or drink 11pm to 5am, 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 black, green and oolong tea, tapioca pearls, popping boba and jellies, fruit syrups and purées and more, with usage, stock value and reorder alerts.
- Operations tracker: drink, category, drinks sold, revenue, costs and gross profit on every line, with "delivery or stock take due" reminders.
- Key figures for your trade: drinks sold, average price per drink, ingredient 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
- Bubble Tea Shop 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 bubble tea shop business in the UK · How much a bubble tea shop owner earns · The KPIs to track · Free startup cost calculator
Often used alongside: Café & Coffee Shop Management System · Takeaway & Fast Food Management System · Dessert Parlour Business Management System · Juice and Smoothie Bar Business Management System
Need a business plan too? Bubble Tea Shop Business Plan Template: £10 · Or get everything: Full Business Pack: £20 (save £5)









