Skip to content

Keg Inventory Spreadsheet: Where Every Keg Is

A free keg inventory spreadsheet for a small brewery: kegs counted as empty, full, out at accounts or missing, fills by beer and date, and the fleet's value.

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 19, 2026 · 6 min read

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.

Questions people also ask

How do breweries keep track of kegs?

By counting each size in four places: empty and clean, full, out at accounts, and missing. The four add up to the fleet, and a regular count keeps them honest.

How many kegs does a small brewery need?

Enough to cover the time kegs spend away. A brewery whose kegs take 35 days to come back needs about 35 days of fills in steel.

How long is beer good in a keg?

It depends on the beer and on keeping it cold. The example brewery sets 90 days for most beers and 60 for hoppy ones.

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.