Recipe Costing: Spreadsheet or Software?

By Rob Bruni, founder of OpsEdge Hospitality, twenty years running restaurants, bars, clubs and resorts. Prices checked on vendor websites November 10, 2026. Part of our spreadsheet or software series.

Recipe costing is the job where a spreadsheet holds up best. A menu gets costed once, then updated when prices move, and the math is simple arithmetic. Software earns its place when your ingredient prices change faster than you can retype them, or when the same recipes have to stay in step across several kitchens. This page shows how to do it in a spreadsheet, what the software adds and costs, and where the line sits.

The short answer

For a single kitchen with a menu under about 80 items, a spreadsheet is enough. Build an ingredient price list, link every recipe to it, and one price change flows through every dish that uses the ingredient.

Software is worth it when you want invoice prices to update recipe costs automatically, when you manage many sub recipes and batch preps, or when several locations need the same recipe book with their own local prices.

We sell spreadsheet templates, so weigh our view with that in mind. The main comparison covers the full cost math and a five question test.

What the job takes

Costing a plate is the same five steps in any tool.

1. Build an ingredient price list. Every ingredient, its purchase unit, its price and its cost per recipe unit (ounce, gram, each).
2. Apply yield. A case of romaine or a whole strip loin is not 100% usable. The cost per usable ounce is what goes in the recipe.
3. Write the recipe card. Each ingredient, the quantity, and the extended cost. Sub recipes such as sauces and dressings get their own cards and feed into dishes by the ounce.
4. Total the plate cost. Add every component, including garnish, oil and bread if you serve it.
5. Compare with the menu price. Plate cost divided by price is the food cost percentage for the dish.

How to run it in a spreadsheet

The single rule that makes a costing spreadsheet work is that prices live in one place. Recipes look prices up from the ingredient list. They never have a price typed into them.

1. Enter every ingredient once on the price list with its purchase unit and current price.
2. Add a yield percentage for anything you trim, peel or cook down.
3. Build each recipe card by choosing ingredients from the list and entering quantities. The cost fills in by lookup.
4. Build sub recipes first, then use them as ingredients in dishes.
5. When a price changes, change it once on the price list. Every recipe that uses it updates.
6. Review plate costs against menu prices monthly, or whenever a major ingredient moves more than about 10%.

The recipe costing guide covers the method in full and the recipe yield guide covers trim and cooking loss. The food cost calculator and menu price calculator handle one dish at a time for free. For a full menu, our Recipe Cost Card System is built around a linked price list, and the Advanced Food Cost Calculator adds target pricing.

What software adds, and what it costs

Recipe software starts where the linked spreadsheet stops.

• Prices update from invoices. When the invoice is scanned, the ingredient price changes and every plate cost moves with it. Nobody retypes anything.
• Unit conversions are handled. Cases to pounds to ounces to portions, including volume to weight for common ingredients.
• Recipes become training tools. Photos, method steps, scaling and allergen tags live with the costing, on a tablet in the kitchen.
• Sales mix is connected. With a POS link, you see the cost and margin of what actually sold, which feeds menu engineering.

Prices are from each vendor's website on November 10, 2026. meez also lists one time setup fees for invoice processing and purchase feeds, so ask for the full first year cost.

Side by side

Stay or switch

Mistakes either way

These are the errors we see most, in spreadsheets and in software alike.

• Ignoring yield. Costing a trimmed protein at the case price can understate plate cost by 20% or more.
• Leaving out the small things. Fryer oil, garnish, sauces on the side and bread add up to real money on every plate.
• Typing prices into recipes. Once a price lives in two places, one of them is wrong.
• Costing once and never again. A costed menu is a snapshot. Recost when prices move, then use the numbers. The menu engineering guide shows what to do with them.

Questions

Keep reading