Count beverages, calculate inventory value, monitor variance, and prepare reorder quantities.
| # | Item | Brand | Category | Size | Location | SKU | Unit | Opening | Purchased | Expected | Current | Waste | Unit Cost | Selling Price | Value | Usage | Variance | Par | Reorder | Supplier | Supplier Code | Supplier Contact | Status | Notes | Action |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Totals | $0.00 | 0.00 | 0.00 | 0.00 | |||||||||||||||||||||
Tip: partial bottles may be entered as decimals, such as 0.25, 0.5, or 0.75.
| Category | Quantity | Value | Reorder |
|---|
A bar inventory count sheet gives managers one structured place to record beverages, mixers, supplies, costs, and reorder needs. Accurate counts reduce guesswork when purchasing and help reveal slow-moving stock. They also make it easier to compare expected inventory against physical inventory after sales, transfers, waste, or breakage. A consistent counting routine is especially useful for busy venues where several bartenders handle the same products. Using the same categories, units, bottle sizes, and storage locations each period improves consistency. Partial bottles can be entered as decimals, allowing a closer estimate of real stock. The generator above calculates current value, usage, variance, and recommended reorder amounts automatically. These figures help managers identify unusual losses before they become expensive patterns.
Begin with the same storage area each time and count products in a fixed order. Enter opening inventory and purchases when period usage is required. Record physical quantities carefully, including partial bottles, opened cases, and keg estimates. Add waste or breakage separately so legitimate losses are not confused with unexplained variance. Set a practical par level for each item based on sales volume, delivery frequency, and available storage. Items below par can then be reordered immediately. Keep supplier names and item codes beside each product to simplify purchasing. After the count, review high-value variances and unusually fast usage. A supervisor should verify important discrepancies before adjustments are made.
Inventory records become more valuable when they are compared over several periods. Managers can spot seasonal demand, over-ordering, poor stock rotation, or repeated shortages. Category totals show how much money is tied up in beer, wine, spirits, mixers, and other supplies. A high inventory value is not always positive because excess stock can reduce cash flow. Reorder quantities should therefore reflect realistic demand rather than fixed habits. Exporting the count to CSV allows deeper analysis in spreadsheet software, while the PDF option creates a convenient printable record. Saving completed counts also supports audits, purchasing reviews, and staff accountability. Regular inventory checks ultimately help protect margins and keep popular products available.
| Product | Category | Typical Unit | Suggested Count Method | Common Control |
|---|---|---|---|---|
| Draft Beer | Beer | Keg | Weight or percentage | Compare pours with sales |
| Wine | Wine | Bottle | Whole plus partial bottles | Track open bottle waste |
| Liquor | Spirits | Bottle | Decimal bottle estimate | Review high-value variance |
| Mixers | Mixers | Case / bottle | Case and unit count | Set minimum par |
| Garnishes | Garnishes | Pack / unit | Approximate usable quantity | Watch spoilage |
Many bars count weekly, while high-volume locations may count selected high-value products daily.
Enter a decimal estimate such as 0.25, 0.50, or 0.75 of a bottle.
Variance compares expected stock with the physical quantity actually counted.
A par level is the target quantity you prefer to keep available before the next delivery cycle.
The tool subtracts current quantity from par level and never recommends a negative reorder.
Yes. Each row includes a waste field plus notes for spills, breakage, spoilage, or complimentary drinks.
Yes. Use the CSV button for spreadsheet analysis or the PDF button for a printable record.
Important Note: All the Calculators listed in this site are for educational purpose only and we do not guarentee the accuracy of results. Please do consult with other sources as well.