Bar inventory is where most restaurants lose money quietly. A bottle here, an over pour there, a comp that never gets rung in. Without a weekly counting process you have no visibility into what is actually happening behind the bar. You only find out when the pour cost percentage comes back wrong at the end of the month.
Our Restaurant Bar Inventory Spreadsheet covers liquor by category, beer by SKU, wine by bottle, and mixers and supplies. Enter your par quantities, your on hand counts, and your bottle costs. The spreadsheet calculates your usage, your theoretical pour cost, and your variance so you can see immediately if something is off.
What is included: a bar inventory count sheet organized by category, automatic pour cost calculation, a variance tracking column, a reorder alert tab based on par levels, and a weekly comparison view so trends are visible over time.
Who this is for: bar managers and restaurant owners who suspect their pour cost but have no system to prove it, operators inheriting a bar program with no documentation, and managers who want to hold their bar team accountable with data.
Download immediately after purchase. Compatible with Google Sheets and Microsoft Excel.
Bar inventory is where most restaurants lose money quietly. A bottle here, an over pour there, a comp that never gets rung in. Without a weekly counting process you have no visibility into what is actually happening behind the bar. You only find out when the pour cost percentage comes back wrong at the end of the month.
Our Restaurant Bar Inventory Spreadsheet covers liquor by category, beer by SKU, wine by bottle, and mixers and supplies. Enter your par quantities, your on hand counts, and your bottle costs. The spreadsheet calculates your usage, your theoretical pour cost, and your variance so you can see immediately if something is off.
What is included: a bar inventory count sheet organized by category, automatic pour cost calculation, a variance tracking column, a reorder alert tab based on par levels, and a weekly comparison view so trends are visible over time.
Who this is for: bar managers and restaurant owners who suspect their pour cost but have no system to prove it, operators inheriting a bar program with no documentation, and managers who want to hold their bar team accountable with data.
Download immediately after purchase. Compatible with Google Sheets and Microsoft Excel.
