Skip to content

Hops Inventory Spreadsheet: Variety, Crop Year, Alpha

A free hops inventory spreadsheet for a small brewery: pounds by variety and crop year, lot numbers with alpha acid, opened bags, use-first dates and a count.

By Koa Sterling. Product specialist at TaroStack and small business owner. Yes, I am a real human, and I actually sit in front of a computer and write these articles. Reviewed November 21, 2026 · 7 min read

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.

Questions people also ask

How do breweries track hop inventory?

By variety, form and crop year in pounds, with each lot's number and alpha acid, noting opened bags and using the oldest first.

How do you adjust a recipe for a different alpha acid?

Multiply the recipe's weight by the old alpha percentage and divide by the new one. 2.0 lb at 13.5% becomes 2.29 lb at 11.8%.

How should hops be stored?

Cold, sealed and away from air. Reseal opened bags with the air removed, date them, and use them first.

We use AI to help with the research for these articles. Every one is read, checked against its sources and edited by Koa before it's published. Spot a mistake? Tell us and we'll fix it and say so. How we write these.

Let’s get your stack in order.

Get TaroStack

Sign up now for your free 14 day trial. No credit card required.