bar inventory list template

Operational Standard for Beverage Stock Auditing

Document ID: SOP-INV-[]
Version: 1.0
Effective Date: []
Review Cycle: Quarterly

1. Purpose & Scope

This procedure establishes the systematic methodology for tracking, auditing, and reconciling liquid assets at [Company Name]. This ensures accurate cost-of-goods-sold (COGS) reporting, prevents shrinkage, and maintains optimal par levels. This scope covers all front-of-house and back-of-house storage locations.

2. Prerequisites

• Tools: Digital tablet or printed audit sheet, barcode scanner (if applicable), calibrated scale (for partials).
• Access: Authorized access to the [POS System Name] and inventory management software.
• Materials: Current master product list, previous audit report, and [__________] (additional tool).

3. Roles & Responsibilities (RACI)

4. Step-by-Step Procedure

Phase 1: Preparation and Zoning

• Clear all workspace surfaces for accurate counting.
• Organize bottles by category (Spirits, Wine, Beer, Mixers) to match the audit sheet layout.
• Ensure all partial bottles are [__________] (e.g., weighed or visually measured by tenths).

Phase 2: Execution of Count

• Start count at [__________] (time) to ensure no active service interference.
• Record full cases first, followed by individual bottles.
• Utilize the "tenth-bottle" method for open containers: [__________].
• Document any damaged, spilled, or comped items in the [__________] log.

Phase 3: Data Entry and Reconciliation

• Input counts into [System/Spreadsheet Name].
• Compare current stock against [POS System Name] depletion data.
• Investigate variances exceeding [__________]% threshold.
• Finalize the report and submit to [Department Name] by [__________] (time/day).

5. Quality Assurance, Pro-Tips, and Pitfalls

• Quality Assurance: Perform a "blind count" once per month where the manager verifies a random 10% sample of the clerk’s data.
• Pro-Tip: Always count in the exact same physical order (e.g., left-to-right, top-to-bottom) to prevent missed items.
• Common Pitfall: Failing to account for "house" or "comp" pours leads to artificial shrinkage numbers. Ensure every non-sale pour is logged in the [__________] ledger.

6. FAQs

Q: How often should we conduct a full audit?
A: A full physical audit should be conducted [__________] (e.g., weekly or bi-weekly) to maintain financial accuracy.

Q: What is the best way to measure partial bottles?
A: Use a digital scale calibrated to the weight of the empty glass bottle, or use a graduated decanter to measure the remaining volume in milliliters.

Q: How do we handle new product arrivals during an active count?
A: Quarantine all new deliveries in the receiving area until the audit is complete to avoid double-counting or omissions.