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…
About this template
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.
$39
Excel & Google Sheets template — instant download on Etsy
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.
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 Ice Cream Shop Profit Tracker track?
The Ice Cream Shop Profit Tracker tracks Products & Sales; Sales Log; Expenses; Monthly P and L; Dashboard.
What do the example numbers show?
The included example shows: 12 products; 2980 units; base revenue 14,920; add-on revenue 405; total revenue 15,325.
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.
This template is a bookkeeping and planning tool only — not tax, legal, or CPA advice. Built by an accountant: B.S. Accountancy, ASU W. P. Carey.
VickeryFinance — “Know your numbers — without the accounting software.”
Gear that pairs with this tracker
Some links below are affiliate links. If you buy through them, Vickery Finance may earn a small commission at no extra cost to you. We only list gear genuinely used in this trade.