Lend tracker: how to keep tabs on money you lent friends & family

There is a particular kind of small dread that comes from lending money to someone close to you. Not because you think they will run off with it — but because, a few months in, you genuinely cannot remember how much is left. Was it ₹15,000 or ₹20,000? Did that dinner they paid for count? A lend tracker exists to kill that uncertainty: it turns "I think they still owe me something" into one exact, current, shareable number.

This is a practical guide to setting one up for money you lent friends and family — what to record, how to handle messy repayments, and how to keep it from feeling like you are running a collections agency.

What a lend tracker is (and isn't)

A lend tracker is simply a running record of one loan: how much you lent, when, whether interest applies, and every repayment since. That is it. It is not a contract, a credit-scoring tool, or anything that involves a bank. The whole point is to bring a little structure to an informal loan without making it feel formal.

The reason it matters is that informal loans fail quietly. Nobody refuses to pay; the balance just dissolves into uncertainty until both people give up on knowing the real number. A lend tracker keeps that number alive. For the broader case of why this matters across all informal lending, see why you need a peer-to-peer lending tracker.

What to record when you lend

When you hand over money, capture four things while they are still fresh:

• The amount — the principal, exactly.
• The date — when the money actually left your account. This anchors everything, especially if interest accrues over time.
• Who — the person, so a tracker for "Loan to Priya" stays distinct from "Rent deposit for Arjun."
• Interest, if any — most loans between friends are interest-free, and that is fine. But if you did agree on a rate, record it now, not later. (Here is how interest on informal personal loans actually works.)

Notice what is not on the list: a repayment schedule. Informal loans rarely have one, and pretending they do just sets up a deadline nobody intends to keep. A good lend tracker shows a live balance, not a list of "missed" EMIs.

The hard part: tracking repayments

Recording the loan is easy. The reason most people lose track is the repayments, because they almost never come back cleanly.

Money you lent comes back in fragments — ₹3,000 one month, ₹1,500 the next, a transfer with no note, sometimes a chunk out of the blue when they get paid. If you are keeping the balance in your head, every one of these is a chance to lose the thread. Track money lent the moment a repayment lands instead:

1. Log each repayment with its date and amount — even tiny ones. The discipline of recording the ₹500 is what keeps the total honest.
2. Apply it to the balance immediately, so the outstanding number is always current. A tracker that does this for you means you never sit down to "reconcile."
3. Decide upfront how non-cash repayments count. If they cover a dinner and you both agree it comes off the loan, log it as a repayment with a note. If it is a gift, leave it out. The key is deciding at the time, not arguing about it later.

When interest is involved, the order matters: each payment should cover accrued interest first, then chip away at the principal. A tracker that applies payments interest-first keeps the balance mathematically fair without either of you doing the arithmetic.

Make it shared, not secret

Here is the move that changes everything: let the borrower see the tracker too.

A lend tracker hidden on your phone still leaves you as the sole keeper of the number — which means you are also the one who has to bring it up. Share the tracker, and the balance becomes a neutral fact both of you can see. No nagging, no awkward "so about that money" texts. They can watch the balance fall as they pay; you never have to ask. This is the difference between a private note and a real lend tracker.

Keep it kind

Tracking money you lent is not about distrust. The friends-and-family loans that go wrong are almost never the ones where someone refused to pay — they are the ones where the amount got fuzzy and resentment filled the gap. A clear, shared record is actually the kinder option: it protects the relationship by making sure money never becomes a question of memory or honesty.

A few ways to keep the tone right:

• Name the tracker plainly ("Loan to Sam"), not like a debt notice.
• Let the numbers do the talking — a shared balance never sounds accusatory the way a text does.
• Close it out when it hits zero. Marking a loan settled is a small, satisfying moment for both people.

Set one up in a minute

You do not need a spreadsheet or a system. Pick the loan, record the amount and date, and share the link.

• Comparing approaches? See a lending tracker vs a spreadsheet.
• Lending within the family specifically? Read lending money to family and friends.

Create a free lend tracker on P2P Track — name it after the loan, add the amount, and send the link to the other person. No login needed to start, and the balance keeps itself current from there.