Variance Report

What a variance report actually means

A variance report is the single most useful document in bar inventory. It lists every SKU, shows the theoretical usage (POS sales times recipe specs), shows the actual usage (from the count), and calculates the difference. The gap is variance, expressed in ounces, bottles, and dollars.

If you only run one report every week, this is the one.

How it is used on the floor

Managers pull the variance report right after every count. They sort by dollar impact and look at the top five problem SKUs. That is where 80 percent of the leak usually sits. Small variances on dozens of SKUs are noise. A big variance on one SKU is a signal.

The review sounds like: “Jameson is off 2 bottles. Patrón is off a half. Vodka is fine. Bourbon is fine. What happened with Jameson last week?” Then the manager checks the POS for comps, scans shift reports, and figures out which of the usual suspects caused the gap.

What a good variance report shows

A useful variance report has:

• SKU name and size
• Beginning on-hand
• Purchases in the period
• Ending on-hand
• Actual usage (ounces or bottles)
• Theoretical usage from POS
• Variance (ounces and dollars)
• Variance as a percent of theoretical

Sorting by dollar variance is the fastest way to prioritize. Sorting by percent catches the small-dollar SKUs that are leaking badly in relative terms.

Variance report benchmarks

• Under 2 percent total variance: healthy, well-run bar
• 2 to 4 percent: room for improvement, focus on top offenders
• 4 to 6 percent: real leak, investigation needed
• Over 6 percent: bleeding, likely a combination of over-pour and theft

Example: a bar with $80,000 in monthly beverage revenue and 5 percent variance is losing $4,000 a month to shrinkage. The variance report is how you find which bottles account for that.

How often to run it

Weekly at minimum. Some operators run it daily for specific high-theft categories (top shelf whiskey, premium tequila). Monthly variance reports exist, but they are too late to change behavior. By the time you see it, the damage is four weeks old and nobody remembers what happened.

Common mistakes

Running the report but not acting on it. Chasing small variances instead of the top five dollar offenders. Using outdated recipe specs that make theoretical usage wrong. Not separating waste and spill logs from real variance.

How PourIQ handles it

PourIQ generates a variance report automatically after every count, ranked by dollar impact and filtered to only the SKUs that matter. You see the top five problems in the first 10 seconds of opening the dashboard. No spreadsheet, no sorting, no manual lookups.