To log medicine brand switches, keep a small table with medicine name, brand, tablets per strip, strip price and date, then work out the cost per month from how many tablets you take. When the chemist or doctor changes the brand, add a new row rather than editing the old one, so you can see exactly what the swap did to your monthly bill.
Why bother logging brands?
On a long-term prescription the same salt can come from several brands, in different strip sizes, at different prices. The chemist may hand you a substitute when the usual brand is out of stock. The doctor may write a different brand next time. You pay and move on, and three months later the monthly figure has crept up or down without anyone telling you.
Whether to switch brands is a decision for your doctor and chemist. The log does not judge it. It only tells you what changed and what it cost.
The table to keep
One row per purchase or per change. Use these columns: Medicine (the name on the prescription), Brand, Tablets per strip, Strip price, Doses per day, Date, and Note (who suggested the change).
Fill the strip price from the bill, never from memory or from a website. Prices on a bill are what you paid, and that is the only price this log cares about.
A worked example with two medicines
Say a prescription has two long-term tablets. All figures here are hypothetical and use a 30-day month.
| Medicine | Brand | Tablets per strip | Strip price (Rs) | Doses per day | Strips per month | Monthly cost (Rs) |
|---|---|---|---|---|---|---|
| Medicine A | Brand X | 10 | 120 | 1 | 3 | 360 |
| Medicine A | Brand Y (after switch) | 10 | 95 | 1 | 3 | 285 |
| Medicine B | Brand P | 15 | 210 | 2 | 4 | 840 |
| Medicine B | Brand Q (after switch) | 15 | 245 | 2 | 4 | 980 |
Here is how each line works. Medicine A: 1 dose a day for 30 days is 30 tablets, which is 3 strips of 10. At ₹120 a strip that is ₹360, and at ₹95 it is ₹285, so the switch saves ₹75. Medicine B: 2 doses a day for 30 days is 60 tablets, which is 4 strips of 15. At ₹210 a strip that is ₹840, and at ₹245 it is ₹980, so the switch costs ₹140 more.
Together the monthly cost moved from 360 + 840 = ₹1,200 to 285 + 980 = ₹1,265, an increase of ₹65. One medicine got cheaper and the other more expensive, so looking at only one of them would have told you the wrong story.
How do I calculate this in a sheet?
With Tablets per strip in C, Strip price in D, Doses per day in E, and 30 days assumed, in Excel or Google Sheets:
- Strips per month in F2: =ROUNDUP(E2*30/C2, 0)
- Monthly cost in G2: =F2*D2
- Total across the current brands, when column H marks the current row with "Current": =SUMIFS($G$2:$G$200, $H$2:$H$200, "Current")
ROUNDUP matters because you cannot buy part of a strip. If the chemist sells loose tablets, adjust the formula, and check how you actually buy.
Who suggested the change, and does it matter?
Yes, write it down. If the doctor changed the brand, the next prescription will usually carry the new one. If the chemist substituted, ask what it was and why, and mention it at your next consultation so the doctor's records stay current. Never change a prescribed medicine yourself because the price looks lower.
Keeping the totals honest in your monthly records
The monthly pharmacy payment, usually by UPI or card, is what shows in your statement. If you use SpendixAI, that payment is categorised under your Health category as usual. The strip-level detail is a separate small sheet, and you can compare its monthly figure with the amount in the statement to see whether the chemist billed anything else.
A quick routine
- Keep every pharmacy bill, or a photo of it, for the month.
- Update the table only when a brand or price changes.
- Once a quarter, recompute the monthly cost and note the change.
- Take the table to your doctor if you have questions about substitutes.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


