Getting started
Bakery Inventory Sheet: 6 Columns That Stop Waste
A simple, free way to track ingredients so you stop wasting money on overbuying and spoilage.
On this page
What to remember
- Track what you have, not just what you buy.
- See your real food cost per recipe.
- Stop buying ingredients you already own.
- Catch waste before it spoils.
Your bakery inventory sheet is the one place you check before you shop. It tells you what is in your pantry and what you need for the week. Without it, you buy extra and waste money.
What goes on a bakery inventory sheet
Your sheet needs six columns. The first three track your stock. The last three track your use and cost.
Ingredient name
List every item you own, from flour to sprinkles. Group them by type, like dry goods, refrigerated, and frozen.
On hand
Write how much you have right now. Use cups, pounds, or bags, but pick one unit per ingredient and stick to it.
Par level
This is the minimum amount you want to keep. When your on hand dips below this, you know it is time to buy more.
Used this week
Track what you pull from stock for your orders. This column shows your real consumption.
Cost per unit
Note the price you paid for each bag or bottle. This lets you cost your recipes accurately.
Notes
Mark expiration dates, supplier names, or special storage needs. This stops spoilage.
How to set up your first sheet
Start with a notebook or a simple spreadsheet. Do not buy software yet. You can get a free template from the USDA’s food buying guide for portion planning, which helps set par levels.
Take a full inventory
Empty your pantry and write down every single baking ingredient. Note the amount and the purchase price if you have the receipt.
Set your par levels
For flour you use weekly, your par level might be 5 lbs. For vanilla extract you use slowly, it might be 1 bottle. A guide from Penn State Extension suggests tracking usage for two weeks to set accurate levels.
Update it every Friday
Before you plan next week’s bakes, check what you used. Subtract it from your on hand column. Then write your shopping list from what is below par.
Review waste monthly
Look for ingredients you threw out. Adjust your par level or buying habits so it does not happen again.
A worked example with real numbers
Let us cost a batch of two dozen chocolate chip cookies using an inventory sheet. You need 2 cups of flour, 1 cup of sugar, 1 cup of chocolate chips, and 1 stick of butter.
From your sheet, you see you bought a 5lb bag of flour for $3.50, a 4lb bag of sugar for $4.00, a 12oz bag of chips for $4.50, and a 1lb box of butter for $5.00. You use 2 cups of flour (about 0.5 lbs from the 5lb bag), 1 cup of sugar (0.25 lbs), 1 cup of chips (0.75 lbs), and 0.25 lbs of butter.
Your ingredient cost is about $2.81 for the batch. Add $0.50 for packaging and $0.20 for power. Your direct cost is $3.51. If you pay yourself $15 an hour and the batch takes 1 hour, your labor is $15. Overhead includes insurance, website fees, and kitchen rent. For a small operation, this might be 20% of direct costs, or $0.70. Your total cost is $19.21. For 24 cookies, that is about $0.80 each, or $9.60 per dozen. This shows your real margin after all costs.
Common mistakes that cost you money
The wrong sheet hides problems instead of showing them. Check these points before you commit to a system.
How to use your sheet for pricing
Your inventory sheet provides the data for profitable pricing. It shows the exact cost of each ingredient you use. First, calculate your direct food cost per recipe from the cost per unit column. Then add your labor cost based on the time it takes to bake. Finally, apply a markup for overhead and profit. The same guide suggests reviewing these costs monthly as prices change. This process ensures your prices cover all expenses.
Without accurate inventory data, you might underprice your goods. You could be losing money on every sale. Your sheet tells you when supplier prices increase so you can adjust your menu prices. It also shows which recipes have the best margin. This helps you decide what to promote in your shop.
Managing inventory for multiple recipes
When you bake several items, your sheet must work harder. List all ingredients in one master list. Then track usage across all recipes in the used this week column. This shows your total consumption of flour or sugar. It prevents you from running out of a shared ingredient. Grouping items by type, as suggested earlier, makes this easier to scan.
Your par levels become more critical with multiple products. A sold-out cookie order might use your last bag of chocolate chips. That could delay a cake order. Set par levels based on your total weekly usage for all recipes. Add a small buffer for unexpected demand. Review these levels each month as your product mix changes.
When to move from paper to a tool
A notebook works for your first 20 orders. When you have more than 30 ingredients or sell more than three products a week, a tool saves time. Look for one that connects inventory to your recipes, so using 2 cups of flour automatically updates your stock. This is part of getting your shop set up right.
Paper works at first, but a tool saves hours as you grow.
| Paper sheet | Digital tool |
|---|---|
| Free to start | Monthly cost |
| You do all the math | Math is automatic |
| Hard to share | Updates on any device |
| No link to recipes | Sees what you need to bake |
A good sheet shows you your real food cost. That lets you price for profit. Learn more in our guide to a bakery costing spreadsheet.
Try the free bake pricing calculator
Free, no signup.
Browse more getting started guides.
Common questions
How often should I update my bakery inventory sheet?
Update it every time you finish baking for the week. Subtract what you used from your on hand column. Then check what is below your par level to make your shopping list. A quick weekly update takes 10 minutes and stops weekend surprises.
What is the biggest mistake new bakers make with inventory?
They track only what they buy, not what they use. This hides waste. If you bought 10 lbs of flour but only used 2 lbs this month, your money is tied up in stock. Track usage to see your real consumption and adjust your buying.
Should I track packaging on my inventory sheet?
Yes, track boxes, bags, and stickers separately. Create a second section on your sheet for packaging supplies. Note how many you have and your par level. Running out of boxes stops orders just as fast as running out of flour.
How do I set a par level for a new ingredient?
Buy a small amount first. Track how much you use over two or three baking weeks. Then set your par level at one and a half times that weekly usage. This gives you a buffer for sudden orders without overstocking.
Sources
General information, not legal or tax advice.