bar inventory google sheets template

Beverage Stock Management Protocol

Document Control

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

1. Purpose & Scope

This document defines the systemic approach for auditing, tracking, and reconciling liquid assets within [Company Name]. This procedure covers the lifecycle of inventory management from initial count to variance reporting, ensuring financial integrity and stock availability.

2. Prerequisites

• Access to [Name of Google Workspace Domain] account.
• Read/Write permissions for the [Name of Spreadsheet] master file.
• Physical access to all storage areas: [List Areas, e.g., Main Bar, Dry Storage, Walk-in].
• Digital scale calibrated to [Unit of Measurement, e.g., grams/ounces].
• Standardized pour-test kit.

3. Roles & Responsibilities

4. Step-by-Step Procedure

Phase I: Preparation & Synchronization

• Ensure all delivery invoices for the period [__________] are uploaded to the digital ledger.
• Verify the master item list in the spreadsheet matches the physical shelving layout.
• Notify all staff of the "frozen" state for stock movement during the audit window.

Phase II: Physical Audit Execution

• Begin count at [Location Name] moving clockwise through the facility.
• Record "Full Bottle" counts as whole integers.
• Record "Partial Bottle" counts using the [Percentage/Weight] method as defined in the spreadsheet columns.
• Cross-reference physical count against the "Expected Stock" column in the digital file.

Phase III: Data Entry & Reconciliation

• Input raw data into the [Tab Name] tab of the template.
• Validate that the "Variance" cell for each SKU is within the acceptable threshold of [+/- 0.5%].
• Flag any SKU with a variance exceeding [__________]% for manual investigation.
• Finalize the report by exporting the summary to PDF and saving to [File Path/Drive Location].

5. Quality Assurance, Pro-tips, and Pitfalls

• QA: Perform a spot-check on 5% of items by a secondary auditor to ensure data integrity.
• Pro-tip: Use a handheld tablet or mobile device to input data directly into the sheet while walking the floor to eliminate transcription errors.
• Common Pitfall: Failing to account for "comped" drinks or spills. Ensure the [Spillage Log] tab is updated daily to prevent false variance reports.

6. FAQs

Q: How often should the inventory be reconciled? A: We recommend a full audit at the close of every [Week/Month] to align with financial reporting cycles.

Q: What should I do if the variance is consistently negative? A: A negative variance indicates shrinkage. Review the [Spillage Log] and check for unauthorized pours or potential inventory theft in the identified categories.