Skip to content

Bar Waste Log: A Template for Spills, Comps and Foam

A bar waste log template: a row for every pour that isn't sold, with the reason and the cost, a week added up by reason, and how it explains variance.

By Koa Sterling. Product specialist at TaroStack and small business owner. Yes, I am a real human, and I actually sit in front of a computer and write these articles. Reviewed November 21, 2026 · 7 min read

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.

Questions people also ask

What goes on a bar waste log?

The date, the item, the amount and its unit, the reason, who logged it and a short note. Add what a unit costs you and the sheet works out the cost.

Should comps go on the waste log?

They should be recorded in one place: on the waste log, or on the register as a zero-price sale. A comp leaves the bottle without reaching the till, so the count has to account for it.

How much bar waste is normal?

There isn't a number that fits every bar. Keep the log for a month, add it up by reason, and compare it with your own next month. In the example a week's waste cost $54.04, and $31.00 of it was one broken bottle.

We use AI to help with the research for these articles. Every one is read, checked against its sources and edited by Koa before it's published. Spot a mistake? Tell us and we'll fix it and say so. How we write these.

Let’s get your stack in order.

Get TaroStack

Sign up now for your free 14 day trial. No credit card required.