Recipe Cost & Bakery Pricing Calculator
Item highlights
Seller's description
Know what every batch really costs and what to charge for each box: ingredients by the cup, your time, packaging and Etsy's fees, worked backwards into a suggested price.
Type a recipe the way you bake it (2.25 cups flour, 1 tsp salt, 2 eggs) and each ingredient's cost fills in from the pack you buy (5 lb of flour, 26 oz of salt, a dozen eggs). Add the batch yield and how many go in a box, and the calculator solves for the price that still hits your profit margin after Etsy's transaction, payment processing, listing and ad fees. Type your own price and see its profit, margin and a green PASS or red FAIL.
WHAT'S INSIDE (one .xlsx workbook, 9 tabs)
• Start Here: how to use it, color key, notes
• Settings: Etsy's US fee rates (filled in and editable: 6.5% transaction, 3% + $0.25 payment processing, $0.20 listing, 15% Offsite Ads with its per-order cap), your Etsy Ads %, target profit margin, hourly rate and price ending (.99)
• Units: grams, kilograms, ounces, pounds, millilitres, liters, teaspoons, tablespoons, cups, fluid ounces, quarts, gallons, each, dozen and a stick of butter, with room to add your own (up to 25)
• Ingredients: up to 60: pack size, unit and price, plus grams per cup for anything bought by weight and measured by volume
• Recipe Ingredients: up to 300 rows: amount in any unit, converted into the unit you buy in and costed; a check column says when a unit can't convert
• Overhead: up to 12 monthly costs (kitchen share, insurance, permits, labels), shared across your sales
• Recipes: up to 40 products: batch cost, batch yield, pieces per pack, minutes per batch, packaging, overhead, cost per pack and per piece, shipping you charge and postage
• Pricing: for every product, the lowest price that hits your margin, a suggested price, and profit, margin, PASS / FAIL and your hourly pay at your own price
• Price Calculator: pick a product to see each cost, each Etsy fee and ad, break-even and target prices, 5 prices side by side with PASS / FAIL, a wholesale price check for cafés and shops, and the sales a month that cover your fixed costs
Plus a 2-page quick-start PDF.
WHO IT'S FOR
Home bakers and cottage bakeries selling cookies, cakes, breads and treats on Etsy, at markets or to cafés, who want prices that cover ingredients, time and fees with profit left over.
HOW IT WORKS
• Yellow cells are your inputs. Everything else is a live formula.
• Change an ingredient price (butter goes up) and every recipe, cost and PASS / FAIL updates.
• Cups and spoons are US measures. Grams per cup vary by ingredient, so the workbook uses yours.
• Example data for a made-up home bakery is filled in so you can see how it works. Type over it.
OPENS IN
• Microsoft Excel 2010 or newer, Windows or Mac, including Microsoft 365 and Excel for the web: open the .xlsx.
• Google Sheets: File → Import → Upload the .xlsx (free Google account).
• Apple Numbers 13 or newer: File → Open the .xlsx. In Numbers, the recipe, ingredient and unit dropdowns may become plain cells: type names exactly as on their tabs.
• LibreOffice Calc: open the .xlsx.
• No macros and no newest-only functions. Tested: LibreOffice recalculates every formula and must match the expected results.
• In Excel, formula cells are locked (no password) so you can't type over them by accident. Google Sheets and Numbers drop that lock on import, so type only in the yellow cells there.
• Made for a computer screen; phone spreadsheet apps aren't tested.
Not affiliated with Microsoft, Google or Apple.
WHAT IT ISN'T
• A pricing calculator, not financial, tax or legal advice. Sales tax isn't part of the fees.
• It doesn't cover cottage food laws, labels or permits; those depend on your state.
• No nutrition facts, order tracking or inventory counts.
• The fee rates are Etsy's US rates for 2026 and you can change any of them; check Etsy's fee page for your shop.
• Not affiliated with Etsy, Inc.
QUICK FAQ
• Can I use it on an iPad or tablet? Set it up on a computer, where it's tested. The iPad apps for Excel, Google Sheets and Numbers can open an .xlsx, but they aren't tested, so a dropdown or color may not work the same there.
• How many recipes? Up to 40 products, 60 ingredients, 300 recipe-ingredient rows, 25 units and 12 monthly costs.
• Can I download it again or reuse it? Yes, keep using it: change an ingredient price or a fee rate and every price recalculates. It also stays on your Etsy Purchases page.
• Can I rename things or customize it? Your ingredients and recipes are yours, you can add your own units (up to 25), and Etsy's fee rates, target margin, hourly rate and price ending are settings. To change the layout in Excel: Review → Unprotect Sheet (no password).
ALSO IN THIS SHOP
• Selling on Etsy? Etsy Seller Bookkeeping & Profit Tracker: every Etsy fee on its own line, cost of goods, and profit by product and by month.
https://www.etsy.com/listing/4589081888/etsy-seller-spreadsheet-etsy-bookkeeping
• Pricing 3D prints? 3D Printing Pricing Calculator: filament, machine time, electricity and failure rate, then the price that hits your margin after Etsy fees.
https://www.etsy.com/listing/4589227759/3d-printing-pricing-calculator
INSTANT DOWNLOAD
This is a digital file; nothing will be shipped. After purchase, download it from your Etsy Purchases page; you can download it again any time. Because it's a digital download, Etsy doesn't allow returns or exchanges. If the file won't open or something looks wrong, message me and I'll help or fix it.
For personal use. Please don't resell or share the file.
Designed by me with the help of AI tools.
If something goes wrong with an order, we've got your back for all eligible purchases. View program terms
NowPrice:$5.24
Original Price: $6.99
25% off
Sale ends in 6 days
You can only make an offer when buying a single item
Delivery
Instant download
Your files will be available to download once payment is confirmed. Here's how.
Instant download items don't accept returns, exchanges or cancellations. Please contact the seller about any problems with your order.
Seller's description
Specifications
Know what every batch really costs and what to charge for each box: ingredients by the cup, your time, packaging and Etsy's fees, worked backwards into a suggested price.
Type a recipe the way you bake it (2.25 cups flour, 1 tsp salt, 2 eggs) and each ingredient's cost fills in from the pack you buy (5 lb of flour, 26 oz of salt, a dozen eggs). Add the batch yield and how many go in a box, and the calculator solves for the price that still hits your profit margin after Etsy's transaction, payment processing, listing and ad fees. Type your own price and see its profit, margin and a green PASS or red FAIL.
WHAT'S INSIDE (one .xlsx workbook, 9 tabs)
• Start Here: how to use it, color key, notes
• Settings: Etsy's US fee rates (filled in and editable: 6.5% transaction, 3% + $0.25 payment processing, $0.20 listing, 15% Offsite Ads with its per-order cap), your Etsy Ads %, target profit margin, hourly rate and price ending (.99)
• Units: grams, kilograms, ounces, pounds, millilitres, liters, teaspoons, tablespoons, cups, fluid ounces, quarts, gallons, each, dozen and a stick of butter, with room to add your own (up to 25)
• Ingredients: up to 60: pack size, unit and price, plus grams per cup for anything bought by weight and measured by volume
• Recipe Ingredients: up to 300 rows: amount in any unit, converted into the unit you buy in and costed; a check column says when a unit can't convert
• Overhead: up to 12 monthly costs (kitchen share, insurance, permits, labels), shared across your sales
• Recipes: up to 40 products: batch cost, batch yield, pieces per pack, minutes per batch, packaging, overhead, cost per pack and per piece, shipping you charge and postage
• Pricing: for every product, the lowest price that hits your margin, a suggested price, and profit, margin, PASS / FAIL and your hourly pay at your own price
• Price Calculator: pick a product to see each cost, each Etsy fee and ad, break-even and target prices, 5 prices side by side with PASS / FAIL, a wholesale price check for cafés and shops, and the sales a month that cover your fixed costs
Plus a 2-page quick-start PDF.
WHO IT'S FOR
Home bakers and cottage bakeries selling cookies, cakes, breads and treats on Etsy, at markets or to cafés, who want prices that cover ingredients, time and fees with profit left over.
HOW IT WORKS
• Yellow cells are your inputs. Everything else is a live formula.
• Change an ingredient price (butter goes up) and every recipe, cost and PASS / FAIL updates.
• Cups and spoons are US measures. Grams per cup vary by ingredient, so the workbook uses yours.
• Example data for a made-up home bakery is filled in so you can see how it works. Type over it.
OPENS IN
• Microsoft Excel 2010 or newer, Windows or Mac, including Microsoft 365 and Excel for the web: open the .xlsx.
• Google Sheets: File → Import → Upload the .xlsx (free Google account).
• Apple Numbers 13 or newer: File → Open the .xlsx. In Numbers, the recipe, ingredient and unit dropdowns may become plain cells: type names exactly as on their tabs.
• LibreOffice Calc: open the .xlsx.
• No macros and no newest-only functions. Tested: LibreOffice recalculates every formula and must match the expected results.
• In Excel, formula cells are locked (no password) so you can't type over them by accident. Google Sheets and Numbers drop that lock on import, so type only in the yellow cells there.
• Made for a computer screen; phone spreadsheet apps aren't tested.
Not affiliated with Microsoft, Google or Apple.
WHAT IT ISN'T
• A pricing calculator, not financial, tax or legal advice. Sales tax isn't part of the fees.
• It doesn't cover cottage food laws, labels or permits; those depend on your state.
• No nutrition facts, order tracking or inventory counts.
• The fee rates are Etsy's US rates for 2026 and you can change any of them; check Etsy's fee page for your shop.
• Not affiliated with Etsy, Inc.
QUICK FAQ
• Can I use it on an iPad or tablet? Set it up on a computer, where it's tested. The iPad apps for Excel, Google Sheets and Numbers can open an .xlsx, but they aren't tested, so a dropdown or color may not work the same there.
• How many recipes? Up to 40 products, 60 ingredients, 300 recipe-ingredient rows, 25 units and 12 monthly costs.
• Can I download it again or reuse it? Yes, keep using it: change an ingredient price or a fee rate and every price recalculates. It also stays on your Etsy Purchases page.
• Can I rename things or customize it? Your ingredients and recipes are yours, you can add your own units (up to 25), and Etsy's fee rates, target margin, hourly rate and price ending are settings. To change the layout in Excel: Review → Unprotect Sheet (no password).
ALSO IN THIS SHOP
• Selling on Etsy? Etsy Seller Bookkeeping & Profit Tracker: every Etsy fee on its own line, cost of goods, and profit by product and by month.
https://www.etsy.com/listing/4589081888/etsy-seller-spreadsheet-etsy-bookkeeping
• Pricing 3D prints? 3D Printing Pricing Calculator: filament, machine time, electricity and failure rate, then the price that hits your margin after Etsy fees.
https://www.etsy.com/listing/4589227759/3d-printing-pricing-calculator
INSTANT DOWNLOAD
This is a digital file; nothing will be shipped. After purchase, download it from your Etsy Purchases page; you can download it again any time. Because it's a digital download, Etsy doesn't allow returns or exchanges. If the file won't open or something looks wrong, message me and I'll help or fix it.
For personal use. Please don't resell or share the file.
Designed by me with the help of AI tools.
-
Designed by
-
Item typeDigital download
-
Digital file type(s)1 PDF, 1 other file
If something goes wrong with an order, we've got your back on all eligible purchases. View program terms
Meet your seller
More from this shop
-
Digital download
Etsy Seller Spreadsheet & Profit Tracker
Sale Price $5.99
Original Price $7.99
-
Digital download
Tax Deduction & Mileage Tracker, Google Sheets
Sale Price $4.87
Original Price $6.49
-
Digital download
Reseller Spreadsheet, Google Sheets & Excel
Sale Price $5.99
Original Price $7.99
-
Digital download
Small Business Bookkeeping, Google Sheets
Sale Price $5.99
Original Price $7.99
-
Digital download
3D Printing Pricing Calculator
Sale Price $5.99
Original Price $7.99
-
Digital download
House Hunting Comparison Spreadsheet
Sale Price $3.74
Original Price $4.99
-
Digital download
Recipe Cost and Pricing Calculator Spreadsheet for Bakery and Food Business Pricing Tool Google Sheets Excel Cake Ingredient Cost and Profit
Sale Price $6.99
Original Price $13.98
-
Digital download
Recipe Cost Calculator Google Sheets, Order Profit Calculator, Pricing Calculator Spreadsheet, Baking Price Calculator, Product Pricing
Sale Price $5.48
Original Price $6.45
-
Digital download
Recipe Cost Calculator Google Sheets, Order Profit Calculator, Pricing Calculator Spreadsheet, Baking Price Calculator, Product Pricing
Sale Price $5.48
Original Price $6.45
-
Digital download
Bakery Recipe Cost Calculator Excel Pricing Template Digital Download for Food Costing Bakery Management and Small Business Budget
$9.99
-
Digital download
U.S. Recipe Cost, Price & Profit Calculator Google Sheets Template | Cost Calculator | Price Calculator | Profit Calculator
$8.27
-
Digital download
UK Recipe Cost, Price & Profit Calculator Google Sheets Template | Cost Calculator | Price Calculator | Profit Calculator | Pricing Template
$8.27
-
Digital download
Baking Calculator, Recipe Spreadsheet Template, Baking Tools, Baking Cost Calculator, Bakery Pricing Tool, Profit Calculator Google Sheet
Sale Price $3.29
Original Price $6.59
-
Digital download
Recipe Cost Calculator, Profit Calculator Spreadsheet, Bakery Pricing Tool, Ingredient Cost Tracker, Google Sheets Template, Cake Pricing
$12.41
-
Digital download
Recipe Cost and Pricing Calculator, Home Baker Business Cake Costing Template, Bakery Pricing Google Sheets, Ingredients Tracker Spreadsheet
Sale Price $5.08
Original Price $12.70
-
Digital download
Recipe Cost Calculator Template for Baking Cupcakes and Desserts Pastry Chef Food Pricing Costing Profit Excel and Google Sheet Calculator
$10.29
-
Digital download
Recipe Cost Profit Calculator, Baking Ingredient Spreadsheet Home Baker Cake Costing Template Bakery Food Costs Excel Baking Pricing Tool
Sale Price $7.97
Original Price $15.95
-
Digital download
Recipe Cost Calculator Food Cost Spreadsheet Bakery Cafe Pricing Tool Profit Margin Tracker Google Sheets Template For Small Business
Sale Price $7.97
Original Price $15.95
Shoppers with similar taste loved these
-
Printed Cake Care Instruction Labels, Glossy Stickers
Sale Price $11.05
Original Price $13.00
-
Digital download
Cake Care And Cutting Guide Card, Printable Serving Instructions, Editable Bakery Labels, Canva Template, Package Insert, Watercolor BB045
Sale Price $3.39
Original Price $6.79
-
Digital download
Editable Bakery Business Canva Template | Invoice Template, QR Code Sign, Cake Order Form, Price List, Daily Planner, Cake Care Cards
Sale Price $6.09
Original Price $9.37
-
1.67" Cute Thank You Stickers for Small Business, packing stickers, business kawaii package stickers, bulk small biz stickers pack plant set
$9.95
-
Custom Bakery Stickers, Personalized Baked with Love Stickers, Baked Goods Label, Bakery Packaging, Small Business Bakery Stickers
$11.49
-
Repeat Customers are the Best Stickers, Personalized Thank You Stickers, Thank You Stickers for Small Business, Small Business Supplies
$4.50
-
Digital download
50+ Editable Bakery Business Canva Templates | Invoice, Order Forms, Price List (Digital Download)
Sale Price $4.94
Original Price $14.11
-
Digital download
Cottage Bakery Business Spreadsheet, Bakery Inventory, Sales & Profit Tracker, Home Bakery Template (Google Sheets)
Sale Price $9.00
Original Price $15.00
-
Digital download
Editable 4x6 Cottage Food Label Template, Thermal Printer Bakery Sticker, Ingredients Label, Canva Home Bakery Packaging
$4.75
-
Digital download
Editable LABEL BUNDLE Home Bakery Business, Cottage Food Sticker, Sourdough Bread Box, Cookie Bag, QR Code, Ingredients, Canva Template 001
Sale Price $9.34
Original Price $12.45
-
Digital download
Cookie Box Care Card Template, 6x4 Editable Canva Bakery Insert, Cookie Storage Instructions Thank You Card
Sale Price $3.00
Original Price $6.00
-
Digital download
Editable Cookie Care Card Canva Template | Instant Download | Package Insert | Printable Cookie Care Guide | Care Instructions
$3.90