Health and family

An expired medicine log and what it says about your ordering

Keep a quarterly note of expired or discarded medicines and their cost; it can show over-ordering and help you set a smaller refill quantity.

Editorial illustration for An expired medicine log and what it says about your ordering

Once a quarter, go through your medicine cupboard, list everything you throw away, and write down what it cost. If the list keeps showing the same few medicines, you are probably buying more than you use, and the log tells you by how much to reduce the next refill.

Why note what you throw away?

Unused medicines are quiet waste. A half-finished course, a spare strip bought for a trip that was cancelled, a syrup opened once. None of it feels like spending because it is already gone. A short log turns that vague sense into a figure you can look at, and the reasons behind it are usually more useful than the total.

What goes in the log?

  • Date of the cupboard check
  • Medicine name and who it was for
  • Quantity discarded: tablets, a bottle, a tube
  • Cost: from the original bill or strip price, divided by tablets where needed
  • Reason: course changed, bought extra, expired before use, opened and not finished, other

Do this when you check expiry dates, which many households do every few months anyway. If you are unsure how to dispose of a medicine safely, ask your pharmacist or doctor, rather than guessing.

A worked example

Say a household's quarterly cupboard check finds the following. The amounts are hypothetical.

ItemQuantityCost (Rs)Reason
Medicine P, one strip10 tablets85Bought extra with a bulk purchase
Medicine Q18 tablets at ₹4.50 each81Dose changed
Cough syrup1 bottle110Opened and not finished
Antibiotic leftovers6 tablets at ₹14 each84Course ended early
Total4 items360Mixed

18 times 4.50 is ₹81, and 6 times 14 is ₹84. The total is 85 + 81 + 110 + 84 = ₹360. If the household spent ₹14,400 on medicines in the quarter, ₹360 is 2.5 per cent, a small but real figure. More important is the pattern: two of the four items came from changes to a prescription, and one from a bulk purchase. That suggests asking the doctor how long a dose is likely to stay the same before buying a large quantity.

What does the log say about ordering?

Group the reasons. If "bought extra" and "bulk purchase" dominate, shrink your refill quantity or check expiry dates before accepting a large pack. If "dose changed" dominates, buy smaller amounts after a new prescription and larger ones once the dose is stable. If "opened and not finished" appears, ask whether a smaller bottle exists. Expiry itself usually means the stock was bought too early.

In a sheet with Reason in column D and Cost in column C, the cost of one reason is =SUMIFS($C$2:$C$200, $D$2:$D$200, "Bought extra"). Compare the reasons side by side.

For example, if the Reason column shows three entries of "Bought extra" and one of "Dose changed", the lesson is about your buying habit rather than about the prescription. Write that single sentence at the bottom of the sheet each quarter, so the next check begins with last quarter’s lesson in front of you.

Does it connect to my other records?

Yes, to your refill and bulk-purchase notes. If you record each purchase with its date and quantity, you can see how long a pack lasted. In SpendixAI, pharmacy payments are in your statement import and the bills can be attached to them. That is a convenient reference when you need to look up what something cost, but the discard note is a small sheet of its own.

Quarterly checklist

  1. Take everything out of the cupboard and check expiry dates.
  2. List what must go, with quantity and cost.
  3. Write the reason against each item.
  4. Choose one change for the next quarter, such as a smaller refill of the medicine that appears most.
  5. Move the nearest-expiry packs to the front so they are used first.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports