Recipe Cost Calculator Spreadsheet, Bakery Pricing Calculator, Batch Scaler, Excel and Google Sheets

Instant digital download: recipe cost calculator spreadsheet for Excel and Google Sheets. You get 2 .xlsx files (blank and filled-in example) and a quick start guide. Nothing physical ships.

Know exactly what every cookie, loaf and cake costs. Type each ingredient's pack price and size once; recipes in grams, ounces, cups or teaspoons convert to a real cost per gram. You get cost per piece with labor, overhead and packaging, your food cost %, profit per piece and a suggested price. When flour goes up, every recipe updates.

Built for home and cottage bakers, small food businesses, meal preppers and anyone pricing what they make.

━━━━━━━━━━━━━━━━━━
WHAT'S INSIDE: 17 TABS
━━━━━━━━━━━━━━━━━━
• START HERE: 15-minute setup and how every number is calculated
• DASHBOARD: ingredients priced, recipes costed, recipes waiting on data, average food cost %, recipes below target, price rises, and your most profitable recipes ranked
• SETTINGS: labor rate, overhead per batch, target food cost %, and the unit conversions used
• INGREDIENTS: up to 200, with pack price, pack size and unit (g, kg, oz, lb, ml, l, tsp, tbsp, cup, fl oz, qt, gal, each), density for cup and spoon measures, usable yield %, allergens, on-hand amount and previous price
• RECIPES: up to 100, with yield, labor minutes, overhead, packaging and your price. Cost per piece, food cost %, profit and suggested price calculate
• RECIPE LINES: up to 1,000 ingredient lines; mix grams and cups in the same recipe
• SCALER: pick a recipe and a new yield, and every amount, gram and dollar scales
• SHOPPING LIST: plan batches of up to 8 recipes. It totals every ingredient, subtracts what's on hand and rounds up to whole packs with an estimated spend

━━━━━━━━━━━━━━━━━━
FEATURES
━━━━━━━━━━━━━━━━━━
• Recipes with missing data are not priced: a missing price never makes a recipe look cheap, and the recipe shows how many lines to fix
• Cup and spoon measures convert with each ingredient's density; with no density, the line is marked ≈ as an estimate
• Flags any ingredient whose price rose 10% or more
• "Losing money per piece" and "Above target food cost" warnings
• Warnings for typos: prices typed as text, a unit that doesn't match how it's bought (eggs in grams), an ingredient that isn't on your list, duplicate names
• Lists that run out of room say so, and totals always include every row
• Blank files plus a filled-in bakery example (21 ingredients, 5 recipes)
• No macros. Shaded typing cells and dropdowns

━━━━━━━━━━━━━━━━━━
WHAT YOU'LL RECEIVE (3 files)
━━━━━━━━━━━━━━━━━━
1. Recipe-Costing-by-the-Gram_Blank.xlsx
2. Recipe-Costing-by-the-Gram_Example.xlsx
3. README.txt (quick start)

━━━━━━━━━━━━━━━━━━
INSTANT DOWNLOAD: HOW IT WORKS
━━━━━━━━━━━━━━━━━━
• After you pay, Etsy emails you a download link. You can also find the files under You ▸ Purchases and reviews.
• EXCEL: open the .xlsx file and click "Enable Editing". Excel 2016 or newer, including Microsoft 365 (Windows/Mac).
• GOOGLE SHEETS: go to sheets.google.com ▸ File ▸ Import ▸ Upload ▸ choose the file ▸ "Replace spreadsheet". Formulas, dropdowns and colors carry over.
• Works best on a computer. Phone and tablet apps are fine for quick entries.

━━━━━━━━━━━━━━━━━━
PLEASE NOTE
━━━━━━━━━━━━━━━━━━
• Manual entry: it doesn't connect to any account or import data automatically.
• Conversions are US measures. Densities in the example are typical values; weighing is most accurate.
• Example data is fictional.
• Formula cells are protected (no password) to prevent accidents; Review ▸ Unprotect Sheet if you want to customize.

━━━━━━━━━━━━━━━━━━
GOOD TO KNOW
━━━━━━━━━━━━━━━━━━
• Photos: the listing photos are screenshots of the actual file with a short caption, not mockups.
• Digital download: nothing physical ships. You get .xlsx file(s) for Microsoft Excel 2016 or newer, or free Google Sheets.
• Prices you set are your decision. This shows the numbers, not tax or business advice.
• Results depend on the numbers you enter. Treat any estimates as rough guides.
• License: for use inside your own single business. Please don't share, resell, or upload the file.
• Problem with your file? Message me on Etsy and I'll fix it within 2 business days or refund you through Etsy.

— Neon

Designed with the help of AI tools, then reviewed and tested by me.