Build guide
Retail Coffee Corner OS
Bean bag lists, roaster catalogs, daily waste logs, POS cash reconciliations, and cleaning schedules.
For: Restaurants, cafés, bakeries, caterers, food trucks, breweries and private chefs
- Linked databases
- 8
- Connections
- 5
- Automatic calculations
- 14
- Ready-made views
- 15
What it saves you
- Coffees on the shelf and in the hopper with roast date - beans past their best are listed before they go stale.
- POS total against card and cash counted - over/short and coffees per hour are calculated.
- Every dish shows its plate cost and food-cost % from its recipe lines
- Change one ingredient price and every dish that uses it updates
- Ingredients below par build your next order list automatically
- Fridge temperatures and checks are logged with who and when
How the parts work together
- Cost a dish: Add the dish and price → Add a recipe line per ingredient with quantity per portion → Read plate cost and food-cost %
- Order: Update stock counts → Open "Order list" grouped by supplier → Create a purchase order and check the invoice on delivery
- Stay safe: Log temperatures twice a day → Record actions for anything "Out of range"
Databases inside
Menu Items
Dishes and drinks with selling price. Plate cost rolls up from recipe lines, so food-cost % and margin are always current.
9 fields · 4 calculated automatically · linked to Recipe Lines
Views: Menu costing, Over target, By section
Recipe Lines
One row per ingredient per dish, with the quantity used. Line cost = quantity x the ingredient's current unit cost.
6 fields · 2 calculated automatically · linked to Menu Items, Ingredients
Views: By dish
Ingredients
Ingredients with pack size, pack price and stock. Cost per unit is calculated from the pack, and low stock flags itself.
10 fields · 2 calculated automatically · linked to Suppliers, Recipe Lines, Bean Stock
Views: Order list, All ingredients
Suppliers
Who you buy from, delivery days and order cut-offs, with the ingredients and orders linked to each.
7 fields · 2 calculated automatically · linked to Ingredients, Purchase Orders
Views: Suppliers
Purchase Orders
Orders to suppliers with totals and delivery status, so you can check what arrived against what was invoiced.
8 fields · linked to Suppliers
Views: Order status, To check
Food Safety Log
Fridge and freezer temperatures, cleaning and opening checks with who did them - your due-diligence record for inspections.
7 fields · 1 calculated automatically
Views: Recent checks, Out of range, Check calendar
Bean Stock
Coffees on the shelf and in the hopper with roast date - beans past their best are listed before they go stale.
7 fields · 2 calculated automatically · linked to Ingredients
Views: Past best, By use
Daily Cash-up
POS total against card and cash counted - over/short and coffees per hour are calculated.
7 fields · 1 calculated automatically
Views: Last 30 days
You get the finished workspace, not homework.
Buy it once for $29 or get it with your membership, then duplicate it into Notion with every field, link, formula, view and example row already set up.
See Retail Coffee Corner OS →