When cousins pool money to buy land, keep a contribution register: one row per payment with the date, the person, the amount, the mode and a running total. Add a column showing each person's percentage of the total so far. It records who put in what; it does not decide ownership, which needs proper legal paperwork from a professional.
What does the register look like?
| Date | Paid by | Amount | Mode | Total so far | Paid by's share of total |
|---|---|---|---|---|---|
| 4 Jan | Cousin A | ₹2,00,000 | Bank transfer | ₹2,00,000 | 100 per cent |
| 4 Jan | Cousin B | ₹2,00,000 | Bank transfer | ₹4,00,000 | 50 per cent |
| 20 Feb | Cousin C | ₹1,00,000 | UPI | ₹5,00,000 | 20 per cent |
| 15 Mar | Cousin A | ₹1,00,000 | Bank transfer | ₹6,00,000 | See below |
The last column in the first rows is only each new payer's contribution against the running total. The table is hypothetical. For the full picture, you also need a summary that shows each person's cumulative amount.
How do you work out each person's share?
Add each person's payments, then divide by the total of all payments. Using the rows above: Cousin A paid 2,00,000 + 1,00,000 = ₹3,00,000. Cousin B paid ₹2,00,000. Cousin C paid ₹1,00,000. The total is ₹6,00,000. The shares are 3,00,000 ÷ 6,00,000 = 50 per cent for A, 33.3 per cent for B and 16.7 per cent for C, which add up to 100 per cent.
- Keep a second block called Summary, with one row per cousin.
- In it, total each person's payments.
- Divide each total by the grand total to get the percentage.
- Check that the percentages add to 100.
- Update the summary every time a payment is added.
In Excel or Google Sheets, a person's total can be found with =SUMIF($B$2:$B$100,A2,$C$2:$C$100), where column B holds names, column C holds amounts and A2 holds the person's name in the summary. Their share is =B2/SUM($B$2:$B$10), assuming the summary totals sit in B2 to B10. Format the share column as percentage.
What else should the register record?
- The seller's name and the plot description, as written in the sale papers
- The agreed price and any advance paid to the seller
- Costs of buying: broker fees, legal fees, registration costs, each with who paid
- Payments that were loans from one cousin to another, marked clearly
- Anyone who dropped out, and what happened to their money
If a payment is not a contribution to the price but a fee or an expense, keep it in its own block so percentages are not distorted. Decide beforehand whether fees are shared in the same ratio or equally.
What happens if someone pays late or pays more?
Shares move with every payment, which is the point of the running column. If one cousin pays late, they have a smaller share for now; if they catch up, the share rises. Agree in writing beforehand whether late payment attracts any adjustment, since that is a matter for the cousins to settle. The register simply reflects the truth at any date.
Who should keep it?
Choose one cousin to hold the master sheet, and let everyone see a view-only copy. Every payment is recorded within a day, with the bank reference. If you pay from your own account, SpendixAI can take your uploaded statement, let you review the rows and file the payment under a category such as Plot contribution, with each transaction keeping its account. That gives you your own side of the record, apart from the shared sheet.
Before the purchase completes
- Check the totals against every bank statement
- Get each cousin's written confirmation of their figure
- Keep receipts for any cash handed to the seller
- Take legal advice on registration before paying the final amount
Useful ideas start with a clearer picture of your own spending.
Explore your reports


