Coffee Shop Spreadsheet: Drink Cost Calculator and Inventory Tracker for Excel and Google Sheets

Seller's description

Coffee shop business planner spreadsheet that tells you exactly what every drink costs you and which ones actually make money. 17 working tabs for cafes, coffee carts, mobile espresso bars and micro-roasteries. Works in both Excel and Google Sheets. Instant download.

Most coffee shop owners price their drinks by looking at the cafe down the street. This file replaces that guess with a number: enter what you paid for your beans, milk, syrups and cups, and the drink cost calculator works out your true cost per cup including labor, overhead and waste. Then it gives you three pricing methods and one recommended menu price.

WHAT'S INSIDE — 17 TABS

Setup Lists — your labor rate, overhead % and waste %, plus 21 editable lists that feed every dropdown in the file
Ingredient DB — every bean, milk, syrup and cup with automatic cost per unit
Drink Cost Calc — true cost per cup: ingredients, labor, overhead, waste
Pricing Calc — three pricing methods and a recommended menu price
Menu and Catalog — your full menu with profit and margin per drink, ranked in a chart
Daily Shift Log — cash and card per shift, with average revenue per drink
Order Tracker — catering and custom orders, deposits, delivery dates
Financial Tracker — income and expenses by category, net profit and margin
Roast Inventory — beans by origin and roast level with reorder alerts
Supply Inventory — milk, syrups, cups and packaging with reorder alerts
Supplier Compare — three quotes per item, cheapest supplier picked automatically
Customer Loyalty — regulars, stamps, spend and favourite drinks
Seasonal Menu — plan spring, summer, fall and winter drinks with margins checked
Maintenance Log — every clean, descale and repair with next due dates
Cart Event ROI — net profit and ROI for every market and pop up
To Do List — tasks by priority, category and status
Dashboard — 8 live KPIs and 3 charts, updated automatically

Plus a Start Here tab with a clickable index to every tab, so you never scroll looking for anything.

SMART DROPDOWNS
Nothing is hard coded. One Setup tab is the source of truth for every list in the file. Add a supplier, a category, a barista or a piece of equipment once and it appears as a dropdown option in every tab that uses it. No typing the same thing in five places.

WHAT YOU GET
- Coffee Shop Command Center spreadsheet, blank and ready to use (XLSX, works in Excel and Google Sheets)
- A filled sample version so you can see exactly how everything works
- Detailed User Guide PDF explaining every tab: what to fill in, what to leave alone and why

HOW IT WORKS
1. Download and make your own copy (File, Save As in Excel, or File, Make a copy in Google Sheets)
2. Fill in Setup Lists with your rates and your own dropdown lists
3. Load your ingredients, then cost and price your drinks
4. Log your shifts, orders and expenses — the Dashboard updates itself

No subscriptions, no apps, no accounts. Just a file that works the minute you open it.

BEFORE YOU BUY
This is a digital product delivered instantly, so no returns, refunds or exchanges are accepted. Please ask me anything before purchasing — I answer quickly and I would rather help you choose right than have you buy the wrong thing.

All my products come with personal support and one free customization: an extra column, an extra formula, a tab adapted to how your shop actually works. Message me after your purchase and I will build it for you.

For personal use only. Please do not resell, share or redistribute this file or its contents.

Sweet Hustle Studio — https://sweethustlestudio.etsy.com