Ice Cream Shop Profitability Dashboard — Daily Sales, Waste & Labor Tracker for Scoop Shops | Excel & Google Sheets Template with Weekly P&L

Stop forcing a restaurant template to fit your scoop shop.

If you've ever tried to track ice cream shop profitability in a generic restaurant spreadsheet, you already know the problem: nothing accounts for scoop count per container, flavor velocity, or freezer waste the way it actually happens behind the counter.

You end up averaging your costs, ignoring your top-sellers, and finding out your labor was 38% three weeks too late.

This dashboard fixes that.

Built for one location. Built for scoops.

The Ice Cream Shop Profitability Dashboard is a fully formula-driven Excel and Google Sheets workbook designed for single-location scoop shops, gelato bars, and frozen dessert cafés. It tracks every dollar that goes through your freezer case — from container cost to net margin — and gives you a weekly P&L that actually reflects how an ice cream business runs.

No more generic "food cost %." No more guessing which flavors pay the rent. No more discovering waste at the end of the month.

What's inside the workbook

🔧 Setup Tab — Enter your shop name, week start date, and 10 cost assumptions in one place: container cost, scoops per container, single/double/pint/quart pricing, target labor %, target waste %, fixed overhead per day, and sales tax rate. Build a catalog of up to 18 named flavors with categories. Every other tab pulls from here automatically.

📅 Daily Log — Log every flavor sold, every day. Enter single scoops, double scoops, pints, and quarts — the dashboard auto-converts to scoop equivalents (1 pint = 6 scoops, 1 quart = 12 scoops) and calculates revenue, COGS, gross profit, labor cost, labor %, and net margin per row. Pre-loaded with sample data from a 7-day week so you can see exactly how it works before you start typing.

📆 Day Summary — Aggregates every flavor by day so you can spot weekday vs. weekend patterns at a glance. Total scoops, total revenue, gross margin %, labor, fixed costs, and net profit by date.

🏆 Flavor Velocity Tab — The feature generic templates don't have. Ranks all 18 flavors by total weekly revenue, total scoops sold, waste cost, waste % of output, and revenue per scoop. Instantly shows which flavors are pulling their weight — and which are taking up freezer space without earning it.

🗑️ Waste Tracker — Auto-flags every flavor as ✅ Within Target, ⚠️ Watch, or 🚨 High Waste based on your target waste % from Setup. Built around the reality that ice cream waste isn't generic food waste — it's batch-specific, flavor-specific, and tied to container yield.

📊 Weekly P&L Summary — A complete profit-and-loss statement formatted the way an accountant actually wants to see it: revenue, COGS broken into product cost and waste, gross profit, gross margin %, labor cost, labor %, fixed overhead, net operating profit, and net margin %. Every line includes a Budget/Target column you fill in once and a Variance column that updates automatically. KPI scorecard at the bottom surfaces top flavor, highest-waste flavor, revenue per labor hour, and daily averages.

Why this beats a generic restaurant template

Who this is for

• Single-location scoop shop owners who want to know their numbers without hiring a bookkeeper
• New ice cream shop operators opening their first location and trying to set targets
• Gelato bars, frozen yogurt shops, and frozen dessert cafés that scoop and serve from containers
• Multi-flavor counter-service businesses that need to track velocity and waste by SKU
• Owners with seasonal swings who need a weekly dashboard, not a quarterly one

What this is not

This dashboard is built for single-location, container-served scoop shops. It is not designed for:

• Multi-unit franchises (no roll-up tab)
• Manufacturers selling pints to retail (use a wholesale margin calculator)
• Soft-serve operations without flavor-by-flavor tracking
• Catering or events businesses (use an events pricing calculator)

Format & delivery

• Excel (.xlsx) — opens in Microsoft Excel, Numbers, or Google Sheets (just upload the file)
• Pre-loaded sample data so you can test it before clearing it
• 1,393 working formulas — zero errors, fully editable
• Color-coded inputs (blue cells = type your numbers; everything else calculates automatically)
• 6 tabs, fully cross-linked
• Instant download after purchase

What you get

✓ The full Excel workbook (.xlsx) ✓ Quick-start guide explaining each tab in one page ✓ Sample data already populated for a 7-day demo week ✓ Lifetime use — no subscription, no expiration ✓ Free updates if the template is revised

About the build

Every formula was tested. Every tab is cross-linked. Every cost assumption flows from one Setup sheet, so you change your container cost in one place and the entire workbook updates. No copy-pasting numbers across tabs. No broken references. No spreadsheet headaches.

This is the dashboard we wish existed when generic templates kept missing the point.