#1 Free Recipe Costing Template

This free recipe costing template is built for smaller operations that need accurate food costs without paying for expensive software. If you’re running a coffee shop, sandwich counter, snack bar, or any kitchen with a focused menu, this Google Sheets template does the job — because I used something just like it for years to make real pricing decisions.

HOW IT WORKS

Your ingredients live in categorized tables. Your recipes pull costs directly from those ingredients. Change a supplier price in one place — every recipe using that ingredient updates automatically. No copying and pasting. No broken formulas. Just accurate food costs you can trust for menu pricing.

Who is this recipe costing spreadsheet for?

Perfect for operations managing 12 to 36 recipes.

WHAT THE TEMPLATE DOES (feature list)

  • Organizes ingredients by category — meat, dairy, produce, dry goods, or whatever categories fit your operation
  • Handles multiple units of measure — kilos, grams, pounds, ounces, cups, teaspoons — weight or volume, your choice
  • Calculates cost per portion automatically — enter your batch yield, get your unit cost instantly
  • Updates all recipes when ingredient prices change — change the price of flour once, every recipe using flour recalculates
  • Shows food cost percentage and gross profit — enter your menu price, see your margins immediately
  • Includes two pricing scenarios per recipe — compare your dine-in price versus your catering price side by side
  • Visual alerts for cost updates — highlights ingredients that haven’t been updated based on your custom timeframe
  • Works in Google Sheets or Excel — access it online or download it to work offline

BUILT FOR FOCUSED MENUS LIKE YOURS


Café with Pastries and Light Fare

If you’re running a café with a rotating selection of scones, muffins, cookies, and a handful of lunch sandwiches, this free recipe costing template is built for exactly your situation. Your ingredient list is manageable — flour, butter, sugar, eggs, a few proteins, some produce — but the margins on baked goods are only profitable when you actually know what they cost.

That blueberry scone looks like pure profit until you factor in the real cost of butter at today’s prices. With this template, you can cost out your banana bread, peanut butter cookies, croissants, and that turkey avocado sandwich, then see exactly what price point keeps you profitable. Pair this with the Menu Engineering Matrix to identify which items deserve prime menu placement and which ones are quietly bleeding margin.

Typical recipes: scones, muffins, cookies, banana bread, quiche, breakfast sandwiches, paninis, soups


Italian-Style Hot Sandwich Shop

Veal cutlet sandwiches, chicken parm subs, and Italian combos loaded with roasted peppers, provolone, and hot giardiniera — these sandwiches have real ingredient depth, which means real cost complexity. Your proteins are expensive, cheese prices fluctuate constantly, and that specialty bread isn’t cheap either. This free recipe costing template lets you break down every sandwich by component: the breaded veal cutlet, the marinara, the melted cheese, the toppings.

When chicken prices spike, you’ll see instantly how it affects your signature chicken cacciatore sub. When your cheese supplier raises prices, every sandwich using provolone updates automatically. For operations doing higher volume or expanding beyond 30+ recipes, the FoodCostChef Calculator handles unlimited recipes with full cascading cost updates. Cool Italian sandwich shop here with a typical menu that would work well with this google sheets recipe template.

Typical recipes: veal parmigiana sandwich, chicken cutlet sub, Italian combo, meatball sub, sausage and peppers, eggplant parm


Fish and Chip Shop

Fish and chips operations live and die on combo pricing — one-piece with fries and coleslaw, two-piece with rings, the family platter. Your food cost on each combo depends on accurate costing of the battered fish, the fries, the sides, and the extras like calamari, shrimp, and fish cakes. This free recipe costing template handles that structure perfectly.

Cost your beer batter recipe, your tartar sauce, your coleslaw — then build combos that show true plate cost. When cod prices jump (and they always do), you’ll know exactly how it hits your two-piece dinner before you get surprised at month-end. The template’s dual pricing feature is especially useful here: set your regular menu price in one column and your delivery app price in the other to compare margins side by side. Perfect fish and chip example here.

Typical recipes: beer-battered cod, fish cakes, calamari, breaded shrimp, coleslaw, tartar sauce, mushy peas, combo platters


Poutine Food Truck

Food trucks win on speed and simplicity, but your margins depend on knowing what every bowl actually costs. Fries, gravy, cheese curds — the classic poutine has only three components, but those components have real cost variability. Cheese curd prices swing seasonally, and your signature pulled pork or smoked meat poutine adds protein costs that need tracking.

This free recipe costing template lets you cost your base poutine, then build out your loaded variations — bacon poutine, butter chicken poutine, Montreal smoked meat poutine — and see exactly where your profit sits on each. The built-in food cost percentage calculator shows whether that $14 loaded bowl is actually making you money at festival pricing. When you’re ready to add menu engineering analysis to identify your stars and dogs, that template pairs perfectly with this one.

Typical recipes: classic poutine, pulled pork poutine, bacon poutine, butter chicken poutine, smoked meat poutine, vegetarian poutine, house gravy


Pub with Wings and Fingers Menu

Wings, chicken fingers, mozza sticks, and a handful of fried appetizers — pub finger food menus are deceptively simple until you realize your margins live or die on sauce costs and portion control. That signature honey garlic glaze or house-made blue cheese dip? Those costs add up across hundreds of orders.

This free recipe costing template lets you cost each sauce recipe, assign per-portion costs to your wings and fingers, and see true plate cost on every basket. When wing prices spike — and every pub operator knows that pain — you can instantly see whether your 1lb wing special still makes sense or if it’s time to adjust pricing. The template’s yield tracking is especially useful here for accounting for fryer oil turnover and sauce waste. For operations adding full entrées or expanding the menu beyond appetizers, the FoodCostChef Calculator scales with you.

Typical recipes: bone-in wings (multiple sauces), boneless wings, chicken fingers, mozzarella sticks, jalapeño poppers, onion rings, house-made dips and sauces

collapsable recipes for easy navigation
The ingredients are separated by category and in collpasible columns for easy navigation.

ADDITIONAL DETAILS / FAQ (optional expandable section)

How many recipes can this handle? Realistically, 24–36 recipes across multiple categories. Beyond that, you’ll want something more robust like the FoodCostChef Calculator.

Does it work on Mac? Yes — Google Sheets runs in any browser. You can also download it as an Excel file if you prefer working offline.

How do I update ingredient prices? Just change the invoice price in the ingredient table. Every recipe using that ingredient recalculates automatically.

What’s the yield factor for? It accounts for real-world product loss — spillage, spoilage, waste, staff consumption, over-portioning. A 95% yield means 5% of what you buy never reaches a customer’s plate. This keeps your costs honest.

Can I customize the categories? Absolutely. Rename them, add new ones, organize however makes sense for your kitchen.

More Food Costing Tips:

Scroll to Top