Home and property

A jointly owned family flat: tracking maintenance contributions

Track joint property expenses in a family flat: a month-by-month contribution table, a running balance per owner and the formulas to keep it correct.

Editorial illustration for A jointly owned family flat: tracking maintenance contributions

For a jointly owned family flat, keep one table with a row for each month: the total expense, each owner's share, what each owner actually paid and a running balance for each. The balance shows who is ahead and who is behind at any time, so nobody has to rely on memory or goodwill. It works for maintenance, repairs and any shared cost.

What should the table look like?

Say three siblings own a flat in equal thirds. One of them, A, pays the bills from their own account and the other two send their share. These numbers are only an illustration.

MonthExpense paid by AShare eachB sentC sentB owesC owes
April₹4,500₹1,500₹1,500₹0₹0₹1,500
May₹10,500₹3,500₹3,500₹2,000₹0₹3,000

The April expense is society maintenance of ₹4,500, so each share is 4,500 ÷ 3 = ₹1,500. In May, maintenance of ₹4,500 plus a repair of ₹6,000 gives ₹10,500, and each share is 10,500 ÷ 3 = ₹3,500. C owed ₹1,500 from April, paid ₹2,000 in May, and owes 1,500 + 3,500 − 2,000 = ₹3,000 now.

Which formulas keep it correct?

In a spreadsheet, put the headings in row 1. Use column A for the month, B for the expense, C for each share, D for what B sent, E for what C sent, F for what B owes and G for what C owes. Then use these formulas, which work in Excel and Google Sheets.

  • Share each, in C2: =B2/3
  • B owes for the first month, in F2: =C2-D2
  • B owes for later months, in F3: =F2+C3-D3
  • C owes for the first month, in G2: =C2-E2
  • C owes for later months, in G3: =G2+C3-E3

Copy F3 and G3 down the column. A negative number means the owner has paid more than their share so far.

What if the shares are not equal?

Put each owner's share, as a decimal or a percentage, in a cell at the top, and multiply the expense by that cell. For example, if B holds 30 percent and the share is in J1 as 0.3, B's share is =$B2*$J$1. Whatever split you use, write it at the top of the sheet, and have every owner confirm it.

What goes into the running balance?

  • Regular costs such as society maintenance and utilities paid for the flat.
  • Repairs and replacements, with the bill attached.
  • Any amount an owner paid out of pocket on behalf of the others.
  • Money received from rent or a tenant, if the flat is let out, kept on a separate line so the arithmetic stays clear.

How do you keep it in your own records?

Your own books should show your share of the cost, not just the whole bill. If A paid the whole ₹10,500 in May and received ₹3,500 from B and ₹2,000 from C, then A received 3,500 + 2,000 = ₹5,500 and the net outlay is 10,500 − 5,500 = ₹5,000. That is A's own ₹3,500 share plus the ₹1,500 that C has not yet sent for the month. Record the payment, then the money received as reimbursement, so the net figure is clear. In SpendixAI, you can add the payment, attach the bill to the transaction and note the reimbursements, so that your report shows the real cost to you.

A closing checklist

  • The split written at the top and agreed by every owner.
  • A row for each month, with the bill attached.
  • Balances reviewed together at fixed intervals.
  • Contributions paid by transfer where possible.
  • If ownership, rent or tax questions come up, ask a CA or a lawyer, because rules and limits change.
SPENDIXAI JOURNAL

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

Explore your reports