What this does that other coffee-shop templates do not: it tracks freshness. Beans lose their peak weeks after roast and milk spoils in days, so on the Freshness sheet you enter a received/roast date and a shelf life, and the kit gives you a best-by date, the days left and a clear OK / USE SOON / EXPIRED flag against your stock date — so beans get pulled at their peak and milk never sours on the shelf. Every ingredient also carries its origin/grade and roast level (Arabica blend, medium-dark, barista oat), so what you serve is documented, not guessed. No pricing template on the market does this.

On top of that it does the money properly. On Ingredients you list what you buy — beans, whole and oat milk, syrups, chocolate, cups, lids, napkins — with pack price, pack size and the usable % after spillage, and the cost of one gram, millilitre or unit is worked out for you. On Recipes you build each drink; on Products the ingredient cost, your barista labour and a share of overhead roll up into the true cost of one latte, cappuccino, mocha or drip. Cups, lids and napkins are counted one-per-drink, so packaging is costed and stocked too — not forgotten like most sheets.

Pricing shows both numbers, named correctly: margin as a share of the price and markup as a share of the cost, side by side, plus the exact price for a target margin and the break-even cups at the price you actually charge — no more guessing whether "65%" meant off the price or on the cost. And it is a full stock room: a reorder point built from your own daily usage and supplier lead time flags every item OK, REORDER or OUT OF STOCK before you run dry mid-rush. The Sales sheet logs each day and the Dashboard adds it all up — revenue, COGS, gross profit and margin, net after fixed costs and the tax to set aside, stock value and which drinks earn the most.

Built for Excel 2016+ and Google Sheets with classic, compatible formulas only — no macros, no add-ons, nothing locked. Any currency (one symbol cell). Sample data for a real coffee shop is filled in so every number and the chart are alive on first open; clear the yellow cells and it is yours. Every headline figure in this listing was measured from the built file, recalculated by LibreOffice and checked against an independent model of the same arithmetic.