Home and property

A family fund for the house: monthly contributions by group

A simple monthly ledger for a family house fund: recording each household's contribution, logging bills paid and posting a balance.

Editorial illustration for A family fund for the house: monthly contributions by group

A family fund for the house works when it has three lists: contributions in, bills out, and a balance posted on the same date every month. Anyone in the group should be able to open the sheet, find their own row and see what the common money did that month.

What is a family fund for, and what is it not for?

Use it for costs the whole family agrees to share: property tax, electricity and water for the common house, a caretaker's salary, small repairs, festival whitewashing. Do not use it for one household's personal spending or for loans between members. Mixing those in is the quickest way to lose trust. Write the purpose in one sentence at the top of the sheet, and add a line saying who can propose a spend and who approves it.

How do you set the monthly contribution?

Count the yearly bills first, then divide. Say the house needs ₹1,20,000 across the April to March year for tax, electricity, water, the caretaker and small repairs. Divide by twelve and the fund needs ₹10,000 a month. With four contributing households that is ₹2,500 each; with five it is ₹2,000 each. Add a small cushion, perhaps one month's worth, if the group agrees, because bills never arrive evenly.

Groups can also be unequal on purpose. A family may agree that the eldest branch, which uses the house most, pays a larger share. Record the agreed weights in a table at the top so the reason is always visible.

What does the contribution ledger look like?

MonthGroupDue (₹)Received (₹)DatePending (₹)
JuneBranch A3,0003,00003 Jun0
JuneBranch B3,0003,00005 Jun0
JuneBranch C2,0001,00010 Jun1,000
JuneBranch D2,0000-2,000

The figures are hypothetical. Due totals ₹10,000, received ₹7,000, pending ₹3,000. If Pending is =C2-D2 in each row, a total at the bottom shows the shortfall in one glance.

What goes in the outgoing ledger?

  • Date, payee and bill type.
  • Amount and how it was paid.
  • The month the bill covers, because an electricity bill paid in July usually belongs to June.
  • A photo or PDF of the bill or receipt, saved in a shared folder with the date in the file name.
  • The name of the person who paid and the person who approved.

Pay from one account. If the person managing it pays from a personal account first and recovers later, record that as a reimbursement row so the money can be traced.

How should the monthly balance be posted?

The formula is simple: opening balance plus contributions received minus bills paid equals closing balance. Using small invented numbers, an opening balance of ₹12,000, plus ₹7,000 received, minus ₹8,400 paid gives ₹10,600. Post this in the group on the same date each month, say the 5th, with a one-line list of pending contributions by branch name, not by individual.

The closing balance should equal the account balance on the statement. A mismatch usually means a cash payment missing from the sheet or a bill paid from someone's pocket that was not logged.

When does an app help?

A shared sheet is enough for most family funds. If the person managing it also wants the fund's account in the same place as their own money, SpendixAI can hold the fund as a separate account, import its statement and show the fund's categories apart from household ones. Bill splitting between households is outside what it does, so keep that table in your sheet.

What to review every year

  1. Compare the actual year's bills with the estimate and reset the monthly amount.
  2. Decide what to do with any leftover balance.
  3. Check the list of who is in the contributing groups, since families change.
  4. Archive the year's sheet and bills in one folder before April begins.
SPENDIXAI JOURNAL

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

Explore your reports