Hops are the ingredient a brewery can't just count by the pound. Two boxes of the same variety can differ in the one number the recipe depends on, alpha acid, because it changes with every crop and every lot. So a hop inventory has one row for each variety, form and crop year, in pounds, and under it a line for each lot, with its alpha acid percentage from the supplier's label. It also tracks what a pound count can't: which bags are open, because an opened bag loses aroma faster, and which lots are oldest, because hops fade with time even when sealed and cold. With those on the sheet, the brewer can adjust a recipe to the lot in hand, use the right bag first, and see a shortage before brew day. Below is a sheet for a made-up brewery, the alpha adjustment, and the file.
The short version
- One row for each variety, form and crop year.
- A lot line under it: lot number, alpha acid, date received, pounds.
- Opened bags: weighed, resealed, used first.
- Oldest crop year first.
- Adjust bittering additions to the lot's alpha: old weight × old alpha ÷ new alpha.
- TaroStack records which hop lot went into which brew, and its cost. More below.
An example sheet
| Item | Unit | On hand | Reorder at | Unit cost | Value | Status |
|---|---|---|---|---|---|---|
| Cascade, T-90 pellets, 2025 crop | lb | 31 | 22 | $9.80 | $303.80 | OK |
| Centennial, T-90 pellets, 2025 crop | lb | 18 | 11 | $11.40 | $205.20 | OK |
| Citra, T-90 pellets, 2025 crop | lb | 9 | 22 | $19.50 | $175.50 | REORDER |
| Mosaic, T-90 pellets, 2025 crop | lb | 26 | 11 | $18.20 | $473.20 | OK |
| Simcoe, T-90 pellets, 2024 crop | lb | 7 | 0 | $16.00 | $112.00 | OK |
| Saaz, T-90 pellets, 2025 crop | lb | 5 | 11 | $13.60 | $68.00 | REORDER |
Eight rows in all, $1,600.40 of hops. Citra is the one to act on: nine pounds on hand, and the next IPA brew takes twelve.
The lots under them:
| Lot | Variety | Alpha acid | Received | Left | Note |
|---|---|---|---|---|---|
| P91-2251 | Cascade | 6.8% | Jan 20, 2026 | 31 lb | One 11 lb box open, resealed |
| P91-3310 | Citra | 12.9% | Jan 20, 2026 | 9 lb | |
| P90-1876 | Simcoe | 12.4% | Feb 11, 2025 | 7 lb | Last of the 2024 crop: use first |
| P91-0440 | Magnum | 13.5% | Jan 20, 2026 | 14 lb | |
| P91-5102 | Saaz | 3.4% | Mar 9, 2026 | 5 lb | Pilsner brews Dec 4 |
Adjusting for alpha
A recipe's bittering addition was written for one lot. When the lot changes, the weight changes, so the same amount of alpha acid goes into the kettle.
| Recipe: Magnum at 60 minutes | 2.0 lb |
| Written for a lot at | 13.5% alpha |
| New lot | 11.8% alpha |
| New weight (2.0 × 13.5 ÷ 11.8) | 2.29 lb |
Use the old weight with the new lot and the beer gets 13% less bittering, and comes out noticeably less bitter. The sum only works if the alpha of the lot in the cold room is written where the brewer will see it, which is why it's on the sheet and not just on a box.
This adjustment is for bittering additions. Late and dry-hop additions are about aroma oils, which alpha doesn't measure, and most brewers keep those weights the same and judge by smell.
Opened bags, and age
Hops lose aroma and bittering with time, and faster with warmth and air. Three habits, all of them on the sheet:
Cold and sealed. Keep pellets in the cold room or freezer in their foil. Write where each variety is.
Opened bags first. When a bag is opened and not finished, weigh what's left, squeeze or flush the air out, reseal it, date it, and put it at the front. On the sheet it's a note on the lot: "one box open".
Oldest crop first. The 2024 Simcoe gets used before any 2025. The file flags lots as their use-first date comes up. The dates in the example are this brewery's own rule, two years from delivery for unopened pellets kept cold. Your supplier's guidance comes first.
Contracts and the spot market
Many breweries buy hops on contract a year or more ahead: so many pounds of each variety from the coming crop, delivered in lots through the year. If you do, add a row or a column for pounds still to be delivered. Citra at nine pounds on hand looks like a crisis; nine on hand and forty-four arriving in December is a note in the brew schedule. And a variety you've contracted but stopped brewing with is money to recover by selling it on.
Counting
Count unopened boxes and bags by their label weight. Weigh every opened one. Do it monthly and before each hop order, in shelf order. A full keg count goes with it: see keg inventory spreadsheet. The rest of the brewery's stock is in brewery inventory spreadsheet, what a beer costs to make in beer cost calculator, and a plan for pulling a batch back in recall plan for a brewery.
Get the spreadsheet
Download the hops inventory spreadsheet. Four sheets: inventory by variety and crop year with value and a REORDER flag, lots with alpha acid and use-first dates, a count sheet to print, and a read-me. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers.
Where this stops working
Brew day uses five hop additions from four lots. Afterwards someone should take 2.29 lb of Magnum, 3 lb of Cascade and the rest off the sheet, and write on the brew log which lot each came from. On a day that started at five in the morning, the brew log gets "Magnum 2.3" and the sheet gets nothing. Three weeks later a customer says the IPA tastes different, and there's no record of which Citra went in.
How TaroStack does it
TaroStack takes the hops off stock, by lot, when the brew is recorded.
Each lot is in stock with its number and dates. The alpha is on the lot, where the brewer picks from.
The brew is a batch. Recording it takes each hop addition from stock and notes which lots were consumed, automatically. The oldest lot is used first by default.
The beer is costed from the lots it used, so a brew with $19.50 Citra and one with spot-market Citra at a higher price each carry their own cost.
"What could I make right now" says whether the cold room covers the next brew, and which hop stops it.
A reorder list in days of cover, with each supplier's lead time.
One report for a recall: which brews used a hop lot, and where the kegs and cases went.
| The job | Spreadsheet | In TaroStack |
|---|---|---|
| Which hop lot went into a brew | What was written at 5 AM | On the batch record |
| Hops left after brew day | Subtract by hand | Taken off when the brew is recorded |
| Enough for Thursday's brew | Count and compare | What could I make right now |
| What the beer cost | A standard figure | From the lots it used |
TaroStack doesn't calculate bitterness or file TTB reports. Recipes, batches, lots and costing are on every plan, from $9.99 a month (5 recipes) or $39 a month (50 recipes). The first 14 days are free, with no credit card. If you'd like a hand setting up, ask, and we'll do it with you.
