Brewery Inventory Spreadsheet
For craft breweries and brewpubs tracking malt, hops, yeast and packaging. Plan brew days around actual ingredient stock and spot when hop contracts need pulling forward.
Works in Excel, Google Sheets (File → Import) and Numbers. No sign-up.
| Item | Category | Storage | Unit | Par Level | On Hand | To Orderƒ | Unit Cost | Valueƒ | Supplier | Expiry |
|---|---|---|---|---|---|---|---|---|---|---|
| 2-Row Pale Malt, 55 lb | Malt | Grain Room | sack | 30 | 22 | auto | 46 | auto | Great Plains Malting Co. | 2026-10-01 |
| Citra-type Hop Pellets, 11 lb | Hops | Hop Freezer | box | 6 | 4 | auto | 165 | auto | Northwest Hop Growers | 2027-03-31 |
| 16 oz Blank Cans, Pallet | Packaging | Warehouse | pallet | 3 | 2 | auto | 1240 | auto | Brewline Packaging Supply |
ƒ = calculated automatically by formula.
What's included
- Item
- Category
- Storage
- Unit
- Par Level
- On Hand
- To Order — calculated automatically
- Unit Cost
- Value — calculated automatically
- Supplier
- Expiry
Tips for using this template
- Store hops cold and vacuum-sealed and track by crop year; older hops lose aroma, so use them first or in bittering additions.
- Track base malt by the sack and specialty malts by the pound; specialty grains run out in small, surprising amounts.
- Count cans, ends and labels against the packaging schedule; a missing pallet of cans can stall a whole release.
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 TemplateBakery Inventory TemplateCoffee Shop Inventory SpreadsheetFood Truck Inventory TemplateCatering Inventory TemplateFood Pantry Inventory TemplatePizza Shop Inventory TemplateWinery Inventory SpreadsheetJuice Bar Inventory Template