Getting started
Bakery Inventory List Template: 6 Columns That Stop Waste
The exact columns to put on your inventory sheet, and how to use them to price what you sell.
On this page
What to remember
- One row per ingredient, one column per number you need.
- Cost per unit is the column that prices your recipes.
- Update it the day a delivery arrives, not at month end.
- A sheet you never open is worse than no sheet.
Your sheet does not need to be fancy. A bakery inventory list template only works if you fill it in the same day you shop and can read it on your phone while you bake. Start with the columns below and add a new one only when a number is missing.
Think of it as a shopping list that remembers. Every time you write down what you paid, you are building the cost side of your prices. Do that for a month and quoting a new order takes minutes instead of an evening.
The six columns that do the work
Six columns cover almost everything a home baker needs. Item name. The unit you buy it in, such as a 5 pound bag or a dozen eggs. What you paid for that unit. Cost per unit. How much you have left. And the point where you reorder.
Keep the sheet flat. One row per ingredient, no merged cells, no colors you cannot read in a dim kitchen. If you sell at a market table, add a column for what left the house that week so your count matches your sales.
Do not track every jar of spice you own. Track what you buy often and what costs real money: flour, butter, eggs, sugar, chocolate, boxes, labels, and bags. A sheet with 60 rows you never finish is worse than 15 rows you keep current.
How to build it in one sitting
List what you actually buy
Walk your pantry, fridge, and freezer with a notepad. Write down only the items you buy again and again. Skip the once a year vanilla you use twice.
Add the unit and the price
For each item, write the pack size and what you paid. A 25 pound bag of flour at $12.99 is one unit, not one pound.
Work out cost per unit
Divide the price by the number of smaller units in the pack. That gives you the number you will use in every recipe cost from now on.
Set a reorder point
Pick the amount left that means buy more now. For flour, that might be 5 pounds. Write it in the last column.
Count once a week
Pick a day, count what is left, and update the sheet. Ten minutes on a Sunday beats an hour of guessing on Friday.
A worked example: one dozen cinnamon rolls
Say a batch of 12 cinnamon rolls uses $6.40 of ingredients and $1.10 of boxes and labels. Your hands are on it for an hour, and you pay yourself $15 an hour, so labor is $15.00. Oven, water, and washing up add about $1.50. Total cost is $24.00.
At $36 a dozen, the margin is $12.00, which is 33% of the price. At $30 a dozen the margin drops to $6.00, or 20%. The sheet gives you the first two numbers. Your time and your bills give you the other two. Set prices with all four, the way this micro bakery price list lays out.
Ask yourself what else the order costs you. A market table fee, a delivery run, a box you did not count. Add those to your price separately, or your margin will look better than it is.
Mistakes that cost you money
The third mistake is updating only when you run out. You find the gap mid order, with a customer waiting. The fourth is keeping the sheet in your head. If it is not written down, it is a guess, and guesses get expensive once you are selling.
One more: buying in bulk to save money and then wasting it. A 50 pound bag is only cheaper if you use it before it goes stale. Check your sheet before the next bulk run.
How often to update it
Count what is left once a week. Update prices the day a receipt changes. Check the sheet before you quote a big order, not after. Three habits, ten minutes each, and your numbers stay honest. Pair it with the three numbers in this home bakery bookkeeping guide so your weekly count and your weekly money check happen together.
Paper, spreadsheet, or your own shop
Paper is free and you can start tonight. A spreadsheet does the division for you and totals a column in one tap. Your own shop does the same job and connects the number to the recipe, so you are not copying costs by hand every time a price moves.
Pick the one you will actually open. A tidy sheet you ignore loses to a messy one you use. If you sell at markets, keep it on your phone so you can check a price while a customer waits.
Brevl keeps ingredient inventory and recipe costing in the same place, and it is $20 a month with no cut of your sales. If you are still setting up, start with the getting started guides. If you have not started selling yet, work through the cottage bakery start guide first, then come back and build the sheet.
Try the free bake pricing calculator
Free, no signup.
- Micro Bakery Business Plan Template: 7 Numbers to Fill In
- Micro Bakery Order Online: Take Orders and Get Paid (2026)
Common questions
What should a bakery inventory list template include?
Start with six columns: item, the unit you buy it in, what you paid, cost per unit, how much is left, and your reorder point. Add a column for what left the kitchen that week if you sell at markets. Six columns you keep current beat twenty you abandon.
Should I use paper, a spreadsheet, or an app?
Whichever one you will open every week. Paper is free and fast to start. A spreadsheet does the division for you. Your own shop keeps the ingredient list and the recipe cost together, so a price change flows through every item you sell without you copying it by hand.
How do I work out cost per unit?
Divide what you paid by how many smaller units are in the pack. A 25 pound bag of flour at $12.99 works out to about 52 cents a pound. Write that number in its own column and use it every time you cost a recipe.
How often should I count what is left?
Once a week on the same day. Pick a quiet morning, count the items that matter, and update the sheet. Ten minutes weekly keeps your numbers close enough to price from. Counting only when you run out means you find the gap while a customer is waiting.
Do I need to track packaging too?
Yes. Boxes, labels, bags, and ribbons are part of what a customer pays for, and they are easy to forget. Give each one its own row with a cost per unit. A box that costs 40 cents feels small until you sell 200 of them.
Sources
General information, not legal or tax advice.