bar inventory google sheets

Beverage Stock Control and Valuation Protocol

Document Control

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

1. Purpose & Scope

This Standard Operating Procedure (SOP) establishes the methodology for tracking, auditing, and valuing liquid assets at [Company Name]. This protocol applies to all bar staff, inventory managers, and procurement officers responsible for maintaining stock accuracy and minimizing variance across all storage locations.

2. Prerequisites

• Tools: Tablet or laptop with Google Sheets access, barcode scanner (optional), digital scale (for partial bottle weights).
• Access: Authorized Google Workspace credentials for [Department Name] folder.
• Materials: Current master product list, vendor price sheets, and physical stock count sheets.

3. Roles & Responsibilities (RACI)

4. Step-by-Step Procedure

Phase 1: Preparation and Setup

• Ensure the master Google Sheet is duplicated from the [Template Name] template.
• Update the "Price List" tab with the most recent invoice costs from [Primary Supplier].
• Assign physical counting zones: [Zone A, Zone B, Zone C].

Phase 2: Physical Count Execution

• Conduct count during [Off-Peak Hours/Pre-Opening].
• Record full bottles as integers; record partial bottles using the [Decimal/Weight] method.
• Verify that all empty items are marked for "Restock" or "Disposal" in the log.

Phase 3: Data Entry and Reconciliation

• Input quantities into the "Live Count" column of the spreadsheet.
• Review the "Variance Report" tab for values exceeding [Percentage]% threshold.
• Cross-reference discrepancies against [POS Sales Data] for the period.

Phase 4: Finalization and Reporting

• Save the completed sheet as [Date]_Inventory_Report.
• Export the summary as a PDF and email to [Management Email Address].
• Clear "Pending" status in the master tracker.

5. Quality Assurance, Pro-Tips, and Pitfalls

• QA: Perform a "spot check" on 10% of high-value items (e.g., premium spirits) to ensure accuracy.
• Pro-Tip: Use Google Sheets "Conditional Formatting" to highlight cells where the current count is lower than the "Par Level."
• Common Pitfall: Failing to account for "comped" or spilled drinks. Ensure every spill is logged in the [Spillage Log] before starting the count.

6. FAQs

Q: How often should we update the cost per ounce? A: Update cost data every time a new invoice is processed or at least once per month to account for supplier price fluctuations.

Q: What do I do if my variance is consistently negative? A: A negative variance indicates theft, over-pouring, or unrecorded waste. Audit your [Standard Pour Size] and review security footage for the high-loss period.