A dementia care expense tracker works best as one monthly sheet with fixed lines: attendant pay, medicines and supplies, day-care, doctor and transport costs, and home safety changes, plus a separate block for one-time items. Fill it from what you actually paid, then look at the same lines month after month so changes in need show up as numbers, not as a feeling of money going out.
Which lines does the sheet need?
Start with the ongoing costs of caring for someone with memory loss, and keep one-time costs apart so they do not distort the monthly figure.
- Attendant or caregiver pay, including any festival gift or leave replacement you agreed.
- Medicines and medical supplies, as prescribed by the treating doctor.
- Day-care or activity centre fees, if used.
- Doctor consultations, tests and transport to appointments.
- Food and household extras that changed because of the care.
- Home safety changes, kept in their own one-time block.
What does a month look like with sample figures?
The amounts below are made up to show the layout, not typical costs. Replace them with your own.
| Line | Amount this month |
|---|---|
| Attendant pay | ₹18,000 |
| Medicines and supplies | ₹4,200 |
| Day-care fees | ₹6,500 |
| Doctor visit and transport | ₹2,000 |
| Extra food and household items | ₹1,800 |
| Total | ₹32,500 |
Check: ₹18,000 plus ₹4,200 is ₹22,200; plus ₹6,500 is ₹28,700; plus ₹2,000 is ₹30,700; plus ₹1,800 is ₹32,500.
How do you total each line automatically?
Give every payment its own row in a log with the date in column A, the line name in column B and the amount in column D. Put the month's first date in G1 and the last date in G2. Then, in Excel or Google Sheets, one formula per line reads from the log:
- =SUMIFS($D$2:$D$500, $B$2:$B$500, "Medicines and supplies", $A$2:$A$500, ">="&$G$1, $A$2:$A$500, "<="&$G$2)
- =SUMIFS($D$2:$D$500, $B$2:$B$500, "Attendant pay", $A$2:$A$500, ">="&$G$1, $A$2:$A$500, "<="&$G$2)
- =SUM(H2:H6) to add the five line totals once they sit in H2 to H6.
The first argument is the range to add, followed by pairs of a criteria range and its condition. Type the line names exactly alike every time, or the totals will miss rows.
What counts as home safety, and how do you record it?
Record changes made to the home because of the illness: grab bars, door sensors or locks, better lighting, non-slip flooring, a bed that is easier to get out of. Ask the doctor or care team what is suitable for your relative, because needs differ from person to person. Put each item in a one-time block with the date, the shop or installer, the cost and where the bill is filed. Keep warranties with the bill.
How should the attendant's pay be recorded?
Write the agreed monthly amount, the payment date and the mode in the log, and note advances separately so you can see what is already paid. Agree leave and notice terms with the attendant in plain words, and write what was agreed in the sheet's notes. If you pay an agency, keep its invoice or receipt. Do not give the attendant's pay a catch-all label such as 'misc', since it will be your largest line.
Where does a sheet stop being enough?
When many small payments by cash and UPI pile up, typing each one gets tiring. SpendixAI lets you add several expenses by hand at once, handy for cash, and lets you build custom categories such as Attendant or Medicines, so monthly totals come from reports. Until then, the sheet above is enough.
Closing checklist
- Create the five monthly lines and the one-time block.
- Log each payment on the day you make it.
- File every bill and receipt with the same date.
- Total the month on the same date each time.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

