Draft beer is the easiest stock in the building to lose, because it leaves a few ounces at a time and nothing on the shelf looks different. A taproom inventory form catches it with one sum for each beer: ounces poured, which is the kegs you started with, plus kegs tapped, less kegs left, times the ounces in a keg; against ounces rung up, from the till. The difference is beer that left the keg and wasn't paid for: foam, line cleaning, tastes, spills, comps, and heavy pours. Some of that is the cost of serving draft. The form's job is to put a number on it, by beer, every week, so that a line running at 15% stands out from four lines running at 4%. Below is a week's form for a made-up taproom with five lines, how to count a part keg, and the file.
The short version
- Count kegs in tenths: full is 1.0, half is 0.5.
- Poured = (open + added − close) × ounces in a keg.
- Rung up = pints × 16, plus other pours at their sizes.
- The difference, as a share of what was poured, by beer.
- A few percent is ordinary. One line far above the others is a problem with that line.
- TaroStack counts kegs on a phone and shows what a difference is worth. More below.
A week's form
| Beer | Keg | Open | Added | Close | Poured | Rung up | Not rung up | Share |
|---|---|---|---|---|---|---|---|---|
| Pale ale | 1/2 bbl | 1.6 | 1 | 0.9 | 3,373 oz | 3,168 oz | 205 oz | 6.1% |
| IPA | 1/2 bbl | 0.8 | 1 | 1.2 | 1,190 oz | 1,136 oz | 54 oz | 4.6% |
| Stout | 1/6 bbl | 1.0 | 0 | 0.4 | 397 oz | 384 oz | 13 oz | 3.2% |
| Cider | 1/6 bbl | 0.5 | 1 | 0.9 | 397 oz | 336 oz | 61 oz | 15.3% |
| Lager | 1/2 bbl | 2.3 | 0 | 1.5 | 1,587 oz | 1,520 oz | 67 oz | 4.2% |
In all, 6,944 oz poured and 6,544 oz rung up: 400 oz, or 5.8%, not paid for. That's 25 pints. At $7 a pint it's $175 for the week.
Reading it
Cider, 15.3%. Four lines sit between 3% and 6% and one is at 15%. The note says a new keg foamed for the first dozen pours. That's a line problem (temperature, pressure, a kinked line, a warm keg tapped too soon), and it's worth an hour with the draft system. On a sixth-barrel, 61 ounces is nearly four pints out of forty-one.
Pale ale, 6.1%. The busiest line and the biggest number in ounces: 205 of the 400. Busy lines pour the most foam and get the most "top it up" pours. If the share stays at 6% while the others are at 4%, watch a few pours.
The rest. Three to five percent, on a system that's cleaned and balanced, is beer you were never going to sell. Aim to keep it there, not to get to zero.
Keg sizes
| Keg | Gallons | Ounces | 16 oz pints, to the last drop |
|---|---|---|---|
| 1/2 bbl | 15.5 | 1,984 | 124 |
| 1/4 bbl | 7.75 | 992 | 62 |
| 1/6 bbl | 5.16 | 661 | 41 |
| 50 L | 13.2 | 1,690 | 105 |
Those are the pints in the keg, not the pints you'll sell. Take your usual loss off: at 5%, a half barrel sells about 118 pints. If your "pint" glass holds 16 oz to the brim, a pour with a head on it is 14 oz or so, and the sum should use what you actually pour.
Counting a part keg
Weigh it. The accurate way. A keg scale, or a platform scale by the cooler door. Subtract the empty shell's weight (it's stamped on many kegs, or weigh an empty) and divide by the weight of a full keg's beer. A half barrel holds about 130 lb of beer.
Lift and judge. The quick way: tilt the keg and estimate in tenths. It's rough, and it's consistent enough if the same person does it the same way every week. Over a month the errors mostly cancel.
Flow meters. Meters on each line measure what was poured directly. They're the answer for a busy bar and more than a five-line taproom needs.
Count at the same time each week, before opening, and include the kegs in the cooler that aren't tapped.
What to ring up
The sum is only as good as the till. Every pour needs a button, including the ones nobody pays for:
| Pour | Ring it as |
|---|---|
| Pint, half, flight glass, growler fill | Its own button, with its ounces |
| Taste | A zero-price "taste" button, 1 oz |
| Staff beer, comp, mug club | A zero-price button with the reason |
| Foam and line cleaning | Not rung: it's what's left over |
Once tastes and comps are rung, what remains really is foam, cleaning and over-pouring, and you know what you gave away on purpose.
Kegs themselves, and where the shells are, are in keg inventory spreadsheet. What a pint costs and how to price it is in how to price beer and drink cost calculator, and the hops behind it in hops inventory spreadsheet.
Get the form
Download the taproom draft inventory sheet. A Draft sheet where ounces poured, ounces not rung up and the share work themselves out, a Keg sizes sheet, and a read-me. Print the first six columns as a count sheet for the cooler. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers.
Where this stops working
The form needs a keg count and a sales report, every week, typed into the same sheet. The count is on a wet clipboard in the cooler. The sales report is in the till's back office. They meet on Monday, if the manager has time, and the cider line has poured foam for a week before anyone sees 15%. And the form only knows this week: it can't say whether the pale ale has been at 6% all quarter.
How TaroStack does it
TaroStack keeps the keg count and its history.
Counting on a phone, in the cooler, with no signal. Kegs in tenths, by beer. It sends itself later.
The count shows what a difference is worth before it's posted: 25 pints is a dollar figure on the screen, at what that beer cost you.
Each beer is stock by lot, with the date it was kegged, and the oldest keg is used first by default.
Every adjustment carries a reason: line cleaning, samples, damaged, comp. Losses are reported by reason and by beer, month on month.
For a brewery, the keg is the end of a batch: which brew, which hops, what it cost.
A reorder list in days of cover for guest kegs, glassware and gas.
| The job | Form and a clipboard | In TaroStack |
|---|---|---|
| The keg count | Paper, typed in Monday | On a phone, in the cooler |
| What the loss is worth | A sum, later | Shown at the count |
| Loss by reason, over time | This week only | Adjustments by reason, by month |
| Which brew is in this keg | The cap, maybe | The lot |
TaroStack isn't a till and doesn't read flow meters. It connects to Square. Stock, counting and lots are on every plan, from $9.99 a month. 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.
