Vero -- Tools for Bar and Restaurant Operators

Bar Weekly Sales Tracker Template -- Control Your Numbers

Bars have more financial control levers than almost any food-service business. Pour sizes, comp policy, pricing by day and time, product mix, staff scheduling -- all of these move margin. But you cannot use levers you cannot see. A weekly sales tracker gives you the visibility to act.

The five numbers a bar must track every week

1. Total beverage revenue

By day and by shift (lunch/dinner/late night if you operate across multiple dayparts). Not just total weekly -- by day. The Monday number and the Saturday number are different businesses and need to be managed differently.

2. Pour cost percentage (target: 18-24%)

Pour cost = Cost of goods sold / Beverage revenue. This is your primary bar efficiency metric. Calculate it weekly using actual inventory counts, not POS estimates. Over 24%: investigate over-pouring, waste, or theft. Under 18%: verify you are not under-reporting inventory (or celebrate if your purchasing is genuinely that efficient).

Track pour cost by category: spirits, beer, and wine have very different cost structures and should be watched separately. A spirits pour cost of 20% is fine. A spirits pour cost of 30% is a problem. The blended number hides the detail.

3. Revenue per labor hour

Total beverage revenue divided by total bar staff hours worked. This is your scheduling efficiency metric. Calculate it by shift. A Friday night shift should generate significantly more revenue per labor hour than a Tuesday afternoon shift. If they are similar, you are either over-staffing Friday or under-pricing Tuesday.

4. Comps and voids as percentage of revenue (target: under 2%)

Comps (manager-approved free drinks) and voids (cancelled transactions) together should be under 2% of revenue. Above 3%: investigate. Above 5%: there is a control problem. This is the number that most clearly signals whether you have an internal theft issue.

5. Average check per guest

Total revenue divided by covers or transactions. Track it by day and by server/bartender. Variance between staff members tells you who needs training on upselling and who is already doing it. A $2 average check difference per transaction across 80 covers is $160 per shift -- $5,000+ per month on a busy bar.

How to run inventory efficiently for weekly tracking

Full physical inventory weekly is the most accurate approach but takes 45-90 minutes for a mid-sized bar. If you cannot do weekly full counts, at minimum do a spirits-only count weekly (highest value, most theft-vulnerable) and a full count monthly.

The counting format matters: same person, same route, same time each week. Variance in counting procedure creates false variance in the numbers. Assign one reliable person to own the count. Check their work monthly against a second counter.

The variance analysis -- what to do when pour cost is off

Pour cost varianceFirst checkSecond check
+2-3% above target Bartender over-pouring; do a measured pour audit this week Spillage and breakage log -- are losses being recorded?
+4-5% above target Inventory counting error; recount top 10 SKUs immediately Review receiving records -- are deliveries being verified?
+6%+ above target Control problem -- review POS transaction patterns for unusual void/comp clusters Check whether unreported breakage or theft is occurring on specific shifts

One metric most bars track wrong: comps

Comps should be tracked as a count and a dollar value -- not only as a percentage of revenue. A bar with 50 weekly comps at $8 average has a different problem than a bar with 5 comps at $80 average. The percentage is the same; the root cause and the fix are completely different.

The Vero Bar and Restaurant P&L Tracker includes a dedicated bar tab with weekly pour cost calculation, shift-level revenue per labor hour, comp and void tracking, and a 12-week trend view for each metric. Built to take 25 minutes per week to update.

Get the Bar and Restaurant P&L Tracker -- $49
Free tools -- start here if you are not sure yet