Bar liquor stock daily check — pour cost, BCM tracking, free Excel template

About this piece. A bar in India runs on excise-licensed inventory that is the single highest-margin and single most-leakable line item in the P&L. A 30-mL pour over-poured by 2 mL doesn't sound like much — until you do the daily math across 600 pours and realise it's a ₹2,800 leak per night. This piece gives you the daily check that catches that leak, the BCM (bottle closing minus opening) format, the pour-cost formula, and a free Excel template.

Why a bar needs a daily check, not a weekly one

A restaurant kitchen can survive a weekly stock check because most ingredients have natural usage patterns and visible portions. A bar can't, for three reasons:

1. Excise compliance. State excise authorities (especially Maharashtra, Karnataka, Delhi) can demand stock reconciliation against permit-purchase records on any inspection day. "I'll check stock on Sunday" is not a defence.
2. Pour variance. A free-pour bartender's 30-mL shot has a real range of 26–34 mL. Across 400 pours/night that's 16 standard drinks of variance — ₹4,000+ on a typical Indian bar menu.
3. Theft surface. Bottles are portable, recognisable, and have street value. A daily count is the deterrent itself; bartenders who know counts happen at close don't even attempt.

Public benchmark: industry surveys (NRAI bar segment 2024 + global Sirvo bar pour-cost data) put pour cost at well-run bars at 18–22% of bar revenue. Indian bars without daily checks routinely run 28–34%. The gap — 10 points of revenue — is often pure leakage, not buying inefficiency.

The pour cost formula

Pour cost % = Liquor cost of sales (₹) / Liquor revenue (₹) × 100

Liquor cost of sales = Opening inventory + Purchases − Closing inventory
                       (all valued at cost, per SKU)

A target pour cost depends on bar type:

If your bar is running 30%+, the daily check below will show you which SKUs are leaking within two weeks.

The BCM daily check (Bottle Closing Minus Opening)

BCM is a simple tenths-of-a-bottle method that takes 12 minutes at close. Per SKU per shelf:

BCM (today) = Opening level (tenths) + Bottles received − Closing level (tenths)
            = Bottles consumed (tenths)

Expected sales per BCM unit = (BCM × 750mL) / standard pour size (30mL)
                            = pours dispensed
                            
Actual pours sold (POS)   = sum of all drinks containing this SKU

Variance = Expected pours − Actual pours sold

Variance > ±5% on any SKU on a given night = investigate. Three consecutive days on the same SKU = systemic.

What goes in the daily check sheet

A bar daily check sheet has 8 columns per SKU:

A 9th column — Variance (#7 − #8) — is where the eye goes. Coloured red if >±5%.

Premium SKUs (single malts, premium gins, imported) get a 9th physical safeguard: a tally mark on the back-bar register every pour, regardless of POS entry. This is overkill for IMFL whisky; necessary for ₹14,000-bottle scotches.

The closing ritual — 11:30pm to 12:00am (30 minutes)

The 2-person rule for premium SKUs is the single biggest theft deterrent. Bartender and manager both initial the closing levels for any bottle ₹3,000+. Disagreements get resolved on the spot by re-counting. This single rule, in two of the operator networks I've sat in on, took bar pour cost from 32% to 23% inside 8 weeks.

Four leakage points specific to bars

1. Free pour drift

A bartender trained to pour 30mL on a 4-count free pour will, after 4 hours of service, reliably drift to 33–35mL. The fix isn't "tell them to pour 30" — it's a jigger. Mandate jiggers for everything except draught beer. Yes, it's slower. Yes, it's cheaper.

2. The "topped-up bottle" trick

Bartender pours 60mL out of a premium bottle to a friend off-POS, then tops the bottle with a cheaper similar-looking spirit. BCM count shows the bottle still at 90% — no variance flagged. Counter-measure: spot-check 3 random premium bottles weekly with a hydrometer. The first time the manager does this in front of the bar team is itself the deterrent.

3. The "lost ticket" comp

Drink made, customer drinks it, ticket gets "voided" or "lost". POS shows no sale; BCM shows consumption. Variance flagged. Counter-measure: every void/comp on the POS requires manager approval with a one-line reason. Daily comp report reviewed at close; >2% of revenue in comps is a yellow flag, >5% is red.

4. Empties not disposed

Empty bottles are evidence. Bartenders who pocket cash on off-POS pours need to make the empty disappear. Counter-measure: empties stored in a locked crate, manager unlocks weekly when excise inspector or scrap dealer comes. Empties count must reconcile to BCM consumption.

The owner's weekly bar pulse

Daily check is operational. Weekly pulse is strategic. Every Monday morning, owner reviews:

• Pour cost % for the week — vs target
• Top 5 SKUs by variance — investigate any > ±5%
• Comp/void % of revenue — vs threshold
• High-margin cocktail mix % — should be 30%+ of bar covers
• Beer : spirits revenue ratio — for restobar typically 35:65

Five numbers. Five minutes. The pulse keeps the bar honest at the strategic layer.

Excel template — what's in it

The free template has:

• SKU master tab — bottle size, cost, standard pour, GL category
• Daily BCM tab — auto-calculated columns, variance flags, manager-sign field
• Weekly roll-up — pour cost %, top variance SKUs, comp %
• POS reconciliation helper — paste POS export, auto-match to BCM expected

Email gate not required.

Where this fits with the rest of bar ops

• Daily BCM check — leakage detection at SKU level (this piece)
• Weekly pour cost review — strategic margin tracking
• Monthly excise reconciliation — permit-purchase vs sales declared
• Quarterly menu engineering — drop low-margin/low-volume drinks

Stack the four and your bar runs at industry-best pour cost. Restaurant Daily automates the BCM-to-POS reconciliation; the discipline below works without software too.

Related on Restaurant Daily

• Petty cash voucher format India — free Excel template
• Imprest cash float for Indian restaurants — formula + ₹2,000/month mistake
• Cafe daily ops checklist (India) — 30-seater opening/mid-day/closing