Shop · Small Business

Recipe Costing & Menu Pricing: photo 1 of 5 from its Etsy listing
Small Business

Recipe Costing & Menu Pricing

Recipe Cost Calculator UK, Menu Pricing Spreadsheet, Food Cost Percentage, Cafe Bakery and Home Baker Profit, Excel & Google Sheets

£12 Buy on Etsy

Instant download: Etsy takes the payment and sends you the files straight away.

Do you know what one scone, one fry or one slice of tray bake really costs you? Type in your ingredient pack prices once, then the recipes you make. This spreadsheet works out the cost per portion, your food cost percentage, your profit, and the exact price you'd need to charge to hit your target.

When a supplier puts a price up, type the rise into Price Check and see straight away which dishes go over target.

Recipe Costing & Menu Pricing: photo 2 of 5Recipe Costing & Menu Pricing: photo 3 of 5Recipe Costing & Menu Pricing: photo 4 of 5Recipe Costing & Menu Pricing: photo 5 of 5

What's inside (7 tabs)

  • Start Here: Your settings, five live totals and every dish ranked
  • Ingredients: Pack sizes and prices, turned into cost per gram, ml or each
  • Menu: Price, food cost %, profit and the price you need
  • Recipes: One line per ingredient in each dish
  • Recipe Card: Pick a dish to see its full costing
  • Price Check: Type a price rise and see which dishes go over target
  • Guide: How to use it, in plain English

What it does

  • Cost per portion for every dish, from your own pack prices
  • Food cost % and gross profit per portion
  • The price needed to hit your target food cost, with VAT added back
  • Price Check: see what a supplier's price rise does to your menu
  • Recipe card for any dish, with each ingredient's share of the cost

What you get

  • recipe_menu_costing.xlsx with example data, so you can see how it works
  • recipe_menu_costing_blank.xlsx: the same file, empty and ready for your own
  • A step-by-step PDF setup guide

What you need

  • Microsoft Excel 2010 or newer (including Microsoft 365), on Mac or PC
  • OR a free Google account to use it in Google Sheets (the guide shows you how)
  • Best on a computer or tablet. Not made for Apple Numbers

Please note

  • This is a digital download. No physical item will be sent
  • A costing tool, not tax advice. Check the VAT rules for your own products
  • For your own business use. Please don't resell or share the file

How it's made

Designed by me, built with the help of AI tools, then checked formula by formula in two different spreadsheet programs.

Recipe Costing & Menu Pricing £12
Buy on Etsy