Spreadsheets

Joint family expense sheet: Excel format with member contributions

A joint family expense sheet in Excel: one row per earning member, a common pool for kitchen and utilities, and a contribution versus agreed share column.

Editorial illustration for Joint family expense sheet: Excel format with member contributions

A joint family expense sheet works best with three parts: a Members tab with one row per earning member and the contribution each has agreed, a Pool ledger for shared spending such as kitchen, utilities and elders' medicine, and a private tab for each household's own costs. The key column compares what each member has put in against what was agreed.

What does the Members tab look like?

Each earning member gets a row. Say three brothers have agreed monthly contributions to the common pool:

MemberAgreed (₹)Cash put in (₹)Paid for pool directly (₹)Total credited (₹)Gap (₹)
Arun30,00030,000030,0000
Bhaskar20,00012,0008,00020,0000
Chandu15,00015,000015,0000
Total65,00057,0008,00065,0000

The agreed amounts are a family decision. Some families divide by income, some by number of household members, and some use a fixed amount. The sheet records whatever you agree; it does not recommend one.

How does the Pool ledger feed those columns?

Name the second tab Pool. It is a simple list in rows 2 to 300: A date, B head (kitchen, utilities, medicine, festival), C amount, D type, E person. D holds either "Contribution" for cash handed to the kitty, or "Spend" for money paid out. E holds the member's name, or "Kitty" if the pool's own cash paid. The Members tab then uses these formulas for Arun in row 2:

  • Cash put in, C2: =SUMIFS(Pool!$C$2:$C$300,Pool!$D$2:$D$300,"Contribution",Pool!$E$2:$E$300,$A2)
  • Paid for pool directly, D2: =SUMIFS(Pool!$C$2:$C$300,Pool!$D$2:$D$300,"Spend",Pool!$E$2:$E$300,$A2)
  • Total credited, E2: =C2+D2
  • Gap, F2: =B2-E2. A positive gap means the member still owes the pool; a negative one means they have given more than agreed.

How do I record a brother paying a bill on behalf of the pool?

This is the situation that breaks most informal sheets. Say Bhaskar pays an ₹8,000 electricity bill from his own account. Enter a row in the Pool tab: head Utilities, amount 8,000, type Spend, person Bhaskar. That row does two things. It records the expense for the common pool, and it counts as ₹8,000 credited to Bhaskar against his agreed ₹20,000. He then only needs to put in ₹12,000 cash. The two columns together make his 20,000.

The kitty balance is the cash that remains with the family: =SUMIFS(Pool!$C$2:$C$300,Pool!$D$2:$D$300,"Contribution")-SUMIFS(Pool!$C$2:$C$300,Pool!$D$2:$D$300,"Spend",Pool!$E$2:$E$300,"Kitty"). Bills a member paid directly are left out of that subtraction, because the kitty never paid them. With the sample figures above, if the kitty paid ₹49,000 for kitchen, medicine and a festival fund, the balance is 57,000 minus 49,000, which is ₹8,000.

What goes on each household's private tab?

Each household keeps its own tab for what the pool does not cover: children's tuition, personal travel, clothes, a car loan. Nobody else needs to see it. The pool then stays clean, and nobody has to explain a personal purchase. If the family wants to show a member's total outgo, a simple =SUM on each private tab can sit beside the contribution in the Members tab.

Festivals are easier if the pool has a Festival head with a small monthly top-up, say ₹2,000 set aside every month, so that no single month's kitchen contribution has to carry the bill for the big days.

How do we keep this fair and visible?

  1. Pick one person to enter rows, and let others view only.
  2. Review the Members tab on the first of every month.
  3. Photograph or file big bills and note the reference in column B.
  4. Protect the formula cells so only the ledger rows can be changed.

SpendixAI has one personal workspace on Pro and is not a team tool, so this sheet stays the right place for the pool. Each member can still track their own household's spending there.

SPENDIXAI JOURNAL

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

Explore your reports