Brewery Inventory Management: From Grain Bill to Finished Kegs

Brewery inventory management is the discipline of tracking a beer's ingredients and volume as it moves from a sack of base malt to a finished half-barrel keg on the loading dock. It is deceptively hard: a single brew day turns pounds of grain, ounces of hops and a pitch of yeast into hundreds of gallons of liquid that then changes state twice more before it is sold. Most small breweries reconcile all of that by hand in a spreadsheet after every brew, and it is exactly where errors, stockouts and untraceable losses creep in.

If you run a 5-BBL, 10-BBL or 30-BBL brewhouse, the core problem is that your stock is never sitting still in one form. It is constantly being consumed, transformed and re-packaged, and generic retail inventory tools have no concept of a grain bill becoming a fermenter becoming a pallet of cans.

Why brewery inventory is different from ordinary retail stock

In a retail shop, a unit comes in, sits on a shelf, and goes out unchanged. A brewery breaks that model in three ways. First, your raw materials are consumed and transformed, not resold: fifty pounds of Pilsner malt do not leave the building as malt, they leave as beer. Second, you carry work-in-progress inventory that has no barcode and no shelf: hundreds of gallons of liquid sitting in a fermenter for two to six weeks. Third, your units of measure change at every stage, from pounds and ounces to gallons and barrels to kegs, cans and case equivalents.

On top of that, you are federally regulated. The TTB (Alcohol and Tobacco Tax and Trade Bureau) expects you to account for every barrel produced, packaged, removed and destroyed, and to file the Brewer's Report of Operations on a monthly or quarterly basis. Loose ingredient math is not just messy, it is an audit risk. This is closer to the discipline of inventory for makers and manufacturers than to shopkeeping.

The three stock states: raw materials, WIP fermenters, finished packaging

Every brewery item lives in one of three states, and a good system tracks all three under one roof.

• Raw materials — base and specialty malts, hops, yeast, water-treatment salts and adjuncts, plus packaging: empty kegs, cans and lids, cardboard, labels and CO2.
• Work-in-progress (WIP) — beer that has left raw-material state but is not yet packaged. It flows mash and lauter, then boil in the brewhouse, into the fermenter, then into a brite or conditioning tank. This is liquid inventory, measured in gallons or barrels.
• Finished goods — kegs, cans and bottles ready to sell, each carrying the batch it came from.

The thread that ties them together is the batch. Every brew gets a batch or lot number, and that number should follow the beer from the fermenter through conditioning all the way to the finished keg. Lose the thread and you cannot answer the two questions that matter most: how much beer do I actually have, and where did it come from.

Build your recipe as a bill of materials so brewing auto-deducts ingredients

Here is the single change that removes most of the manual work. A beer recipe is a bill of materials. It is not a metaphor for one; it is literally a list of components consumed to produce one output. If you have never formalized one, our primer on what a bill of materials is covers the concept.

A brewery BOM has three parts:

• The grain bill in pounds — base malts plus specialty grains.
• The hop schedule — each hop by variety, form (pellet, whole leaf or extract), alpha acid percentage and addition timing, from 60-minute bittering additions through whirlpool and dry-hop.
• The yeast pitch and the packaging that finishes the batch — kegs, cans, lids and CO2.

In Shelvr you define each beer once as a BOM, and when you record a batch as brewed, the production step auto-deducts the exact grain, hops, yeast and packaging consumed from raw-material stock. Your fifty pounds of Pilsner malt and four ounces of Citra come off the shelf, WIP appears, and when you package, that WIP becomes a known count of kegs and cans. No post-brew spreadsheet reconciliation.

The recipe you already keep in your brewing software is a bill of materials. The only missing piece is a system that treats "brew this batch" as a production event and does the subtraction for you.

Tracking grain, hops and yeast by supplier, harvest year and generation

Not all hops are interchangeable, and treating them as a single SKU throws away the information you need on brew day. Hops should be tracked by supplier, harvest (crop) year and alpha acid percentage, because alpha acid drives bitterness and degrades over time, so two lots of the same variety are genuinely different ingredients. Keep them cold and use the older, lower-alpha lot first.

Yeast has its own attributes: strain, generation number (how many times it has been re-pitched) and a viability window. Over-generation or old yeast produces off-flavors or simply fails to take off, dumping a whole batch. Even malt stales if it sits too long. All three ingredients call for oldest-first rotation.

Batch and lot tracking for FEFO rotation and TTB recalls

Because hops degrade, yeast expires and even canned beer carries a best-by date, breweries run on FEFO — first-expiry, first-out. Sell and consume the oldest stock first, at both the ingredient and finished-goods ends. Shelvr's batch and expiry tracking attaches a batch and date to every lot, so the app surfaces what to use next rather than leaving it to memory.

Batch tracking is also your recall and audit backbone. When a batch number follows the beer from fermenter to finished can, you can trace any package back to its exact ingredient lots. That matters for a product recall, and it matters for TTB reconciliation, where you must account for what you produced and removed. The same batch spine works for wineries too, as covered in our guide to winery inventory management.

Kegs, cans and case equivalents: getting your units of measure right

Volume in a brewery starts from the barrel (BBL) = 31 US gallons, and everything else is a fraction or multiple of it. Get these conversions into your item setup once and stop doing mental math.

One barrel is roughly 13.78 case equivalents, the unit distributors and the TTB often want output reported in. And remember that kegs are returnable assets with deposits, not consumables. An empty half-barrel in the wild is money owed to you, so tracking full versus empty keg counts is part of inventory, not an afterthought.

Waste tracking: trub, hop absorption, spillage and dumps

Total process losses typically run 8 to 15% of starting volume, and if you are not logging where it goes, you cannot cost your beer or defend your numbers in an audit. The usual suspects:

• Trub — the protein and hop sludge left in the kettle and fermenter, which can be as much as a half-barrel per batch.
• Hop absorption — hops soak up wort and beer, especially in heavily dry-hopped styles.
• Yeast slurry pulled off the cone, plus racking and transfer losses.
• Packaging shortfalls, foaming and spillage, and intentional dumps of infected or off-spec batches.

Under 27 CFR 25.292 you are required to log every bottle, can or keg broken or destroyed, with date, volume and cause. Unreported breakage can be treated as untaxed removals in an audit. Shelvr's waste tracking lets you record losses by category and tie each dump or spill back to its batch, so the shrinkage that is real is documented and the shrinkage that is theft or miscount stands out.

Reorder points and offline counting in the cellar and cold room

Perishable, lot-specific ingredients make ordering a balancing act: run short of a hop lot and brew day stalls, over-order and your hops lose alpha acid and your yeast ages out. Reorder points and low-stock alerts tuned to your real recipe consumption keep base malts and CO2 topped up while stopping you from overbuying perishables. A simple starting formula is reorder point = (avg daily sales × lead time) + safety stock, adapted to ingredient usage per brew.

The last piece is where the counting actually happens. Cellars, walk-in coolers and cold rooms are exactly the places with the worst cell signal in the building, and they are where you receive grain pallets, count kegs and check hop inventory. Shelvr is offline-first: you can scan a barcode with your phone camera, count, receive and adjust stock with no signal at all, and it syncs across your devices the moment you are back online. For a brewery, that is the difference between counting on paper and re-keying it later versus counting once, in place.

Put it together and the manual spreadsheet disappears. Define each beer as a BOM, brew a batch and let the ingredients auto-deduct, carry the batch number through to finished kegs and cans, log your losses against it, and count in the cold room offline. You can start for free and move to Pro when you are ready — see pricing for details.