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:

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

  1. Open Google Sheets or Excel. Create three tabs.
  2. Build the Ingredients tab first. Enter every ingredient you use with current prices.
  3. In the Recipes tab, use VLOOKUP or INDEX/MATCH to pull costs from the Ingredients tab automatically.
  4. In Menu Pricing, reference recipe costs and calculate food cost percentage with a simple formula: =PlateCost/MenuPrice.
  5. 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

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 account

View this article in the app: https://percyplate.com/blog/free-food-cost-spreadsheet-template