Elder care is easiest to track in three layers: what is paid every month, what changes from month to month, and what comes once a year. Record each layer separately and compare three months at a time, because one month on its own is misleading when a parent's needs change.
What is the fixed layer?
The attendant's salary, a monthly allowance for your parents, a regular tiffin or grocery delivery. Set these up once, note the due date and the payment mode, and tick them off each month. If any has a rise coming, such as an annual salary revision you have agreed, write the effective date.
What is the variable layer?
Supplies, equipment, taxi rides for hospital visits, helper overtime, a short stay by a relative. These change with how the parent is doing. Look at them closely, because a sudden rise here is often the first sign that needs have shifted.
What is the yearly layer?
Items that recur once a year or so: a health check-up, a parent's insurance premium, annual maintenance of a medical device, a long visit home. If they add up to ₹24,000 a year, setting aside ₹2,000 a month keeps them from landing as a shock.
What does a three-month view look like?
Say the fixed layer is ₹25,000 a month: ₹15,000 for an attendant and ₹10,000 sent to parents. Variable items were ₹4,200 in month one, ₹6,800 in month two and ₹2,500 in month three, plus ₹2,000 a month set aside for yearly items.
| Month | Fixed | Variable | Yearly set-aside | Total |
|---|---|---|---|---|
| One | ₹25,000 | ₹4,200 | ₹2,000 | ₹31,200 |
| Two | ₹25,000 | ₹6,800 | ₹2,000 | ₹33,800 |
| Three | ₹25,000 | ₹2,500 | ₹2,000 | ₹29,500 |
The three totals are 31,200, 33,800 and 29,500, which add up to ₹94,500. Divided by three, the average is ₹31,500 a month. If month four comes in at ₹40,000, you can tell at once that it is about ₹8,500 above the usual.
In a spreadsheet, put the three monthly totals in B2, B3 and B4 and use =AVERAGE(B2:B4) to see the same figure.
How do I spot that something has changed?
- Variable items rise two months in a row.
- A new recurring item appears, such as a second attendant shift.
- Travel and taxi costs climb because of more hospital visits.
- Medicines grow, which belongs in Health but may explain the rest.
When one of these shows up, talk to the family early about the next three months, instead of waiting for the end of the year.
What should the monthly review ask?
- Were the fixed payments all made, and on time?
- What was the variable total, and what drove it?
- Did the yearly set-aside go aside?
- Who else contributed, and what is pending?
- Does anything need a conversation with a sibling or doctor?
Making the routine stick
When the entries grow beyond what a sheet handles comfortably, SpendixAI can import your bank statements, keep elder care in a custom category with sub-categories, and let you run a filtered report by month. Pro also includes budgets, bills and savings goals, which suit the yearly set-aside.
What about cash payments to the attendant?
Write the month, the amount and the days worked at the time you hand it over, and ask the attendant to acknowledge it with a message. If leave or extra days are agreed, note them in the same entry. These small notes settle most misunderstandings about salary later.
A monthly reminder list
- Pay and tick off the fixed layer.
- Log variable items weekly.
- Add to the yearly pot.
- Review three months at a time.
Revisit the three layers once a year. The fixed layer tends to grow slowly, the variable layer swings with health, and the yearly layer is the easiest to overlook.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


