To see whether a pharmacy membership is worth it, add up the extra discounts it gave you over a few orders and subtract the membership fee. If the answer is positive, that is your net saving. Count only the discount you would not have got without the membership, and use the amounts on your own invoices.
What counts as a saving, and what does not
Membership schemes bundle several things: an extra percentage off, free delivery above a certain order value, sometimes points or cashback. Not all of it is saving. A discount you would have received anyway, or a delivery fee you would have avoided by ordering more at once, is not credit to the membership. Be strict, because the aim is to find out what the fee actually bought you.
The sheet: one row per order
Columns: A Date, B Order list value, C Membership discount on the invoice, D Delivery fee waived, E Note. Put the membership fee and its validity period in a separate cell, say H1 for the fee and H2 for the number of months. Keep the invoices or screenshots of each order.
Record delivery fee waived only when you can say what you would have paid otherwise. If you would have ordered anyway and been charged a delivery fee, count it. If you added items only to reach the free-delivery level, do not count it.
A worked example
Say a membership costs ₹399 for three months. The orders below are hypothetical.
| Order | List value (Rs) | Membership discount (Rs) | Delivery fee waived (Rs) |
|---|---|---|---|
| Order 1 | 1,850 | 185 | 40 |
| Order 2 | 2,100 | 210 | 40 |
| Order 3 | 1,640 | 164 | 40 |
| Total | 5,590 | 559 | 120 |
- Discounts only: 559 minus the fee of 399 leaves ₹160 saved over three months
- Discounts plus waived delivery: 559 plus 120 is 679, minus 399, leaves ₹280
- Average discount per order: 559 divided by 3 is about ₹186
- Break-even point: the fee of 399 divided by ₹186 is about 2.1, so the membership repaid itself on the third order
The two answers, ₹160 and ₹280, differ because of the delivery fees. If you would have been happy to pay ₹40 per delivery, the true saving is the larger one. If you would not have used delivery at all, it is ₹160. Report both and decide honestly.
How do I calculate this in a sheet?
With discounts in C2:C50, waived delivery in D2:D50, the fee in H1:
- Net saving on discounts only: =SUM($C$2:$C$50)-$H$1
- Net saving including delivery: =SUM($C$2:$D$50)-$H$1
- Orders needed to break even, using the average discount: =ROUNDUP($H$1/AVERAGE($C$2:$C$50), 0)
SUM over the two columns C and D adds every number in both, which is why the second formula works. Empty cells are ignored.
Does the discount apply to every item?
Often, it does not. Prescription medicines and other categories may be treated differently from wellness or personal care items. Read your invoice line by line, and record the discount from the total at the bottom, not the headline percentage on the app.
What if the membership auto-renews?
Note the renewal date as soon as you join, and the fee that will be charged. A subscription that renews silently is a recurring cost. If you track spending in SpendixAI, bills and recurring charges are something you can keep an eye on in Pro, and the statement import will show the renewal as a payment. Whether you keep it is your call.
Decision checklist after three months
- Net saving on discounts only, from the formula above.
- Net saving including delivery, if you would have used delivery anyway.
- Change in total monthly pharmacy spend since joining.
- Whether you still need the convenience, apart from money.
Scheme terms change, so reread the current terms before renewing.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

