bar inventory sheet template

Beverage Stock Management and Valuation Protocol

Document Control

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

1. Purpose & Scope

This procedure establishes the systemic method for auditing, recording, and reconciling liquid assets within [Company Name]. It applies to all bar staff, inventory managers, and procurement officers responsible for maintaining stock accuracy and minimizing variance in the [Location Name] facility.

2. Prerequisites

• Access to [Inventory Management Software/Spreadsheet Platform]
• Digital scale (calibrated to 0.1oz/1g precision)
• Printed or digital stock count log
• Access credentials for [POS System Name]
• Uniformed staff in [Department Name]

3. Roles & Responsibilities (RACI)

R=Responsible, A=Accountable, C=Consulted, I=Informed

4. Procedure

Phase 1: Preparation and Calibration

• Verify the scale is calibrated to [Standard Weight] before starting.
• Ensure all partial bottles are organized by category (e.g., Spirits, Wine, Beer).
• Confirm all deliveries from [Date] have been fully processed into the system.

Phase 2: Execution of Physical Count

• Record the full bottle count for each SKU in [Location Name].
• Utilize the "tenths" method for partial bottles: [ ] 0.1 [ ] 0.2 [ ] 0.3 [ ] 0.4 [ ] 0.5 [ ] 0.6 [ ] 0.7 [ ] 0.8 [ ] 0.9.
• Document any damaged, spilled, or comped inventory on the [Incident Log Form].

Phase 3: Data Input and Variance Reconciliation

• Input counts into the master template located at [File Path/URL].
• Compare physical count against [POS System Name] theoretical usage.
• Flag any variance exceeding [Percentage]% for immediate review by [Manager Title].

5. Quality Assurance and Pro-Tips

• QA: Perform a "spot check" on 10% of high-value items (e.g., premium tequilas, scotches) after the primary count is completed.
• Pro-Tip: Always count in the same physical sequence (e.g., left-to-right, top-to-bottom) to prevent skipping items.
• Common Pitfall: Failing to account for "open bottles" at multiple stations (e.g., speed rails vs. back bar). Always consolidate or count all locations simultaneously.

6. FAQs

Q: How often should we perform a full count? A: A full physical count should be conducted at the close of every [Week/Month] to ensure accurate financial reporting.

Q: What do I do if my variance is consistently high? A: High variance indicates either poor tracking of spills/comps or potential theft. Conduct a root-cause analysis by reviewing POS logs against the [Inventory Log] for the preceding 7 days.

Q: Should I count kegs by weight or volume? A: Weight is the industry standard for precision. Use a digital keg scale to determine the remaining liquid percentage based on the empty keg weight provided by [Supplier Name].