Free Template
Café Waste Tracker
A simple CSV waste log for cafés — track every binned item by category, cause and dollar loss. Most shops cut waste 20–30% within four weeks of using it consistently.
| Date | Shift | Category | Item | Quantity | Unit | Unit cost | Loss $ | Cause | Logged by |
|---|---|---|---|---|---|---|---|---|---|
| 2026-06-10 | AM | Dairy | Whole milk | 1.5 | gallon | 4.20 | 6.30 | Over-steamed | Maya |
| 2026-06-10 | AM | Pastries | Croissant | 3 | each | 1.10 | 3.30 | Stale at 11am | Maya |
| 2026-06-10 | PM | Prepared Drinks | Iced latte | 2 | drink | 1.85 | 3.70 | Wrong order | Jordan |
| 2026-06-10 | PM | Dairy | Oat milk | 0.5 | carton | 3.40 | 1.70 | Expired | Jordan |
| 2026-06-11 | AM | Coffee | Espresso shots | 6 | shot | 0.45 | 2.70 | Training | Maya |
| 2026-06-11 | AM | Food Prep | Avocado | 2 | each | 1.20 | 2.40 | Over-prepped | Sam |
| 2026-06-11 | PM | Syrups | Vanilla | 0.25 | bottle | 9.50 | 2.38 | Spilled | Jordan |
| 2026-06-12 | AM | Packaging | 12oz cup | 8 | cup | 0.04 | 0.32 | Mis-stack | Maya |
| 2026-06-12 | PM | Pastries | Muffin | 4 | each | 1.25 | 5.00 | End of day | Sam |
| 2026-06-12 | PM | Dairy | Whole milk | 0.5 | gallon | 4.20 | 2.10 | Steamed extra | Sam |
Why waste is the most expensive number nobody tracks
A typical café runs 4–8% waste on revenue. On $40k of monthly sales, that's $1,600–$3,200 — pure margin into the bin. Recovering even 3 points is faster than a price increase and doesn't risk a single customer.
The five causes that explain 80% of café waste
- Over-prepped milk at the start of a shift.
- End-of-day pastries baked to the wrong forecast.
- Wrong-order remakes — usually a labeling or POS issue.
- Expired backstock in the walk-in (oat milk is the usual suspect).
- Training pours — necessary, but should be counted.
The weekly waste rhythm
- Every shift: log every binned item — 30 seconds, one line per item.
- Sunday close: sort by Loss $, look at the top 3 causes.
- Monday open: cut prep on the worst category by 15%.
- Next Sunday: measure again. Two cycles is usually enough to find a new baseline.
From spreadsheet to two taps
Pen-and-paper waste logs work for about two weeks before they break. Coffee Shop Dashboard's waste feature is two taps from any shift — category, item, cause — and rolls straight into your live COGS and profit number.