Free Google Sheets Recipe Costing Template | Step-by-Step Tutorial

Download the free recipe costing template for Google Sheets and learn exactly how to calculate your food cost per portion. This step-by-step tutorial shows you how to set up ingredients, connect them to recipes, and see your costs update automatically when prices change. 🔗 GET THE FREE TEMPLATE: https://foodcostchef.com/free-recipe-... This recipe costing spreadsheet is built for smaller food service operations — cafés, sandwich shops, fish-and-chip shops, food trucks, and pubs with focused menus. If you're managing 24–36 recipes and need accurate food costs without the expense of monthly software, this template does the job. WHAT YOU'LL LEARN: Template overview and structure Adding ingredients with unit conversions Setting up yield factors for real costs Building a recipe and linking ingredient costs Calculating food cost percentage and menu pricing Using the price update alerts Scaling recipes and adding instructions WHAT THE TEMPLATE DOES: Organizes ingredients by customizable categories Handles multiple units — kilos, grams, cups, teaspoons Calculates cost per portion automatically Updates all recipes when ingredient prices change Shows food cost % and gross profit instantly Includes two pricing scenarios per recipe Works in Google Sheets or downloads to Excel FREE RESOURCES: 📊 Menu Engineering Matrix (free download): https://foodcostchef.com/menu-matrix 🧮 FoodCostChef Calculator (full software): https://foodcostchef.com/fccc ABOUT: I'm Chef Marty — 40 years in professional kitchens before building food cost tools for independent operators. I used templates like this one for years to run real food cost programs. Now I'm sharing it for free because accurate costing shouldn't require a monthly subscription. Website: https://foodcostchef.com TikTok: @foodcostchef LinkedIn/in/martyshmanka