To track money lent to friends, keep a small ledger with one row per person: the amount lent, the amount returned and what is outstanding, then review it once a month. It takes three minutes and stops the common problem of remembering a favour but forgetting the sum.
What belongs in the ledger?
- Person's name and the date you lent.
- Amount lent and the mode: cash or UPI.
- The promised return date, even a rough one.
- Each repayment, with its date.
- Outstanding balance after every repayment.
A worked ledger with invented numbers
| Person | Lent | Returned | Outstanding |
|---|---|---|---|
| Ravi | ₹10,000 | ₹4,000 | ₹6,000 |
| Meera | ₹2,500 | ₹2,500 | ₹0 |
| Sandeep | ₹5,000 | ₹0 | ₹5,000 |
| Total | ₹17,500 | ₹6,500 | ₹11,000 |
Check the totals: 10,000 + 2,500 + 5,000 = 17,500 lent. 4,000 + 2,500 = 6,500 returned. 17,500 − 6,500 = 11,000, which is also 6,000 + 0 + 5,000. If the columns do not agree, one entry is wrong, and that is the very thing a ledger is for.
How often does this arrive?
Irregularly. Some months nothing is lent, and some months there are three requests. What stays constant is the review: once a month, open the ledger, mark anything that has passed its promised date and decide what to do about it.
A monthly review in four steps
- Add any new loans and repayments from your statement and your cash notes.
- Update each person's outstanding balance.
- Mark any loan past its promised date.
- Decide on each overdue one: remind, agree a new date, or write it off.
How do you spot a problem?
A balance that stays the same for three months is a warning, and so is a friend who asks again while still owing. You do not need a rule against lending; you need a limit you can live with. A common habit is to lend only what you could afford to give away, then anything returned is a pleasant surprise.
How does this connect to your expense tracker?
Keep a Money lent category outside your spending total, record repayments against it, and review its balance monthly. Cash lending is the easiest to lose, so enter it the same day. SpendixAI lets you add cash entries by hand and shows category totals in reports, but it does not split bills or send reminders to your friends, so the reminders are yours to make.
If you lend small amounts for shared outings, such as a cab or a dinner, you can group them under one short-term sub-category and clear them each month, which keeps the main ledger for the larger sums.
How do you handle small amounts and screenshots?
Small sums disappear fastest. A ₹500 cab or a ₹1,200 ticket paid for someone is easy to forget, so group these in a short-term list and clear it monthly. When a friend pays you by UPI, the incoming row is a repayment, not income, so match it to the entry. Keep screenshots of payment requests in the transaction as proof of the date and amount, since a short note in the ledger and a clear confirmation message settle most disagreements quickly.
It also helps to decide your own limits once, calmly, instead of in the moment when a friend asks. For example, you might lend only when the earlier loan is settled, or only up to a sum you can live without. Write the rule at the top of your ledger. A rule you made when you were relaxed is easier to follow than a decision made under pressure.
When to involve someone else
- If a large amount is outstanding, put the terms in writing.
- If a friendship is under strain, say it kindly and directly rather than letting it drift.
- If the sum is significant to your finances, ask a professional how to document it.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


