A UPI payment to a friend can be a loan, a repayment, or your share of a shared bill, and your statement shows all three as the same kind of line. If you leave them mixed up, your monthly spend total is wrong, sometimes by a lot. The fix is a simple tag on each line saying what it really was.
What are the main tags?
- Loan given: you sent money you expect back. It is not spending.
- Repayment received: a friend returned earlier money. It is not income.
- Shared expense, my share: you paid for something you used. This is real spending.
- Shared expense, reimbursed: you paid the whole bill, and a friend sent their half. The reimbursement reduces your spending.
Add a fifth tag, Unsure, for lines you cannot place. Fix those later, by asking the friend or checking the date against your calendar.
What does tagging look like on a real month?
Here are five invented lines, plus a card payment, from one October.
| Date | Line | Amount | Tag | Counts as my spending? |
|---|---|---|---|---|
| 3 Oct | Sent to Neha | ₹1,800 | My share of cab and tickets | Yes, ₹1,800 |
| 5 Oct | Sent to Karan | ₹10,000 | Loan given | No |
| 9 Oct | Received from Karan | ₹4,000 | Repayment received | No |
| 12 Oct | Received from Neha | ₹1,600 | Her half of a ₹3,200 dinner I paid by card | Reduces dinner to ₹1,600 |
| 20 Oct | Sent to Amit | ₹6,000 | Loan given | No |
How much does misclassification distort the total?
Treat every outgoing line as spending and ignore the incoming ones. UPI sent: ₹1,800 + ₹10,000 + ₹6,000 = ₹17,800. Add the ₹3,200 dinner on the card, and the month looks like ₹21,000 of spending.
Now tag properly. Real spending is ₹1,800 for the shared trip, plus ₹3,200 - ₹1,600 = ₹1,600 for your half of the dinner, which is ₹3,400. The gap is ₹21,000 - ₹3,400 = ₹17,600.
The loans also deserve their own view. You lent ₹10,000 + ₹6,000 = ₹16,000 and got ₹4,000 back, so you are owed ₹12,000. If you never tag them, that figure is hidden inside a spending total that will make you feel you overspent when you actually lent.
Why does the app not just know the difference?
A statement line says who the money went to, not why. The same friend can appear as a loan one week and a shared dinner the next. Only you know. That is why a quick tag matters, and why rules that match a name are useful only when the friend always plays the same role.
How can an expense tracker help here?
SpendixAI imports a bank statement and shows the rows for review before saving, which is the natural moment to fix a line that is wrongly guessed. You can also make your own categories, for example Loans given and Loans repaid, and correct a row; corrections become history, so the next similar line is easier to place.
The categorisation works in stages, starting with your own rules, so setting a rule for a friend who always receives shared bill payments saves effort, while a friend who is sometimes borrower and sometimes dinner partner is best handled by hand.
What about a friend who is sometimes both?
Some friends appear on both sides in the same month: you lend ₹2,000 on the 4th and split a dinner on the 18th. Do not net them off in your head. Tag each line on its own, then look at the loan ledger for that person. The loan balance should only move when a loan or a repayment happens, never because of a dinner.
What is a sensible monthly routine?
- Import or open the month's statement.
- Filter the lines that are UPI to or from people, not shops.
- Tag each as loan given, repayment, share, or reimbursed.
- Update the loan ledger for the people involved.
- Check that tagged spending looks like your real month.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

