Getting started
Home Bakery Spreadsheet: 5 Columns That Show Real Profit
A simple spreadsheet that shows real profit per order, not just sales.
On this page
- What five columns show real profit?
- How do you cost one order from start to margin?
- How to split batch costs fairly across orders
- What numbers should you enter every week?
- How to set your labor rate and track hours
- What mistakes cost home bakers money?
- How to use your weekly totals to make decisions
- When should you move from a spreadsheet to a shop tool?
What to remember
- Track ingredient cost, labor, overhead, and margin for every order.
- Enter costs the day you bake, not weeks later.
- Price from the margin column, not from the price you hoped for.
- A $20 a month shop cost still belongs in your numbers.
You can start with a notebook and a calculator. A home bakery spreadsheet keeps the same math in one place, so you see profit before you bake. You do not need accounting software to begin.
What five columns show real profit?
Use one row for each order. The five money columns are price, ingredient cost, labor, overhead, and margin. Date and item are labels, not cost columns. Copy these headers into a new sheet: Price, Ingredient cost, Labor, Overhead, Margin.
Ingredient cost is the food and packaging used for that order. Labor is the time you spent baking, decorating, packing, and delivering. Overhead is your share of monthly shop costs. Margin is price minus all three. If you want a deeper cost sheet, use Bakery Costing Spreadsheet: 5 Columns That Show Real Profit.
How do you cost one order from start to margin?
Say you sell one dozen decorated sugar cookies for $30. You bake a batch of two dozen. Ingredients for the full batch cost $16, so the cost for one dozen is $8. This includes flour, sugar, butter, and specialty packaging.
You spend 1.5 hours on tasks for this order. This includes mixing, baking, cooling, decorating, and packing. You want $12 an hour, so labor is $18. Your shop overhead costs $20 a month for tools, boxes, labels, and a share of your power bill.
You fill about seven orders a month, so overhead is about $3 for this order. Add them up: $8 plus $18 plus $3 equals $29. Your margin is $1. That margin is thin, so you would raise the price or bake a bigger batch.
The point is not the exact numbers. The point is that you counted your time and your shop costs before you called it profit. Overhead is not free, even when you work at home.
How to split batch costs fairly across orders
You rarely bake for a single order. A batch makes several items. You must split the ingredient cost fairly. The simplest way is to divide the total batch cost by the number of items it produced.
If a cake batch costing $20 yields two cakes, each cake costs $10 in ingredients. If one order is for a full cake and another is for half, you must adjust. A half cake would cost $5, not $10. Your spreadsheet should reflect this accurate split.
Labor can also be split. Time spent on batch tasks like mixing and oven watching is shared. Time spent on order specific tasks like custom decorating belongs to that order alone. Note these times separately to keep your labor column honest.
What numbers should you enter every week?
Update the sheet after every order, then total it once a week. For a simple weekly routine, see Home Bakery Bookkeeping: 3 Numbers to Track Every Week.
Open one row per order
Add the date, the item, and the price you charged.
Enter ingredient cost
Use the receipt total for the batch, then split it by the orders that batch filled.
Add your labor
Hours baked, decorated, packed, and delivered, times the hourly pay you want.
Add overhead
Shop costs like your $20 monthly tool, boxes, labels, and power, split across the month orders.
Read the margin
Price minus ingredients, labor, and overhead. If it is thin, raise the price or cut a cost.
How to set your labor rate and track hours
Your labor rate is not your take home pay. It is the value of your time. Start with a rate you would accept from a customer for skilled baking work. A common starting point is between $15 and $25 per hour.
Track all time related to the order. This includes shopping, recipe planning, and cleaning. Use a timer on your phone. Log the minutes as you go. Do not estimate at the end of a long day.
If you spend 30 minutes driving to deliver one order, that is labor. If you spend an hour designing a custom topper, that is labor. Every minute you spend is a cost your customer should cover.
What mistakes cost home bakers money?
The biggest mistake is pricing from ingredients alone. Flour is rarely the largest cost. Your time, boxes, labels, and power add up fast. Another mistake is skipping overhead because you work at home. If you do not count it, the sheet shows sales, not profit.
Before you count profit, check your state rules. Read Home Based Bakery Business: Cottage Kitchen Rules (2026) so you know what you can sell and where. If you are still setting up, read Starting Your Own Home Bakery: 5 Steps and First Costs before you buy equipment.
How to use your weekly totals to make decisions
Your weekly total margin is your key metric. It shows if your week was profitable. Look at the individual order margins that built that total. Identify your best sellers and your loss leaders.
A product with a consistently low margin needs a price increase. A product with high labor costs might need a process change. Your spreadsheet data gives you the reason to make these changes. You are not guessing.
Compare weeks to see trends. A rising ingredient cost will show as a shrinking margin over time. You can then adjust your prices proactively. The spreadsheet turns reactive worry into proactive business management.
When should you move from a spreadsheet to a shop tool?
A spreadsheet still works, but it will not take orders or get you paid. Brevl costs one flat $20 a month and takes no cut of your sales. You can take card payments through your own Stripe or Square account, plus Venmo, Cash App, Zelle, and cash.
It works on a computer and on a phone, and a real person answers, usually within minutes. There is a 14 day free trial.
Try the free bake pricing calculator
Free, no signup.
Browse more getting started guides.
Common questions
Do I need a paid spreadsheet app to start?
No. A free sheet app or even paper works if you use the same five columns every time. The tool matters less than the habit. Enter costs the day you bake, not weeks later, or your numbers turn into guesses.
Should I include my time as labor?
Yes. If you do not pay yourself in the math, the spreadsheet shows sales, not profit. Pick an hourly rate you would accept from a customer. Multiply it by the hours you spent baking, decorating, packing, and delivering that order.
How often should I update it?
Update it after every order and total it once a week. Weekly totals show which items earn and which quietly lose money. A monthly look is too late to fix a price before you bake another batch. Keep it on your phone so you can enter costs between batches.
What if a spreadsheet feels like too much?
Start with one order. Write the price, the ingredient cost, your hours, and your share of monthly costs. If the margin looks wrong, you have found the problem before you sell again. You can grow the sheet as your orders grow.
How do I calculate my monthly overhead?
List every cost to run your baking space for a month. This includes boxes, labels, power, tool replacements, and any permitted kitchen fees. Total these costs. Divide that total by your average number of monthly orders to get a cost per order.
What if my margin is negative?
A negative margin means you paid to make that order. This is a clear signal. You must either increase your price for that item or find a way to reduce one of your three costs. The same guide shows you where to start looking.
General information, not legal or tax advice.