To keep track of whose money paid for a parent's medical expenses, add a 'paid from' column to your expense record and fill it for every bill: parent's pension account, parent's savings, you, or a sibling. Then add a second column for any money that came back from insurance. The ledger takes two minutes per bill and prevents the arguments that begin with 'I thought Papa paid that'.
Why does the source of funds need its own column?
Medical bills for a parent are often paid in a hurry, from whatever account is at hand. Months later, nobody is sure whether the pension covered a surgery or the child did. A tag on each bill settles it in a glance. It also helps when siblings share costs, when a parent's savings run down faster than expected and when reimbursements arrive in an account different from the one that paid.
What does the ledger look like?
| Date | Bill | Patient | Paid from | Amount | Insurer paid back | Net cost |
|---|---|---|---|---|---|---|
| 4 Aug | Cardiology consult | Mother | Mother's pension account | ₹1,500 | ₹0 | ₹1,500 |
| 12 Aug | Pharmacy | Mother | Me | ₹6,000 | ₹0 | ₹6,000 |
| 19 Aug | Scan and tests | Father | Me | ₹2,500 | ₹1,000 | ₹1,500 |
| 27 Aug | Physiotherapy | Father | Father's pension account | ₹4,000 | ₹0 | ₹4,000 |
These rows are invented. For August in this example: total paid is ₹1,500 plus ₹6,000 plus ₹2,500 plus ₹4,000 = ₹14,000. Parents' own accounts paid ₹1,500 plus ₹4,000 = ₹5,500. You paid ₹6,000 plus ₹2,500 = ₹8,500, and ₹1,000 of that came back, so your net is ₹7,500. Check: ₹5,500 plus ₹8,500 = ₹14,000.
How do you total by source of funds?
If the Paid from values sit in column D and the amounts in column E, one formula per source in Excel or Google Sheets gives the total:
- =SUMIFS($E$2:$E$500, $D$2:$D$500, "Me")
- =SUMIFS($E$2:$E$500, $D$2:$D$500, "Mother's pension account")
- =SUM($F$2:$F$500) for the total returned by insurers.
Pick one spelling for each source and use a drop-down list for the column, so the formula does not miss rows.
Is this money a gift or something to repay?
This is the question that causes the most friction later. When you pay a parent's bill from your own account, decide with them whether it is a gift or a loan to be repaid from their pension, and write the answer in a notes column on the same row. If siblings split the cost, add a monthly line showing who owes whom. Treat it as a record of what the family agreed, not a scoreboard.
What about small and cash payments?
The ledger is only trustworthy if the small items are in it too. A taxi to the clinic paid in cash, or medicines bought by a neighbour on your behalf, are easy to forget and add up over a year. Keep a note on your phone through the day and enter those rows each evening, with the source marked as cash from you or cash from the parent's purse. A parent who keeps their own envelope of cash for the pharmacy can tell you each week what was spent, and you can enter it as one row marked 'cash, parent' with the receipts clipped behind it.
Where do insurer refunds go?
A reimbursement can land in the account that paid, in the parent's account or in another account listed on the claim form. Add a row, or fill the 'insurer paid back' cell, with the date and the account that received it. If it landed in a different account from the payer, note who should pass it on.
In SpendixAI you can add each medical bill as an expense, create categories such as Medical and sub-categories for each parent, and pick the account the bill was paid from, so the tag on the bill can be seen in reports.
A quick routine
- Add a row the same day as the bill, with the source of funds.
- Attach the receipt image or note where the original sits.
- Update the row when the insurer pays back.
- Total by source on the first of every month and share it with siblings.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


