To budget monthly medicine costs for two elders, add up each person's pharmacy receipts for the last three months, divide by three to get an average, then add a buffer line for prescriptions that appear unexpectedly. Work from real receipts, not from what you think the strips cost.
Start with the receipts, not a guess
Chronic medicines look predictable, but the bills are not. A chemist may bill on different days, an antibiotic course shows up one month, a cream or a pain tablet another. Pull out the last three months of bills, or the UPI and card entries for the chemist, and sort them by person. If you pay in cash and have no receipts, start recording now and use a rough figure for a month or two.
A worked example for two elders
Say the pharmacy receipts, in made-up amounts, come to the following.
| Person | Month 1 | Month 2 | Month 3 | Three-month total | Monthly average |
|---|---|---|---|---|---|
| Elder A | 3,200 | 3,450 | 3,200 | 9,850 | 3,283 |
| Elder B | 2,100 | 2,100 | 2,650 | 6,850 | 2,283 |
| Both | 5,300 | 5,550 | 5,850 | 16,700 | 5,567 |
Elder B's Month 3 included an extra short course, so the amount went up. The average across both elders is 16,700 divided by 3, which is ₹5,567 a month. Notice that the highest month, ₹5,850, is above the average. That gap is exactly what a buffer is for.
How big should the buffer be?
There is no correct percentage. One simple way is to pick a round proportion you are comfortable with, say 10%. Ten per cent of 5,567 is about ₹557. Adding the two gives ₹6,124, which you might round to ₹6,100 a month. If a prescription suddenly changes in an elder's care, the buffer is the money you draw on before you change the plan.
If you prefer a data-based buffer, look at the difference between your highest month and the average over a longer period, six or twelve months. Two or three bad months is a small sample, so revisit the number as you collect more.
What are the lines of the budget?
- Regular medicines for Elder A, taken from the prescription and the refill pattern
- Regular medicines for Elder B
- Occasional medicines: seasonal infections, pain relief, ointments
- Supplies: test strips, gloves, dressings (see them as their own line if the amount is regular)
- Buffer for new prescriptions or dose changes
Give each line an owner, meaning who pays it, if more than one family member contributes. A budget that nobody owns is a figure on paper.
How do I set this up in a sheet?
List each person's monthly pharmacy total in separate rows. In Excel or Google Sheets, with Elder A's three months in B2:D2:
- Three-month average for Elder A: =AVERAGE(B2:D2)
- Buffer at 10 per cent, with the combined monthly average in F4 and the buffer in F5: =ROUND(F4*0.1, 0)
- Monthly budget in F6: =F4+F5
Change the 0.1 to whatever suits you. Update the sheet each quarter with the latest three months.
Where does the app come in?
If you track spending in SpendixAI, monthly pharmacy payments can sit under a Health category with a sub-category per person, and budgets are part of Pro. You can also add cash medicine purchases by hand so the budget is not missing the shops that do not take UPI.
Review checklist
- Every quarter, replace the oldest month with the newest.
- When a doctor changes a prescription, note the date and the new strip prices.
- If an elder moves between cities or pharmacies, record the change and review the budget.
- Keep the buffer visible, and top it up before it runs out rather than after.
The budget only tracks what you spend. Which medicines the elders take is a matter for their doctors.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

