Cards and UPI

Joint bank account: how to see who spent what

A forum-style answer on splitting joint account spending between two people: tag each debit with an owner, use a household bucket, and check a worked example.

Editorial illustration for Joint bank account: how to see who spent what

The question: "We have a joint account and no idea who spent what, can we split it up?" Yes, but not from the bank, because the statement does not say which of you made a payment. You add that piece yourselves: one letter per line, a household bucket for shared costs, and a monthly total for each person.

Step one: what does the statement actually tell us?

It tells you date, amount, and a narration such as the merchant or the UPI handle. It does not tell you whose phone or card was used. Some narrations hint at it, for example if only one of you has a particular app. Treat hints as clues, not proof, and ask each other when unsure.

If one of you uses a debit card and the other uses UPI almost entirely, a rough split by payment type may already be possible. Treat it as a first pass and then correct it by hand, since a shared card or a payment made on the other person's behalf will fool any shortcut.

Step two: how do we tag each line?

  1. Download the month's statement as a spreadsheet file, or copy the rows into a sheet.
  2. Add a column called owner.
  3. Mark each row with A, B or H. H means household: rent, bills, groceries, school fees.
  4. Resolve the leftovers together in one sitting, not a week later, when nobody remembers.
  5. Add a SUMIF per owner to total the debits.

In Excel or Google Sheets, if amounts are in column C and owners in column D for rows 2 to 200, then person A's total is =SUMIF($D$2:$D$200,"A",$C$2:$C$200). Change the letter for B and H. The three totals should add up to the full debit total.

Worked example with made-up numbers

OwnerDebits for the monthWhat is in it
A₹9,800Fuel, lunches, a phone accessory
B₹11,300Clothes, classes, a gift
H₹38,900Rent, bills, groceries, help

The three add up to 9,800 plus 11,300 plus 38,900, which is ₹60,000. Say A put in ₹30,000 and B put in ₹30,000 to the account. Household costs of ₹38,900 split equally would be ₹19,450 each. A also spent ₹9,800 personally, so A's total outflow is ₹29,250, and B's is 19,450 plus 11,300, which is ₹30,750. Nothing is wrong; the table simply makes the picture visible.

What if we earn different amounts?

Then you may prefer to share household costs in proportion to income or in a fixed amount each. That is a decision for the two of you, not a rule. The tagging works either way, because the H total is what you split by whichever method you agree.

  • Equal split: simple, but can feel unfair if incomes differ a lot.
  • Proportional split: each pays a share of household costs that matches their share of income.
  • Fixed amounts: each puts in a set sum and anything beyond that is discussed.

Can an app do the tagging?

SpendixAI imports a statement as PDF, CSV or Excel, and lets you set up categories and sub-categories. A simple trick is categories like Household, A personal and B personal, which you assign at review. Pro covers one personal workspace and is not a team tool, so treat it as the ledger one of you keeps, not a shared login for two.

Every month

  • Download the statement the day after month end.
  • Tag every row in one sitting.
  • Check that A plus B plus H equals the total debits.
  • Agree any adjustment and write it down.
SPENDIXAI JOURNAL

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

Explore your reports