Beer Inventory Sheet: Kegs, Cans and Bottles
By mise · Updated September 29, 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 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. 7-day free trial, then US$33 a month (£26 in the UK).
Start free
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 much does mise cost?
A 7-day free trial, then US$33 a month per location (£26 in the UK).