Skip to content

Taproom Inventory Form: Kegs, Pours and What's Missing

A free taproom inventory form: kegs at open and close in tenths, ounces poured against ounces rung up, and the share of each beer that wasn't paid for.

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

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.

Questions people also ask

How do you track draft beer inventory?

Count kegs in tenths at the start and end of a period, work out ounces poured from the kegs used, and compare with the ounces the till recorded. The difference is the loss.

How many pints are in a keg?

A half barrel holds 1,984 oz: 124 pints of 16 oz. A sixth barrel holds 661 oz: 41 pints. Expect to sell a few percent fewer.

What is an acceptable loss on draft beer?

It depends on the system, but a few percent for foam and line cleaning is ordinary. A single line far above the others points to a problem with that line.

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.