Liquor inventory sheets: 2026 guide to counting by weight and catching bar shrinkage

Step 1: the master list of items and its unit of measure

A bar inventory sheet starts with a master list of every item the bar can pour, with its bottle size, its purchase cost and the unit it is measured in, which must be the SAME unit the cocktail recipe and the ticket use. A sheet that only lists what someone remembers leaves out precisely the bottles that move without control, the ones at the back of the shelf or the sample the supplier dropped off. Order it the way the bar is laid out, left to right, so whoever counts does not jump from one end to the other. New categories belong there too: liquor-based ready-to-drink cocktails grew +16.4% year over year in 2025, according to the Distilled Spirits Council, and they rarely show up on the old sheet. The deliverable is a file with every item, its code and its unit, and it checks out when nobody finds a bottle on the shelf that is missing from it.

Step 2: count by weight, with a scale and a tare per bottle

Counting by weight ends the argument between shifts, because a kitchen scale and a tare recorded per item turn the level of an open bottle into a number anyone can reproduce. Weigh one full and one empty bottle of each item a single time, record both figures on the master list, and from then on every count subtracts the tare and divides by the weight of the liquid. For example, if a full vodka weighs 1,200 g, an empty one 450 g and today it reads 825 g, it has 375 g of 750 left, exactly half a bottle. Vodka calls for that care because it is the largest category on the shelf, with U.S. sales of 7 billion USD in 2025 (Distilled Spirits Council, 2025). The deliverable is the weight column for every open bottle, and you verify it by asking a second person to reweigh three random bottles: the numbers have to match.

Step 3: calculate actual usage for the period

Actual usage for each item comes from simple arithmetic, opening inventory plus purchases for the period minus closing inventory, all in the same unit. What the Masterestaurant method demands is that one week's closing inventory becomes, untouched, the next week's opening, and that purchases come from INVOICES received rather than orders, because an order is not a bottle on the shelf. Diego F. Parra insists on a detail almost everyone skips: transfers between bar and kitchen, like the rum that goes into a dessert, are recorded as an outflow on their own line, or they reappear later disguised as a shortage. For example, if there were 4 bottles of gin on Monday, 6 came in and 3.5 remain on Sunday, the bar used 6.5 bottles. The deliverable is that figure per item, which you can check against the filed invoices.

Step 4: match usage against what the point of sale recorded

The sheet starts to control the moment actual usage is compared with theoretical usage, which is what the point of sale says was sold multiplied by each drink's recipe. For that, every menu item needs its recipe loaded in milliliters per bottle item, and a margarita with tequila, orange liqueur and juice deducts three separate lines, not one. Tequila deserves its own watch because it ranks among the highest-value categories: the Distilled Spirits Council puts U.S. sales of tequila and mezcal together at 6.4 billion USD in 2025. The difference between actual and theoretical, item by item, is the variance. For example, if the POS accounts for 5 bottles of tequila and the subtraction came to 6, one WHOLE bottle left without being charged. The deliverable is a variance table per item, complete when every line shows both figures.

Step 5: investigate the variance before blaming anyone

A high variance points to where you should look, and the investigation starts with recording errors BEFORE it gets to people. First check the POS buttons (the comp drink rung up as water, the recipe loaded with a smaller pour than the bar actually serves), then the unrecorded invoices and, last of all, the pour. Sculpture Hospitality puts monthly inventory loss in bars, from overpouring, theft or spoilage, at 10-20%, and a good part of that leak can be explained without accusing anyone. Think of the owner who fires the bartender with the biggest shortage without checking the recipes: the wrongly loaded recipe stays the same, the variance comes back the next month and the whole bar learns the sheet is a tool for blame, so the team starts adjusting the count. The deliverable is a note for every item outside the tolerance management sets, with its likely cause and the action taken.

Common mistakes when keeping the bar inventory sheet

The most repeated mistake is counting at a different time every week, because a sheet taken on Saturday at midnight and another on Monday at noon do not compare equivalent periods. Next comes eyeballing bottles in tenths, which for years I accepted because it was fast and now consider my own error, since two people see different levels in the same bottle. Another stumble is letting only the person who pours do the count, when the sound practice is to have someone else count or, at the very least, stand alongside. And there is the belief that counting is expensive. With the median bartender wage at 16.51 USD per hour (BLS, May 2025), a two-hour weekly count costs, for example, about 33 USD in labor, less than one premium bottle lost every week without a trace. That is why the bar that spends the least time counting ends up paying the most for skipping it.

How to know the inventory sheet is working?

The sheet is right when anyone on the team can take the count without the owner present and the result matches another count taken at the same hour.

The closing review has five points: every item on the shelf appears on the master list with its tare, last week's closing inventory is this week's opening, purchases come from invoices, every POS item has its recipe in milliliters, and the variance table explains every line outside tolerance. The U.S. sold 318.1 million 9-liter cases of distilled spirits in 2025 (Distilled Spirits Council, 2025), and of that volume the only share you can trace is the one that passes through your bar. If total variance drops against the previous month when you close the books, the sheet is doing its job. If it does not, go back first to the POS recipes, which is where the LEAK is almost always hiding.

Mistake vs. right way: where the liquor goes that the sheet never sees

The first mistake is not counting badly, it is counting in the wrong unit. For years I accepted tenths of a bottle because it was fast, and I was wrong: two people holding the same bottle of rum to the light write down different levels, and that gap across forty open bottles is bigger than the leak you are trying to find. Weighing fixes it with a kitchen scale and a recorded tare per item. For example, if a full bottle weighs 1,250 g, an empty one 500 g and today it reads 875 g, exactly half the liquid is left, with no argument between shifts. The second difference is scope. An improvised sheet lists the bottles someone remembers; a method sheet starts from a master list updated every time a new product arrives, and more arrive than you think. Ready-to-drink spirits cocktails grew 16.4% year over year in the US, according to the Distilled Spirits Council (2025), and they are counted by sealed unit in their own section.

Mistake vs. right way: where the liquor goes that the sheet never sees — in practice

High-value categories need the same attention: tequila and mezcal, which the council puts at $6.4 billion in sales, deserve a weekly count even if the rest of the bar is counted monthly. Picture what happens if the sheet stays as it is for six more months. The bartender who pours long gets no correction, so the long pour becomes the house standard; the new hire learns it from whoever trains them; beverage cost climbs a couple of points nobody blames on pouring because the sheet does not show it, and the owner ends up raising menu prices, which means charging guests for your own lack of control. All of it starts with one missing column, theoretical usage. But there is a real tension managers are right to raise: counting often costs labor hours, and counting rarely costs liquor. You solve it with priority, not a lukewarm middle. At Masterestaurant, Diego F. Parra recommends counting the few items that hold most of the bar's value every week and saving the full count for month-end, so counting hours go where the money is.