Debt

Splitting a parent's loan EMI between siblings: a shared record

A shared sheet for siblings splitting a parent's home loan EMI: monthly contributions, notes and a quarterly reconciliation, with a three-sibling example.

Editorial illustration for Splitting a parent's loan EMI between siblings: a shared record

If you and your siblings share a parent's loan EMI, one shared sheet stops the arguments before they start. It needs the monthly EMI, what each sibling paid, a notes column and a reconciliation every quarter. Here is a three-sibling example with invented numbers, plus the formulas to copy into Excel or Google Sheets.

How do you agree the split first?

Talk about it once, honestly, and write the result. Splits are often equal, but they can follow income or other contributions, such as who is also paying for the parents' medicines. In the example, the EMI is ₹30,000 and the three siblings agreed 50 per cent, 30 per cent and 20 per cent. That is ₹15,000 for Asha, ₹9,000 for Bharat and ₹6,000 for Chitra.

What does the sheet look like?

One row per month. Columns are A month, B EMI, C Asha paid, D Bharat paid, E Chitra paid, F total received, G gap and H notes.

MonthEMIAsha paidBharat paidChitra paidTotal receivedGap
April₹30,000₹15,000₹9,000₹6,000₹30,000₹0
May₹30,000₹15,000₹9,000₹4,000₹28,000₹2,000
June₹30,000₹15,000₹9,000₹6,000₹30,000₹0

In May, Chitra paid ₹4,000 instead of ₹6,000, so the sheet shows a ₹2,000 gap. The note beside it might say, 'Chitra's laptop repair, will make up in June.' Her June payment of ₹6,000 meets that month's share but does not clear the gap, so the sheet should carry the ₹2,000 forward until it is paid or agreed otherwise.

Which formulas do the sums?

  • F2: =SUM(C2:E2) adds what the three paid.
  • G2: =B2-F2 shows the gap for that month.
  • Quarter gap, with April to June in rows 2 to 4: =SUM(G2:G4).
  • Each sibling's share due for the quarter, with 0.5 in cell K1: =SUM($B$2:$B$4)*$K$1, so for Asha 90,000 times 0.5 is ₹45,000.
  • What Asha actually paid in the quarter: =SUM(C2:C4), which here is ₹45,000.

Share the sheet with each sibling as viewers, and let one person, the treasurer, update it. Everybody sees the same numbers, and nobody argues from memory.

How do you reconcile each quarter?

Add the three months and compare, sibling by sibling, what was due and what was paid. For April to June the EMI is ₹90,000. Asha owed ₹45,000 and paid ₹45,000. Bharat owed ₹27,000 and paid ₹27,000. Chitra owed ₹18,000 and paid ₹16,000, because of May, so ₹2,000 is outstanding. Write that number at the bottom, and agree on a date for it.

What about extra costs like repairs or a prepayment?

Treat them as separate rows with their own note, such as 'Roof repair, ₹12,000, split equally', so they do not blur into the EMI total. A prepayment should be written down with the date, the amount, who paid and what the lender said it reduced.

If one sibling, such as the treasurer, imports the bank statement of the account that pays the EMI into SpendixAI, the debit and incoming transfers can be seen in one place for the quarter, and a CSV download from reports can be pasted into the shared sheet.

Decide in advance what happens if one sibling cannot pay for a while. Options include the others covering the gap and recording it as owed, or the share being reduced for an agreed period. Write the choice in the notes column, and review it at the next quarterly check.

A quarterly routine

  1. Update the sheet with all payments by the 7th of the month.
  2. At the end of the quarter, add each sibling's payments and compare with the share due.
  3. Write the outstanding amount and agree a date.
  4. Send a short summary message to the group.
  5. Keep the loan papers and the lender's statement in the same shared folder.
SPENDIXAI JOURNAL

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

Explore your reports