To tag expenses by patient, add one label for the family member, such as the person's first name, to every payment connected to their care: medicines, nurse, equipment, tests and transport. A report filtered by that label then gives the full monthly cost in one figure, even though the payments sit in different categories.
Normal categories answer 'what kind of spending was this?'. A patient label answers a different question: 'how much did this one person's care cost us?'. Both are useful, and the label is what you need when one relative is ill for a long period.
Why is a category not enough?
Take a month in which a parent's care involves medicines at the pharmacy, an attendant's pay, a rented bed and a few taxi rides. Under normal categories, those are Health, Household help, Rent and Transport. Each total is right, yet none tells you what that parent cost. The label cuts across the categories and collects them.
What does a patient-tag view look like?
| Category | Spend on the patient (₹) | Spend on others (₹) |
|---|---|---|
| Health | 9,200 | 1,400 |
| Household help | 14,000 | 3,000 |
| Equipment rent | 2,500 | 0 |
| Transport | 1,800 | 2,200 |
| Total | 27,500 | 6,600 |
These figures are invented. The patient column adds up as 9,200 plus 14,000 plus 2,500 plus 1,800, which is ₹27,500. Without the tag, you would have to go through each category by hand to find that figure.
How do you do it in a spreadsheet?
- Add a column 'For' beside the category column and fill it with a short name, such as Amma or Papa.
- Total a person for a month: =SUMIFS($D$2:$D$500, $E$2:$E$500, "Amma", $B$2:$B$500, "June"), where D is the amount, E the person and B the month.
- Break one person down by category by adding a third condition on the category column.
- Or make a pivot table with 'For' as the filter, category as rows and month as columns.
Use the same spelling every time. A data validation drop-down list on the 'For' column keeps it consistent; both Excel and Google Sheets can create one.
What if your app has no tags?
Many apps, including SpendixAI, work mainly with categories. In that case, make a sub-category per person under a health or care category, such as 'Care: Amma', and put the nurse and equipment under it as well. SpendixAI supports custom categories and sub-categories with colours, and the Report builder can filter and group so you can see a total for the sub-category by month. Check the filter options in your own view and test with one month of data.
Pick the approach that fits: if you want to keep 'Medicines' and 'Nurse' as separate categories for other reports, a person-named sub-category inside each is a little more work but keeps both views.
What about shared costs?
Some costs serve everyone, such as a bigger electricity bill from a medical device or a car used for appointments. Decide a rule once, such as tagging only costs that exist because of the patient, and keep the rest in the household. Write the rule on the first row of your sheet so anyone who adds entries follows it. When a payment is unclear, such as a pharmacy bill that covers two people, split it by item if the bill allows, or tag it to the person whose medicines make up most of it and add a short note.
A checklist to set up the tag
- Choose one short name per family member.
- Apply it to every care payment, including cash.
- Check the monthly total against the sum of the categories.
- Review at month end and fix any missing tags.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


