When you send money to a sibling for their education, decide at the start whether each transfer is a gift or a loan, and write it down where both of you can see it. A ledger with a type column, an expected return date for loans and a note you both agreed to will prevent years of fuzzy memories. Repayments are recorded as their own rows, not as income.
Why does the gift or loan label matter?
Families often skip this conversation because it feels awkward. The result is that one person thinks they gave a gift and the other thinks they owe money, usually discovered at a bad moment. Saying it once, in writing, is kinder than leaving it unsaid. You can also mix the two: a gift for the first year, a loan for the rest.
What columns does the ledger need?
| Column | What to write |
|---|---|
| Date | Date the money left your account |
| Amount | Exact amount |
| Mode and reference | UPI, NEFT or cheque, with the reference |
| Purpose | For example, first-year fee or hostel deposit |
| Type | Gift or Loan |
| Expected return | Date or schedule, if a loan; blank for a gift |
| Agreed note | One sentence you both confirmed in a message |
| Repaid so far | Total of repayments received |
| Balance | Loan amount minus repaid so far |
The agreed note might read: Fee for first semester, treated as a loan, to be returned after the first job, no interest. Send it as a message to your sibling and ask them to reply with a yes. Keep the reply.
How do I handle repayments?
A repayment is money coming back, not new income. Add it as its own row, dated and linked to the loan it repays, and subtract it from the balance. Say you lent ₹60,000 for fees in July and another ₹60,000 for the second year in January (made-up numbers), with a gift of ₹40,000 for a laptop and books.
- Loans: ₹60,000 + ₹60,000 = ₹1,20,000
- Repayments received: 6 × ₹5,000 = ₹30,000
- Loan balance: ₹1,20,000 − ₹30,000 = ₹90,000
- Gift: ₹40,000, with no balance to track
- Total sent in all: ₹1,20,000 + ₹40,000 = ₹1,60,000
In a sheet, if the repayments are listed in D5:D40 and the loan total is in B2, the balance is =B2-SUM(D5:D40). Put it in a cell near the top so that it is always visible.
What if the plan changes?
Things change: a scholarship comes in, the course is extended, a job is delayed. When that happens, do not rewrite the old row. Add a new dated note saying what was agreed now, such as the return date moved by six months, and ask your sibling to confirm in a message. You keep the full history and nobody is surprised.
Where can SpendixAI help?
The transfers appear when you import your statement, and you can put gifts and loans in separate custom categories so that you can see them apart from daily spending. The Report builder can filter by category and give you a CSV for the family. Repayments are your own notes: record them by hand and mention the loan in the description. A spreadsheet with the formula above does the balance.
Questions to settle at the start
- Is this transfer a gift, a loan or part of each?
- If a loan, is there a date or a trigger for repayment, such as a first job?
- Will there be interest? Most family loans have none, but say so.
- What happens if the course or plan changes?
- Who keeps the ledger, and how often do we both look at it?
Whether a transfer is treated as a gift or a loan can matter for tax and for family property, so check with your CA if the amount is large.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

