By Heidi Macomber · July 13, 2026 (updated July 28, 2026)
Free Food Cost Spreadsheet Template (And Why You Will Outgrow It)
A food cost spreadsheet helps you track recipe costs, calculate food cost percentages, and price your menu. This guide gives you a free template structure, explains how to set it up, and shows you where spreadsheets hit their limit -- and what to do when they do.
The Free Food Cost Spreadsheet Template
If you want to build your own food cost spreadsheet, here is the structure that works. You need three tabs: Ingredients, Recipes, and Menu Pricing.
Tab 1: Ingredients
This is your master price list. Every ingredient you buy goes here.
| Column | What to Enter | Example |
|---|---|---|
| Ingredient Name | Name | All-Purpose Flour |
| Supplier | Where you buy it | Restaurant Depot |
| Package Size | How much you buy | 25 lb bag |
| Package Cost | What you paid | $13.75 |
| Cost Per Ounce | Package Cost / (Package Size x 16) | $0.034/oz |
| Cost Per Cup | Cost Per Ounce x 4.5 | $0.155 |
| Yield % | Edible portion after prep | 100% (no waste) |
| Adjusted Cost/Cup | Cost Per Cup / Yield % | $0.155 |
| Last Updated | Date of last price check | 2026-07-01 |
Tab 2: Recipes
Each recipe gets its own section.
| Column | What to Enter | Example |
|---|---|---|
| Ingredient | Linked from Tab 1 | Chicken Breast |
| Recipe Quantity | Amount used | 24 oz |
| Unit | Measurement | oz |
| Cost | Qty x Cost Per Ounce | $5.24 |
| Ingredient | Linked from Tab 1 | Long Grain Rice |
| Recipe Quantity | Amount used | 2 cups |
| Unit | Measurement | cups |
| Cost | Qty x Cost Per Cup | $0.31 |
At the bottom: Total Recipe Cost and Cost Per Serving (Total / Number of Servings).
Tab 3: Menu Pricing
| Column | What to Enter | Example |
|---|---|---|
| Menu Item | Name | Chicken Rice Bowl |
| Plate Cost | From Tab 2 | $2.63 |
| Menu Price | What you charge | $10.50 |
| Food Cost % | Plate Cost / Menu Price | 25.0% |
| Profit Per Plate | Menu Price - Plate Cost | $7.87 |
| Target % | Your goal | 28% |
| Status | Above/Below target | On Target |
Free Downloadable Templates
Want to skip the manual setup? Download these pre-built CSV templates -- they work in Google Sheets, Excel, or any spreadsheet program:
- Ingredient Cost Tracker (CSV) -- Pre-filled with 15 common ingredients and all the cost-per-unit formulas. Just update with your prices.
- Recipe Costing Calculator (CSV) -- A worked example showing how to calculate plate cost and food cost percentage. Copy the pattern for your own recipes.
To use in Google Sheets: Open a new Google Sheet, then File > Import > Upload the CSV. The formulas will work automatically.
How to Set Up the Spreadsheet
- Open Google Sheets or Excel. Create three tabs.
- Build the Ingredients tab first. Enter every ingredient you use with current prices.
- In the Recipes tab, use VLOOKUP or INDEX/MATCH to pull costs from the Ingredients tab automatically.
- In Menu Pricing, reference recipe costs and calculate food cost percentage with a simple formula: =PlateCost/MenuPrice.
- When a supplier price changes, update it in the Ingredients tab. Every linked recipe updates automatically -- if you set up the lookups correctly.
The Limitations of a Food Cost Spreadsheet
Spreadsheets work when you have 5-10 recipes and update prices monthly. But they break down fast as you grow:
Problem 1: Unit conversion hell. Your recipe calls for 2 cups of flour. You bought a 25 lb bag. How many cups in a pound? (Answer: about 3.9 cups.) Now do this for 40 ingredients, and update it every time a recipe changes. This is where most people give up.
Problem 2: Yield calculations. Raw chicken yields 78% after cooking. Potatoes yield 80% after peeling. If you do not factor yield into every recipe, your costs are wrong. Most spreadsheets skip this entirely.
Problem 3: Multi-recipe price updates. If you use butter in 8 recipes and butter goes up $1.00/lb, you need every recipe to update. With VLOOKUP, it works -- until someone breaks a formula or deletes a row.
Problem 4: No mobile access. You are at Restaurant Depot checking prices. Can you update your spreadsheet on your phone? Technically yes. Will you? Probably not.
Problem 5: No sales data. A spreadsheet tells you recipe cost, but not which items are selling or whether your actual food cost matches your theoretical food cost.
When to Move Beyond a Spreadsheet
You have outgrown your spreadsheet when:
- You have more than 15 recipes and updating prices takes more than an hour
- You are not updating ingredient costs because it is too tedious
- You cannot calculate actual vs theoretical food cost
- You want to see profitability by menu item alongside sales data
- You have multiple people who need access
At that point, dedicated food cost software is not a luxury -- it is the difference between knowing your numbers and guessing.
What Percy Plate Does That a Spreadsheet Cannot
Percy Plate was built specifically for food trucks, caterers, cottage food operators, and small restaurants who have outgrown spreadsheets but cannot justify $300+/month enterprise software.
- Built-in unit conversions. Enter 2 cups, it knows that is 9 oz of flour. Enter 3 tablespoons, it knows that is 1.5 oz of oil.
- Automatic yield adjustments. Raw-to-cooked yield percentages are built in.
- Instant price ripple. Update butter from $4.99 to $5.49, and every recipe using butter recalculates immediately.
- Recipe scaling. Need to serve 200 instead of 4? One click.
- Revenue tracking. Connect your sales data to see actual vs theoretical food cost variance.
- Mobile-friendly. Check and update prices from your phone at the supplier.
Try it free at percyplate.com -- no credit card, no setup fee. If you are currently using a spreadsheet, import your ingredients via CSV and you are running in 5 minutes.
Related Guides
- How to Calculate Food Cost Percentage: A Complete Guide for Restaurants — Food cost percentage formulas
- Recipe Costing 101: How to Cost Out Any Recipe for Profit — Recipe costing fundamentals
- Actual vs. Theoretical Food Cost: Formula & Variance — Variance tracking methods
- What Is Percy Plate? A Recipe Cost Calculator Built for Real Food Businesses — When to upgrade from a spreadsheet
Stop guessing what your dishes cost.
Percy Plate calculates recipe costs, menu prices, and FDA-compliant labels for food businesses. Free to start.
Create your free accountView this article in the app: https://percyplate.com/blog/free-food-cost-spreadsheet-template