Life events

A relative asks for a loan: recording the amount and repayment dates

Lending money to a relative: keep a small ledger with date, mode, agreed repayment and reminders, and keep it outside your regular spending.

Editorial illustration for A relative asks for a loan: recording the amount and repayment dates

If a relative asks you for a loan, write down three things before sending any money: the amount, how it will be paid back and the dates. Then keep a small lent-money ledger with each payment out and each repayment in. Treat it as a separate list from your regular spending, so a loan never shows up as if you had spent the money.

What should I decide before I send anything?

Ask yourself whether you could manage if the money never came back. If not, lend less. Then agree on the amount, the repayment plan and the mode. Send a message that states it plainly: I am sending ₹50,000 today by UPI; you will return ₹5,000 on or before the 5th of each month for ten months. Ask for a yes. This is not about mistrust; it is how adults stay friends over money.

What does the ledger look like?

Keep one small sheet per loan. The top block holds the facts and the bottom block lists each repayment as it arrives.

CellLabelExample value
B2Amount lent₹50,000
B3Date sent and mode1 January, UPI
B4Monthly instalment₹5,000
B5First due date5 February
B6Months elapsed since first due date4
D9 downwardsRepayments received, one per rowAmounts as they arrive

Three formulas do the work, and they work in Excel and in Google Sheets. The balance still owed is =B2-SUM(D9:D40). The amount that should have been paid by now is =MIN(B2, B4*B6). The shortfall is the second figure minus the sum of repayments: =MIN(B2, B4*B6)-SUM(D9:D40). A positive result means you are behind schedule.

Can I see a worked example?

Using the made-up figures above, four instalments are due by early May, so B6 is 4. Say your relative paid ₹5,000 in February, ₹5,000 in March, nothing in April, and ₹5,000 in May.

  • Repayments received: ₹5,000 + ₹5,000 + ₹5,000 = ₹15,000
  • Balance still owed: ₹50,000 − ₹15,000 = ₹35,000
  • Due by now: 4 × ₹5,000 = ₹20,000
  • Shortfall: ₹20,000 − ₹15,000 = ₹5,000

Those four lines tell you what to say, without guesses: you are one instalment behind, and ₹35,000 is outstanding.

How do I remind someone without it turning into a fight?

Set a calendar reminder two days before each due date for yourself, not for them. If a payment is late, send a short, friendly message with the figure, such as: April's ₹5,000 is still pending; could you send it this week? Keep your messages factual. If you need to agree a new schedule, put the new dates in the ledger as a dated note, and keep the old ones.

How do I keep a loan out of my regular spending?

In a spreadsheet, keep it on its own tab. In an expense tracker, use a separate category. If you use SpendixAI, the transfer arrives with your imported statement, and a custom category such as Money lent lets you exclude it when you look at ordinary spending in the Report builder. Repayments you note by hand against the same category. The balance formulas above still do the tracking.

What if I decide not to lend?

Saying no, or lending less than asked, is allowed. You might offer a smaller amount as a gift that you do not expect back, which keeps your own books simple and spares both of you the awkwardness of a pending loan. Whatever you choose, tell them plainly and keep the message.

Before you lend

  1. Decide the largest amount you could afford to lose.
  2. Agree the amount, instalments and dates in a message.
  3. Send by a traceable mode.
  4. Open the ledger the same day.
  5. Review it every month on the same date.

If the sum is large or the relative disputes the loan later, speak to a lawyer about formal paperwork. This page covers record keeping only.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports