Food Cost Spreadsheet Template: Free Download & Guide
A step-by-step guide to building a food cost tracking spreadsheet, with the exact columns, formulas, and layout you need — plus when it's time to upgrade to software.
A food cost spreadsheet is a structured workbook that tracks ingredient prices, calculates recipe costs per portion, and monitors food cost percentage over time. It is the most common first step in food cost management for restaurants — inexpensive, flexible, and immediately useful — though it becomes fragile and time-consuming as the menu grows beyond 20-30 items.
Why Track Food Cost in a Spreadsheet?
Every restaurant needs to know its food cost percentage — the ratio of ingredient cost to selling price. Without tracking it, you're guessing at profitability. A spreadsheet is the fastest way to start: zero cost, no learning curve, and you can build exactly the tracker you need.
The goal is straightforward: for every dish on your menu, know the cost per portion and the food cost percentage. These two numbers tell you whether a dish is profitable, which dishes need repricing, and where your margin is strongest.
Sheet 1: Ingredient Price Database
The foundation of any food cost spreadsheet is a single sheet listing every ingredient you buy, with its current price per unit. This is the source of truth — every recipe cost calculation pulls from this sheet.
| Column | Example | Purpose |
|---|---|---|
| Ingredient Name | Chicken Breast | Unique, consistent naming |
| Supplier | Metro | Track where you buy each item |
| Pack Size | 5 kg | What the supplier sells |
| Pack Price | €42.50 | What you pay per pack |
| Unit Price (per kg/L) | €8.50/kg | = Pack Price / Pack Size (the formula cell) |
| Yield % | 85% | Usable portion after trim/waste |
| Effective Price | €10.00/kg | = Unit Price / Yield % (true cost of usable product) |
| Last Updated | 2026-05-10 | Prices go stale — this column keeps you honest |
A chicken breast at €8.50/kg with 85% yield actually costs €10.00/kg of usable meat. Skipping the yield column understates your true food cost by 10-20% on most proteins and produce.
Keep this sheet alphabetized and update prices every time you receive a new invoice. Stale prices are the number-one source of inaccurate food cost data — a price from three months ago is essentially fictional.
Sheet 2: Recipe Costing
Each recipe gets a section (or its own tab) that lists ingredients, quantities, and costs. The critical formulas:
Extended Cost (per ingredient)
Example: 200g of chicken at €10.00/kg = 0.2 × 10.00 = €2.00
Cost Per Portion
Example: recipe total €12.40 ÷ 4 portions = €3.10 per portion
Food Cost Percentage
Example: €3.10 ÷ €14.00 × 100 = 22.1%
Link ingredient prices from Sheet 1 using cell references (e.g., `=VLOOKUP(A2, Ingredients!A:E, 5, FALSE)`). This way, updating one ingredient price in Sheet 1 ripples through every recipe that uses it.
Hardcoding prices in recipe sheets instead of linking to the ingredient database means you update every recipe manually when prices change. With 40 recipes and shared ingredients, that's hundreds of cells to update — and you'll miss some.
Sheet 3: Menu Cost Overview
A summary sheet that pulls cost-per-portion from each recipe tab and compares it to the selling price. This is your management dashboard — one glance shows which dishes are within target and which are not.
| Dish | Cost/Portion | Selling Price | Food Cost % | Status |
|---|---|---|---|---|
| Pasta Carbonara | €3.10 | €14.00 | 22.1% | Within target |
| Grilled Salmon | €6.80 | €19.00 | 35.8% | Above target |
| Caesar Salad | €2.40 | €12.50 | 19.2% | Within target |
| Beef Burger | €4.20 | €14.50 | 29.0% | Within target |
| Lobster Risotto | €9.50 | €24.00 | 39.6% | Above target |
Use conditional formatting to highlight dishes above your target range (typically 28-35%). The dishes flagged here are your candidates for portion adjustment, ingredient substitution, or repricing. This is the beginning of menu pricing strategy.
Sheet 4: Weekly Food Cost Tracker
Recipe-level costing tells you what each dish should cost (ideal food cost). The weekly tracker tells you what you actually spent. Both numbers matter — the gap between them is where profit leaks.
Actual Food Cost %
Run this calculation weekly, not monthly — monthly is too late to act on problems
A 2-3% gap between ideal and actual is normal. Above 5% signals waste, theft, or over-portioning
Enter your inventory value at the start of the week, add all purchases, subtract ending inventory, and divide by total food sales. Compare to your ideal food cost (from the recipe costing sheets). The restaurant food cost formula article covers this in detail.
Spreadsheet Best Practices
- One ingredient database, referenced everywhere — never hardcode prices in recipe sheets
- Date-stamp every price update — stale data is worse than no data because it creates false confidence
- Lock formula cells — protect sheets so staff can update prices without accidentally breaking formulas
- Version the file — use "FoodCost_2026-05-12" naming or a shared drive with version history
- Back up weekly — a corrupted spreadsheet with no backup means starting over
- Audit monthly — spot-check 5 ingredient prices against recent invoices to catch data entry errors
When the Spreadsheet Stops Working
Spreadsheets are a great starting point. They stop working when:
- You have more than 30 recipes — cross-sheet references become fragile and slow
- Multiple people edit the file — version conflicts corrupt formulas, even on shared drives
- Recipes share sub-components — a chicken stock used in 8 recipes needs its own costing, and VLOOKUP chains get brittle
- Prices change frequently — updating 50+ ingredients monthly takes hours and errors compound
- You need shopping lists from recipes — aggregating ingredients across recipes in a spreadsheet requires complex macros that break easily
- You open a second location — the spreadsheet doesn't sync, and two copies diverge immediately
At this point, recipe management software replaces the spreadsheet. The transition is straightforward: export your ingredient list, import it into the software, and rebuild your recipes with auto-costing. Most teams complete the migration in 1-2 weeks and immediately gain automatic cost recalculation, scaling, and shopping list generation. The comparison between Cucinovo and spreadsheets covers the full trade-off.
A spreadsheet is the right tool to start tracking food cost. It becomes the wrong tool when your menu exceeds 30 items, prices change frequently, or multiple people need to edit it. Know when to upgrade.
More in This Topic
Key Takeaways
- Build your spreadsheet on a single ingredient price database sheet — every recipe references it via formulas, never hardcoded prices.
- Include yield percentage in your ingredient database. A €8.50/kg chicken breast with 85% yield actually costs €10.00/kg usable.
- Track both ideal food cost (from recipes) and actual food cost (from weekly inventory). The gap reveals waste and inefficiency.
- Date-stamp every price update. Stale prices create false confidence and lead to mispriced menu items.
- Spreadsheets work for up to 30 recipes with stable prices. Beyond that, cross-references break, updates take hours, and errors compound. Know when to upgrade to software.
Outgrown your spreadsheet?
Cucinovo auto-calculates recipe costs when ingredient prices change, generates shopping lists from your menu, and scales recipes with one click. 14-day free trial.
Start free trial