Build guide
Craft Beer Brewpub OS
Craft Beer Brewpub OS: brew log and keg tracker, connected to menu items, recipe lines and ingredients - calculations, views and example rows already set up.
For: Restaurants, cafés, bakeries, caterers, food trucks, breweries and private chefs
- Linked databases
- 8
- Connections
- 5
- Automatic calculations
- 13
- Ready-made views
- 16
What it saves you
- Every batch from mash to keg with gravities and volume - ABV and brewhouse efficiency are calculated.
- Kegs by number with what is in them and where they are - kegs out at trade accounts too long are listed.
- 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
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
Brew Log
Every batch from mash to keg with gravities and volume - ABV and brewhouse efficiency are calculated.
8 fields · 1 calculated automatically · linked to Keg Tracker
Views: Cellar board, All batches
Keg Tracker
Kegs by number with what is in them and where they are - kegs out at trade accounts too long are listed.
6 fields · 1 calculated automatically · linked to Brew Log
Views: By location, Chase return
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 Craft Beer Brewpub OS →