Bakery Inventory List Example: 6 Columns and a Real Count

On this page

1. What goes on a bakery inventory list?
2. How do you turn counts into money?
3. What mistakes cost home bakers money?
4. How do you use the list after the count?
5. What should you check before you commit to a sheet?

This bakery inventory list example is built for a home kitchen, not a warehouse. You will count the same items every week, in the same order, so the sheet takes minutes instead of an hour. If you are still setting up your baking side, start with the getting started guide for home bakers, then come back and build your list.

What goes on a bakery inventory list?

Keep six columns: item, unit, count on hand, par level, cost per unit, and total value. The item is what you buy, like a 25 pound bag of flour. The unit is how you count it, like pounds, cups, or each.

The count on hand is what you see today. The par level is the lowest number you want before you buy more. Cost per unit is what you paid, and total value is count times cost.

You do not need every spice on day one. Start with the items you buy every week and the packaging you use every week. Add holiday items when the season starts. A short list that you finish beats a long list that you skip.

1. 1

   Print one sheet per week

   Use the same columns every time so you can compare weeks.

2. 2

   Count before you bake

   Count flour, sugar, and butter on the same morning each week.

3. 3

   Write the count, not the guess

   Look in the bin and read the bag. Round to the unit you buy.

4. 4

   Mark what is low

   Circle anything under your par level so the shopping list is done.

5. 5

   Update after orders

   Subtract what you sold and what you baked, then save the sheet.

How do you turn counts into money?

A count only helps when you price from it. Add the ingredient cost for the batch, add your labor, then add overhead. Overhead is the monthly cost of running your bakery, divided across the batches you bake. If you skip overhead, your margin is fake.

For example, say one dozen cookies uses $8 of ingredients. You spend 1 hour baking and decorating, and you pay yourself $18 an hour, so labor is $18. Your monthly overhead is $80, and you bake 20 batches a month, so overhead is $4 a batch. The batch costs $30. Sell the dozen for $42 and your margin is $12 after ingredients, labor, and overhead.

That $12 is not extra spending money yet. It is the money that pays for the next round of ingredients, the broken mixer, and the slow week. If you sell 20 batches a month at that margin, you clear $240 before taxes. Put some of it back into the business and pay yourself on purpose.

What mistakes cost home bakers money?

The first mistake is guessing. A memory of a half bag of flour is not a count. The second is counting only ingredients and forgetting boxes, stickers, and bags.

The third is buying in bulk because the unit price looks low, then letting half of it expire. The fourth is never writing down waste, so the same loss repeats every week. Another quiet loss is overbuying fresh items.

If you buy five pounds of berries and sell three, the two pounds are not a discount, they are a cost with no sale. Write the waste down. After a month, the sheet shows which items to buy smaller or drop.

How do you use the list after the count?

Turn the count into a shopping list the same day. Buy only what is under par. When an order comes in, check the count before you promise it. If the count is low, either buy more or offer a different item.

Save each week’s sheet in one folder, paper or digital. After a month, look at the total value column. Items that sit with a high value and no sales are waste with a price tag.

Keep the old sheets. One week is a snapshot, four weeks are a pattern. If flour keeps dropping below par, raise your par level or buy a bigger bag. If a decorated item sits in the total value column for weeks, stop making it until orders come first.

What should you check before you commit to a sheet?

Check that the list fits on one page. Check that the units match how you buy and how you bake. Check that you can finish it in 15 minutes on your phone.

Check that the sheet shows a par level, so it becomes a shopping list. If any answer is no, cut the list until it is yes. A good sheet also helps you price. Use your counts with the micro bakery price list guide to set prices that cover every cost.

If you like numbers on a screen, the home bakery spreadsheet guide shows five columns that show real profit. For a simple starting point, copy the bakery inventory list template. When the week is busy, the manual bookkeeping guide keeps five numbers in one place.

You do not need a perfect system on day one. You need one sheet you will finish. Start with the items you bake every week, count them, and let the numbers guide your shopping and your prices.

Common questions

How often should I count bakery inventory?

Count the same items once a week, on the same day. A weekly count catches low stock before a custom order and shows what is not selling. If you bake daily, count fast moving items like flour and sugar twice a week.

What is the difference between inventory and par level?

Inventory is what you have right now. Par level is the smallest amount you want on hand before you buy more. The gap between the two is your shopping list, and it keeps you from buying five bags of flour you already own.

Should I count packaging in my inventory list?

Yes. Boxes, bags, stickers, and ribbon are part of your cost. Count them with your ingredients so a price includes every dollar that leaves your account. Packaging is easy to forget because it sits on a shelf instead of in the fridge.

Can I use a spreadsheet instead of paper?

Yes. A spreadsheet is fine if you update it after every bake and sale. The risk is a phone photo of a handwritten count that never gets typed in. Pick the one you will actually use on a busy Friday.

General information, not legal or tax advice.