Inventory & Purchasing · $11.00 each

Bakery supply list: know what you have, buy what you need

A bakery supply list starts with counting what is on the shelf, and these three sheets count it, reorder from your suppliers and turn this week’s cakes into a buy list. $11.00 each.

See the three sheets
A pantry shelf with glass jars of flour, sugar and oats and a basket of eggs
Ingredient On Hand, the On hand tab: ten sample ingredients with quantity, threshold and an In stock, Low or Out word
Supplier Reorder, the Reorder tab: seven sample lines across three suppliers with a 56.55 dollars total
Order Ingredient List, the This week tab: sample orders and recipes with a buy list of ingredients
The three sheets

Pick one, or take all three

Ingredient On Hand cover: Inventory & Purchasing spreadsheet, editable .xlsx for Excel and Google Sheets
Inventory & Purchasing

Ingredient On Hand

Quantity on hand against your threshold, and a shop list of what is low or out.

$11.00
Supplier Reorder cover: Inventory & Purchasing spreadsheet, editable .xlsx for Excel and Google Sheets
Inventory & Purchasing

Supplier Reorder

Supplier, item, last price and packs to reorder, with the line cost worked out.

$11.00
Order Ingredient List cover: Inventory & Purchasing spreadsheet, editable .xlsx for Excel and Google Sheets
Inventory & Purchasing

Order Ingredient List

This week’s cake orders turned into a buy list of ingredients.

$11.00

Which stock sheet first?

Start with Ingredient On Hand, which tells you what is low or out. Supplier Reorder is the buying side: supplier, last price and how many packs to reorder. Order Ingredient List works backwards from this week’s cake orders to what you still need to buy.

Questions

Questions bakers ask

What supplies do I need for a bakery?

For cake, the first month usually means boxes, boards and liners, plus a steady list of ingredients. First Month Packaging covers the packaging, and Ingredient On Hand covers the ingredients.

How do I make my own inventory list?

List every ingredient with its quantity, unit and where you keep it, and add a level at which you want to reorder. Ingredient On Hand is built that way and turns the low items into a shop list.

What should an inventory list include?

For a baker, an inventory list includes the item, how much you have, the unit, where it is kept, what a pack costs, when it expires and the level where you reorder. Those are the columns of Ingredient On Hand.

What is a bakery equipment list?

A bakery equipment list names the tools and machines you own, which is a different job from tracking ingredients. The three sheets in this group track ingredients and what you buy, not equipment, so keep your equipment on its own sheet.

Where can I get Excel templates for free?

The three inventory and purchasing sheets are not free: each costs $11.00 and opens in Excel and Google Sheets. Each has a filled-in sample, so you can see how it works before you clear it.

How do I make a spreadsheet for my expenses?

List every purchase with its supplier, item and price, then total the column. Supplier Reorder does this for what you buy again: line cost is the last pack price times the packs you reorder, and a Total row adds every line. It covers what you buy from suppliers, not every expense a bakery has.