Operations

Tracking Prep and Waste With a Log Your Team Will Actually Keep

A simple reason-and-cost waste log that separates trim, over-prep, spoilage and drops — with a prep list driven by actual sales and no invented industry targets.

Clean kitchen prep station with clear containers and a blank clipboard

Reviewed 2026-09-30 · Hospitality Tech Guide · Restaurant and cafe operators

Start with a one-line log written at the bin, not reconstructed at the end of the night: item, reason, quantity, and cost. Two weeks of honest entries will show you more about where food cost actually goes than a year of guessing. The log is the tool; everything else is commentary.

Why reason and cost matter, not just quantity

A bag of trimmings and a tray of over-prepped food are both "waste", but they come from different problems and need different fixes. Trim is a menu-design question; over-prep is a par-level question; spoilage is a purchasing or rotation question; a dropped dish is a training or floor question. If your log only records weight, you cannot tell those apart. Recording the reason, plus the cost of what was thrown out, turns the log from a guilt list into a decision tool.

The log fields

Keep it to a handful of fixed columns so the team will actually fill it in:

  • Date and shift.
  • Item. The specific ingredient or prepared item.
  • Reason. Choose from a short fixed list — spoilage, over-prep, trim, dropped/damaged, comp or remake, other.
  • Quantity and unit. Be consistent (pounds, count, or each).
  • Cost. The cost of that quantity, not the menu price.
  • Initials. So a pattern can be traced to a station or a shift, not to punish.

Five or six fixed reasons are better than free-text, which turns into a novel no one reads.

Turning the log into a number

Add up the cost column per reason each week. The useful question is not "how much did we waste?" but "which reason is biggest, and is it shrinking?". The arithmetic is simple and should be done in plain view, with no hidden targets.

Use the prep list you already have

Prep should be driven by what you actually sell, not by habit. Write the prep list from yesterday's and last week's sales, and only par-up items that ran out before close. After changing a prep quantity, compare the over-prep line with sales and stockouts. A smaller discard does not help if you run out of items guests want to buy.

Operating workflow

  1. Print or post a one-line log sheet at each station where food is discarded.
  2. Record every discard at the moment it happens, with reason, quantity and cost.
  3. Total the cost column by reason at the end of each week.
  4. Pick the single largest reason and change one thing — a par level, a menu item, or a rotation habit.
  5. Repeat weekly and watch that one line, not the whole sheet, for movement.

When a free or manual option is enough

A clipboard and a spreadsheet are enough until the log is being filled reliably every day. Do not buy a tracking tool to fix a logging habit that does not exist yet — a paid app recording nothing is the same as no system. Move to software only once the manual log has become a steady routine and you want the totaling automated.

Boundaries

A waste log measures cost; it does not keep food safe. Do not treat a better log as a substitute for proper storage, temperature and rotation practices, and do not let a log lead you to extend the life of an ingredient past what is safe. This guide makes no claim about industry waste percentages or food-safety outcomes — those are matters for your local food-safety requirements, not for a spreadsheet.

Follow the tomatoes from prep to the bin

Suppose a café preps 20 pounds of tomatoes at $2.50 per pound and records 3 pounds discarded because of spoilage. The spoilage line contains $7.50 of ingredient cost: 3 × $2.50. If a later log records only 1 pound spoiled at the same unit cost, that line becomes $2.50, a $5.00 difference. The manager checks whether sales and stockouts changed too before deciding that a smaller prep batch worked. Lower waste alone is not a win if it leaves the kitchen unable to serve orders.

Continue with a related task

Browse the practical guide library or check your costs with a free calculator.