A joint account statement shows what left the account, not who spent it. To see who spent what, tag every row as Shared, Person 1 or Person 2, then total each tag. The tagging can be quick if you agree the rules first and each person tags their own purchases.
What clues does the statement give you?
- Cards: if you each have your own debit card, the statement may show the last four digits or a card identifier; check your own layout.
- UPI: payments from a joint account through two different phones look the same on the statement, so check each person's UPI app history.
- Merchants: a gym membership or a hobby store is likely one person's.
- Cheques and transfers: the narration may include a name or reference.
- Cash: ATM withdrawals carry no person at all, so ask.
What is a simple tagging system?
- Add a Tag column to a copy of the statement.
- Use three values: Shared, P1, P2.
- Tag the obvious rows first, then message each other about the doubtful ones.
- Agree a rule for cash: either tag it Shared or ask whoever withdrew it to record how it was spent.
- Do this once a month, not once a year.
A worked example with made-up numbers
Say the joint account sees debits of ₹62,000 in a month:
| Tag | Amount in rupees |
|---|---|
| Shared: rent, groceries, utilities | 41,500 |
| P1 personal | 11,200 |
| P2 personal | 9,300 |
| Total | 62,000 |
41,500 plus 11,200 plus 9,300 is 62,000, so the tags cover everything. If the two earn in a ratio of 60 to 40 and you agree to split shared costs the same way, P1 covers 0.6 times 41,500, which is ₹24,900, and P2 covers 0.4 times 41,500, which is ₹16,600. Then compare each person's deposits into the account with their share plus their personal spend, and settle any difference with a transfer.
What formulas total it?
With tags in column C and amounts in column D, use:
- =SUMIFS($D$2:$D$500,$C$2:$C$500,"Shared")
- =SUMIFS($D$2:$D$500,$C$2:$C$500,"P1")
- =SUMIFS($D$2:$D$500,$C$2:$C$500,"P2")
- =SUM($D$2:$D$500) to check that the three above add up
They work in Excel and Google Sheets.
Is it worth changing the setup?
If tagging is a monthly fight, a simpler structure may help: each person keeps a personal account for their own spending and sets up a regular transfer into the joint account for shared costs. Whether that suits you depends on your relationship and your bank; this is a choice for the two of you.
What can SpendixAI do for this?
SpendixAI Pro covers one personal workspace, so it is not a shared-access or team tool, and it will not work out who spent what automatically. What you can do is import the joint account's statement against its own account, create a category or sub-category for each person's personal spend, and use reports to total them. Use it as a ledger, with the decisions staying with you.
What if the numbers never seem fair?
Look at the ratio you chose, not at individual purchases. If one partner earns more, a split in proportion to income is common, but an equal split of shared costs with equal personal allowances is also common. Neither is correct in itself. Write the rule down, review it every few months or when pay changes, and treat a change in income as the trigger to revisit it. A joint account works best when both people can see the same monthly page and nothing on it is a surprise.
Monthly routine
- Download the statement on the first of the month.
- Tag it together over a cup of tea.
- Total each tag and compare with the agreed ratio.
- Settle up and note any rule changes.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

