Getting started
Bakery Inventory Spreadsheet: 6 Columns That Stop Waste
A simple spreadsheet that tracks what you have, what you need, and what it really costs.
On this page
You can build this list in any spreadsheet program or on paper. The goal is to see your stock at a glance and know your costs before you bake. This guide shows you the six columns that work and a real example with numbers.
What to remember
- Track what you have, not just what you buy.
- See your real cost per batch before you bake.
- Stop running out of key ingredients.
- Plan your shopping list from your recipe plan.
The six columns your inventory needs
Start with a simple table. These six columns give you control over your ingredients and your money. You can add more later, but these are the core.
Ingredient
List every raw item you use. Flour, sugar, butter, eggs, vanilla, chocolate chips, sprinkles, boxes, bags.
On Hand
How much you have right now. Write it in the unit you buy it in, like pounds for flour, dozens for eggs.
Unit Cost
The price you paid for that unit. Update this when you shop. Use your last receipt.
Minimum Level
The amount that triggers a buy. For flour, it might be 2 pounds. For vanilla, 1 ounce.
To Buy
A formula column. It shows zero if On Hand is above Minimum. It shows the difference if you are low.
Buy Cost
Another formula. To Buy multiplied by Unit Cost. This is your upcoming shopping cost.
How to set your minimum levels
Your minimum level is your safety net. It is the point where you must buy more to avoid running out. Setting it too low causes rush orders. Setting it too high ties up cash in excess stock.
Look at your baking schedule. If you bake two batches of cookies every Thursday, and each uses one pound of flour, your weekly need is two pounds. Add a buffer for mistakes or extra orders. Your minimum level for flour might then be four pounds.
For slow moving items like specialty extracts, your minimum can be one bottle. The goal is to never see a zero in your On Hand column when you are ready to bake. The same guide on food cost control notes that consistent stock prevents lost sales.
A real example with numbers
Here is how a row looks for all-purpose flour. Your Unit Cost is from your last grocery trip. Your Minimum Level is from your weekly baking plan.
Ingredient: All-Purpose Flour. On Hand: 3.5 lbs. Unit Cost: $0.45 per lb. Minimum Level: 5 lbs. To Buy: 1.5 lbs. Buy Cost: $0.68. You see you are low and need to buy 1.5 pounds before next week.
Now cost a full recipe. Your chocolate chip cookie batch uses 2.5 lbs of flour, 2 lbs of sugar at $0.55 per lb, 1 lb of butter at $3.50 per lb, and one dozen eggs at $2.40 per dozen. Your inventory provides each Unit Cost.
Your total ingredient cost is $1.13 for flour, $1.10 for sugar, $3.50 for butter, and $0.20 for the eggs used. That sums to $5.93. Add $0.50 for chocolate chips and $0.10 for packaging. Your total ingredient cost for the batch is $6.53.
Now add labor and overhead. If the batch takes one hour to make at $15 per hour, and your overhead for utilities and kitchen space is $2 per batch, your total cost is $23.53. Selling the batch for $35 gives you a margin of $11.47 after all costs.
Connect inventory to recipe costing
Your inventory holds your real prices. Use those numbers in your bakery costing spreadsheet. That sheet adds your labor and overhead to find your real profit. The two sheets work together.
First, your costing sheet lists every ingredient for a recipe. Second, it pulls the Unit Cost from your inventory sheet. Third, it multiplies by the amount used. This gives you an accurate ingredient cost, not a guess.
How to handle bulk purchases and storage
Buying a twenty five pound bag of flour changes your inventory math. Your unit cost becomes lower, but your minimum level should rise. You now store more ingredient value on your shelf.
Divide the total bag price by twenty five to find your new unit cost per pound. Update your inventory column. Your minimum level might shift to ten pounds because you have the space and want to buy less often.
Track the date of your bulk purchase. Some ingredients like nuts or whole grain flour have a shorter shelf life. Its calculator can help you plan usage before quality declines. This prevents waste from spoilage.
What to check before you build
A few minutes of setup saves hours of confusion. Check these points before you fill your first row.
Use consistent units
Buy flour in pounds, measure in cups, but track in pounds. Convert all your recipes to the unit you buy.
Update after you shop
When you unpack groceries, update On Hand and Unit Cost. This keeps your numbers true.
Set a weekly review
Every Sunday, check your sheet against your recipe plan for the week. Update your To Buy list.
Start with a template
Use a free bakery inventory list template to skip the column setup.
Mistakes that cost you money
A simple list can still have holes. Watch for these common errors that hide your real costs.
Forgetting packaging. Cake boxes, cupcake liners, and treat bags are ingredients too. Add them to your inventory with their unit cost.
Not tracking partial units. You used half a bottle of vanilla. Your On Hand should reflect that. Estimate if you must, but adjust the number.
Letting prices get stale. Flour cost $0.45 last month, but $0.55 this week. Update your Unit Cost when it changes, or your recipe costing will be low.
This is a core tool for your getting started journey. It feeds into your costing, which feeds into your pricing.
From inventory to tax records
A well kept inventory sheet supports your business records. It provides a paper trail for your cost of goods sold. This figure is essential for tax time.
Start with your opening inventory value at the beginning of the year. Add all your ingredient purchases. Subtract your closing inventory value at year end. The result is your cost of goods sold for the year.
Your inventory spreadsheet, updated weekly, gives you those closing numbers without a frantic year end count. The same guide from the University of Minnesota extension stresses this link between daily tracking and annual reporting.
Try the free bake pricing calculator
Free, no signup.
Browse more getting started guides.
Keep reading: Bakery Costing Spreadsheet: 5 Columns That Show Real Profit.
Common questions
Should I track spices and extracts?
Yes, but start with the expensive ones you use often, like vanilla and cinnamon. Small, cheap spices can be a flat monthly cost until your volume grows.
How often should I update my inventory?
Update your On Hand numbers right after a big bake or right after a grocery trip. Do a full review of all numbers once a week, before you plan your baking.
Can I use this for a cottage food bakery?
Yes. A cottage bakery spreadsheet uses the same inventory principles. It helps you stay within your state's sales limit by tracking your cost of goods sold.
What if I buy in bulk?
Your Unit Cost is the price per pound or ounce from your bulk purchase. Your Minimum Level will be higher because you store more. This makes your cost per recipe lower.
Sources
General information, not legal or tax advice.