Report this item to Etsy

Recipe Cost & Bakery Pricing Calculator

Item highlights

  • Digital download
  • Digital file type(s): 1 PDF, 1 other file

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.

View more
Etsy's Purchase Protection

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

Loading

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

Recipe Cost & Pricing Calculator: Ingredients, batch, Etsy fees, price. Excel, Google Sheets and Numbers

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 type
    Digital download
  • Digital file type(s)
    1 PDF, 1 other file
Shop with confidence
Etsy Purchase Protection

If something goes wrong with an order, we've got your back on all eligible purchases. View program terms

You may also like

Shoppers with similar taste loved these

Show more
Show more
Listed on Oct 5, 2026