Inventory & Purchasing
Supplier Reorder
Supplier, item, last price and packs to reorder, with the line cost worked out.
$11.00
Inventory & Purchasing
Bakery inventory spreadsheet: what you have and what to buy
Ingredient On Hand is a bakery inventory spreadsheet. Type what is on the shelf and the level where you want to be warned. The sheet marks each item In stock, Low or Out and builds a shop list from the last two.
$11.00Ingredient On Hand
- Editable .xlsx for Excel and Google Sheets
- Files arrive by email after checkout
Need more than one sheet? All twelve are $77.00. One by one they add up to $83.91.
Sample data shown
Two of three pages, whole. The file has more.
You type hereLocked formula
How it works
How does Ingredient On Hand work?
Ingredient On Hand compares what is on your shelf with the level where you want to be warned. You type each item, its quantity, unit, location, pack price, expiry date and the low threshold. The sheet marks every item In stock, Low or Out, and lists the low and out items on a Shop list tab.
Fill the On hand tab
Item, quantity, unit, location, pack price, expiry and the low threshold you set. Type 0 if you have none.
Read the stock word
In stock, Low or Out, each with a symbol, so it still reads in black and white.
Open the Shop list
Low and out rows appear there with the quantity to buy. In stock rows stay off the list.
The sample in the file
Ten sample ingredients, five of them low or out, which is exactly what the Shop list tab shows.
A shop list that writes itself
Anything Low or Out lands on the Shop list tab with the quantity to buy. In stock items stay off it, so the list holds only what you need.
Good to know before you buy
- Expiry is a date you type. The file does not count days left and does not total stock value.
- It does not count what you buy from a supplier. Supplier Reorder is the buying side.
Opens in the app you use
Excel opens the .xlsx file as it is. For Google Sheets, upload the file to Google Drive and open it with Google Sheets. There is a How to use tab in the file.
Pairs well with
Sheets that sit next to this one
Each file stands alone. These three are the ones bakers open side by side.
Inventory & Purchasing
Order Ingredient List
This week’s cake orders turned into a buy list of ingredients.
$11.00
Startup & Launch
First Month Packaging
How many packs of boxes, boards and liners the first month needs.
$5.99
Questions
Questions about this sheet
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: 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 supplies do I need for a bakery?
For cake, the first month usually means boxes, boards and liners plus a steady list of ingredients. Ingredient On Hand tracks the ingredients, and First Month Packaging turns the cakes you expect into packs to buy.
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. Ingredient On Hand tracks ingredients, with a quantity, a unit, a location, a pack price and an expiry date.
Where can I get Excel templates for free?
Ingredient On Hand is not a free template: it costs $11.00 and is an editable .xlsx file. It opens in Excel, and in Google Sheets after you upload it to Google Drive.
How do I make a spreadsheet for my expenses?
List every purchase with its item, quantity and price, then total the column. Ingredient On Hand keeps a pack price for each ingredient, but it does not total your expenses or the value of your stock. Supplier Reorder totals what you buy from suppliers.
Ingredient On Hand$11.00