Google Sheets template

Bakery Pricing Studio: a pricing spreadsheet for home bakers

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 Try the free calculator first

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.

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.

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.
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 or single cupcakes?

Yes. Use 1 piece per pack and the price is per item.

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