Juice Bar Smoothie Shop Profit Tracker Excel for your drinks — drinks and smoothies, produce cost, and a monthly P and L dashboard. Know what every drink actually earns — and whether the month actually made money. Built…
About this template
Juice Bar Smoothie Shop Profit Tracker Excel for your drinks — drinks and smoothies, produce cost, and a monthly P and L dashboard. Know what every drink actually earns — and whether the month actually made money. Built for juice bars and smoothie shops who need to know, drinks by drinks and drinks by drinks, what produce really costs — without accounting software. If the cheapest smoothie on the menu is also the thinnest margin, this workbook shows it before the next menu goes to print.
$39
Excel & Google Sheets template — instant download on Etsy
Drinks & Sales — drink, category, drinks sold, price per drink, produce cost per drink, margin per drink, add-on revenue, and total revenue, for 12 drinks.
Sales Log — date, drink, sale or task, drinks, price per drink, amount, produce cost, and billable flag, for 15 rows in October 2026 (12 drinks, 2 cleanse orders, 1 complimentary staff tasting).
Expenses — item, category, unit, quantity per month, cost per unit, monthly cost, and notes, for 12 expense items.
Monthly P and L — revenue, produce cost, rent, utilities, staff, marketing, insurance, supplies and other expenses by month, Jan-Dec, with net profit and margin. Revenue and produce cost are formulas from the Sales Log.
Dashboard — total revenue, drinks, drinks sold, billable vs non-billable drinks, capacity used, average revenue per drink, produce cost, gross profit and margin, expenses, net profit and margin, best and weakest drinks, revenue by drink, costs by category, and drinks by drink.
Cover and How to Use — start here. Yellow cells are the only ones you edit.
Quick profit check — Juice Bar Smoothie Shop Profit Tracker
Try the headline numbers for a typical month. The full template does this job by job with a monthly P&L and dashboard.
Frequently asked questions
What does the Juice Bar Smoothie Shop Profit Tracker track?
The Juice Bar Smoothie Shop Profit Tracker tracks Drinks & Sales; Sales Log; Expenses; Monthly P and L; Dashboard.
What do the example numbers show?
The included example shows: 12 drinks; 2525 drinks; base revenue 22,260; add-on revenue 240; total revenue 22,500.
Does it work in Excel and Google Sheets?
Yes. The workbook works in Microsoft Excel and in Google Sheets (upload the .xlsx file to Google Drive to open it in Sheets). It is an instant digital download from Etsy — no physical item is shipped.