Ice Cream Shop Inventory Spreadsheet
For scoop shops and creameries tracking ice cream tubs, mix-ins, cones and toppings through busy summer weekends. Know how many tubs of each flavor you have before the line forms.
Works in Excel, Google Sheets (File → Import) and Numbers. No sign-up.
| Item | Category | Storage | Unit | Par Level | On Hand | To Orderƒ | Unit Cost | Valueƒ | Supplier | Expiry |
|---|---|---|---|---|---|---|---|---|---|---|
| Vanilla Bean Ice Cream, 3 gal tub | Ice Cream | Dipping Cabinet / Hardening Freezer | tub | 8 | 5 | auto | 34 | auto | Blue Meadow Creamery | 2026-04-30 |
| Waffle Cones, 240-ct | Cones & Cups | Dry Storage | case | 3 | 2 | auto | 68 | auto | Sweet Supply Co. | 2026-09-15 |
| Rainbow Sprinkles, 5 lb | Toppings | Topping Bar Shelf | jar | 2 | 1 | auto | 21 | auto | Sweet Supply Co. | 2027-02-28 |
ƒ = calculated automatically by formula.
What's included
- Item
- Category
- Storage
- Unit
- Par Level
- On Hand
- To Order — calculated automatically
- Unit Cost
- Value — calculated automatically
- Supplier
- Expiry
Tips for using this template
- Count tubs by flavor at close, including open tubs as halves or quarters, to catch over-scooping.
- Keep par higher for the top three flavors; most shops sell more vanilla, chocolate and one signature flavor than everything else.
- Track cones and cups together by size since you can't sell a waffle cone without the sleeves.
Stop typing deliveries by hand
Every time stock arrives you have to copy the supplier invoice into your sheet. Upload the invoice or packing slip to our invoice to inventory converter and paste SKU, item, quantity and unit cost straight into this template.
More free templates
Small Business Inventory TemplateRestaurant Inventory TemplateReseller Inventory SpreadsheetRetail Store Inventory TemplateWarehouse Inventory TemplateHome Inventory TemplateBar & Liquor Inventory TemplateOffice Supplies Inventory TemplateBakery Inventory TemplateCoffee Shop Inventory SpreadsheetFood Truck Inventory TemplateCatering Inventory TemplateBrewery Inventory SpreadsheetFood Pantry Inventory TemplatePizza Shop Inventory TemplateWinery Inventory Spreadsheet