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
Tables
Recipes, Recipe lines, Ingredients
Fields
29
Views
grid, cards, dashboard
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.
13 fields · 3 sample rows
| RecipeText | PhotoAttachment | CategorySingle select | Portions per batchNumber | Menu priceCurrency | LinesLink to another table | Ingredients usedCount | Batch costRollup | Cost per portionFormula | Food cost %Formula | Profit per portionFormula | Suggested price (30%)Formula | Method notesLong text |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Paneer tikka | Starter | 8 | ₹340 | Paneer – paneer tikka, Yoghurt – paneer tikka, Spices – paneer tikka | 3 | ₹630.00 | ₹78.75 | 23.2% | ₹261.25 | ₹270 | ||
| Butter chicken | Main | 10 | ₹420 | Chicken – butter chicken, Butter – butter chicken, Cream – butter chicken, Spices – butter chicken | 4 | ₹1,033.56 | ₹103.36 | 24.6% | ₹316.64 | ₹350 | ||
| Chocolate brownie | Bakery | 16 | ₹160 | Chocolate – brownie, Butter – brownie, Eggs – brownie | 3 | ₹715.00 | ₹44.69 | 27.9% | ₹115.31 | ₹150 |
7 fields · 8 sample rows
| LineText | RecipeLink to another table | IngredientLink to another table | QuantityNumber | Base unitLookup | Cost per unitRollup | Line costFormula |
|---|---|---|---|---|---|---|
| Paneer – paneer tikka | Paneer tikka | Paneer | 1,200.0 | g | ₹0.420 | ₹504.00 |
| Yoghurt – paneer tikka | Paneer tikka | Hung curd | 400.0 | g | ₹0.180 | ₹72.00 |
| Spices – paneer tikka | Paneer tikka | Tikka masala | 60.0 | g | ₹0.900 | ₹54.00 |
| Chicken – butter chicken | Butter chicken | Chicken thigh | 2,000.0 | g | ₹0.378 | ₹755.56 |
| Butter – butter chicken | Butter chicken | Butter | 250.0 | g | ₹0.560 | ₹140.00 |
| Cream – butter chicken | Butter chicken | Fresh cream | 300.0 | ml | ₹0.220 | ₹66.00 |
| Spices – butter chicken | Butter chicken | Tikka masala | 80.0 | g | ₹0.900 | ₹72.00 |
| Chocolate – brownie | Chocolate brownie | Dark chocolate | 400.0 | g | ₹1.350 | ₹540.00 |
9 fields · 8 sample rows
| IngredientText | SupplierText | Pack priceCurrency | Pack sizeNumber | Base unitSingle select | YieldPercent | Cost per base unitFormula | Used inLink to another table | Price updatedDate |
|---|---|---|---|---|---|---|---|---|
| Paneer | Amul distributor | ₹420 | 1,000 | g | 100% | ₹0.420 | Paneer – paneer tikka | 14 Nov 2026 |
| Hung curd | Amul distributor | ₹180 | 1,000 | g | 100% | ₹0.180 | Yoghurt – paneer tikka | 14 Nov 2026 |
| Tikka masala | MDH wholesale | ₹450 | 500 | g | 100% | ₹0.900 | Spices – paneer tikka, Spices – butter chicken | 20 Oct 2026 |
| Chicken thigh | Licious B2B | ₹340 | 1,000 | g | 90% | ₹0.378 | Chicken – butter chicken | 17 Nov 2026 |
| Butter | Metro Cash & Carry | ₹560 | 1,000 | g | 100% | ₹0.560 | Butter – butter chicken, Butter – brownie | 9 Nov 2026 |
| Fresh cream | Amul distributor | ₹220 | 1,000 | ml | 100% | ₹0.220 | Cream – butter chicken | 14 Nov 2026 |
| Dark chocolate | Callebaut India | ₹1,350 | 1,000 | g | 100% | ₹1.350 | Chocolate – brownie | 30 Oct 2026 |
| Eggs | Local farm | ₹210 | 30 | piece | 100% | ₹7.000 | Eggs – brownie | 16 Nov 2026 |
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.
A week-by-week pregnancy diary for moods, symptoms, weight and bump photos, alongside every check-up and scan.
2 tables · 20 fieldsRecipe OrganizerYour personal cookbook — photos, ingredients, method, timings and diet tags — plus a meal plan that pulls from it.
2 tables · 24 fieldsSprint Planning TemplatePlan sprints against team capacity, move backlog items through the board, track velocity and capture daily stand-ups.
3 tables · 31 fields