Ice Cream Shop Profit Tracker

Ice Cream Shop Profit Tracker Excel for your products — flavors and scoops, ingredient cost, and a monthly P and L dashboard. Know what every unit actually earns — and whether the month actually made money.

Built for ice cream shops and frozen dessert shops who need to know, products by products and units by units, what ingredient really costs — without accounting software. If the most-sold add-on earns less than a dollar a unit, this workbook shows it before the next menu goes to print.

WHAT'S INCLUDED (6 sheets):

- Products & Sales — product, category, units sold, price per unit, cost per unit, margin per unit, add-on revenue, and total revenue, for 12 products.

- Sales Log — date, product, sale or task, units, price per unit, amount, cost, and billable flag, for 17 rows in October 2026 (12 products, 4 party and catering orders, 1 complimentary tasting).

- Expenses — item, category, unit, quantity per month, cost per unit, monthly cost, and notes, for 12 expense items.

- Monthly P and L — revenue, ingredient cost, rent, utilities, staff, marketing, insurance, supplies and other expenses by month, Jan-Dec, with net profit and margin. Revenue and ingredient cost are formulas from the Sales Log.

- Dashboard — total revenue, products, units, billable vs non-billable units, capacity used, average revenue per unit, ingredient cost, gross profit and margin, expenses, net profit and margin, best and weakest products, revenue by product, costs by category, and units by product.

- Cover and How to Use — start here. Yellow cells are the only ones you edit.

EXAMPLE DATA (October 2026 — replace with your own numbers):

- 12 products; 2980 units; base revenue 14,920; add-on revenue 405; total revenue 15,325.

- 3004 units logged (2984 billable, 20 non-billable); capacity used 93.9 percent of a 3200-unit month; average revenue per billable unit 5.14.

- Direct cost 5,393; gross profit 9,932; gross margin 64.8 percent.

- rent 1,800, utilities 415, staff 1,450, marketing 150, insurance 135, supplies 720, other 144; total expenses 10,207; net profit 5,118; net margin 33.4 percent.

- Best product by revenue: Pint To-Go, 2,030. Best margin: Pint To-Go, 5.60 per unit. Lowest margin: Waffle Cone Upgrade, 0.95 per unit.

- Average price per unit 5.65; average revenue per product 1,277.08; best add-on revenue 140 (Pint To-Go).

HOW IT WORKS:

1. Download the Excel file instantly after purchase.

2. On sheet 1, enter each product's category, quantity, price per unit, cost per unit, and add-on revenue. Margin per unit and total revenue fill in by formula.

3. On sheet 2, add a row per sale: date, product (spelled exactly as on sheet 1), task, quantity, price per unit, and whether it was billable. Amount and cost fill in by formula. Main rows pull the price and cost from sheet 1.

4. On sheet 3, enter each month's item, quantity, and cost per unit.

5. On sheet 4, enter the seven expense columns each month, then check gross profit, capacity and net profit on the Dashboard.

HOW THE NUMBERS WORK:

Margin per unit is price per unit minus cost per unit. Total revenue is quantity times price plus add-on revenue. Gross profit is revenue minus direct cost. Average revenue per billable unit is total revenue divided by billable units. Capacity used is units logged divided by a 3200-unit month. Net profit is revenue minus direct cost and rent, utilities, staff, marketing, insurance, supplies, other — before the owner's own pay, which comes out of profit as drawings.

WHO IT'S FOR:

Ice cream shops, gelato shops, and frozen dessert shops who want flavor sales, ingredient cost per unit, margin per unit, and a monthly P and L in one workbook — without accounting software.

PLEASE NOTE:

- This is a digital download. No physical item will be shipped.

- Works in Microsoft Excel and Google Sheets (upload to Google Drive to open in Sheets).

- Example data for October 2026 is included (12 products, 2980 units, 3004 units logged in total, 12 expense items). Replace it with your own numbers.

- The example is simplified: net profit is before the owner's own pay — the owner takes drawings from profit, so add an owner-pay line on the P and L if you draw a salary. Capacity is measured against a 3200-unit month; change it on the Dashboard if your month is different.

- This is a bookkeeping and planning tool only, not tax, legal, or CPA advice.

- Due to the nature of digital downloads, refunds are not available. Message me before buying if you have a question.

Built by an accountant: B.S. Accountancy, ASU W. P. Carey, with revenue-reconciliation experience at Marriott and audit work at PwC.