A daily wastage sheet needs six columns: item, quantity made, quantity sold, quantity unsold, cost per piece and the reason it was left over. Fill it at closing time while you still remember why the evening went the way it did. At the end of the week the sheet shows which item and which reason cost you the most, which is more useful than a vague feeling that "a lot goes waste".
What columns does the sheet need?
Set up one row per item per day. Unsold is not something you count separately; it is made minus sold, and your sheet can work it out.
- A: Date
- B: Item
- C: Made
- D: Sold
- E: Unsold, formula =C2-D2
- F: Cost per piece (what it cost you to make, not the selling price)
- G: Wastage value, formula =E2*F2
- H: Reason, picked from a short fixed list
Keep the reason list short so you actually use it: overmade, rain or low footfall, broke or damaged, went dry or stale, sampled or gifted, returned by a customer.
What does a made-up bakery day look like?
| Item | Made | Sold | Unsold | Cost each | Wastage value | Reason |
|---|---|---|---|---|---|---|
| Milk bread loaf | 40 | 34 | 6 | ₹20 | ₹120 | Overmade |
| Veg puff | 60 | 52 | 8 | ₹9 | ₹72 | Rain, low evening footfall |
| Cake slice | 24 | 20 | 4 | ₹18 | ₹72 | Went dry |
The costs are invented for the example. The day's wastage is 120 + 72 + 72 = ₹264. If you can sell the leftover bread loaves next morning at a reduced price, note that on the sheet too, so you know the real loss is smaller than the cost.
How do you total the week?
Add each day's wastage value into a weekly list. Say the week came out like this: Monday ₹264, Tuesday ₹210, Wednesday ₹305, Thursday ₹180, Friday ₹240, Saturday ₹410 and Sunday ₹350. The total is 264 + 210 + 305 + 180 + 240 + 410 + 350 = ₹1,959.
In a spreadsheet, with the data in rows 2 to 200, the same figures come from these formulas:
- Week total: =SUM($G$2:$G$200)
- Total for one item: =SUMIFS($G$2:$G$200, $B$2:$B$200, "Veg puff")
- Total for one reason: =SUMIFS($G$2:$G$200, $H$2:$H$200, "Overmade")
What should you look for in the totals?
Two patterns matter. First, an item that is left over almost every day, which means you are making too many. Second, a reason that keeps repeating, which points at the fix. Lots of "overmade" says cut the batch size. Lots of "went dry" says change how or when it is stored or baked. Lots of "rain" says prepare less on days the weather turns.
In this made-up week, Saturday and Sunday are the biggest losses, and these are probably the days you make more because you expect a crowd. That is worth testing: make a little less on one Sunday and see whether you actually run out before closing.
Should every item go on the sheet?
Start with the five items that you make most or that cost most to waste. A sweet shop might begin with milk-based sweets and anything made with fresh cream, since they spoil fastest. Add more items later only if you find you can keep up with the writing.
A short routine to follow
- At opening, write the made quantities as the trays come out.
- At closing, count what is left and write the sold figure from your billing or tally.
- Fill the reason before you leave, not next morning.
- On Sunday night or Monday morning, total the week by item and by reason.
- Change one thing in the coming week, such as one batch size, and see if the number moves.
Ingredient bills and supplier payments that come through your bank or card statement can be imported into SpendixAI and categorised, so the wastage figure on your sheet can be read against what you spent on raw material in the same month.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

