Free Bakery Costing Spreadsheet
Work out what each recipe actually costs you to make — per batch and per item — then set a price that holds its margin. Enter your ingredients once and the sheet does the rest.
- Cost per batch and cost per item, calculated automatically
- Gross margin and markup on any price you enter
- Handles unit conversions — buy in kilos, use in grams
- Opens in Excel, Google Sheets, or Numbers
Join the Stocksmith mailing list and we'll send you our bakery costing spreadsheet template for free! We typically send 2-4 emails a month about small batch production topics which we hope are useful to our readership.
What's included
From ingredient price to shelf price, in one sheet
Most bakery pricing starts with what the shop down the road charges. This sheet starts with what your recipe costs, which is the only number that tells you whether the price works.
Ingredient list with real costs
Enter what you paid and the pack size, and the sheet works out the cost per gram, millilitre or unit for you.
Recipe costing by yield
Build a recipe from those ingredients, enter the yield, and get cost per batch and cost per item without a calculator.
Margin at a glance
Enter your retail and wholesale prices and see gross margin and markup side by side, so you can spot the lines that aren't earning.
How do I cost a bakery recipe?
Cost a recipe by converting each ingredient to a cost per unit of measure, multiplying by the quantity used, then dividing the total by your yield.
In practice that's four steps:
- 1. Get to a cost per unit. A 16kg sack of flour at $38 is $0.002375 per gram. Do this once per ingredient and the recipe maths becomes trivial.
- 2. Use landed cost, not list price. Include delivery and subtract bulk discounts. Freight spread across an order lifts the true cost of every ingredient in it above what the invoice line says — often by several percent.
- 3. Multiply through the recipe. 900g flour at $0.002375 is $2.14. Repeat for every ingredient, including the ones that feel too small to matter — salt and yeast are cheap, but vanilla and saffron are not.
- 4. Divide by actual yield. Not theoretical yield. If a batch is meant to make 24 and reliably makes 22 after trim and breakage, divide by 22 or you'll understate every unit by roughly 9%.
Packaging belongs in the recipe too. A box, liner and label can easily add 40 to 80 cents to a retail item — enough to turn a thin margin negative on its own.
What margin should a bakery aim for?
Most small bakeries target a gross margin well above 50% on retail lines, because ingredients are only part of what a price has to cover.
The mistake is treating ingredient cost as the cost. Rent, power for the ovens, wages, delivery, spoilage and the hours you spend baking all come out of the gap between ingredient cost and price. A 40% gross margin can still lose money once those are paid.
Wholesale complicates it further: a wholesale price is typically well below retail, so a product that works at the market stall may not work through a distributor at all. Cost the recipe once, then check it against both prices before agreeing to a wholesale line.
Whatever target you pick, the sheet shows margin and markup on each price you enter, so you can see immediately which products are carrying the business and which are quietly being subsidised by the others.
Where bakery costings usually go wrong
- Using theoretical yield. Trim, breakage and the ones that don't rise are real. Cost against what you actually sell.
- Forgetting packaging. The single most common omission, and it hits retail lines hardest.
- Costing once and never again. Butter and flour prices move. A costing from eighteen months ago is a guess wearing a spreadsheet.
- Ignoring the small ingredients. Individually trivial, collectively several percent of the batch.
- Leaving out your own labour. Even if you don't pay yourself yet, a price that doesn't cover the time can never scale to a price that pays someone else.
Recosting everything by hand each time an ingredient price changes is exactly the job that stops being practical as the product list grows — that's the point where bakery inventory software starts earning its keep, because a price change updates every recipe that uses it at once.
Frequently Asked Questions
How do I calculate cost per item for a bakery product?
Total the landed cost of every ingredient in the batch, add packaging, then divide by the number of saleable units the batch actually produced. Use real yield rather than theoretical yield — if a batch is meant to make 24 and makes 22, dividing by 24 understates every unit by about 9%.
Should I include my time and labour in the cost?
Yes. Keep it as a separate line from ingredients so you can see both, but include it. A price that only covers ingredients cannot cover the day you hire someone to do the baking — and pricing that assumes free labour is the most common reason a growing bakery finds its margins shrinking as volume rises.
How often should I recost my recipes?
At least quarterly, and immediately after any noticeable supplier price change. Butter, eggs and flour move enough to erode a margin within a single season. If you hold wholesale accounts with fixed price lists, recost before every renewal — that's the moment a stale figure gets locked in for another year.
Is this bakery costing spreadsheet free?
Yes, completely free. Enter your email above and we'll send the download link straight away. It works in Excel, Google Sheets and Apple Numbers, handles unit conversions so you can buy in kilos and use in grams, and calculates cost per batch, cost per item, gross margin and markup.
What's the difference between this and the inventory spreadsheet?
This one answers "what should I charge?" — it costs recipes and shows margins. The bakery inventory spreadsheet answers "what have I got and what did I use?" — it tracks stock levels, purchases and COGS across the year. Many bakeries use both: cost the recipes here, track the stock there.
Get the free bakery costing spreadsheet
Enter your email and we'll send it straight over.
Download the free spreadsheet →