After Monday’s count, drop in your variance report (CSV or Excel). You’ll see your total shortage and your top three items. Your file is read inside your browser. Nothing is uploaded or stored.
CSV or Excel · any variance or actual-vs-theoretical report with an item column and a variance column
No file handy?
Private by Design. The file is read by your browser only. It is never sent to me or anyone else.
A Preview, Not a Diagnosis. It shows what your Monday report already says. Finding out whether each shortage is a recording issue or a physical check is the review.
Want to See the Full Thing? Open the Sample Report →
A real review is built from your own exports and reads like this: what to fix in the system, what to check on the floor, and what is just count noise. Everything below is fictional.
Harbour & Pine (fictional) · liquor, wine and draft · one inventory period
All 3 House Mix ingredients ran about 35% over recipe together. That pattern points to one batch logged at the wrong yield, not three separate losses.
Next: Check the recipe yield and how batches are entered.
No recording explanation, and still short after 0.85 L of logged comps and spills.
Next: Watch pours, spot-count mid-week, review the comps and spills log.
Premium Gin Y is 2.7 bottles short while House Gin X is 3.0 bottles over. Roughly equal volumes in opposite directions suggest premium pours rung in as house.
Next: Compare POS item mapping with what is poured. Ask staff which button they use.
| Item | Expected | Actual | Variance | % | Value | Status |
|---|---|---|---|---|---|---|
| Premium Gin Y | 6.5 | 9.5 | -2.7 | -41.0% | −$192 | Recording |
| Spirit A (batch base) | 11.2 | 15.0 | -3.8 | -33.7% | −$144 | Recording |
| Tequila Blanco | 10.0 | 15.0 | -3.9 | -38.7% | −$139 | Check |
| Spirit B (batch base) | 7.5 | 10.0 | -2.5 | -33.7% | −$66 | Recording |
| Mixer (batch base) | 14.0 | 19.0 | -5.0 | -35.5% | −$20 | Recording |
| Draft Lager (kegs) | 2.9 | 3.0 | -0.1 | -2.1% | −$11 | Within tolerance |
| Rye Whisky | 6.5 | 7.0 | -0.3 | -4.6% | −$9 | Within tolerance |
| Amaro | 3.2 | 3.5 | -0.3 | -8.2% | −$9 | Within tolerance |
| Red House Wine | 14.6 | 15.0 | -0.4 | -2.7% | −$6 | Within tolerance |
| Vodka Z | 10.5 | 10.8 | -0.1 | -1.1% | −$4 | Within tolerance |
| Dry Vermouth | 6.0 | 6.0 | +0.0 | +0.0% | $0 | Within tolerance |
| House Gin X | 10.0 | 7.0 | +3.0 | +30.0% | +$102 | Recording |
| Shift | What Was Logged | Value |
|---|---|---|
| Sat PM | Draft Lager (line cleaning), Premium Gin Y (comp), Tequila Blanco (spill + comp) | $54 |
| Fri PM | Tequila Blanco (comp (regular)), Vodka Z (spill) | $16 |
| Sun PM | Rye Whisky (comp) | $6 |
| Thu PM | Tequila Blanco (comp (regular)) | $5 |
Variance is expected usage (from sales and recipes) minus actual usage (from counts), plus logged waste and comps; negative means shortage. Differences within a 2% allowance or one bottle are treated as normal. These findings show where to look. They are not proof of loss and not a savings guarantee.
It Never Points at Staff. The review shows what the data supports and what to verify first. Fraud findings aren’t part of it.
It Says What It Can’t Explain. Where exports can’t settle a variance, the memo says so and names the extra data that would.
It Works From Your Exports. No system access and nothing changed in your POS or inventory software.
Tell me which variance your team keeps investigating and which system you export from. I’ll reply to set up a short screening call.