Getting started
Bakery Business Spreadsheet: 5 Columns That Show Profit
A simple spreadsheet setup that shows your true profit after ingredients, labor, and overhead.
On this page
What to remember
- Track ingredients, labor, and overhead separately.
- Update sales every week, not once a year.
- Check margin per product, not just total sales.
- Use the $20 monthly Brevl fee as a real overhead line if you use Brevl.
You do not need accounting software to start. A bakery business spreadsheet on your phone or computer can show you the truth about your prices, and the trick is knowing which columns to keep. Start with the getting started guide if you are still deciding what to sell.
What columns does a bakery business spreadsheet need?
Five columns cover the basics. Ingredients is what you pay for flour, butter, eggs, and packaging. Labor is your time, valued at an hourly rate you choose. Overhead is the monthly cost of running your shop, like the $20 Brevl fee or your phone bill. Sales is what customers pay you. Margin is sales minus all three costs.
Keep each cost in its own column so you can see what changes. If you lump ingredients and labor together, you cannot tell whether a price increase came from butter or from your own hours. A separate column for each cost makes the fix obvious.
Do not add columns you will not use. A column for every possible cost becomes a mess. Stick to the five basics until you have a reason to add more. You can always add a column later.
How to set up your spreadsheet in 5 steps
Set up the columns first, then fill in one product at a time. Do not try to track everything in week one. The order below keeps the math simple and shows you where the money goes.
List your products
Write down every item you sell. Start with the ones that bring in the most money.
Add ingredient cost per batch
Use your receipts to find the cost of one batch. Divide by the number of items in the batch.
Add labor cost per batch
Decide on an hourly rate for your time. Multiply by the hours you spend on one batch.
Add overhead per month
List fixed monthly costs. Include the $20 Brevl fee if you use Brevl, plus any other tools or utilities.
Add sales and margin columns
Enter what you charge and what you sold. Subtract ingredients, labor, and overhead to see your margin.
A worked example with real numbers
Here is how the math works with the one number we can give you: the $20 monthly Brevl fee. You fill in your own ingredient and labor costs from your receipts and time log. The spreadsheet does the subtraction.
For example, your spreadsheet has a row for a batch of cookies. You enter your ingredient cost from the receipt. You enter your labor cost by multiplying your hourly rate by the hours you worked. You enter the $20 monthly Brevl fee as overhead. Then you subtract all three from your sales price. The number left is your margin.
How to read your margin
Margin is the money left after ingredients, labor, and overhead. A positive margin means you can pay yourself and cover costs. A negative margin means you are losing money on every sale, even if your bank account looks fine this week.
Check margin per product, not just total margin. One product can carry the whole shop while another loses money. The spreadsheet shows you which is which. If a product has a thin margin, raise the price or cut the cost before you bake more.
Mistakes that cost you money
The biggest mistake is leaving out your own time. If you do not count labor, you will think a product is profitable when it is not. The second mistake is mixing personal and business money in the same column. Keep them separate so your margin is real.
Another mistake is updating the spreadsheet once a month instead of once a week. Prices change, and so do your ingredient costs. A weekly update takes ten minutes and stops small errors from growing. Use the bakery expenses spreadsheet to see which costs move most.
What to check before you commit
Before you build a full spreadsheet, check three things. First, make sure your ingredient costs come from receipts, not memory. Second, decide on a labor rate and write it down. Third, list every monthly fee, including the $20 Brevl fee if you use Brevl.
Also check that your spreadsheet has a row for each product you sell. A single total row hides the product that loses money. If you sell ten items, you need ten rows. The home bakery spreadsheet shows how to set up those rows without extra work.
Packaging counts as an ingredient cost in your spreadsheet. Boxes, stickers, and bags add up fast. If you forget them, your margin looks better than it is. Put packaging in the same column as flour and butter.
When to move off the spreadsheet
A spreadsheet works well when you have a handful of products. When you start taking orders daily, you need a system that updates inventory and costs for you. Signs include missing ingredient counts, orders that slip through, and prices you have not checked in months.
Brevl has recipes with real costing, ingredient inventory, and a weekly planner. It costs one flat $20 a month with 0% commission. You can try it free for 14 days. The bakery inventory spreadsheet guide shows what to track if you stay on a spreadsheet a little longer.
A spreadsheet takes time to update. If you spend more time typing than baking, a tool that does the math for you is worth the $20 monthly fee. Brevl updates costs and inventory as you go.
Try the free bake pricing calculator
Free, no signup.
- Home Bakery Spreadsheet: 5 Columns That Show Real Profit
- Bakery Costing Spreadsheet: 5 Columns That Show Real Profit
- Bakery Expenses Spreadsheet: 6 Columns That Show Real Profit
Common questions
What is the easiest way to start a bakery business spreadsheet?
Start with five columns: ingredients, labor, overhead, sales, and margin. Pick one product and fill in the numbers from your receipts and time log. Do not try to track every product in week one. Add rows as you go.
How do I count my own labor in the spreadsheet?
Choose an hourly rate you would pay someone else, or the wage you need to take home. Multiply that rate by the hours you spend on one batch. Put the result in the labor column. Do not leave it at zero, or your margin will look better than it is.
Should I include the $20 Brevl fee as overhead?
Yes, if you use Brevl. The $20 monthly fee is a real cost of running your shop. Put it in the overhead column so your margin reflects it. The same goes for any other monthly tool or phone bill.
How often should I update the spreadsheet?
Update sales and ingredient costs every week. Prices change, and a weekly habit stops small errors from growing. A ten minute update is enough for most home bakers. Check your margin per product once a month.
What if my spreadsheet shows a negative margin?
A negative margin means you are losing money on that product. Raise the price, cut the cost, or stop selling it. Check that you counted labor and overhead. A zero in either column hides the real cost.
General information, not financial or tax advice.