Home Bakery Pricing Spreadsheet for Google Sheets: Recipe Cost Calculator, Cookie & Cake Order Quotes

Know what to charge for every box of cookies, brownies or cupcakes. Bakery Pricing Studio is a Google Sheets pricing spreadsheet for home bakers: save ingredient costs once, build recipe cards and see a price per box that covers ingredients, your time, packaging and payment fees.

Instant download: a PDF guide with links to a Demo and a blank Start Fresh template. You save your own copy in Google Drive. For desktop Google Sheets, in English.

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 entered 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. Optionally change the price, add an extra cost or use a different margin for that order only. The fixed fee is counted once per order.
• 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; items count as "each".
• Guided input: yellow cells for your numbers and status messages that tell you what to fix.

CAPACITY
100 ingredients · 20 recipe cards · 15 ingredient lines per recipe

WHAT YOU RECEIVE
• Bakery_Pricing_Studio_Quick_Start.pdf (2 pages) 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.

HOW TO START
1. After purchase, download the PDF from your Etsy Purchases page in a web browser.
2. Open a template link on your computer and sign in to your Google account.
3. Choose File > Make a copy to save your own editable copy in Google Drive.
4. On Home, enter your hourly rate, payment fees and target margin.
5. Add your ingredient purchases, fill a recipe card and use Quote when a customer asks for a price.

BEFORE YOU BUY
• Requires a free Google account and Google Sheets on a desktop or laptop. Not designed for phones or tablets.
• Google Sheets only: there is no Excel version.
• Template and 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.
• 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.
• This is a digital item; nothing physical is shipped.

FAQ
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 linked recipes update automatically. If you rename an ingredient, select it again in the recipes that use it.

Which payment fees can I enter?
One percentage and one fixed amount per order, such as the fees of your card reader or online checkout. Enter 0 if none apply.

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.

Can I download the files in the Etsy app?
Use Etsy.com in a web browser to download the PDF, then open its links on a computer.

Can I keep a list of my orders?
Not in this template. Bakery Order Tracker, sold separately in the TidyBatchStudio shop, is a Google Sheets order log with pickup dates, deposits and balances. The two files are not linked; you type the price into each order.

SUPPORT
Questions before or after buying? Send TidyBatchStudio a message on Etsy.

AI disclosure: Bakery Pricing Studio was designed with the help of AI tools and checked with worked recipe and order pricing examples. The instructions in the Help tab and the PDF guide were written by TidyBatchStudio and translated into English with AI assistance.