Recipe Costing Template

Price your ingredients once, build recipes from them and get batch cost, cost per portion, food-cost % and profit per plate.

Sign in with your Edesy account, then click Use template in the preview to copy the base, with its sample rows, into your workspace.

Category

Planners

Tables

Recipes, Recipe lines, Ingredients

Fields

29

Views

grid, cards, dashboard

Tables, columns and sample rows

The 3 linked tables in this template, with their real columns, field types and sample rows. Copy the template to edit them in Edesy Tables.

Recipes

13 fields · 3 sample rows

  • Menu costing (Grid)
  • Cards (Cards)
  • Margins (Dashboard)
RecipeTextPhotoAttachmentCategorySingle selectPortions per batchNumberMenu priceCurrencyLinesLink to another tableIngredients usedCountBatch costRollupCost per portionFormulaFood cost %FormulaProfit per portionFormulaSuggested price (30%)FormulaMethod notesLong text
Paneer tikkaStarter8₹340Paneer – paneer tikka, Yoghurt – paneer tikka, Spices – paneer tikka3₹630.00₹78.7523.2%₹261.25₹270
Butter chickenMain10₹420Chicken – butter chicken, Butter – butter chicken, Cream – butter chicken, Spices – butter chicken4₹1,033.56₹103.3624.6%₹316.64₹350
Chocolate brownieBakery16₹160Chocolate – brownie, Butter – brownie, Eggs – brownie3₹715.00₹44.6927.9%₹115.31₹150
Field details
Recipe · Text
Photo · Attachment
Category · Single select
Starter, Main, Dessert, Bakery, Beverage
Portions per batch · Number
Menu price · Currency
INR
Lines · Link to another table
Links to Recipe lines
Ingredients used · Count
Batch cost · Rollup
sum of Line cost via Lines
Cost per portion · Formula
IF({Portions per batch} > 0, {Batch cost} / {Portions per batch}, BLANK())
Food cost % · Formula
IF(AND({Menu price} > 0, {Portions per batch} > 0), {Cost per portion} / {Menu price}, BLANK())
Profit per portion · Formula
IF({Portions per batch} > 0, {Menu price} - {Cost per portion}, BLANK())
Suggested price (30%) · Formula
IF({Portions per batch} > 0, ROUNDUP({Cost per portion} / 0.3, -1), BLANK())
Method notes · Long text

Recipe lines

7 fields · 8 sample rows

  • Lines (Grid)
LineTextRecipeLink to another tableIngredientLink to another tableQuantityNumberBase unitLookupCost per unitRollupLine costFormula
Paneer – paneer tikkaPaneer tikkaPaneer1,200.0g₹0.420₹504.00
Yoghurt – paneer tikkaPaneer tikkaHung curd400.0g₹0.180₹72.00
Spices – paneer tikkaPaneer tikkaTikka masala60.0g₹0.900₹54.00
Chicken – butter chickenButter chickenChicken thigh2,000.0g₹0.378₹755.56
Butter – butter chickenButter chickenButter250.0g₹0.560₹140.00
Cream – butter chickenButter chickenFresh cream300.0ml₹0.220₹66.00
Spices – butter chickenButter chickenTikka masala80.0g₹0.900₹72.00
Chocolate – brownieChocolate brownieDark chocolate400.0g₹1.350₹540.00
Field details
Line · Text
Recipe · Link to another table
Links to Recipes
Ingredient · Link to another table
Links to Ingredients
Quantity · Number
Base unit · Lookup
Base unit via Ingredient
Cost per unit · Rollup
sum of Cost per base unit via Ingredient
Line cost · Formula
ROUND({Quantity} * {Cost per unit}, 2)

Ingredients

9 fields · 8 sample rows

  • Price list (Grid)
IngredientTextSupplierTextPack priceCurrencyPack sizeNumberBase unitSingle selectYieldPercentCost per base unitFormulaUsed inLink to another tablePrice updatedDate
PaneerAmul distributor₹4201,000g100%₹0.420Paneer – paneer tikka14 Nov 2026
Hung curdAmul distributor₹1801,000g100%₹0.180Yoghurt – paneer tikka14 Nov 2026
Tikka masalaMDH wholesale₹450500g100%₹0.900Spices – paneer tikka, Spices – butter chicken20 Oct 2026
Chicken thighLicious B2B₹3401,000g90%₹0.378Chicken – butter chicken17 Nov 2026
ButterMetro Cash & Carry₹5601,000g100%₹0.560Butter – butter chicken, Butter – brownie9 Nov 2026
Fresh creamAmul distributor₹2201,000ml100%₹0.220Cream – butter chicken14 Nov 2026
Dark chocolateCallebaut India₹1,3501,000g100%₹1.350Chocolate – brownie30 Oct 2026
EggsLocal farm₹21030piece100%₹7.000Eggs – brownie16 Nov 2026
Field details
Ingredient · Text
Supplier · Text
Pack price · Currency
INR
Pack size · Number
Base unit · Single select
g, ml, piece
Yield · Percent
Cost per base unit · Formula
IF({Pack size} > 0, {Pack price} / ({Pack size} * IF({Yield}, {Yield}, 1)), 0)
Used in · Link to another table
Links to Recipe lines
Price updated · Date

Recipe Costing Template: questions

Yes. Copy the template, then import a .csv, .tsv or .xlsx file into any of its tables and map the columns. Delete the sample rows first if you do not need them.

Yes. An automation runs when a record is created, updated or matches a filter, when a form is submitted, on a schedule or when a date arrives, and can update or create records, call a webhook or post to a connected Slack channel.

Related templates