A parent support tracker is a single list of every rupee sent or spent on your parents: fixed transfers, medicines, bills you paid for them and one-off gifts, with a column for who paid. A monthly total shows the real figure, and a sibling-share cell shows at year end whether the split you agreed is the split that happened.
What should each row record?
| Column | Heading | Example |
|---|---|---|
| A | Date | 5-Nov-2026 |
| B | Type | Fixed transfer, Medicines, Bill, One-off gift, Settlement |
| C | Description | Monthly transfer, pharmacy, electricity |
| D | Mode | UPI, NEFT, cash, paid at counter |
| E | Amount (₹) | 15,000 |
| F | Paid by | Me, Sibling 1, Sibling 2 |
| G | Bill or note | Pharmacy bill kept, photo in shared folder |
Use the same names in column F every time, and the same type labels in column B. A drop-down avoids spelling differences. Settlements, where one sibling pays another to even things out, are a separate type so they do not count as spending on parents.
How do I get the monthly total and each person's share?
Put the start of the period in K1 (say 1 April 2026) and the end in K2. Then list names in J4:J6 and use:
- Total spent in the period: =SUMIFS($E$2:$E$500, $B$2:$B$500, "<>Settlement", $A$2:$A$500, ">="&$K$1, $A$2:$A$500, "<="&$K$2)
- Paid by one person: =SUMIFS($E$2:$E$500, $F$2:$F$500, J4, $B$2:$B$500, "<>Settlement", $A$2:$A$500, ">="&$K$1, $A$2:$A$500, "<="&$K$2)
- Agreed share in K4 as a percentage, for example 50%
- Fair amount: =total*K4
- Difference: =paid by person - fair amount
A positive difference means that person paid more than their share; a negative one means they paid less.
What does one month look like?
Say in one month you send a fixed ₹15,000, your sibling pays the pharmacy ₹3,200, you pay the electricity bill of ₹1,800, and your sibling sends a one-off ₹5,000 for a family function.
| Item | Paid by | Amount |
|---|---|---|
| Fixed transfer | Me | ₹15,000 |
| Medicines | Sibling | ₹3,200 |
| Electricity | Me | ₹1,800 |
| One-off gift | Sibling | ₹5,000 |
Total is 15,000 + 3,200 + 1,800 + 5,000 = ₹25,000. You paid ₹16,800 and your sibling ₹8,200. With an equal split, each fair share is ₹12,500, so you paid ₹4,300 above your share and your sibling ₹4,300 below. The numbers are invented, but the same arithmetic works for any month.
What if one of us sends money from abroad?
Add two columns: amount in the foreign currency and the rate you actually got on that transfer, taken from the transfer receipt. The rupee amount is =amount x rate. Do not use a rate from the internet, because the amount that reached your parents is the one that counts. Where a currency is involved, SpendixAI can hold each expense in its own currency, with totals in a base currency using the rate saved with the transaction.
Should the split be equal?
That is for the family to decide, and the sheet takes no side. Some siblings split equally, some by income, some by who lives closer and gives time instead of money. Put the percentage in a cell, so changing the agreement later changes every figure. Review the year-end difference together and settle with a transfer recorded as a Settlement row.
How can I keep this easier?
- Enter each payment the day you make it, from the UPI confirmation.
If many of those payments appear in your bank statement, SpendixAI can import the statement and let you review the rows before saving; the sheet is then left for the sibling split.
What if a sibling pays in cash?
Ask for a short message with the date and amount, or write the entry yourself and ask them to confirm it. Cash with no trail is the main reason these splits turn into arguments at year end. A shared folder for photos of bills, and a rule that every entry has a date and a name, keeps the sheet believable to all of you.
Year-end checklist
- Dates set to your financial year, April to March
- Paid-by names consistent
- Differences reviewed with siblings
- Settlement rows added and totals rechecked
Useful ideas start with a clearer picture of your own spending.
Explore your reports


