Health and family

Who owes whom across the family: a net-balance sheet

A family net balance sheet for who owes whom: a matrix of amounts given and received, netted to one balance per household, with a worked three-household example.

Editorial illustration for Who owes whom across the family: a net-balance sheet

In a joint family or a close circle of relatives, loans often run in several directions at once. A net-balance sheet lists every amount given and received between households in a matrix, then nets each household to a single figure: positive if the family is owed money overall, negative if it owes. The net figure is what you settle and not each old loan separately.

What does the matrix look like?

Make a grid with one row for the household that lent and one column for the household that borrowed. Each cell holds the amount lent and the date. Here is a worked example with three households, A, B and C, and invented figures:

Lender / borrowerABC
A lent to-₹50,000₹10,000
B lent to₹0-₹30,000
C lent to₹20,000₹0-

Read across each row. A has lent ₹50,000 to B and ₹10,000 to C. B has lent ₹30,000 to C. C has lent ₹20,000 to A.

How do you net it?

For each household, add everything it is owed and subtract everything it owes.

  • A is owed 50,000 + 10,000 = ₹60,000 and owes ₹20,000, so the net is +₹40,000.
  • B is owed ₹30,000 and owes ₹50,000, so the net is -₹20,000.
  • C is owed ₹20,000 and owes 10,000 + 30,000 = ₹40,000, so the net is -₹20,000.

The three nets must add to zero, because every rupee owed by one household is owed to another: 40,000 - 20,000 - 20,000 = 0. If your total is not zero, a figure has been missed or entered twice. That check alone finds most mistakes.

In this example, the simplest settlement is for B to pay A ₹20,000 and C to pay A ₹20,000. A then receives ₹40,000, which matches the net, and nobody pays anyone else. The five separate loans collapse into two payments.

What should each loan row record?

The matrix is the summary. Underneath it, keep a list with one row per loan: lender, borrower, date, amount, how it was sent, what was agreed about repayment and any payments received. The matrix cells are the sum of the open rows in that list. When a loan is repaid, mark it closed and the cell updates.

Is it fair to net debts that were made for different reasons?

Sometimes it is not. A loan for a medical emergency and one for a holiday may not feel equal to the people involved. Netting is arithmetic and says nothing about feelings or priorities. If a family member is uncomfortable, leave that loan out of the net and handle it by itself.

How often should you tidy up?

Once a year is enough for most families. Choose a date that is easy to remember, such as the weekend after Diwali or the start of April when the financial year turns, and go through the matrix with each household in turn. Settle what can be settled, restate what remains, and note the date at the top. Keep last year's sheet, so that you can look back when memories differ.

Where do your own records come in?

For the loans you gave or received by bank transfer or UPI, your statements are the reliable source for dates and amounts. If you import them into SpendixAI, you can find the transfers to a particular relative, and a category such as Loans to family keeps them away from ordinary spending. The matrix and the loan list remain in your sheet, because the app does not keep a ledger of who owes whom.

A short routine

  1. List every open loan with its date and amount.
  2. Fill the matrix from the list and net each household.
  3. Check that the nets add up to zero.
  4. Propose a settlement and get each household to agree.
  5. Update the list when payments are made and save a dated copy.
SPENDIXAI JOURNAL

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

Explore your reports