A yearly parent-support summary is a single table with categories down the side, each sibling across the top and totals at the bottom, produced once after the financial year ends in March. It tells everyone the total spent on parents, who paid what, and leaves a notes column for the context that numbers cannot carry.
What goes into the template?
Keep the categories few, otherwise nobody reads the page. Four work for most families: medical, household, travel and gifts. If one cost is large and different, such as full-time care, give it its own row. Add a column for each sibling, a total column and a notes column.
Here is a filled sample with made-up amounts for one year:
| Category | You | Brother | Sister | Total | Notes |
|---|---|---|---|---|---|
| Medical | ₹52,000 | ₹20,000 | ₹8,000 | ₹80,000 | Includes one hospital stay in August |
| Household | ₹36,000 | ₹36,000 | ₹0 | ₹72,000 | Bills, society dues, repairs |
| Travel | ₹18,000 | ₹0 | ₹12,000 | ₹30,000 | Six visits home |
| Gifts and festivals | ₹10,000 | ₹6,000 | ₹6,000 | ₹22,000 | Diwali and two family functions |
| Total | ₹1,16,000 | ₹62,000 | ₹26,000 | ₹2,04,000 | Per-sibling average ₹68,000 |
To verify: your column is 52,000 + 36,000 + 18,000 + 10,000 = ₹1,16,000. The brother's is 20,000 + 36,000 + 0 + 6,000 = ₹62,000, and the sister's is 8,000 + 0 + 12,000 + 6,000 = ₹26,000. The three add up to ₹2,04,000, the same as the sum of the row totals (80,000 + 72,000 + 30,000 + 22,000).
What should the notes column say?
Use it for facts, not feelings. A note might say that the hospital stay was a one-off, that the sister's travel was for a long journey, or that part of the household total was paid from your parents' own account. Notes stop the table from being misread. A low figure next to "stayed with Mummy for two weeks after surgery" reads very differently from the same figure on its own.
Should the table compare shares or just totals?
That depends on whether your family has agreed shares. If it has, add one more line under the total showing each sibling's agreed share in rupees and the difference. In the sample the average is ₹68,000 each, so you paid ₹48,000 more than an equal share, the brother is ₹6,000 below and the sister ₹42,000 below. Present these numbers only if everyone has agreed to an equal share in the first place.
How do you produce it each year without a weekend of work?
The work happens during the year, not in April. Give every parent-related payment a category the day it happens, or when you review the statement at month end. If you import your bank and card statements into SpendixAI, you can set categories and sub-categories for medical, household, travel and gifts, then use the Report builder to filter and group by them for the financial year and download the result as a CSV. Cash spending goes in as manual entries. Your siblings' payments are not in your statements, so ask them to send their totals by category before you finalise.
A short routine for the year
- In April, agree the categories and whether shares are equal or different.
- Every month, tag parent-related payments and add cash expenses.
- In September, share a half-year version so there are no surprises.
- In the first week of April, build the full table and add the notes.
- Send it, invite corrections for a week, and then save the final version with the year in its name.
Keep receipts for large medical items, in case an insurer or your parents ask. If any of the spending might matter for tax, ask your CA how to record it, since rules change from year to year.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


