Use a one-page write-off slip for every piece of damaged, expired or lost stock: the item, the quantity, the reason, the date, a photo and the cost. Attach it to your stock sheet, and the gap between what you bought and what you sold has an explanation that you can show your CA.
Why does stock disappear on paper?
Stock moves in three ways: it is bought, it is sold, or it leaves the books some other way. The third way, breakage, expiry, theft, samples or spoilage, is the one that is rarely written down. Without a note, closing stock looks short, and it reads like a mistake or worse. With a note, it reads like ordinary trade.
What goes on the write-off slip?
- Date and the name of the person who found it.
- Item and code, as it appears on the purchase bill.
- Quantity and the cost per unit, taken from the bill.
- Reason: broken in transit, dropped in the godown, expired, water damage, missing in a stock count.
- Photo reference: the file name of the photo of the damage or the expired batch.
- Your signature and the date, and a partner's if you have one.
Stick to one slip per incident, or per batch if it all happened together. Number the slips the way you would number vouchers, for example W-26-007.
A worked example: broken tiles and expired packets
Say a shop that sells tiles and a few packaged goods writes off the following. The costs are made up for the example.
| Item | Quantity | Cost per unit in rupees | Reason | Write-off in rupees |
|---|---|---|---|---|
| Floor tile, 2x2 | 12 | 85 | Broken while unloading | 1,020 |
| Packaged snack | 30 | 18 | Past expiry date | 540 |
| Total | 42 units | Not applicable | Two slips | 1,560 |
Twelve tiles at 85 rupees come to 1,020 rupees, and thirty packets at 18 rupees come to 540 rupees. Together the loss is 1,560 rupees.
How does the slip make stock and purchases reconcile?
The basic equation is opening stock plus purchases minus sales minus write-offs, which should equal closing stock. For the packets, say you started the month with 400, bought 600 and sold 930. Without the write-off, you would expect 400 plus 600 minus 930, which is 70 left. A count finds only 40. The 30 expired packets explain the gap exactly, because 70 minus 30 is 40. Without the slip, you would suspect theft.
What if stock is simply missing, not broken?
A missing item is harder than a broken one, because there is nothing to photograph. Write the slip anyway, with the reason given as missing at stock count and the date of the count. Then look at the pattern. If the same product goes missing every month, the answer may be a counter habit, a billing gap or a supplier short-supplying cartons, and the slips will show it long before the loss grows.
What about the tax side?
Whether damaged, expired or lost goods need any adjustment for tax, such as on credit taken earlier, depends on your registration and the facts. Do not decide it yourself. Give your CA the slips for the period and ask. Having them ready is what turns a long conversation into a short one.
Where an expense tracker fits
A tracker is not a stock system, so keep quantities in your stock sheet. If you wish to keep the money side visible, you can add the write-off as a manual entry in a category of your own, such as Stock loss, and attach the photo as a receipt. SpendixAI lets you add expenses by hand and keep receipts with transactions, and a custom category gives the monthly total in one place.
For insurance claims, keep the photo, the bill and any police or courier complaint together and follow your insurer's process.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

