When siblings pool money to buy a flat for their parents, the safest habit is to record every rupee each person puts in, with the date, the amount, the mode of payment and what it was for. A ledger does not decide who owns what, but it gives you and a lawyer the facts to discuss.
Why a ledger matters even among close siblings
Flat purchases run over many months: a booking amount, stage payments, registration, stamp duty, brokerage, interiors. Each sibling pays at a different time, some from savings, some from a loan, some in cash from a parent's gift. Memory fades faster than a purchase completes. Five years later, a question such as "did I put in the second instalment or did you?" turns into a quarrel only because nothing was written down.
What should each row record?
- Date the money left your account.
- Who paid, using full names as in the agreement.
- Amount in rupees.
- Mode: UPI, NEFT, IMPS, cheque, cash or a loan disbursement.
- Paid to whom: builder, seller, registrar, broker.
- Purpose: booking, instalment, stamp duty, registration, brokerage, repair.
- Source of funds, in a few words: own savings, home loan, gift from parent.
- Where the proof sits: receipt, bank statement line or builder's demand letter.
A sample layout
| Date | Paid by | Amount (₹) | Mode | To | Purpose |
|---|---|---|---|---|---|
| 02 Jun | Arun | 2,00,000 | NEFT | Builder | Booking |
| 18 Jul | Bhavna | 3,00,000 | NEFT | Builder | First instalment |
| 18 Jul | Arun | 1,00,000 | NEFT | Builder | First instalment |
| 05 Sep | Chetan | 1,50,000 | Cheque | Registrar | Stamp duty and registration |
The figures are invented for illustration. Total paid so far is ₹2,00,000 + ₹3,00,000 + ₹1,00,000 + ₹1,50,000 = ₹7,50,000. By sibling: Arun ₹3,00,000, Bhavna ₹3,00,000, Chetan ₹1,50,000.
How do you show each person's share of what has been paid?
Divide each sibling's total by the grand total. In the example, Arun has put in 3,00,000 out of 7,50,000, which is 40 percent. Bhavna is also 40 percent. Chetan is 20 percent. Add a column to your sheet that does this after every new row, so the split is always current. In Excel or Google Sheets, if the amounts are in column C and names in column B from row 2 to row 200, the total for one sibling can be =SUMIF($B$2:$B$200, "Arun", $C$2:$C$200), and the grand total is =SUM($C$2:$C$200).
A percentage of money paid is a record of contribution. It is not automatically a percentage of ownership, and it is not necessarily what the family intends.
What about gifts, loans between siblings and the parents' own money?
Add a column for the nature of each contribution. Is it a gift to the parents, a loan to be repaid, or a stake meant to be recognised later? Write what the family said at the time, in plain words, and ask each sibling to confirm in a message. If parents put in money, record their rows in the same ledger. Do not guess the legal effect; the purchase documents, who is named as owner and how the property is held decide that, and a lawyer or CA can explain the consequences, including tax and stamp-duty questions.
Where does an expense tracker fit?
For the purchase ledger, a shared sheet is the right tool. Alongside it, SpendixAI can help each sibling keep their own outgoing payments tidy: upload the bank statement, tag the builder's instalments with their own category, and keep the receipt with the transaction so the proof is already attached when you fill the ledger.
Ten-minute monthly routine
- Add any new payment rows with proof.
- Check the sheet totals against each sibling's own bank statement.
- Note any change in the plan, such as a new loan or a revised stage payment.
- Share a screenshot or PDF of the sheet with every sibling and the parents.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

