Soap Making Inventory Spreadsheet
For cold-process and melt-and-pour soap makers tracking oils, lye, colorants and curing bars. Keeps batches, raw ingredients and finished stock aligned.
Works in Excel, Google Sheets (File → Import) and Numbers. No sign-up.
| SKU | Item | Category | Location | Unit | Qty on Hand | Reorder Point | Unit Cost | Stock Valueƒ | Statusƒ | Supplier |
|---|---|---|---|---|---|---|---|---|---|---|
| SP-OIL-OLV-7 | Olive Oil (pomace), 7 lb | Base Oils | Ingredient Shelf A | jug | 5 | 2 | 19.75 | auto | auto | Green Valley Soap Supply |
| SP-NAOH-2 | Sodium Hydroxide Beads, 2 lb | Lye | Locked Cabinet | jar | 4 | 2 | 9.8 | auto | auto | Green Valley Soap Supply |
| SP-BAR-LAV-B214 | Lavender Oat Bar, Batch 214 | Finished Bars | Curing Rack 2 | bar | 36 | 12 | 1.85 | auto | auto | In-house (batch cost) |
ƒ = calculated automatically by formula.
What's included
- SKU
- Item
- Category
- Location
- Unit
- Qty on Hand
- Reorder Point
- Unit Cost
- Stock Value — calculated automatically
- Status — calculated automatically
- Supplier
Tips for using this template
- Weigh base oils by the pound at each count; recipes are built on weight, so volume estimates throw off what you can make.
- Keep curing bars in their own location until they've cured, then move them to sellable stock so they're not sold early.
- Record the batch number on finished bars so you can trace any customer feedback back to a specific pour.
Stop typing deliveries by hand
Every time stock arrives you have to copy the supplier invoice into your sheet. Upload the invoice or packing slip to our invoice to inventory converter and paste SKU, item, quantity and unit cost straight into this template.
More free templates
Small Business Inventory TemplateRestaurant Inventory TemplateReseller Inventory SpreadsheetRetail Store Inventory TemplateWarehouse Inventory TemplateHome Inventory TemplateBar & Liquor Inventory TemplateOffice Supplies Inventory TemplateAuto Parts Inventory TemplateHardware Store Inventory SpreadsheetClothing Boutique Inventory TemplateConvenience Store Inventory SpreadsheetGift Shop Inventory TemplateBookstore Inventory SpreadsheetPet Store Inventory TemplateFlorist Inventory Template