How to keep track of money you lend to friends and family

Money between people who know each other rarely arrives as one clean loan. It shows up as an advance before a salary, a share of a dinner, a bus fare, half of a gift. Nobody writes any of it down, because each amount feels too small to bother with. Then six months later two people remember the same year differently, and the argument is never really about the money.

Why remembering does not work

Most people can recall lending money. What they cannot recall is the repayments. You lend ₹5,000, you get ₹2,000 back a few weeks later in cash, and that ₹2,000 is the part that disappears. Months on, you are sure you are owed ₹5,000 and the other person is sure they already paid you something. Both of you are honest and both of you are wrong.

That is the whole problem in one sentence: people track the lending and forget the settling. Any method that fixes this is good enough, and any method that does not will fail no matter how tidy it looks.

The four things worth writing down

You do not need a contract or a spreadsheet with formulas. For each amount that moves, record four things:

• Who — the person, not the occasion. "Rakesh", not "the Goa trip".
• How much — the actual figure, not a rounded one you will later doubt.
• Which direction — did the money leave you, or come to you? This is the field everyone skips, and it is the one that makes the total meaningful.
• When — the date it happened. Not the date you got around to writing it down.

A short note about what it was for helps, but it is optional. Six months later "advance" is usually enough to jog the memory, and waiting until you can phrase it nicely is how entries never get made at all.

Pick one place, and only one

The method matters far less than using the same one every time. Two half-kept records are worse than one scrappy one, because now you have to reconcile them.

• A notes app — instant and always with you, which is its real advantage. The weakness is that it does not add anything up, so you end up doing mental arithmetic on a list that has grown too long to trust.
• A spreadsheet — good at totals, bad at the moment that matters. You are standing outside a restaurant; you are not opening a spreadsheet. Entries you mean to add later mostly do not get added.
• A dedicated app — worth it only if recording something takes a few seconds, and if it shows you a balance per person without being asked.

Whatever you choose, write the entry at the moment the money moves. Almost every failed system fails there rather than in the choice of tool.

Record what comes back, too

This is the same point as before, and it is deliberately repeated, because it is the one that decides whether your records are worth anything. Every repayment is an entry. A partial repayment is an entry. Someone buying you lunch to square things off is an entry.

Once both directions are in, you stop keeping a list of loans and start keeping a balance — one number per person that already accounts for everything that has passed between you. That number is the thing you actually want. It is also much harder to argue with than a list.

Think per person, not per transaction

Nobody wants to know that there were eleven amounts. They want to know whether they are owed money or owe it, and roughly how much. So net it out: everything you sent, minus everything you received, gives one figure for that person. Positive means they owe you. Negative means you owe them.

Keep the individual entries underneath, though. The total is what you look at day to day; the entries are what you need on the rare occasion someone asks how you arrived at it.

Say it out loud, early

A record is not a substitute for a conversation. When you hand over the money is the easiest moment in the whole cycle to say "just remind me at the end of the month" — the amount is small, nobody is embarrassed, and nothing has gone wrong yet. Every week you wait makes that sentence harder to say.

If you are already past that point and unsure how to raise it, we wrote a separate guide on how to ask someone to pay you back.

What not to expect from a record

A note you keep on your phone is a note you keep on your phone. The other person never agreed to it, so it does not bind them to anything, and it is not evidence of a debt. What it does is remove the disagreement about what happened, which is where most of these conversations actually go wrong. If money between you and somebody else needs to be enforceable, that takes a real agreement, made properly and outside any app.