Getting started
Bakery Inventory Excel Template: 6 Columns That Work
Build a bakery inventory excel template that shows the true cost of a batch, labor included.
On this page
- What your inventory sheet actually needs to do
- The 6 columns to build first
- A worked example: 24 cinnamon rolls
- Costing one recipe from the sheet
- Packaging and delivery belong in the sheet too
- How to keep it updated without losing an evening
- Where a spreadsheet starts costing you money
- What to check before you commit to a template
You do not need a paid system to start. A simple bakery inventory excel template you build yourself will do more for your profit than an app you never open. Keep it small enough that you still update it after a long bake day.
What to remember
- One row per ingredient, one column per number.
- Track cost per unit, not the price of the whole bag.
- Count what is left before you shop, not after.
- Add labor and overhead before you call anything profit.
What your inventory sheet actually needs to do
Inventory is not a list of what sits in your pantry. It is a record of what you paid and what is left, so you can price a batch without guessing. If your sheet cannot tell you the cost of one cup of flour, it is a shopping list, not inventory.
Start with the ingredients you buy most: flour, butter, sugar, eggs, yeast, chocolate, and boxes. Everything else can wait until the first six columns are a habit. If you are still setting up your business, the getting started guides walk through the order to do things in.
The 6 columns to build first
Ingredient
One row per item, named the way you buy it. All purpose flour, unsalted butter, large eggs, 9 by 13 boxes.
Pack size and price
What you paid and how much came in the pack. A 5 pound bag of flour at $3.49 is your starting number.
Cost per unit
Price divided by the units in the pack. This one column is what makes the sheet worth keeping.
On hand
How much is left right now. Update it after each bake, not once a month.
Reorder point
The amount where the item goes on the shopping list. Set it high enough that you never run out mid order.
Used per batch
How much one recipe takes. This is what turns a pantry list into real costing.
A worked example: 24 cinnamon rolls
Say a batch of 24 cinnamon rolls uses $9.40 of ingredients and $3.60 of boxes and labels. Your hands are on it for 2.5 hours and you pay yourself $15 an hour, so labor is $37.50. Oven power, water, and the drive to drop them off add $4.50. Total cost is $55.00. At $4 a roll you bring in $96.00, which leaves $41.00, about 43 percent of sales.
The sheet did three jobs in that example. It turned a recipe into a cost, a cost into a price, and a price into a number you can defend when someone asks why a roll is $4.
Costing one recipe from the sheet
Pick your best selling recipe and cost it line by line. Multiply the cost per unit by the amount the recipe uses, then add the packaging for one unit. That gives you the cost of one item before labor.
Then add labor and overhead. Labor is your hours times a rate you choose. Overhead is the small stuff that shows up every week: oven power, water, foil, labels, and miles. Skip either one and your margin is fiction.
Do this for your five best sellers first. Five recipes cover most of your orders, and five rows are easy to keep current. Add the rest as they start selling. The three numbers to track every week are the same ones your sheet should already hold.
Packaging and delivery belong in the sheet too
Boxes, labels, bags, and ribbon are easy to forget because you buy them in a different aisle. Give them their own rows. A $0.35 box on a $4 roll is almost 9 percent of the price.
Delivery is the same. If you drive 12 miles round trip for one order, that cost belongs in the sheet. Add a row for miles and update the rate when gas moves. If you take orders through messages, taking orders online keeps the address and the payment in one place.
How to keep it updated without losing an evening
A sheet you update weekly beats a perfect sheet you update twice a year. Set a 15 minute slot on the same day each week. Add the receipt and let the cost per unit change. Walk the shelf and note what is close to the reorder point. Then cost your best seller again and check the margin.
Where a spreadsheet starts costing you money
The sheet is free. The time is not. Once you track 40 ingredients across 12 recipes, every price change means editing rows by hand. One butter price change touches every recipe that uses butter.
The other trap is a sheet only you can read. If you get sick for a week, nobody else can pick up an order and know what to buy or what to charge.
What to check before you commit to a template
Before you spend an evening building columns, check three things. Can it show cost per batch, not just cost per item. Can you change a price in one place. Can you read it on your phone in the grocery store.
If the answer to any of those is no, you will stop using it. That is the real test, not how many tabs it has. A template you abandon is worth less than a notebook you keep.
One more check: can you share it. If a family member helps you bake on Saturdays, they need to see the reorder list without calling you. A business plan template uses the same numbers, so keep the two in step.
Try the free bake pricing calculator
Free, no signup.
- How to start a cottage bakery from home: 7 steps and costs
- How to start a home bakery for extra income: 6 steps
Common questions
Can I just use a free bakery inventory excel template?
Yes, and it is a fine place to start. Download one, delete the columns you will not use, and rename the rest in your own words. A free template you understand beats a paid one you do not. Just check that it can show cost per batch, not only cost per item.
How often should I update the prices in my sheet?
Update a price the day you notice it changed at the store. Butter, eggs, and chocolate move the most, so check those first. Then run your five best selling recipes again. If a recipe's cost rose by more than a few cents a unit, it is time to look at your price.
Should I count my own labor in the sheet?
Yes. If you leave your hours out, every recipe looks profitable and you cannot tell which ones actually pay. Pick an hourly rate you would accept from someone else and use it every time. You can always lower the rate later, but you cannot make a good decision without the number.
What is the difference between inventory and costing?
Inventory is what you have and what you paid. Costing is what one recipe uses and what that costs to make. You need both in the same sheet, because a recipe cost built on an old price is wrong. Keep them on one tab so a price change flows straight into your recipe.
When should I stop using a spreadsheet?
When updating it takes longer than baking the order. If you are editing 40 rows every time butter moves, the sheet is working against you. That is the point where a tool that updates recipe costs for you saves real hours. Until then, keep the sheet simple and keep using it.
General information, not legal or tax advice. Check your own state rules and talk to a tax professional about your business.