To track loan repayments you receive on UPI, find every credit from that relative in your bank statement, mark each as a repayment and not as income, and subtract it from the loan balance in a running list. The statement gives you the dates and amounts; the loan record gives them meaning.
How do you find a relative's credits?
Open the statement for the period, as a PDF, a CSV or an Excel file, and look for the name or the UPI handle that appears in the narration of each credit. Narration formats differ from bank to bank, so check your own statement to see how a payment from your cousin is written. In a spreadsheet, use the filter or the find command on the narration column for his name or handle. Note that the same person may appear under more than one handle, and a payment from his wife may be for the same loan.
Do not rely on memory for amounts. Pick up each credit's date and exact figure from the statement.
What does a running balance look like?
Take an example with invented numbers. You lent your cousin ₹30,000 and he repaid in six instalments of uneven size as he could manage.
| Credit date | Amount received | Balance left |
|---|---|---|
| Start | - | ₹30,000 |
| 5 Feb | ₹5,000 | ₹25,000 |
| 3 Mar | ₹3,000 | ₹22,000 |
| 8 Apr | ₹6,000 | ₹16,000 |
| 2 May | ₹4,000 | ₹12,000 |
| 6 Jun | ₹2,500 | ₹9,500 |
| 4 Jul | ₹9,500 | ₹0 |
The six credits add up to 5,000 + 3,000 + 6,000 + 4,000 + 2,500 + 9,500 = ₹30,000, which clears the loan. The last row is a check: the balance reaches exactly zero. If it does not, either a credit is missing or one of them was for something else, such as a share of a dinner bill.
Why tag them as repayments and not income?
A repayment is your own money coming back, not something you earned. If it sits under income, your monthly picture is inflated: it looks as though you earned ₹5,000 more in February than you did. It also makes the loan look unpaid when you review your records later. Keeping repayments in their own category, with a clear name such as Loan repayments received, keeps your income figures honest.
Can SpendixAI help with this?
It can help with the finding and the tagging. After you pick the account and import the statement, you review the rows before they are saved, and you can give each credit from your cousin a category you created, for instance Loan repayments received. Corrections you make become history, and a merchant alias can group differently written names for the same person. It does not run a loan ledger, so the running balance stays in your sheet. If the statement will not parse perfectly, check the rows by eye before saving.
What if he pays the wrong amount or skips a month?
Record what arrived, whatever it is, and update the balance. If a month is missed, add a line to your notes with the date, and mention it kindly rather than keeping score. Uneven payments are normal in a family loan. What matters is that the balance in the sheet and the balance in both your minds are the same.
A monthly routine
- After each statement, search for credits from the relative and their handles.
- Mark every matching credit as a repayment and write the date.
- Subtract each from the loan balance and read the new figure.
- Share the balance with the relative every couple of months, with no pressure.
- Close the loan in your record when the balance reaches zero.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


