A keg isn't stock in the usual sense. It's a container you own that leaves full, sits in someone else's cooler, and comes back empty, if it comes back. So a keg inventory spreadsheet counts each size of keg in four places: empty and clean, full, out at accounts, and not seen in 90 days. The four add up to the fleet you own. A second sheet lists each filling by beer and brew, with its date, so you know what's in the kegs and how old it is. Together they answer the two questions that stop a brewery: are there kegs to fill tomorrow, and where did the rest go? Below is a sheet for a made-up brewery with 180 kegs, and the file.
The short version
- Each keg size on four rows: empty, full, out, missing.
- The four rows add up to what you own. If they don't, count.
- Every filling is a lot: beer, brew, date, best-by.
- Write which account has which kegs, and since when.
- A keg out for 90 days is a phone call.
- TaroStack tracks the beer in each keg by lot and which account got it. More below.
An example sheet
| Kegs | Empty and clean | Full | Out at accounts | Not seen in 90 days | Fleet |
|---|---|---|---|---|---|
| Half-barrel (15.5 gal) | 22 | 31 | 64 | 3 | 120 |
| Sixtel (5.16 gal) | 14 | 18 | 27 | 1 | 60 |
In the file each of those eight numbers is its own row, with caps and collars below. At $135 a half-barrel and $95 a sixtel, the fleet is worth $21,900, which makes kegs the most valuable thing in the building that regularly leaves it.
What the four rows tell you
Empty and clean: can you package? A 3-barrel batch fills about five half-barrels and a few sixtels. With 22 and 14 clean, tomorrow is fine. The "reorder at" on this row isn't for buying kegs. It's the level where you go and collect empties.
Out at accounts: more than half the fleet. 64 of 120 half-barrels are in other people's coolers. That's normal. What matters is how long they stay.
Not seen in 90 days: $500. Three half-barrels and a sixtel. Each one gets a call, and after that a decision: charge the deposit, or write it off.
The cycle. This brewery filled 310 half-barrels in the last 90 days with 120 kegs, so each keg went round 2.6 times, about 35 days a trip. If that stretches to 50 days, the same fleet fills 30% fewer kegs. Chasing empties is cheaper than buying steel.
Fills are lots
| Filled | Beer | Keg lot | Kegs | Best by | Where |
|---|---|---|---|---|---|
| Nov 6 | Pale ale, half-barrel | B-141-K | 9 | Feb 4, 2027 | 6 out, 3 in the cold room |
| Nov 6 | Pale ale, sixtel | B-141-S | 6 | Feb 4, 2027 | 4 out |
| Nov 12 | IPA, half-barrel | B-142-K | 8 | Jan 11, 2027 | Shorter date on hoppy beer |
| Nov 13 | Oatmeal stout, half-barrel | B-143-K | 9 | Mar 13, 2027 | Contains oats |
| Aug 4 | Pale ale, half-barrel | B-128-K | 2 | Nov 2, 2026 | At an account since August: past date |
The keg lot is the brew number with a letter for the package. That ties a keg to its brew, and the brew to its malt, hops and yeast in the brew log sheet.
The last row is the one to act on. Two kegs of August pale ale are still at an account, past the date the brewery set. Beer that's gone stale on someone's tap is the brewery's name on a bad pint. Collect them.
The best-by dates here are this brewery's own: 90 days for most beers, 60 for the IPA. Yours will depend on the beer and how it's kept.
Which account has which kegs
The file's Lots sheet has a notes column for this, and for a handful of accounts that's enough. Write the account on the keg collar as well, with the fill date. When an empty comes back with a collar from a different account, you've learned something about where kegs wander.
The rest of the brewery's stock, malt to packaging, is in brewery inventory spreadsheet. Checking that a washed keg has no cleaner left in it is a control point in some breweries' plans: see brewery HACCP plan.
Get the spreadsheet
Download the keg inventory spreadsheet. Four sheets: the keg count by size and place with its value, fills with days left to their best-by, a count sheet for the monthly keg census, 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
Every delivery and every pick-up changes two rows, and the driver isn't the one who keeps the sheet. By the end of the month, "out at accounts" is whatever makes the rows add up to 120. The only cure is a full count, which means visiting every cooler.
How TaroStack does it
TaroStack follows the beer, keg by keg lot, to the account.
Kegging is a batch. Record it and the beer comes off the brew's lot and the filled kegs go into stock under their own lot code and best-by. The batch record notes the brew automatically.
Orders record the lot. Deliver nine kegs and the order shows which lot went to which account. One report lists everywhere a lot went.
Dates on every lot. The oldest beer ships first, and an alert flags lots close to their date, wherever they are in your own stock.
Empty kegs are items too. Clean empties are stock with a reorder point. Kegging a batch uses them, like any other packaging.
| The job | Spreadsheet | In TaroStack |
|---|---|---|
| Clean kegs for tomorrow | Count the wash room | Stock on hand, with a reorder point |
| What beer is in these kegs | Read the collar | The keg lot, tied to its brew |
| Which accounts got B-142 | The delivery book | One report |
| Beer getting old | Read the dates | An alert |
TaroStack records what you ship, not what an account sends back, so returns of empties are still yours to count. Stock, lots and batches 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.
