When you buy three months of medicines in one go, record the payment on the day you paid, then spread the cost across the three months it covers in a separate monthly view. This stops your health line showing one huge month followed by two empty ones, and gives you a monthly figure you can budget with.
Why a bulk purchase distorts your months
Many people with long-term prescriptions buy a quarter's supply at a time, to save trips or use a discount. In your bank statement, the whole amount sits in one month. A monthly report then shows a spike in the month of purchase and nothing for the next two, so budgets look broken and comparisons between months mean little.
There are two views of the same money. The cash view says when it left your account. The allocation view says which months of treatment it paid for. Keep both, and be clear which one you are looking at.
A worked example
Say you buy ₹7,800 of medicines on 3 October to last October, November and December. Divide by three: 7,800 / 3 = ₹2,600 a month. In November you also buy a ₹450 cough remedy that is not part of the stock-up.
| Month | Cash paid (Rs) | Allocated from the stock-up (Rs) | Other purchases (Rs) | Monthly health line (Rs) |
|---|---|---|---|---|
| October | 7,800 | 2,600 | 0 | 2,600 |
| November | 450 | 2,600 | 450 | 3,050 |
| December | 0 | 2,600 | 0 | 2,600 |
| Total | 8,250 | 7,800 | 450 | 8,250 |
The cash totals and the allocated totals agree, at ₹8,250 across the quarter. Only the timing differs. The monthly health line of ₹2,600, ₹3,050 and ₹2,600 is a much more honest picture of care than the cash view of 7,800, 450 and 0.
How should the cost be split?
Equal thirds is the simplest and is fine when the monthly doses are the same. If a medicine is taken only in some months, or a dose changes, allocate by what each month actually uses. When the total does not divide evenly, round the first two months and let the last one take the difference. For example, ₹7,850 would become 2,617, 2,617 and 2,616.
In Excel or Google Sheets, with the total in B2 and the first month's date in B3:
- Monthly share, rounded: =ROUND($B$2/3, 0)
- Last month's share, so the sum is exact: =$B$2-2*ROUND($B$2/3, 0)
- Month labels, starting from the purchase month: =EDATE($B$3, 1) in the next row, then copied down
What if a prescription changes in the middle?
Then the stock-up covers fewer months than you planned, or the medicines are not used. Update your allocation to reflect what you actually consumed, and note the leftover quantity. Unused medicines are still money spent, and they come back later as a refill you do not need to buy. Ask your doctor or pharmacist before using leftover stock after a change.
How does this look in an expense tracker?
In SpendixAI, a statement import records the payment on the date it went out of your account, which is the cash view. The monthly allocation view is a small sheet or note you keep alongside it. You can add a note to the transaction such as "covers Oct to Dec", so that when you see the large amount a month later, you remember why.
Quick routine for each bulk purchase
- Photograph the bill and write the months it covers on the photo.
- Divide the total by the number of months, or allocate by use.
- Add a reminder for the last week of the third month to plan the next purchase.
- Check the expiry dates on arrival and note the earliest.
- At the end of the quarter, compare the allocation with what you actually used.
Useful ideas start with a clearer picture of your own spending.
Explore your reports
