Buyer's Guides

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.

Digitory Bar Inventory Control Guide

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:

  1. Actual usage = opening stock + purchases and transfers in − transfers out − closing stock
  2. 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)
  3. Variance = actual usage − expected usage
  4. 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:

  1. 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.
  2. 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.
  3. Use measures. Peg measures or calibrated pourers remove the biggest source of honest over-pouring.
  4. 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.
  5. Check deliveries at receiving. Count and match against the purchase order and invoice before signing.
  6. 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.
  7. 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.

Digitory team

Let’s look at your restaurant together

A 30-minute walkthrough of the modules that matter to your venue, with time for your questions. No slides.

  • A call within one working day
  • A demo on a menu like yours
  • A clear plan: modules, hardware, go-live date
DIGO, the Digitory mascot, waving

Prefer to talk now?
WhatsApp us · [email protected]

Get a call back in one working day

Free 30-minute walkthrough. We only use your details to arrange it.

Request received. We’ve got your request and will call you within one working day.WhatsApp usEmail sales