Start free

Beer Inventory: How to Count Kegs, Cans and Bottles

By mise · Updated October 7, 2026

Quick answer: beer inventory counts kegs by weight (or percentage full), and cans and bottles by case plus loose units. Weekly counts compared with draft sales show how much beer is lost to foam, spills and free pours.

Draft beer is the easiest product to lose without noticing: nobody sees the extra half-inch of foam or the pint poured for a regular.

What to count in a bar or brewery taproom

CategoryWhat it includesHow often
KegsFull and partial (by weight)Weekly
Cans & bottlesCases + looseWeekly
CoolerBackups and seasonalsWeekly

Step by step

  1. Weigh partial kegs.
  2. Count cases, then loose units.
  3. Compare ounces sold with ounces used.
  4. Log line cleaning and spills.

Mistakes that throw the count off

How to count beer, line by line

FormatCount asTip
Kegs, fullNumber of kegs per sizeCount the walk-in and the keg cooler separately
Kegs, tappedFraction left (by weight)Weigh an empty and a full keg of each size once
Cans and bottlesFull cases + loose unitsCount the back stock before the bar fridge
Growlers / crowlersUnitsCount only sealed, saleable ones

Draft beer is best tracked in ounces: a US 1/2 barrel holds 15.5 gallons (1,984 oz), a 1/4 barrel 7.75 gallons (992 oz) and a 1/6 barrel about 5.16 gallons (661 oz). Ready-made columns are in the free beer inventory sheet (Excel and CSV), and the weighing method is in keg inventory.

Draft yield: comparing usage with sales

Ounces used = ounces on hand at the last count + ounces delivered − ounces on hand now. Ounces sold = pints and glasses rung through the POS × their size. Yield % = ounces sold ÷ ounces used × 100.

Worked example: last week the house lager went from 1.4 half barrels to 0.6, with 2 delivered: 2.8 kegs used = 5,555 oz. The POS shows 312 pints (16 oz) = 4,992 oz. Yield = 4,992 ÷ 5,555 = 90%. About 560 oz, or 35 pints, went to foam, line cleaning, spills or unrung pours.

Beer cost

Beer cost % = (beginning beer inventory + beer purchases − ending beer inventory) ÷ beer sales × 100. Track draft and packaged separately; they behave differently. See beverage cost for the full method.

How mise helps

Scan the barcode with your phone camera or snap a photo of the label; mise's AI finds the product and categorizes it with name, brand, category, photo and price. Scan cans and bottles; kegs are counted by weight or fraction. Every count is saved with a date and a name, par levels warn you before you run out, and you see shrinkage and food cost for the period without building a spreadsheet.

Try mise in your business

Scan the barcode or snap a photo: mise's AI finds the product and categorizes it. Free trial.

Start free
Download on the App StoreGet it on Google Play
Keep reading Beer inventory sheet: free template for kegs, cans and bottles Bar inventory: how to count liquor, beer and wine Pour cost calculator (free): cost per pour, pour cost % and drink price Keg inventory: how to count and weigh kegs All guides

Frequently asked questions

How much draft beer loss is normal?

Around 5–10% of a keg is common; above 15% points to over-pouring or unrecorded pints.

Is there an inventory template?

Yes: item, unit, par, count and variance. With mise you count by scanning and export to Excel or PDF.

How do I inventory a tapped keg?

Weigh it and compare with the empty and full weights of that keg size: (current − empty) ÷ (full − empty) is the fraction left.

Should line cleaning be recorded?

Yes. Record the beer pulled through when cleaning lines and changing kegs; otherwise it shows up as unexplained loss in your yield.

Can I count with my phone instead of a sheet?

Yes. Scan each barcode with the phone camera, type the quantity, and the count is valued and saved with the date. Items without a barcode are added once by name or photo.

Can I try mise for free?

Yes. You get a free trial, with no card needed.