Health and family

Medical costs for both sets of parents: one tracker, two tags

How to track medical expenses for in-laws and parents in one record using a family label, so the household sees what supporting each side costs.

Editorial illustration for Medical costs for both sets of parents: one tracker, two tags

To track medical expenses for in-laws and parents together, keep one record with a 'Family' column that says whose parent each cost belongs to, for example 'Mine' and 'Partner's'. Fill the column for every medical row, and use a total per label to see what each side costs. One sheet, one label, no duplicate files, and no need to ask who paid for what.

Why one sheet instead of two?

Two separate sheets start well and drift. One partner updates theirs, the other forgets, and months later you cannot say what the household spent on medical care altogether. A single record with a clear label answers three questions without extra work: what did the household spend on medical care, what did each side cost, and who paid.

What columns make it work?

  • Date of the expense.
  • Person it was for, for example Father, Mother, Partner's father.
  • Family label: Mine or Partner's, chosen from a drop-down list so spelling stays the same.
  • Type: doctor, tests, medicines, hospital, transport.
  • Amount in rupees.
  • Paid by and from which account.
  • Receipt kept: yes or no, with the folder name.

In Excel or Google Sheets, set up the Family column with data validation so only the two labels can be typed. That alone prevents most bookkeeping errors.

How do you total each side?

If the Family label is in column C, the amount in column E and the date in column A, then these formulas work in Excel and Google Sheets. Put the month's first date in H1 and the last date in H2.

  • =SUMIFS($E$2:$E$500, $C$2:$C$500, "Mine", $A$2:$A$500, ">="&$H$1, $A$2:$A$500, "<="&$H$2)
  • =SUMIFS($E$2:$E$500, $C$2:$C$500, "Partner's", $A$2:$A$500, ">="&$H$1, $A$2:$A$500, "<="&$H$2)

Say a month has these invented rows: my parents' doctor visit ₹4,200 and medicines ₹5,200; partner's parents' tests ₹2,300 and medicines ₹4,500. My side: ₹4,200 plus ₹5,200 = ₹9,400. Partner's side: ₹2,300 plus ₹4,500 = ₹6,800. Together: ₹9,400 plus ₹6,800 = ₹16,200.

What do a few filled rows look like?

DatePersonFamilyTypeAmountPaid by
3 NovFatherMineDoctor₹4,200Me, savings account
8 NovMotherMineMedicines₹5,200Me, credit card
11 NovPartner's fatherPartner'sTests₹2,300Partner, UPI
19 NovPartner's motherPartner'sMedicines₹4,500Partner, cash

Keep a Paid by column even though the Family column says whose parent it is. A cost for your parents can be paid by your partner and the other way round, and the record should show both facts. When a parent lives in another city and a relative pays locally, enter the relative as the payer and settle the amount later, noting the date you repaid.

What about costs that belong to both sides?

A taxi that took both sets of parents to the same clinic, or a family doctor's visit for everyone, cannot be labelled with one side. Decide the rule once, for example splitting it in half, and enter two rows of equal size, one for each label. If you leave a third label such as 'Both', the totals for each side will quietly be understated.

Can the same idea work in an app?

Yes. In SpendixAI you can create a Medical category with sub-categories such as My parents and Partner's parents, and see the totals for each sub-category in reports. A sheet with a Family column does the same thing.

Setting it up in an evening

  1. Create the columns and the Family drop-down.
  2. Add last month's medical payments from your statements.
  3. Enter the two SUMIFS totals on a summary tab.
  4. Agree the rule for shared costs with your partner.
  5. Review the totals together once a quarter.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports