Tracking spoilage and shrinkage in perishables

Spoilage is stock that loses sale value because it expires, rots, leaks, breaks or becomes unsafe. Shrinkage is the wider difference between the quantity the records say you should have and what is physically present. It can include spoilage, theft, counting mistakes, supplier shortages, unrecorded household use and sales entered with the wrong quantity.

If losses are recorded only as “purchase expense,” the owner knows profit is weak but cannot see the cause. A simple loss log, regular counts and reason codes turn hidden shrinkage into actions.

Separate the reasons for loss

Use a short list of reasons:

• Expired or spoiled
• Damaged in storage or handling
• Supplier shortage or damage
• Customer return not resellable
• Suspected theft
• Unrecorded use or sampling
• Counting or data-entry correction
• Unknown difference

Do not label every difference theft. A wrong unit conversion, duplicate sale or carton counted as one piece can create a large apparent shortage. Investigate first. “Unknown” is acceptable temporarily, but repeated unknown losses require a process review.

Record product, quantity, cost value, date, reason and approver. Selling price shows missed revenue, but cost value is important for stock and profit. Use one consistent valuation method with your accountant.

Count high-risk stock more often

Not every item needs a daily count. Count products with high value, short shelf life, easy concealment or frequent differences more often. Milk, curd, bread, fresh produce, frozen goods, tobacco products, cosmetics and small premium items may deserve different schedules.

Use cycle counting: choose a manageable set each day so every important category is checked during the month. Count “A” items weekly or more often, medium-risk items monthly and stable low-value items less frequently. Always count during a controlled period when stock movement is paused or clearly recorded.

Compare physical quantity with expected quantity. Investigate large differences immediately while delivery and shift details are available.

Worked example: yoghurt loss over one week

A shop receives 120 yoghurt cups at a cost of ₹24 each. During the week:

• Recorded sales: 98 cups
• Customer returns, not resellable: 2 cups
• Recorded expiry: 8 cups
• Physical closing count: 9 cups

Expected closing quantity is 120 − 98 − 2 − 8 = 12 cups. Physical stock is 9, leaving an unexplained shrinkage of 3 cups.

Known loss cost is (2 + 8) × ₹24 = ₹240. Unknown shrinkage cost is 3 × ₹24 = ₹72. Total loss cost is ₹312.

The owner checks deliveries and learns that one tray was recorded as 12 cups, but only 10 arrived. That explains 2 cups and should be raised with the supplier. The final 1 cup remains unknown. The next week, staff count yoghurt at shift change and record every damaged cup immediately.

The point is not the ₹24 unit alone. If similar losses occur across 50 products, the monthly effect can be substantial. The reason breakdown directs the remedy: better ordering for expiry, delivery checks for shortages and shift control for unknown differences.

Reduce expiry with first-expiry-first-out

Arrange products so the earliest expiry is sold first. “First in” is not always enough when a new delivery has an earlier expiry than old stock. Check dates during receiving and place short-dated stock at the front.

Maintain an expiry watch list. Review items at a useful interval before expiry, not on the expiry date. Options may include reducing the next order, moving stock to a busier shelf, offering a transparent discount while the product is safe and legally saleable, or returning it under a supplier agreement.

Never sell unsafe or expired goods. The cost of a complaint, illness or regulatory action is far greater than the stock value.

Control receiving and storage

Count or sample deliveries before accepting them. Compare the supplier invoice with physical cartons and units. Note damaged seals, temperature problems and short expiry. Photograph a supplier issue when appropriate without capturing unrelated private information.

Storage conditions matter. Temperature, sunlight, moisture, stacking and pest control can turn good stock into loss. Assign responsibility for fridge checks and closing power status. A low-cost temperature log may identify recurring failures.

Use consistent units. If purchasing in cartons and selling in pieces, define how many pieces belong to a carton. Conversion mistakes can make stock records useless even when every sale is entered.

Distinguish waste from discounts and free use

A discounted item is still a sale; record the actual selling price. A free sample or promotional giveaway is a deliberate stock movement, not unexplained shrinkage. Staff or owner consumption should also be recorded using an appropriate internal-use category.

This detail prevents a false conclusion. If 20 near-expiry items were sold at half price, the business recovered cash and should measure the markdown. If they are simply removed as spoilage, the report cannot compare which action worked better.

Authorise stock write-offs. One person can identify damage, but a manager or owner should review larger adjustments. Keep the process quick so staff do not hide small losses to avoid paperwork.

Measure a useful loss rate

Calculate loss cost ÷ relevant sales or stock handled for the period. Compare the same category over time. A percentage gives context: ₹3,000 loss on ₹30,000 sales is very different from ₹3,000 on ₹3,00,000 sales.

Do not chase a universal “perfect” percentage. Product mix, weather, supply quality and customer patterns differ. Set an internal baseline, investigate worsening trends and compare stores or shifts only when processes are similar.

Track known and unknown loss separately. Known expiry can be improved through ordering. Unknown loss requires counting, access and entry controls. A declining total with rising unknown difference is not a success.

Connect loss data to ordering

Reduce the reorder quantity when repeated expiry shows demand is lower than assumed. Increase delivery frequency if suppliers allow it. For seasonal perishables, use smaller first orders and replenish after real sales confirm demand.

Include lead time and a modest safety stock, but do not call excess perishable inventory “safety.” Safety stock should protect normal variation, not cover poor counting or optimistic forecasts.

Review margin after waste. A product with an attractive unit margin may be weak after expiry. Use the net contribution and shelf effort when deciding whether to keep, resize or remove a line.

Practical takeaway

Create a loss log with product, quantity, cost, reason and approval. Count high-risk stock on a schedule, use first-expiry-first-out, verify deliveries and record internal use or discounts separately. Investigate unknown differences without automatically accusing staff.

Start with one category that expires often. Count it today, value the known loss and trace any difference. Use the result to adjust the next order. The guides on reorder points and safety stock and ABC inventory analysis will help decide which products deserve the closest attention.