How to Keep Track of Money You Lend to Friends and Family

There are really only four ways to keep track of money you lend: your memory, a notes app, a spreadsheet, or a dedicated IOU tracker. They’re not equal. Ranked by effort versus reliability, memory is effortless but useless, a notes app is easy but messy, a spreadsheet is reliable but a chore, and a dedicated tracker is both quick and dependable. If you lend to friends and family more than once or twice a year, the fastest reliable method wins — and the fastest one logs a new IOU in about ten seconds. For larger loans, pair whichever tracker you choose with a written note — the free IOU template generator produces a signed one in a minute.

What are the four ways to track money you lend? (ranked)

Here’s the honest trade-off for each method, ranked from least to most dependable. The thing that separates them isn’t whether they can work — it’s whether you’ll actually keep them up to date once life gets busy.

The pattern is clear. The methods that are reliable (spreadsheet) are high-effort, and the methods that are low-effort (memory, notes) are unreliable — except the last one, which is the only option that’s both quick and dependable.

Why do the notes-app and spreadsheet methods break down?

The notes app feels perfect at first: jot “Sam £30” and move on. But notes have no structure. A month later you’ve got “Sam £30”, “sam paid 10?”, and “dinner Sam” scattered across three notes, and you genuinely can’t tell what the balance is. There’s no date, no record of partial repayments, and nothing stopping the same debt being written twice.

Spreadsheets fix the structure but tax your willpower. They’re brilliant the week you build them and abandoned by the following month, because adding a row means opening a laptop, finding the file, and formatting a date. The friction is small but it’s exactly large enough that you skip it “just this once” — and once you skip a few, the sheet is out of date and you stop trusting it. A tool you don’t trust is the same as no tool at all.

What does a good IOU record actually need?

Whatever method you choose, a record you can rely on needs four things for every loan:

• The amount — the exact figure, not a rounded guess.
• The person — tied to a contact, so multiple loans to the same person add up.
• The date — so “how long ago was this?” is never a debate.
• Partial repayments — most debts get paid back in pieces, and a record that can’t show “£30 lent, £10 back, £20 outstanding” will quietly drift wrong.

Miss any one of those and the record eventually fails you at the worst moment — when you’re trying to ask a friend to pay you back without it being awkward and you can’t state the number with confidence.

The 10-second method: log it the moment it happens

Method four wins because it removes the friction that kills the other three. You don’t format anything; you pick the person, type the amount, and you’re done — at the table, not later at a laptop. Because every entry is structured and dated, the running balance is always correct, and marking a repayment is a single swipe.

How do you handle partial repayments?

Most loans between friends don't get repaid in one go — you lend £50, get £20 back at the pub, and the rest trickles in over a fortnight. This is exactly where memory and notes fail: you remember the original £50 but forget the £20, or you remember a repayment and forget how much was left. A reliable record treats each repayment as its own dated event against the original loan, so the running balance always reflects reality. When someone pays back part of what they owe, log it in the same ten seconds it took to record the loan. That way "you still owe me £30" is never a guess — it's a figure with a visible history behind it. It also protects the relationship: there's no accidental double-asking for money that's already been returned, which is one of the fastest ways to make a friend feel mistrusted. Whatever method you land on, make sure it can show the whole chain — lent, part-paid, outstanding — not just a single static number that quietly drifts wrong the moment the first instalment arrives.

If you only ever need a private, one-sided record — not a shared group ledger — that’s exactly the niche a solo tracker fills better than a group app. And once your IOUs are under control, the same calm-dashboard idea extends to subscriptions and debt; the guide to organising all your money in one place ties it together.

Tracking money you lend isn’t about being mistrustful — it’s about never having to rely on two fallible memories to agree on a number. Pick the method that you’ll actually keep up, and the awkward “wait, how much was it?” conversation simply stops happening.