Costing
Recipe Costing Spreadsheet
Know exactly what each recipe costs before you put it on your menu.
₱499
No checkout provider is connected yet, so this product cannot be bought here. The catalogue is ready for one.
XLSX
Who it's for
Built for a specific job
A working Excel workbook that holds your ingredients once and costs any recipe built from them. It converts units, handles pack sizes and yields, and shows the cost per serving, food cost percentage, gross profit and margin.
- Small cafés and restaurants
- Home-based food businesses
- Food entrepreneurs costing a first menu
What you'll get
Everything in this product
- Start Here sheet with a five-step setup
- Ingredient Database — 40 ingredients with unit conversion
- Recipe Costing sheet — 30 lines per recipe
- Recipe Summary with packaging and labour kept separate
- Pricing Calculator with both pricing methods and rounding options
- Food Cost Dashboard with the four figures and a cost breakdown
- Instructions sheet with every formula written out
- Units reference table
Feature breakdown
What it actually does
An ingredient database
Enter what you buy once. Every recipe reads from it, so a supplier price change updates in one place.
Real unit conversion
Buy in kilos, cook in grams. Buy by the bottle, pour in millilitres. The workbook converts using the same factors as the calculator.
Yield and waste
A kilo of onions at 85% yield is ₱117.65 per usable kilo, not ₱100. The workbook costs the usable amount.
It refuses to guess
A count unit with no pack size, or weight against volume with no density, is flagged on the row and left out of the total rather than silently invented.
Both pricing methods
Price from a target food cost percentage or from the gross profit you want, side by side.
Protected formulas
Formula cells are locked so a stray paste cannot break the workbook. Input cells stay white and editable.
Example
A worked example
Example: the workbook ships with a five-ingredient chicken rice bowl already costed at ₱49.91 a serving, including a soy sauce priced by the bottle and used by the millilitre, and onions at an 85% yield. Change any input and every downstream figure follows.
What's included
Files and formats
Deliverables
- XLSX workbook, 8 sheets, formulas throughout
- Worked example recipe included
- Formats
- XLSX
- Version
- 1.0
- Last updated
- 2026-08-20
- Updates
- 12 months of updates
- Licence
- Single business licence. Use it in your own business, on any number of your own devices.
One XLSX file, downloadable immediately after purchase.
How it works
From download to answer
Set up your ingredients
Enter price, quantity, unit and yield for what you buy.
Build a recipe
Pick ingredients from a dropdown and enter how much of each you use.
Read the cost
Cost per serving appears with every line broken out.
Set a price
Use either pricing method, then choose a rounding.
Questions people actually ask
Will it work in Google Sheets?
Yes. It uses VLOOKUP, IF and SUM rather than Excel-only functions, so it opens and calculates in Google Sheets and Numbers.
How many recipes can I cost?
The Recipe Costing sheet holds one recipe at a time with up to 30 lines. Duplicate the sheet for each recipe, or save a copy per dish.
Why are some cells locked?
They hold formulas. Review > Unprotect Sheet with the password costmymenu if you want to change them.
Does it handle pack sizes?
Yes, and it insists on them. If you price something by the bottle and use it by the millilitre, it asks what the bottle holds instead of guessing.
Try it free first
The free calculator this is built around
Related products
Others reach for these next
Recipe Costing Spreadsheet
Know exactly what each recipe costs before you put it on your menu.
Get the product₱499 · Single business licence. Use it in your own business, on any number of your own devices.
Every figure in this product is an estimate based on what you enter. Real profitability also depends on labour, rent, utilities, taxes, delivery commissions, waste, discounts and other operating costs. All example data is illustrative, not a market rate or a benchmark.