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
| Category | What it includes | How often |
|---|---|---|
| Kegs | Full and partial (by weight) | Weekly |
| Cans & bottles | Cases + loose | Weekly |
| Cooler | Backups and seasonals | Weekly |
Step by step
- Weigh partial kegs.
- Count cases, then loose units.
- Compare ounces sold with ounces used.
- Log line cleaning and spills.
Mistakes that throw the count off
- Partial kegs guessed.
- Line cleaning losses not logged.
- Comped pints not rung in.
How to count beer, line by line
| Format | Count as | Tip |
|---|---|---|
| Kegs, full | Number of kegs per size | Count the walk-in and the keg cooler separately |
| Kegs, tapped | Fraction left (by weight) | Weigh an empty and a full keg of each size once |
| Cans and bottles | Full cases + loose units | Count the back stock before the bar fridge |
| Growlers / crowlers | Units | Count 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.
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.
Scan the barcode or snap a photo: mise's AI finds the product and categorizes it. Free trial.
Start freeFrequently 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.
