Life events

Paying a sibling’s education: gift or loan, log it either way

Paying for a sibling's education? Decide if it is support or a loan, write a one-line understanding and log each payment by date. Formula inside.

Editorial illustration for Paying a sibling’s education: gift or loan, log it either way

If you are paying for a brother's or sister's education, decide early whether the money is support or a loan to be repaid, write that in a single line, and record every payment with its date. The label can be changed later by agreement, but a record that starts on the first day avoids arguments and confusion about what was understood.

Should I treat it as a gift or a loan?

That is a family decision, not a bookkeeping one. Some people pay as support with no expectation of return. Others expect repayment after the sibling starts earning, fully or partly. Many land in between: repay whatever you can, when you can. Whichever it is, say it out loud once and write it down. Use plain words, for example, "Support for the BCom course, not to be repaid" or "Loan to be repaid in instalments after the first job, amount to be agreed".

What should the record look like?

Here is an invented set of payments for one year.

DateWhat forAmountTag
10 JulyFirst semester fee₹45,000Sibling education
15 JulyHostel deposit and fee₹18,000Sibling education
2 AugustBooks and lab kit₹4,500Sibling education
8 JanuarySecond semester fee₹45,000Sibling education

The total is ₹45,000 + ₹18,000 + ₹4,500 + ₹45,000 = ₹112,500. Keep the fee receipts and the college's confirmation with each row.

How do I track repayments if it is a loan?

Use two columns in a sheet: amount paid by you in column C and amount repaid in column D, starting at row 2. A running balance in column E is:

  • Row 2, balance after each entry: =SUM($C$2:C2)-SUM($D$2:D2)
  • Fill this formula down. Each row then shows what is still owed up to that date.
  • Total still to be repaid: =SUM($C$2:$C$200)-SUM($D$2:$D$200)

With the example above and a repayment of ₹10,000, the balance is ₹112,500 − ₹10,000 = ₹102,500. If the arrangement is support, leave column D empty and use the sheet only as a record.

How do I talk about it without making it awkward?

Pick a calm moment, not a fee deadline. Say what you are planning, ask what your sibling expects, and listen. Offer to share the record if they want to see it. Many siblings feel more comfortable when the expenses are visible and written, because nobody has to guess. If your parents are also contributing, agree who pays which items so fees are not paid twice. A one-line message after each payment, such as "Paid second semester fee today, receipt attached", keeps everyone informed without a long conversation.

What if we change our minds?

Plans change. A sibling may fall ill, or a job may come late, or you may decide to waive repayment. Add a dated note to the record: "On 5 March we agreed to treat the balance as support". Do not rewrite old rows. Adding a line keeps a clear history, which is the point.

Where does SpendixAI fit?

SpendixAI records the payment itself: import the bank statement, put the fees in a category such as Sibling education, and keep the fee receipts with the transactions. It does not track money owed to you, so the repayment balance stays in your sheet. That split works well: the app for the expenses, the sheet for the understanding.

Before the next fee is due

  1. Write the one-line understanding and share it with your sibling.
  2. Record the date, amount and purpose of each payment.
  3. Keep fee receipts in one folder.
  4. Review the position at the end of every academic year.
SPENDIXAI JOURNAL

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

Explore your reports