Getting started
Bakery Excel Spreadsheet (2026): Price a Batch, See Margin
A simple way to turn a bakery excel spreadsheet into prices that cover ingredients, labor, and overhead.
On this page
What to remember
- Cost ingredients, labor, and overhead in the same row.
- Divide by the count you actually sell.
- Add margin after costs, not before.
- Update prices when your receipts change.
- Keep the sheet for costing, not for order messages.
A bakery excel spreadsheet is not a recipe file. It is a small money file that shows what a batch costs and what you keep. Start with the columns in Home Bakery Spreadsheet: 5 Columns That Show Real Profit, then come back to the basics in getting started.
What should a bakery excel spreadsheet track?
Track the money, not the mood. One row should cover one batch or one product. You need the ingredient cost, the time you spend, the overhead you cannot avoid, and the count you sell. If a row cannot answer ‘did this batch pay me,’ it is decoration.
Keep the file on your phone and your computer. You will update it at the kitchen counter, not at a desk. Use short labels so you can type fast. Save one row per batch, then copy the row when you bake the same item again.
Set your columns
Use batch name, ingredient cost, labor minutes, labor cost, overhead, and batch count. Keep them in the same order every time.
Cost the ingredients
Enter what you paid for the ingredients in one batch. Use receipts, not memory, and update when prices change.
Add your labor
Track the minutes you spend mixing, baking, cooling, and decorating. Multiply by the hourly pay you want.
Add overhead
Include a share of monthly costs such as power, packaging, and your shop tools. Brevl is one flat $20 a month if you use it for orders.
Price with margin
Divide total batch cost by the count, add your margin, and compare the price to what customers already pay.
How do you cost one batch in the spreadsheet?
Cost the whole batch before you divide. Add every ingredient you use, including the ones you already own. Add the labor it takes to mix, bake, cool, and decorate. Add a share of overhead so the batch carries its part of your monthly costs. The Bakery Costing Spreadsheet: 5 Columns That Show Real Profit guide uses the same order.
Overhead is not a mystery number. List the monthly costs that keep the bakery running, then divide by the batches you bake. Power, gas, packaging, and your shop tools all belong there. If you skip overhead, your margin is a story, not a number.
Do not guess the labor. Set a timer for one batch and write the minutes down. Include the cleanup and the packaging time, because those minutes are part of the job. If you pay yourself later, the sheet should still show the hours now.
Say your sheet shows $9 of ingredients, 45 minutes of labor at $24 an hour, which is $18, and $3 of overhead from a $20 a month tool spread across your batches. The batch cost is $30. Sell the dozen for $45 and your margin is $15 after ingredients, labor, and overhead.
What price leaves a real margin?
Margin is the money left after the batch is paid for. Divide the batch cost by the count, then add the margin you need. A higher price is not always the answer if it slows your orders. Check the price against what your customers already pay for a similar treat.
Test the price with a small order first. Bake one batch, sell it at the new price, and watch how fast it moves. If customers pause at the number, shrink the portion or simplify the decoration before you cut your margin. Price changes are easier when you can point to the cost.
What mistakes cost home bakers money?
The first mistake is forgetting your own time. The second is leaving out overhead and then wondering why the month feels tight. The third is setting a price once and never checking it again. The fourth is using the sheet as an order log, which turns costing into message sorting.
Before you commit to a new template, check three things. Can you open it on your phone? Can you add a column without breaking the math? Can you see last month’s costs next to this month’s? If not, the file will slow you down. A clean Bakery Expenses Spreadsheet: 6 Columns That Show Real Profit keeps the answers in view.
Check the sheet before you buy a new pan or sign up for a new tool. If the sheet cannot show the cost of the last three batches, it is not ready to guide a purchase. Fix the columns first. A template like Bakery Spreadsheet Template: Free Download and 4 Columns can give you a clean start.
When should you move from a spreadsheet to a shop tool?
Keep the spreadsheet for costing. Move the order work when messages, payments, and pickup times take more time than baking. A shop tool should take orders, get you paid, and hold your recipes with real costing. Brevl is one flat $20 a month with no cut of your sales, and it works on a computer and a phone.
You can take card payments through your own Stripe or Square account, plus Venmo, Cash App, Zelle, and cash. Your shop is yours to customize with your photos, your colors, and your own web address. We set it up with you and move your old shop over. A real person answers, usually within minutes.
Migration does not have to be hard. Keep your old costs in the sheet, then move products, photos, and dates into the new shop. Brevl sets it up with you and moves your old shop over, so you do not retype every order. Your first week should feel lighter, not busier.
Try the free bake pricing calculator
Free, no signup.
- Manual bookkeeping for bakery: 5 numbers to track and price
- Micro Bakery Income: Your Real Take-Home Pay
Common questions
Should I use Excel or Google Sheets?
Either one works if you can open it on your phone at the market. The tool matters less than the columns. Use the same file every week so your costs stay in one place and you can see trends before you price.
How often should I update the spreadsheet?
Update it every time you buy a main ingredient or change a recipe. Your receipts change, and an old price can quietly eat your margin. A quick weekly check keeps your numbers close to what you actually pay.
What margin should I aim for?
Your margin is what is left after ingredients, labor, and overhead. There is no single right number for every baker. Pick a margin that pays you, covers waste, and still sells at your local price. Test it with real orders before you raise prices.
Can a spreadsheet replace a shop tool?
A spreadsheet can track costs, but it does not take orders or get you paid. If you spend hours copying messages into rows, move the order work to a shop tool and keep the spreadsheet for costing. Brevl takes orders and payments while your sheet stays simple.
General information, not legal or tax advice.