Coffee Shop Operations

Independent coffee shops and cafes

Menu margins, supplies and par levels, waste log, equipment service and orders for a cafe.

HospitalityFood and hospitalitycoffee shopcafewasteinventory
Use this template
☕

Coffee Shop Operations

The daily running of the shop in one page: the menu with margins, supplies against par, the waste log, machines and their service dates, and orders on the way. Start with the Dashboard, order whatever the Order? column flags and log waste before you close.

Dashboard

Opening and closing checklist

Dialing in and training baristas

Waste and ordering routine

Machine care and service

Menu

What the shop sells, with price, cost and margin.

Menu
Drink or foodStatusCategoryPrice (USD)Cost to make (USD)Sold last weekAdded
Flat whiteCoreEspresso$4.75$1.05410—
Oat milk latteCoreEspresso$5.50$1.40365—
AmericanoCoreEspresso$3.50$0.40150—
Pour-over, single originCoreBrewed$5$1.20120—
Cold brewCoreBrewed$4.75$0.90205—
Iced chaiSeasonalTea$5.25$1.1095—
Earl greyCoreTea$3.75$0.3540—
Brown butter croissantCorePastry$4.25$1.30260—

5 more rows

Supplies

Everything stocked, counted against par.

Supplies
SupplyCategoryCounted inOn handPar levelLast countedLast ordered
House blend beansCoffeelb3860Oct 17, 2026Oct 12, 2026
Single origin, GuatemalaCoffeelb1420Oct 17, 2026Oct 9, 2026
Whole milkMilk and dairygallon1218Oct 17, 2026Oct 16, 2026
Oat milkMilk and dairycase35Oct 17, 2026Oct 14, 2026
Vanilla syrupSyrupsbottle44Oct 17, 2026Sep 28, 2026
Chai concentrateSyrupscarton26Oct 17, 2026Oct 7, 2026
Croissant doughBakerytray36Oct 17, 2026Oct 17, 2026
Banana bread loavesBakeryloaf56Oct 17, 2026Oct 17, 2026

3 more rows

Waste log

Everything thrown away, with the reason and the value lost.

Waste log
What was wastedDateQuantityReasonValue lost (USD)Menu itemLogged by
Unsold croissantsOct 17, 20266Expired$7.80Brown butter croissantWilhelmina Tan
Banana bread slicesOct 16, 20264Expired$3.80Seeded banana breadWilhelmina Tan
Milk shot droppedOct 16, 20261Spill$1.10Flat whiteCyrus Delacroix
Wrong drink made, iced chaiOct 15, 20262Mistake$2.20Iced chaiDexter Halvorsen
Cold brew batch off tasteOct 14, 20263Quality$18Cold brewAnaya Petrovic
Egg sandwiches unsoldOct 13, 20265Expired$14Egg and cheddar sandwichWilhelmina Tan
Oat latte remakesOct 12, 20263Mistake$4.20Oat milk latteCyrus Delacroix
Croissants unsoldOct 11, 20269Expired$11.70Brown butter croissantWilhelmina Tan

1 more rows

Equipment

The machines that make the coffee, with service dates.

Equipment
MachineConditionKindLast servicedNext service dueTechnicianAdded
Two-group espresso machineWorkingEspresso machineAug 9, 2026Nov 7, 2026Bellwether Coffee Service—
Main grinderNeeds serviceGrinderMay 11, 2026Oct 8, 2026Bellwether Coffee Service—
Decaf grinderWorkingGrinderJul 20, 2026Jan 16, 2027Bellwether Coffee Service—
Batch brewerWorkingBrewerSep 3, 2026Mar 2, 2027In-house—
Undercounter fridgeWorkingRefrigerationApr 1, 2026Apr 1, 2027Coldline Repair—
Pastry ovenOut of orderOvenOct 3, 2025Oct 3, 2026Coldline Repair—
Walk-in coolerWorkingRefrigerationJun 20, 2026Dec 17, 2026Coldline Repair—

Orders

Orders sent to vendors and when they arrive.

Orders
OrderStatusPlacedArrivesOrder total (USD)VendorPlaced by
Weekly milk and dairyPlacedOct 17, 2026Oct 19, 2026$286Cascadia DairyCyrus Delacroix
Cups and lids restockDraft—Oct 24, 2026$410Greenware PackagingDexter Halvorsen
Roastery beans, wall and barPlacedOct 16, 2026Oct 20, 2026$640Fernwood roasteryDexter Halvorsen
Syrups and chaiDraft—Oct 15, 2026$198Lantern BeverageCyrus Delacroix
Cleaning suppliesArrivedOct 10, 2026Oct 13, 2026$74Tidy Supply Co.Dexter Halvorsen
Weekly milk and dairy, last weekArrivedOct 10, 2026Oct 12, 2026$301Cascadia DairyCyrus Delacroix

What's inside

6 tables · 20 views · 1 form · 2 row actions · 1 agent

6 pages

  • Coffee Shop Operations
  • Dashboard
  • Opening and closing checklist
  • Dialing in and training baristas
  • Waste and ordering routine
  • Machine care and service

5 tables

  • Menu2 views · 13 sample rows
  • Supplies2 views · 11 sample rows
  • Waste log4 views · 9 sample rows
  • Equipment6 views · 7 sample rows
  • Orders6 views · 6 sample rows