A bar waste log is a sheet behind the bar where every drink or pour that doesn't get sold is written down: what it was, how much, and why. A spilled shot, a wrong order remade, the foam off a new keg, a comp, a dropped bottle. Its job is to explain the gap. At the end of the month a bar counts its bottles, works out what should have been poured from what was sold, and finds a difference. Without a log, that difference is a mystery and everyone's a suspect. With one, most of it has a name and a date, and what's left over is the part worth worrying about. Below is a week's log for a made-up bar, the week added up by reason, how to keep one, and the file.
The short version
- One row for every pour that isn't rung in: spills, foam, wrong orders, comps, breakage, wine past its day.
- Item, amount, unit, reason, who. Written at the moment, by the person it happened to.
- Cost = amount × what that unit costs you.
- Keep the list of reasons short. Six is plenty.
- Add it up by reason every week. The biggest reason is the one to fix.
- What the log doesn't explain is the real variance.
- TaroStack records waste with a reason and values a count before you post it. More below.
An example week
| Date | Item | Amount | Reason | Cost a unit | Cost | Menu price lost | By | Note |
|---|---|---|---|---|---|---|---|---|
| Nov 16 | House vodka | 1.5 oz | Spill | $0.62 | $0.93 | $8.00 | KJ | Knocked over on the rail |
| Nov 16 | IPA, draft | 14 oz | Foam | $0.19 | $2.66 | $7.00 | KJ | New keg: first pours all foam |
| Nov 17 | Margarita | 1 drink | Wrong order | $2.35 | $2.35 | $12.00 | ML | Rang as salt rim, wanted none. Remade |
| Nov 18 | Chardonnay, by the glass | 12 oz | Past its day | $0.55 | $6.60 | $24.00 | ML | Bottle opened Friday, poured out Wednesday |
| Nov 19 | Old fashioned | 1 drink | Comp | $2.90 | $2.90 | $13.00 | KJ | Manager's comp, table 6, long wait for food |
| Nov 20 | IPA, draft | 40 oz | Foam | $0.19 | $7.60 | $20.00 | ML | Cooler ran warm after the door was left open |
| Nov 20 | Bourbon, call | 1 bottle | Breakage | $31.00 | $31.00 | $192.00 | KJ | Dropped restocking. Nearly full |
Seven rows, $54.04 at cost, $276.00 at menu prices.
Cost a unit is what the bar pays: a 750 ml bottle of house vodka at $15.75 is 62 cents an ounce, and a sixth-barrel of IPA at $125 over 661 oz is 19 cents an ounce. For a cocktail it's the recipe's cost.
Menu price lost is optional. It's the number that gets an owner's attention, and it overstates the loss: a spilled drink wasn't going to be sold twice. Cost is the honest one.
The week, by reason
| Reason | Rows | Cost |
|---|---|---|
| Breakage | 1 | $31.00 |
| Foam | 2 | $10.26 |
| Past its day | 1 | $6.60 |
| Comp | 1 | $2.90 |
| Wrong order | 1 | $2.35 |
| Spill | 1 | $0.93 |
| Total | 7 | $54.04 |
The bottle is bad luck. The foam is a pattern. Breakage is the biggest number this week and won't be next week. Foam appears twice, 54 oz in all, more than three pints, and both notes say why: a keg tapped too soon and a cooler door left open. That's a line to fix, and it's the cheapest row on the page to prevent.
The Chardonnay is a menu question. A glass-pour wine that doesn't empty in five days is a wine that shouldn't be poured by the glass, or should be bought in smaller bottles. One row won't show that. Four weeks of the same row will.
Comps aren't waste, and they belong here anyway. A comp is a decision. It still left the bottle without reaching the till, so the count has to know about it. Some bars keep comps on the register as a zero-price sale. Either works, as long as it's one or the other and never neither.
What the log is for
The monthly count gives a bar its usage: opening stock, plus purchases, less closing stock. Sales give what should have been used. The difference is variance.
| Bourbon, call, for the month | Bottles |
|---|---|
| Used, by the count | 14.0 |
| Sold, by the register, at 1.5 oz a pour | 11.6 |
| Difference | 2.4 |
| In the waste log: one bottle broken, three comps | 1.2 |
| Unexplained | 1.2 |
Without the log, the conversation is about 2.4 bottles. With it, it's about 1.2, and the first thing to check is the pour: a bartender free-pouring 1.65 oz instead of 1.5 uses a tenth more bourbon than the register thinks, and on 11.6 bottles sold that's about 1.2 bottles, the whole of what's unexplained. The count itself is in bar inventory spreadsheet, and what a pour should cost in how to price liquor in a restaurant.
Keeping one
- Behind the bar, on a clipboard, where it takes ten seconds.
- At the moment. A log filled in at close has three rows on it. One filled in as it happens has ten, and the ten are the truth.
- No blame for a row. The first week a bartender is told off for a spill is the last week spills get written down.
- Initials on every row, and a manager's initials on comps.
- Add it up weekly, by reason, and say the result out loud at the staff meeting.
Draft beer has its own arithmetic: see keg inventory spreadsheet and how much profit on a pint of beer. A kitchen's version of this sheet is waste log template.
Get the log
Download the bar waste log. One sheet and a read-me: a row for each pour that wasn't sold, with the amount, the reason and what a unit costs you, and the cost worked out. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers. Print it for the clipboard and type the week in on Monday.
Where this stops working
The log is one of three numbers, and on paper they live apart. The count is on a spreadsheet, sales are in the register, and the waste is on a clipboard with beer on it. Putting them together takes an evening, so it's done monthly at best, and by then a pattern that started on the 3rd has had four weeks to run.
How TaroStack does it
TaroStack keeps the stock and the waste in one place.
An adjustment carries a reason: damaged, spoiled, expired, sample, lost. Waste is reported by reason and by item.
Counting on a phone, bottle by bottle or keg by keg, with what a difference is worth shown before you post it.
Counting suggests what to count first: what it would cost to be wrong, times how much has moved.
Buy by the bottle or the keg, pour by the ounce. TaroStack does the conversion.
Every movement says who, when and why, and corrections are recorded as corrections.
| The number | Clipboard and spreadsheet | In TaroStack |
|---|---|---|
| What was wasted, and why | Add up the clipboard | Adjustments, by reason |
| What the count found | A monthly spreadsheet | Counts, with the variance valued |
| What to count this week | Everything, or nothing | Suggested by risk |
| Who recorded it | Initials, if legible | On every movement |
TaroStack connects to Square. It doesn't measure pours or read a draft system. Stock, counts and waste reasons are on every plan, from $9.99 a month (50 items) or $39 a month (3,000 items). The first 14 days are free, with no credit card. If you'd like a hand setting up, ask, and we'll do it with you.
