# Bakery Pricing Studio: a pricing spreadsheet for home bakers Canonical: [Bakery Pricing Studio: a pricing spreadsheet for home bakers](https://tidybatchstudio.com/bakery-pricing-spreadsheet/) Locale: en-US Purpose: Google Sheets template (USD 3.50 on Etsy) that prices recipes per box or piece from ingredient purchases, work time, packaging and payment fees, with order quotes. Content updated: 2026-11-06 Source revision: 7a689caf5a94 Maintenance owner: Tidy Batch Studio [Topic map](https://tidybatchstudio.com/llm/topics/pricing.md) · [Complete scoped map](https://tidybatchstudio.com/sitemap.md) Google Sheets template Know what to charge for every box of cookies, brownies or cupcakes. Save ingredient costs once, build recipe cards and see a price per box that covers ingredients, your time, packaging and payment fees. Instant download on Etsy · USD 3.50 · Google Sheets on desktop · English - [Get it on Etsy](https://www.etsy.com/listing/4606345560) - [Try the free calculator first](https://tidybatchstudio.com/cookie-pricing-calculator/) *Image: Bakery Pricing Studio Home tab with the recipe shelf, the price of each recipe per box and the settings entered once: hourly rate, payment fees and target margin* Home tab of the Demo: your recipe shelf and the settings you enter once. All examples are fictional. ## What it does - **Price per box or per piece.** Enter one full recipe and the sheet splits its cost into the boxes you sell, for example 24 cookies, 6 per box = 4 boxes. - **Every cost counted:** ingredients, active work time at your hourly rate, packaging per box and other costs you enter. - **Payment fees included:** one percentage fee plus one fixed fee per order, using the rates you enter. - **Three numbers to compare:** the minimum that covers costs and fees, a price for your target margin, and what is left at the price you choose. - **Order quotes:** pick a saved recipe and the number of boxes to see the customer total, fees and what is left. Change the price, add an extra cost or use a different margin for that order only. - **Ingredient prices in one place:** update a purchase cost once and every linked recipe card updates. - **Unit conversion:** weight converts between g, kg, oz and lb, volume between mL, L and US fl oz, and items count as "each". - **Guided input:** yellow cells for your numbers and status messages that tell you what to fix. *Image: Recipe card ingredient list with the quantity, unit and cost of each ingredient for one batch* A recipe card: choose saved ingredients and enter the quantities for one batch. *Image: Order quote with a selling price of 12.00, entered costs of 5.75, payment fees of 0.78, 5.47 left and a 45.6% margin* Quote tab: what is left for one order at the price you choose. ## What you receive - A 2-page PDF guide with links to two Google Sheets templates. - **Demo:** fictional cookie and brownie examples to learn the workflow. - **Start Fresh:** a blank workspace for your own costs and recipes. - A built-in Help tab. Capacity: 100 ingredients, 20 recipe cards and 15 ingredient lines per recipe. ## Before you buy - Requires a free Google account and Google Sheets on a desktop or laptop. It is not designed for phones or tablets. - Google Sheets only: there is no Excel version. The template and the guide are in English. - Use one currency throughout; the currency label does not convert money. - Each quote uses one recipe. There is no order history, inventory tracking, invoicing or production planning. For orders, see [Bakery Order Tracker](https://tidybatchstudio.com/bakery-order-tracker/). - Cups, spoons and weight-to-volume conversions are not supported, because ingredient density varies. - Costs assume the whole recipe batch is used or sold. Add your own allowance for waste and overhead. - Results are before tax and depend on the numbers you enter. A calculated price is a guide; it does not guarantee sales or profit. ## Questions ### Can I price whole cakes, bread or single cupcakes? Yes. Use 1 piece per pack and the price is per item, for example one cake or one loaf. ### Is there a free version? The free [recipe cost](https://tidybatchstudio.com/recipe-cost-calculator/), [cookie pricing](https://tidybatchstudio.com/cookie-pricing-calculator/) and [cake pricing](https://tidybatchstudio.com/cake-pricing-calculator/) calculators use the same math for one recipe at a time. Bakery Pricing Studio is a paid download (USD 3.50 on Etsy) that keeps your ingredient purchases and up to 20 recipe cards, updates every price when a cost changes and builds order quotes. ### Is there an Excel version? No. It is made for Google Sheets on a desktop or laptop. ### Can I use my own selling price? Yes. Save a price on each recipe card, or enter a different one in Quote, and compare it with the minimum and target prices. ### Can I set a different margin for one order? Yes. Enter an order margin in Quote. Leave it blank to use your Home margin, or enter 0% to target the minimum. Your saved settings stay unchanged. ### What happens when an ingredient price changes? Update its purchase cost in Ingredients and every linked recipe card updates automatically. ### Do I need to install anything? No. There are no scripts or add-ons. The original templates are view-only until you make your own copy. ## Price your next order with clear numbers Instant download on Etsy for USD 3.50. Questions before buying? Send TidyBatchStudio a message on Etsy. - [Get Bakery Pricing Studio on Etsy](https://www.etsy.com/listing/4606345560) Related: [How to price cookies for a home bakery](https://tidybatchstudio.com/guides/how-to-price-cookies/) · [How to price holiday cookie boxes](https://tidybatchstudio.com/guides/holiday-cookie-box-pricing/)