Bar Liquor Cost and Inventory Audit
Track liquor counts, pour accuracy, and POS sales in one weekly audit. Catch variance early, protect margins, and keep bar inventory aligned with actual usage.
Trusted by frontline teams 15 years of frontline software AI customization in seconds
Built for: Hospitality · Food Service · Bars & Nightlife · Restaurants
What's inside this template
Audit Setup and Scope
- Audit date and shift recorded
- Bar location and service area confirmed
- Inventory period and cutoff time verified
- All liquor categories included in scope
Physical Inventory Counts
- All sealed liquor bottles counted and recorded
- All open bottles counted using standard par levels
- Measured partial bottles documented consistently
- High-value or premium spirits verified separately
- Unlabeled or unaccounted bottles identified
Pour Test Verification
- Standard pour size verified for core spirits
- Measured pour test completed for sample drinks
- Pour spouts and dispensing equipment functioning correctly
- Bartenders following approved pour standards
Variance and Cost Analysis
- Physical inventory matches theoretical usage within acceptable variance
- Liquor cost percentage within target range
- Top variance items identified and explained
- Waste, spillage, and comps documented separately
POS Sales Reconciliation
- POS sales report matches audit period
- All liquor sales categories reviewed
- Discounts, voids, and comps reviewed for impact
- Unusual sales patterns flagged for follow-up
Controls and Corrective Actions
- Inventory storage secured and access controlled
- Corrective actions assigned for discrepancies
- Follow-up review date scheduled
- Inspector signature
Common use cases
Frequently asked questions
How often should this audit be used?
This template is designed for weekly use, but you can run it more often in high-volume bars or after events. Regular audits make it easier to spot shrink, overpouring, and POS issues before they affect margin.
Can this template handle both sealed and open bottles?
Yes. It includes separate checks for sealed bottles, open bottles, and partial bottles so your counts stay consistent. That helps you compare physical inventory against expected usage more accurately.
Does it support pour test checks for staff compliance?
Yes. The pour test section verifies standard pour sizes, equipment function, and bartender adherence to approved standards. It gives you a simple way to confirm that serving practices match cost controls.
How does this help with POS reconciliation?
The template ties inventory findings to POS sales, discounts, voids, and comps for the same audit period. That makes it easier to explain variances and flag unusual sales patterns for follow-up.
Who should use this audit template?
It works well for bar managers, beverage directors, and owners who need tighter control over liquor cost. It is also useful for multi-location operators that want a repeatable audit process across sites.
Related templates
Ready to use this template?
Get started with MangoApps and use Bar Liquor Cost and Inventory Audit with your team — pricing built for small business.
