Inventory control for bars

For a bar, inventory control is not an end-of-month chore: it is a daily routine that decides whether the business makes or loses money. Beers sold by the unit, 750 ml bottles of spirits that last for weeks, juices and fruit that spoil within days, and mixers that run out all at once during peak hours all share the same shelf and the same cooler. Each of those products runs out at a different pace, is easy to waste, and can disappear without a trace if nobody writes it down. That is why a bar needs its own inventory controls, different from those of a retail store or a regular restaurant. This article explains why bar inventory gets out of control, which records and counts to start using today, and how to calculate the real cost of sales to spot money leaks before they eat the profit.

Why bar inventory gets out of control

A bar brings together conditions that make it very hard to keep stock up to date. These are the most common challenges:

Very different kinds of products: a 750 ml bottle of whiskey may last three weeks, but beer runs out by the unit every night and lime juice spoils in a few days. No single method fits them all.
Fast night-time consumption: during peak hours dozens of drinks are poured every minute and nobody has time to write things down; if the point of sale does not deduct stock automatically, the information is lost.
Half-open bottles: an opened bottle is not a full unit, and if it is counted as full, the physical inventory will never match the theoretical one.
Consumption that never reaches the register: the complimentary drink, the one poured for a bartender's friend, the taste test of a new spirit and staff consumption are all inventory outflows that generate no sale and, without a record, become invisible losses.
Constant shrinkage: damaged or returned beers, spills while pouring, bottles that fall, ingredients that expire. If they are not reported, every shortage looks like theft and every theft looks like shrinkage.

Controlling a bar does not mean eliminating all of these problems; it means making sure each one is recorded and measurable. For that you need five basic controls that work as a chain: purchases, outflows, physical count, shrinkage and standard recipes.

Record purchases: everything that arrives goes into inventory

The cycle starts when the goods reach the bar. Every purchase, whether bottles, cases of beer, juices, ice or fruit, must be recorded as an inbound movement on the day it is received, stating product, quantity, unit cost and total cost according to the invoice. When receiving, check against the invoice: many beer cases arrive short and some bottles arrive damaged, and if that is not caught on the spot, the bar ends up paying for product it will never sell. One important detail: if the purchase is not recorded as an inbound movement, the bottle sold later comes out of nowhere and the month's cost will be wrong. Keeping purchase records up to date is the only way to make the month-end inventory reliable.

Record outflows: sales, internal consumption and complimentary drinks

Inventory outflows in a bar are of three kinds, and each one is recorded differently:

Sales: if your point of sale deducts stock per product, every beer or drink sold subtracts the unit automatically when the sale is confirmed. This is the cleanest outflow and requires the least effort.
Internal consumption: when staff consume product or spirits are used for tasting, it is recorded as internal consumption with the quantity and the person responsible. It is not a sale, but it is still an outflow and must be deducted from inventory.
Complimentary drinks: the drink the house offers is recorded as a comp or promotional consumption, approved by the manager. If comps are not recorded, each one becomes an unexplained shortage at the end of the day.

The golden rule is simple: everything that leaves the shelf or the cooler must be explainable by a record. If the point of sale says 38 beers were sold today, the physical inventory must show exactly 38 units fewer than yesterday; any difference that does not match a recorded internal consumption or shrinkage is a leak alert.

The daily physical count: at opening and at closing

The physical count is the control that validates all the others. In a bar it is worth counting twice a day: at opening, to know how much stock the shift starts with, and at closing, to compare what should be left according to the records with what is actually there. Counting spirit bottles at the start and end of a shift takes a few minutes if you use a fixed form and walk the shelf in the same order every time. For opened bottles, use fractions: half a bottle counts as 0.5 and a bottle that is half empty is noted as such, because counting it as full distorts the whole calculation. In bars with high turnover, the daily count can be limited to the critical items, such as beer, best-selling spirits and wine, and once a week a full count is done, including cocktail ingredients and perishables. The formula that validates the day is this: expected inventory = opening inventory + purchases − recorded outflows. If the actual count is lower than expected, the difference must be investigated the same day, while there are still witnesses and fresh memory of the shift, not at the end of the month. For example: if you open with 120 beers, sell 38 and there were no other outflows, you should count 82 at closing. If you count 79, 3 are missing and you need to know why before closing the register.

Shrinkage control in the bar

Shrinkage is any product lost without generating a sale: beer that is damaged or returned, liquor spilled while preparing a drink, a bottle that breaks, fruit that over-ripens, juice that expires. In a bar shrinkage will never be zero, but it can be small and, above all, known. To control it, every event is recorded on the spot: which product, how much, when it happened, what the cause was and who reported or caused it. With that record, a broken bottle is logged as handling shrinkage and a case of beer damaged by the supplier is logged as receiving shrinkage, and both are kept apart from a shortage that nobody can explain. Without this control, all discrepancies blend together and the bar cannot tell whether it is losing money to carelessness, expired products or theft.

The standard recipe: how many drinks a 750 ml bottle yields

To know whether the bar is making money on every drink, define the standard recipe for each cocktail: how many millilitres of each spirit, how much juice or mixer, what garnish and which glass. With the standard recipe you can calculate how many cocktails each bottle yields and what each one costs to produce. The classic example is a 750 ml bottle of gin for a cocktail that uses 45 ml of gin per drink:

Yield: 750 ÷ 45 = 16.67. Each bottle yields 16 full cocktails and leaves 30 ml (0.67 × 45 ≈ 30), enough for an extra half drink or to be kept for the next bottle.
Cost per cocktail: if the bottle costs 110,000, the cost per millilitre is 110,000 ÷ 750 = 146.67 and the 45 ml cost 146.67 × 45 = 6,600. Add the other cocktail ingredients, such as juice, syrup or fruit, about 1,200 more, for a total cost close to 7,800 per unit.

The standard recipe also protects the margin from over-pouring: if the bartender serves 60 ml instead of 45, the bottle yields 750 ÷ 60 = 12.5 drinks instead of almost 17, and more than 4 drinks per bottle are lost without anyone noticing. That is why the jigger and the written recipe matter as much as the inventory itself.

Costs, prices and margins per drink

With the unit cost defined, review the margin of every drink. Gross margin is calculated as (selling price − cost) ÷ selling price: a beer that costs 2,800 and sells for 7,000 has a margin of (7,000 − 2,800) ÷ 7,000 = 60%. A typical margin table for a bar looks like this:

Drink	Serving unit	Cost	Selling price	Gross margin
Domestic beer	330 ml bottle	2,800	7,000	60%
Craft beer	330 ml bottle	5,500	12,000	54%
Rum	45 ml shot	2,700	9,000	70%
Gin	Cocktail with 45 ml	6,600	18,000	63%
Whiskey	45 ml shot	7,200	20,000	64%
Wine	150 ml glass	6,000	15,000	60%

For alcoholic drinks a healthy gross margin is usually between 60% and 75%, because the production cost is low and the price is set by the local market. When the real margin of a drink is far below what is expected, there is almost always a yield problem: too much is being poured, product is being lost, or the price does not cover the real cost.

Bar cost of sales: how to calculate it and detect leaks

The most important indicator in the bar is the cost of sales, calculated in two ways that are then compared:

Theoretical cost: it comes from the point of sale: units sold of each product times its standard unit cost. It is what the bar should have spent if everything went according to the recipe and the price.
Actual cost: opening inventory of the period + purchases for the period − closing inventory. It is what the bar really spent, including shrinkage, theft and mistakes.

Monthly example: opening inventory of 6,800,000, purchases of 5,400,000 and closing inventory of 5,900,000. The actual cost is 6,800,000 + 5,400,000 − 5,900,000 = 6,300,000. If the month's sales were 21,000,000, the actual cost represents 6,300,000 ÷ 21,000,000 = 30% of sales, a normal level for a bar with a good product mix. Now the comparison: if the theoretical cost according to the recipes was 5,400,000, there is a difference of 900,000 that is not explained by any recorded shrinkage. That difference, 4.3% of sales, is the leak: theft, unrecorded consumption, over-pouring or shrinkage that was never reported. A bar that detects a leak of that size every month is losing more than 10 million a year without seeing it in any invoice. The path to closing that leak is the same one described above: record every purchase and outflow, count at opening and closing, report all shrinkage and define standard recipes. So that this control does not depend on loose spreadsheets or the manager's memory, rely on an inventory system such as Kardex Tauro, which keeps the card of each product and compares the physical count with sales to show the leak in numbers.

Labels:

#bar #inventory #drinks