bar inventory template google sheets free download

Standard Operating Procedure: Beverage Stock Management and Valuation

Document Control

• Document ID: SOP-INV-001
• Version: 1.0.0
• Effective Date: [__________]
• Review Cycle: Annual

1. Purpose & Scope

This procedure establishes the systematic method for tracking, valuing, and auditing liquid assets within [Company Name]. The scope includes all primary storage areas, bar service stations, and cellar locations managed by the [Department Name] team.

2. Prerequisites

• Access to a Google Workspace account.
• Digital copy of the [Company Name] Beverage Inventory Ledger (Template).
• Handheld device or tablet for real-time data entry.
• Standardized unit-of-measure reference sheet (e.g., ounces, liters, bottle counts).

3. Roles & Responsibilities (RACI)

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

4. Procedure

Phase 1: Preparation and Setup

• Create a master copy of the inventory spreadsheet in the [Department Name] shared drive.
• Rename the file using the format: [YYYY-MM-DD]_Inventory_Report.
• Verify that all product categories (Spirits, Wine, Beer, Mixers) are populated in the "Settings" tab.
• Input current unit costs for all SKUs provided by [Supplier Name].

Phase 2: Physical Count Execution

• Begin the count at the same physical location every cycle, moving from [Starting Point] to [Ending Point].
• Record partial bottles using the decimal system (e.g., 0.25, 0.5, 0.75) based on the [Standardized Measuring Tool].
• Flag any damaged, expired, or missing items in the "Notes" column.
• Input counts directly into the [Google Sheets Name] mobile interface.

Phase 3: Reconciliation and Reporting

• Review the "Variance Report" tab to identify discrepancies between expected and actual stock levels.
• Investigate any variance exceeding [Percentage]% of total volume.
• Save a PDF export of the final report to the [File Path/Folder Name].
• Submit the final digital report to [Finance Department Email].

5. Quality Assurance and Best Practices

• Pro-Tip: Perform counts immediately before or after service hours to ensure the highest level of accuracy when the bar is not in motion.
• Common Pitfall: Failing to account for "comped" items or spills. Ensure a secondary log for waste is kept alongside the inventory sheet.
• QA Check: Total inventory value should be cross-referenced against the previous month’s ending balance plus new purchases minus cost of goods sold (COGS).

6. FAQs

Q: How often should I perform a full inventory count? A: For most high-volume operations, a weekly count is standard. High-loss items (e.g., premium spirits) should be spot-checked daily.

Q: What do I do if the spreadsheet shows a negative variance? A: A negative variance indicates missing product. First, verify the count accuracy. If the variance persists, review waste logs and POS sales data to identify potential theft or unrecorded pours.