Beer inventory sheet: free template for kegs, cans and bottles
By mise · Updated October 7, 2026
Download the Excel file (.xlsx) Kegs CSV Cans & bottles CSV
Free, no sign-up. Two tabs: kegs and cans & bottles.
Quick answer: count beer in two parts. Kegs: full kegs plus the open keg as a share of its size, in ounces — a 1/2 barrel holds 15.5 gallons (1,984 oz), a 1/4 barrel 7.75 gallons (992 oz), a 1/6 barrel about 5.16 gallons (661 oz). Cans and bottles: full cases plus loose units. Value each at cost, then compare ounces used with ounces sold on the POS. mise counts cans and bottles by scanning: 7 days free.
Beer is the easiest thing in the bar to count and the easiest to lose: foam, line cleaning, long pours and free pints all disappear from the keg without a ring on the register. A sheet that counts in ounces makes that loss visible.
Keg sizes in ounces
| Keg | Gallons | Ounces | 16 oz pours (before foam and waste) |
|---|---|---|---|
| 1/2 barrel | 15.5 | 1,984 | 124 |
| 1/4 barrel | 7.75 | 992 | 62 |
| 1/6 barrel | about 5.16 | about 661 | about 41 |
A US beer barrel is 31 gallons, so the "half barrel" most draft lines run on is 15.5 gallons. Real yield is lower than the pour count: foam, the first pour after a keg change and line cleaning all take a share.
What is in the template
- Kegs tab: location, beer, keg size, ounces per keg, full kegs, open keg (% left), total ounces, cost per keg, cost per ounce, value, par and kegs to order.
- Cans & bottles tab: pack, units per case, full cases, loose units, total units, cost per case, cost per unit, value, par and cases to order (rounded up).
- Totals at the bottom of each tab, and a "How to use" tab.
How much is left in the open keg?
Weighing beats guessing. Weigh one empty keg and one full keg of each size once, write the numbers down, and from then on every open keg is a simple proportion:
From the count to beer cost
- Usage = last count + deliveries − this count (in ounces for draft, in units for packaged).
- Compare draft ounces used with ounces sold on the POS. The gap is foam, waste, over-pouring and unrung beer.
- Beer cost % = usage at cost ÷ beer sales × 100. See beverage cost and keg inventory.
Skip the typing
In mise you scan cans and bottles with your phone and the product comes back named and sized; kegs are counted as a fraction or weighed with a Bluetooth scale. The rest of the bar goes in the same count — see the bar inventory spreadsheet if you prefer to start on paper.
Scan the barcode or snap a photo: mise's AI finds the product and categorizes it, and the count values itself. 7 days free, no card.
Start free
Frequently asked questions
How many ounces are in a half barrel keg?
1,984 ounces: a half barrel is 15.5 US gallons and a gallon is 128 ounces.
How many 16 oz beers are in a keg?
A 1/2 barrel holds 124 sixteen-ounce pours, a 1/4 barrel 62 and a 1/6 barrel about 41, before foam and waste.
How do I measure how much beer is left in a keg?
Weigh it. Subtract the empty keg weight and divide by the weight of the beer in a full keg; that share times the keg size in ounces is what is left.
How do I count cans and bottles?
Full cases times units per case, plus the loose units. The template does the math and rounds orders up to whole cases.
How much does mise cost?
7 days free with everything included and no card.