How to Control Liquor Pilferage and Bar Stock Variance in Indian Bars and Pubs
A practical guide for Indian bars, pubs and breweries: how to calculate liquor variance in millilitres, where stock goes missing, how often to count, and what bar inventory software should do.

To control liquor pilferage and bar stock variance, compare what your POS says you sold with what actually left the bottle, every day, in millilitres, and investigate any gap the same day. Most bars that bring variance down do it with three habits: a daily or shift-wise stock count of open bottles, recipes for every drink linked to billing, and a clear owner for every gap.
This guide explains what bar stock variance is, how to calculate it, where liquor usually disappears in Indian bars, pubs and breweries, and how to set up a simple routine that your bar manager can actually follow.
What is bar stock variance?
Bar stock variance is the difference between the liquor you should have used and the liquor you actually used over a period. "Should have used" comes from your sales: every peg, cocktail and pint sold has a recipe, so the POS can tell you how many millilitres of each spirit, beer or wine should have been poured. "Actually used" comes from your stock count: opening stock plus purchases minus closing stock.
If the two numbers match, your bar is under control. If actual usage is higher than expected usage, liquor has gone somewhere it was not billed. That gap is your variance, and it is money.
How do you calculate liquor variance?
Use the same simple formula for every item, measured in millilitres rather than bottles:
- Actual usage = opening stock + purchases and transfers in − transfers out − closing stock
- Expected usage = quantity sold × recipe quantity (for example, 60 ml for a large peg, 30 ml for a small peg, or the spirit quantity in a cocktail recipe)
- Variance = actual usage − expected usage
- Variance % = variance ÷ expected usage × 100
Here is a worked example for one whisky over one week, using a 750 ml bottle (25 small pegs of 30 ml each):
|
Line |
Quantity (ml) |
How it is worked out |
|---|---|---|
|
Opening stock |
3,750 |
5 sealed bottles counted on Monday |
|
Purchases received |
7,500 |
10 bottles from the supplier, checked against the invoice |
|
Closing stock |
4,200 |
5 sealed bottles plus one open bottle with about 450 ml left |
|
Actual usage |
7,050 |
3,750 + 7,500 − 4,200 |
|
Expected usage |
6,600 |
80 large pegs (4,800 ml) + 60 small pegs (1,800 ml) billed |
|
Variance |
450 |
Roughly 7.5 large pegs not billed |
|
Variance % |
6.8% |
450 ÷ 6,600 × 100 |
Multiply that variance by your selling price per millilitre and you see the real loss. Doing this for your top 20 spirits each week usually shows where the problem is.
What is an acceptable variance for a bar?
There is no single official number. A small gap is normal because of spillage, evaporation in open bottles, and the limits of eyeballing the level in an open bottle. What matters more than any industry benchmark is your own trend: set a target with your bar manager, track it every week, and treat a sudden jump on one brand, one shift or one bartender as a reason to look closer. A consistent, explained variance is better than a low number that nobody can account for.
Where does liquor go missing in Indian bars?
Variance is rarely one big theft. It is usually many small leaks. The common ones are:
- Over-pouring. Free pouring without a peg measure, or "generous" pegs for regulars.
- Unbilled drinks. Drinks served to friends, staff or guests and never punched into the POS.
- Wrong item billed. A premium brand poured but a cheaper brand billed, or a large peg billed as a small one.
- Complimentary drinks with no record. Comps given by managers but not entered as complimentary in the system.
- Breakage and spillage not logged. A broken bottle that never gets written off makes the count look like theft.
- Transfers between bars. In multi-bar venues and breweries with a taproom and a restaurant, stock moves between counters without paperwork.
- Receiving errors. Short deliveries accepted without checking the invoice against what arrived.
- Recipe gaps. Cocktails sold without a recipe in the system, so expected usage is understated.
How often should a bar count its stock?
Count high-value items more often than low-value ones. A practical routine for most Indian pubs and bars looks like this:
|
What to count |
How often |
Who |
|---|---|---|
|
Open bottles of top-selling and premium spirits |
Every shift or every day at close |
Bartender on duty, checked by bar manager |
|
All open bottles |
Daily |
Bar manager |
|
Sealed bottles in the bar and the store |
Weekly |
Store keeper and bar manager together |
|
Draught beer kegs (in-house brewed or bought in) |
Daily keg change log, weekly reconciliation |
Bar manager or brewer |
|
Full stock-take of all liquor |
Monthly, and before any excise or audit filing |
Owner or an independent auditor |
Daily counts sound like work, but a count of 20 open bottles takes a few minutes once the routine is set. The key is to compare the count with sales the same day, while the team still remembers what happened on the shift.
How do you stop liquor pilferage at the bar?
Most of the fixes are process, supported by software. Start with these:
- Put a recipe on every drink. Every peg size, cocktail, mocktail with liquor, bucket deal and happy-hour item should have a recipe in millilitres, so sales turn into expected usage automatically.
- Bill before you pour. Make it a rule that no drink leaves the bar without a KOT or bill. Running tabs should still be punched as drinks are served, not at the end of the night.
- Use measures. Peg measures or calibrated pourers remove the biggest source of honest over-pouring.
- Record every comp, breakage and transfer. Give managers a simple way to log them in the system with a reason. Unlogged comps look exactly like theft in the numbers.
- Check deliveries at receiving. Count and match against the purchase order and invoice before signing.
- Review variance daily, by brand and by shift. A daily report that shows the top gaps is far more useful than a monthly report that shows one big number.
- Rotate counting duties. The person who pours should not be the only person who counts.
Does excise compliance affect how I track bar stock?
Yes. Liquor in India is regulated by each state, and licensed bars generally have to keep stock registers that their state excise department can inspect. The rules, formats and filing frequency differ from state to state, so check with your excise consultant or your state excise department for what applies to your licence. The practical point is simple: if your daily stock records are accurate and come straight from your POS and inventory system, your excise registers are much easier to prepare and defend.
What should bar inventory software do?
Spreadsheets work for one small bar, but they break down when you have many brands, peg sizes, happy hours and more than one counter. When you compare software, check that it can:
- Track open bottles in millilitres, not just whole bottles
- Link every menu item, including cocktails and combo offers, to a recipe
- Pull sales straight from billing, so expected usage needs no manual entry
- Handle happy-hour and time-based pricing without breaking the recipe link
- Show variance by item, by bar counter and by day
- Record transfers, comps and breakage with a reason and a user name
- Manage purchase orders and goods receiving against invoices
- Support excise-ready stock registers for your state
- Work across multiple outlets if you run more than one venue
How Digitory helps
Digitory is a Bengaluru-based restaurant technology platform, founded in 2016, that brings POS and billing, AI inventory and purchasing, and recipe costing into one system. Because billing and inventory are connected, every peg or cocktail sold is deducted from stock through its recipe, so you can see expected versus actual usage without re-typing sales. For breweries, pubs and bars, Digitory supports peg and bottle stock with open-bottle tracking, excise-ready stock registers, happy-hour pricing and running tabs across multiple bars.
If you would rather not run stock control yourself, Managed Inventory puts Digitory's experts in charge of your stock counts and reconciliation. Digitory works with 600+ clients across 10+ cities in India, Thailand and Trinidad & Tobago, including breweries and pubs such as Toit, BygBrewski and Windmills.
See how it works for bars on the breweries and bars page or the inventory page, or book a free demo on a menu like yours.
Frequently asked questions
What is the difference between bar stock variance and pilferage?
Variance is the measured gap between expected and actual liquor usage. Pilferage is one possible cause of that gap. Over-pouring, unlogged comps, breakage and billing mistakes also create variance, so investigate before assuming theft.
How many pegs are there in a 750 ml bottle?
A 750 ml bottle gives 25 small pegs of 30 ml or 12 large pegs of 60 ml with 30 ml left over. In practice you will get slightly less because of spillage and what stays in the bottle.
Should I count stock daily or weekly?
Count open bottles of high-value and fast-moving spirits daily, and do a full count of sealed stock weekly. Daily counts let you catch problems while the shift is still fresh in everyone's memory.
Can software alone stop liquor theft?
No. Software makes the gap visible quickly and shows where it is, by brand, shift and counter. You still need clear rules, measures at the bar and a manager who reviews variance and acts on it.
How do I track draught beer variance in a brewery or taproom?
Treat each keg like a bottle: log every keg change, set a recipe for each pour size, and compare the volume poured according to sales with the volume of kegs emptied. Line cleaning and foam loss should be logged so they are not mistaken for theft.
Does Digitory work with my existing accounting software?
Digitory integrates with Tally for accounting, along with Swiggy, Zomato and District dine-in QR, and Easebuzz for payments. Book a demo to check your setup.



