How to keep track of money you lend to friends

Lending money to friends and family is normal. Losing count of who owes what is how it goes wrong. Here is a simple way to keep a record that stays fair to both of you.

By Locus ·

Why it goes wrong

Most lending trouble is not about trust. It is about memory. Two people remember the same loan differently: one remembers five hundred, the other four. One remembers paying some back last month, and the other has forgotten it. Small loans add up without anyone noticing, and money paid back in parts is the hardest of all to keep straight.

Asking is awkward, so people put it off. The longer it waits, the vaguer it gets, and the vaguer it gets, the harder it is to raise.

A written record fixes most of this. It does not need to be formal. It needs to be written when the money moves, and in the same place every time.

Decide before you lend

A minute of thought before the money changes hands saves a lot of trouble.

  • Lend what you could live without. If it never came back, would you be all right? If not, lend less, or say no kindly.
  • Say whether it is a loan or a gift. Both are fine. Mixing them up is not.
  • Agree on when. “By the end of the month” or “when you get paid” is enough.

Put it in a message, so you both have it: “Here is the 500 for the tickets, pay me back when you get paid.” It is friendly, it is clear, and it is already a record.

What to write down

For each loan, write down five things:

  • Who. One name per person, spelled the same way each time, so all their loans add up together.
  • How much.
  • When. The date the money moved.
  • Which way. Did you lend, or did you borrow? Keep both in the same record.
  • What for. A few words, like “train tickets” or “rent”. It helps you both remember.

After a few weeks, a record might look like this:

A lending record (the amounts are only an example)
DatePersonWhatAmount
3 OctRafiLent, train tickets500
12 OctRafiLent, lunch300
20 OctImranBorrowed1,000

Record each return as its own line

When money comes back, do not cross out the loan or change its amount. Write the return as a new line, with its own amount and its own date.

Rafi's lines, after he pays some back
DateWhatAmount
3 OctLent500
12 OctLent300
1 NovReturn−200
Rafi owes you600

Why a line of its own?

  • The history stays honest. You can see what was lent, what came back and when. Nothing is written over.
  • Paying back in parts adds up by itself. Three small returns are three lines. You never have to work out which loan each one belongs to.
  • You can show it. If your friend remembers it differently, go through the lines together. A disagreement becomes a check.

The balance is then a sum: everything lent, less everything that came back.

One balance for each person

If you lend to a friend and also borrow from them, keep both in the same list. They count against each other. If you lent Rafi 500 and later borrowed 200 from him, he owes you 300. Settle the difference, not each loan on its own.

It keeps the conversation short, too. “I make it 300 between us” is easier to say than going through every loan.

When you pay for other people

A lot of lending is not a loan at all. You pay for the whole dinner, the taxi or the tickets, and the others owe you their share. It is easy to forget, because nobody asked to borrow anything.

Treat each share as a small loan to that person, on the day you paid. If four of you shared a 2,000 dinner and you paid, write down 500 lent to each of the other three. Your own share is simply what you spent. When someone sends their part, it is a return like any other.

Writing the shares down the same evening matters more here than anywhere else. By the next week, nobody remembers who had the extra dish.

Asking for it back without making it awkward

Asking is the part people dread. A few things make it easier:

  • Be specific. Name the amount and what it was for. A vague request can sound like an accusation; a specific one sounds like admin.
  • Make it easy to say yes. Part of it now is fine, and you can say so.
  • Ask in private, and in writing if you like. A message gives the other person time to answer.
  • Ask once, kindly, then wait. If nothing happens, ask again in a couple of weeks.

For example: “Hi Rafi, I was going through my notes and I have 600 from the tickets and the lunch. No rush, and part of it is fine.”

A record makes this much easier. You are not relying on memory, so there is nothing to argue about, only a number to agree on.

When you are the one who borrowed

Keep the same record for money you owe. It is a courtesy to the person who lent it, and it protects you as well: you can see exactly what you have already paid back. Pay in parts if you need to, say so when you do, and write each payment down as a return of its own.

When to let it go

Sometimes the kind thing, or the realistic one, is to stop waiting. If you decide to forgive a loan, tell the person, so neither of you carries it around. Then mark it as forgiven in your own record, so you stop counting it as owed.

A simple rule helps: decide in advance how long you will wait for small amounts, and let them go when that time has passed.

Paper, a spreadsheet or an app

Any of these works, as long as you use it every time:

  • A notebook. A page for each person. Simple and private, but it cannot add up for you.
  • A spreadsheet. Columns for the date, the person, what it was and the amount, with a total for each person. Flexible, but fiddly on a phone.
  • An app that does the sums. Quick to add to and always up to date, as long as it keeps each return as an entry of its own.

What matters more than the tool: write it down the same day, give every return its own line, and keep everyone in one place.

Doing it in Locus

Lending in Locus works this way, on the web and on Android. Tap Lend or borrow, enter the amount, choose I lent or I borrowed, and add the name. When money comes back, open the person and tap Return, or choose All of it, and Locus tells you where you will stand before you save: “After this, you and Rafi are settled.”

Each person shows one balance, the sum of their lines, and the list filters to Owes you, You owe and Settled. The record is yours alone: the people in it do not see it, and do not need an account.