Bar Liquor Cost and Inventory Audit

Weekly inspection template for auditing bar liquor inventory, pour tests, variance, and POS sales reconciliation.

Audit Setup and Scope

• Audit date and time recorded
• Audit period matches weekly reporting window
• Inventory count sheet or digital count list available
• POS sales report for audit period available
• Product list includes all liquor SKUs, house pours, and high-variance items
• Any stock transfers, comps, spills, or breakage documented for the period

Physical Inventory Counts

• All liquor bottles counted by SKU and size
• Counted on-hand quantity matches expected inventory within tolerance
• Opened bottles inspected for estimated remaining fill level
• Sealed bottles intact and not expired or damaged
• Back bar, speed rail, and storage locations fully included in count
• Any missing, misplaced, or unaccounted-for bottles identified

Pour Test Verification

• Pour test completed for each standard pour size
• Measured pour volume within acceptable tolerance
• Pour spouts, jiggers, and measuring tools clean and functioning
• Over-pour or under-pour trend identified by product
• Staff retraining required based on pour test results

Variance and Cost Analysis

• Theoretical usage calculated from POS sales and recipe standards
• Variance percentage entered for each major liquor category
• Variance within acceptable threshold
• Cost of variance calculated and reviewed
• Potential causes of shrinkage documented

POS Sales Reconciliation

• POS liquor sales match itemized sales summary
• Voids, comps, discounts, and refunds reviewed
• Unusual sales patterns or missing transactions identified
• Reconciliation difference entered

Controls and Corrective Actions

• Corrective actions assigned with owner and due date
• Repeat deficiency noted from prior audit
• Inspector signature completed