bar inventory sheet pdf

Standardized Beverage Stock Reconciliation Protocol

Document Control

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

1. Purpose & Scope

This procedure establishes a standardized methodology for auditing liquid assets within [Company Name]. The scope covers all storage areas, including main bars, service stations, and off-site cold storage. This protocol ensures inventory accuracy, loss mitigation, and data integrity for financial reporting.

2. Prerequisites

• Tools: Digital tablet or printed audit log, barcode scanner (optional), precise weighing scale (for partials).
• Materials: Current master product list, previous period closing report.
• Access: Authorized credentials for the [Inventory Management System Name] and physical access keys for all storage lockers.

3. Roles & Responsibilities (RACI)

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

4. Step-by-Step Procedure

Phase 1: Preparation

• Verify that all deliveries are logged and processed in the system.
• Ensure all bottles are organized by category (e.g., Spirits, Wine, Beer, Mixers).
• Print the [__________] audit template from the central registry.
• Set the inventory cut-off time to [__________] AM/PM.

Phase 2: Data Collection

• Conduct a physical count of full cases and individual bottles.
• Utilize the "Tenths" method for partial bottles (e.g., 0.1 to 1.0).
• Record findings on the audit sheet for [Storage Location Name].
• Verify that empty bottles are accounted for in the breakage/spillage log.

Phase 3: Reconciliation

• Input physical counts into the [Inventory Management System Name].
• Compare physical stock against theoretical usage reports.
• Investigate any variance exceeding [__________]%.
• Generate the final reconciliation PDF for archival.

5. Quality Assurance, Pro-Tips, and Pitfalls

• QA: Perform a "blind count" on high-value items (e.g., premium spirits) to ensure accuracy.
• Pro-Tip: Standardize the order of counting to match the physical layout of the shelves; this prevents skipping items.
• Pitfall: Failing to account for "comped" drinks or staff samples is the leading cause of unexplained shrinkage. Always maintain a secondary log for non-sale inventory outflows.

6. FAQs

Q: How should I account for partially filled kegs? A: Use a digital scale to measure the weight of the keg and subtract the tare weight provided by the manufacturer. Divide the remaining liquid weight by the standard pour size.

Q: What is the acceptable variance threshold? A: Industry standards typically allow for a 1–2% variance. Anything higher requires a secondary audit and a review of POS transaction logs.

Q: How long should I retain these records? A: Retain all signed audit documents for a minimum of [__________] years for tax and audit compliance purposes.