Bakery Pricing Spreadsheet – Recipe Cost Calculator

Name: Bakery Pricing Spreadsheet
Brand: Sorted Templates
SKU: ST-0040
Price: 8.00 USD
Availability: InStock

Overview

Ingredient cost is the easy part. The hours spent decorating, answering messages and cleaning up are what home bakers tend to leave out, and that's where the profit goes. This spreadsheet costs your recipes down to the gram, adds your hourly pay, overhead and margin, and gives you a suggested price with a quote message you can send straight away.

Once an order is booked, the same file follows it: deposits, balances, a calendar and a warning when you've taken on more than you can bake.

Real cost per recipe
Enter what you pay for supplies and see the cost per batch and per cookie.
Your time counted
Hours, overhead and profit go into every suggested price and show your real hourly pay.
Quote in a minute
Get a price per serving, a deposit amount and a ready-to-send quote message.
Orders under control
Alerts flag over capacity, a missing deposit or a balance to collect.

What's inside

Pantry
What you pay for flour, butter, eggs, boxes and labels, turned into a cost per gram or per item
Recipes and recipe costs
Measure in grams, cups, tablespoons, teaspoons or each, with cost per batch and per piece
Custom order price calculator
Ingredients, packaging, your hours, overhead and profit margin give a suggested price, price per serving, deposit and quote message
Menu pricing
Prices for dozens, boxes and loaves
Orders
Deposits, balances and alerts for over capacity, waiting on deposit and collect balance
Business tracking
Order calendar, customers, expenses by tax category, mileage, monthly summary and dashboard
Examples
Sample rows and prices that show how each tab works
START-HERE PDF
Your Google Sheets link

How it works

1
Buy on Etsy, then download START-HERE.pdf and the Excel file from your Etsy Purchases page.
2
Click the Google Sheets link in the PDF, or open the Excel file.
3
Enter your pantry prices, recipes and hourly pay, then price each order and track it to pickup.

Good to know

Digital download: nothing is shipped
For use in your own business: please don't share or resell the templates
Cottage food rules differ by state: check your own state's rules

Questions

How do I price custom cakes from home?

Add up ingredients and packaging, then add your hours at the pay you want, a share of overhead and a profit margin. The price calculator tab does this for you and suggests a price per serving and a deposit.

Can I measure recipes in cups instead of grams?

Yes. Each ingredient can be entered in grams, cups, tablespoons, teaspoons or by the piece.

Does it work in Excel and Numbers?

Yes. It works in free Google Sheets, Microsoft Excel and Apple Numbers.

Does it track deposits?

Yes. The orders tab records deposits and balances and flags orders still waiting on a deposit or a balance to collect.

How it's made: designed by Sorted Templates. We use AI tools to help draft text and lay out pages, and every page is reviewed and edited by us before it's listed. Lifestyle and mockup images may be AI-generated or AI-edited; the page previews show the actual files.