Getting started

Track money lent to friends with a repayment schedule

Lend money to a friend and keep the friendship intact: a simple repayment schedule, a running balance table and a few words to confirm it in writing. Dollar example.

Editorial illustration for Track money lent to friends with a repayment schedule

When you lend a friend money, the cleanest way to keep track is a short repayment schedule: the amount, the dates you both agree on, and a running balance that you update every time a payment arrives. Write it down together, so there is no memory contest later.

It is not an expense, it is money owed to you

Money lent is an asset on your side until it comes back. Do not file it under spending, or your month looks worse than it was. Keep it in a separate list titled Owed to me, and record each repayment as it arrives.

Agree on four things before you hand over anything

  • The amount lent and the date
  • How it will be repaid: one lump sum or instalments, and on which dates
  • How payments will be made, so there is a trail
  • What happens if a payment is late, in your own friendly words

Send a message that repeats the plan and ask the friend to reply with a yes. That reply is a simple written record. It is not a legal document, and if the amount is large it is worth asking someone who understands your local rules.

A worked schedule

Say you lend a friend $600, to be repaid in four instalments of $150 starting in February. All numbers are made up.

Due dateInstalment ($)Paid onBalance owed ($)
Start--600
1 Feb1501 Feb450
1 Mar1504 Mar300
1 Apr1501 Apr150
1 May150pending150

The balance after each payment is the previous balance minus the instalment: 600 − 150 = 450, 450 − 150 = 300, 300 − 150 = 150. The March payment came three days late, so note it, because a pattern matters more than a single slip.

How do you follow up without awkwardness?

  1. Put each due date in your calendar a day before.
  2. If a payment is missed, send a light message the next day with the amount and the date.
  3. Ask if the plan still works for them rather than demanding.
  4. If the plan changes, write the new dates and the new balance in the schedule.

When not to lend

A useful rule is to lend only an amount you could live without. If you would be upset by never seeing it again, it may be a gift rather than a loan, or no deal at all. That is your call; it is not financial advice, just a way to keep friendships calm.

If the plan needs to change

Life interrupts. A friend may lose a job, face a medical bill or simply forget. If the plan needs to change, agree the new dates and amounts and write them under the old schedule with the date of the change, leaving the original rows visible. For example, if the friend can pay $75 a month instead of $150, the remaining $300 takes four more months, since 300 ÷ 75 = 4. Write that new schedule down and ask for a reply to confirm it.

Keep in mind that lending to friends carries a risk for both the money and the friendship. A written schedule does not remove that risk, but it makes the conversation easier.

Using a tool

A shared note or a spreadsheet with the four columns above is enough. SpendixAI is built around India and rupees, so if you are tracking dollars on a different system, you can still follow the same table. The habit matters more than the app.

SPENDIXAI JOURNAL

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

Explore your reports