In a household with two UPI apps and two bank accounts, double counting has a sneaky cause: money sent from one of you to the other. It leaves one account as spending and arrives in the other as income, and if one of you then pays the shop, the same rupees appear three times. Mark transfers between you, then total only the real purchases.
Where the extra rupees come from
Say A sends ₹5,000 to B on the 3rd for groceries, and B pays ₹5,000 to the grocery store that afternoon. The household spent ₹5,000 once. But A's statement shows ₹5,000 out, B's shows ₹5,000 in, and B's shows ₹5,000 out. If you add everything that went out, you get ₹10,000.
| Owner | Date | Description | Money out | Money in |
|---|---|---|---|---|
| A | 03 May | UPI to B | 5,000 | - |
| B | 03 May | UPI from A | - | 5,000 |
| B | 03 May | UPI to grocery store | 5,000 | - |
| A | 06 May | UPI to gas agency | 1,050 | - |
Naive money out is 5,000 + 5,000 + 1,050 = ₹11,050. Real spending is the grocery 5,000 plus the gas 1,050, which is ₹6,050. The ₹5,000 transfer between you is moving money, not spending it.
How do we find transfers between us?
Put both bank statements on one tab with Date in A, Owner in B, Description in C, Money out in D and Money in in E. In F2 use:
=IF(D2>0,COUNTIFS($E$2:$E$500,D2,$A$2:$A$500,">="&A2-2,$A$2:$A$500,"<="&A2+2,$B$2:$B$500,"<>"&B2),0)
A result of 1 or more means the other person received the same amount within two days. Check each flagged row and, if it is indeed a transfer between you, type Between us in column G. Do not trust the formula alone, because two real payments of the same amount can match.
Then total what is left
=SUMIFS($D$2:$D$500,$G$2:$G$500,"<>Between us") adds money out except the marked transfers. Here that gives 5,000 + 1,050 = ₹6,050. Do the same for each person with an added condition on Owner.
Should the UPI app history be involved?
Only for names. Each payment is in both the app and the bank, so use the bank statements as your records and consult the app to recall what a vague line was. If you also paste app histories, you will duplicate everything.
SpendixAI offers one personal workspace on Pro, with each transaction kept against its account, and it flags possible duplicate imports. Because it is not a team tool or a bill-splitter, a shared sheet like this is still handy for the settle-up conversation.
What about payments one of us makes for the other's family?
Those are real spending, but they belong to a different bucket. If A pays ₹3,000 to B's parents for a repair, the money is gone from the household, not moved between you. Give it a category such as Family support so you can see it separately from groceries and bills. It will not be marked as Between us because the receiver is not the other partner.
The test for a transfer is simple: does the money stay inside your household's two accounts? If yes, it is Between us. If it leaves, it is spending.
How often should we reconcile?
Monthly is enough for most couples, with a quick scan for transfers weekly. The longer you wait, the more you rely on memory about what a vague UPI line meant, and the less either of you can say with confidence.
Agree on three rules
- Bank statements are the record, apps are for names
- Transfers between us are tagged the same week
- Every month, one shared look at the real total
Useful ideas start with a clearer picture of your own spending.
Explore your reports

