When a prescription changes in the middle of a month, keep the old figure for the days before the change and apply the new daily cost from the day it starts. That gives this month's true amount, and the new full-month figure becomes your budget from next month on. Never rewrite the earlier days.
Why not just replace the old budget?
If you overwrite the figure, last month's record no longer matches what happened, and any comparison of months is meaningless. A budget is a history as well as a plan. The cleaner way is to give each version an effective-from date and let the month be a blend of the two.
A worked example
Say the medicine budget has been ₹3,000 a month. On the 20th of a 30-day month, the doctor changes the prescription, and the new regimen costs ₹3,900 a month at the same pharmacy. Daily cost is monthly cost divided by 30, so all of this is hypothetical.
| Period | Daily cost (Rs) | Days | Amount (Rs) |
|---|---|---|---|
| 1st to 19th, old prescription | 100 | 19 | 1,900 |
| 20th to 30th, new prescription | 130 | 11 | 1,430 |
| This month blended budget | - | 30 | 3,330 |
| Next full month, new prescription | 130 | 30 | 3,900 |
₹3,000 divided by 30 is ₹100 a day, and 3,900 divided by 30 is ₹130. Nineteen days at 100 is 1,900, and eleven days at 130 is 1,430. The total for the month is 1,900 + 1,430 = ₹3,330. Next month the budget moves to ₹3,900. The earlier months stay at ₹3,000.
Notice what the blended figure does and does not tell you. It says that, on a plan basis, this month should carry ₹3,330 of medicine cost. It does not say you will pay ₹3,330 at the counter. If you bought the old medicines in full earlier in the month, part of the new cost will arrive as an extra purchase later, and a month-end review will show the gap as an actual difference, not as an error in the plan.
The days run from the 20th to the 30th inclusive, which is 11 days. Count carefully on the day the change takes effect. A common mistake is to count from the 21st.
What if the purchase happens on a different day?
The budget is prorated by days of use. The pharmacy payment depends on when you buy. If you buy the new medicine on the 18th for the whole month, your cash spend and your budget will not match this month. That is fine, as long as you know why. Note the purchase date on each payment so you can tell the two apart.
The formulas for a sheet
Put the change date in B1, the old monthly cost in B2 and the new monthly cost in B3. In Excel or Google Sheets, with a 30-day month assumed for the daily rate:
- Days at the old rate: =DAY($B$1)-1
- Days at the new rate: =DAYS(EOMONTH($B$1,0),$B$1)+1
- Blended budget for the month: =B2/30*(DAY($B$1)-1)+B3/30*(DAYS(EOMONTH($B$1,0),$B$1)+1)
EOMONTH gives the last day of the month, and DAYS counts the gap between two dates. For a change on the 20th of a 30-day month the formula returns 19 old days and 11 new days, as above. In a 31-day month, replace 30 with the real number of days, or use =DAY(EOMONTH($B$1,0)) in a helper cell.
Where does a tracker fit?
SpendixAI has budgets on Pro, and you can compare what you spent in a category with what you planned. When a prescription changes, update the monthly amount for the new month and keep a note of the date and the reason. The statement import records what you actually paid, and the daily proration is a quick sum on the side.
A short routine
- Write the change date and the new prescription on the budget sheet.
- Compute the blended figure for the month with the formula above.
- Set next month's budget to the new full-month cost, plus any buffer you keep.
- After the next two refills, check the real bills against the plan.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


