Download the free template

Download the template (CSV for Excel or Google Sheets)

Open it in Excel, Google Sheets or Numbers. Each row has the package price, package size, amount used and a formula that works out the line cost. The totals at the bottom give the batch cost, cost per serving and a menu price at 30% food cost. The example rows use example prices; replace them with yours.

What each column means

  • Package price: what you paid for the case, bag or jar.
  • Package size and amount used: in the same unit, like ounces.
  • Line cost: package price ÷ package size × amount used.
  • Servings and target food cost %: give the cost per serving and menu price.

Where spreadsheets get hard

A template works for a few dishes. With a full menu, every price change means hunting through tabs, and one broken formula throws off a whole sheet. In Saucebook you update an ingredient price once and every dish that uses it recosts instantly. See the spreadsheet alternative.

Or cost it in the free calculator Save it free in Saucebook

Opens the free calculator. Paste your recipe and type your prices. No signup. Saving recipes, scaling and recosting needs a free account, on the web on any phone or computer. One account works everywhere.

Questions

Is the recipe costing template free?

Yes. It's a plain CSV file with formulas, and no email is needed to download it.

Does it work in Google Sheets?

Yes. In Google Sheets choose File, Import, and upload the file. Excel and Numbers open it directly.

What's the difference between the template and Saucebook?

The template is a one-recipe sheet. Saucebook keeps all your recipes and recosts every dish when you update an ingredient price.