How to Track Money Lent to Friends and Their Repayments

How to track money lent to friends: what to record, how to log repayments and balances, when to share the record, and how to keep it beside your other family notes.

11 min readPersonal lending and family financial agreements5 viewsHow to Track Money Lent to Friends and Their Repayments
— · 0 votes
Contents
  1. What is a money lent to friends tracker?
  2. Why does tracking personal loans matter in everyday life?
  3. What should you record for each loan?
  4. How do you set up a tracker for money lent to friends?
  5. How do you record repayments and keep the balance accurate?
  6. Example of a simple payment history
  7. What if a repayment is partial, late or not in money?
  8. Which tracking method suits you best?
  9. Should you write a loan agreement with a friend?
  10. How can repayment reminders stay friendly?
  11. How does a loan tracker fit with appointments, questions and family handovers?
  12. When should you share your loan record, and with whom?
  13. How do you keep the tracker useful over time?
  14. What should you do if repayments stop?

The simplest way to track money lent to friends is to keep one short record for each loan. Note who borrowed, how much, the date, what you both agreed about repayment, and each repayment as it arrives. When every loan has its own record and every payment is written down on the day, the outstanding balance is always clear, and neither of you has to rely on memory. Keep this record in the same calm place where you already note appointments, questions to ask and family handovers, so it is easy to find, easy to update and easy to hand over if someone else ever needs it.

What is a money lent to friends tracker?

A money lent to friends tracker is a personal loan record that lists the informal loans you have made to friends or family and the repayments you have received. It can be a page in a notebook, a simple spreadsheet, a note in an organiser or a shared document. The method matters less than the habit: one entry per loan, one line per repayment, and a running balance that shows what is still owed.

A tracker is not a contract and does not replace one. It is a clear, dated memory aid that helps you and the borrower see the same picture.

Why does tracking personal loans matter in everyday life?

Tracking personal loans matters because memories of small money matters fade quickly, and different memories of the same loan can strain a friendship. A written record turns a possibly awkward conversation into a simple check of the facts.

  • It protects the relationship. If you both agree on the amount and the payments, there is less room for misunderstanding or hurt feelings.
  • It reduces mental load. You no longer need to remember whether Alex paid back the second instalment in May or June.
  • It helps with your own budgeting. Knowing what is still owed to you makes it easier to plan household spending.
  • It supports family handovers. If a partner or trusted relative ever needs to step in while you are unwell or away, they can see what was lent and what was agreed, instead of guessing.
  • It gives you a basis if questions come up later. A dated record of what was agreed and what was paid is more reliable than recollection alone.

What should you record for each loan?

For each loan to a friend, record the borrower's name, the amount, the date, the purpose, the agreed repayment terms and every repayment received. These details are enough to answer almost any later question without making the record complicated.

Detail to recordExampleWhy it helps
Borrower's nameSam PatelKeeps loans separate when you lend to more than one person.
Amount lent£600Sets the starting balance for every later calculation.
Date lent3 March 2026Anchors the repayment schedule and any later check-ins.
How the money was givenBank transferA bank transfer or receipt can confirm the loan if needed.
Purpose (optional)Car repairHelps you both remember the context, kindly and briefly.
Agreed repayment terms£100 per month from April, no interestShows what both people expected at the start.
Where the agreement is notedText message, 3 MarchMakes it easy to find the original wording later.
Repayments received£100 on 1 April, £100 on 2 MayBuilds a payment history you can both check.
Outstanding balance£400Answers the most common question at a glance.
NotesSam asked to skip June; agreedRecords changes so they are not forgotten.

Keep notes factual and neutral. Write what happened rather than how you felt about it. If the borrower ever sees the record, you will both be comfortable with it.

How do you set up a tracker for money lent to friends?

You can set up a money lent to friends tracker in a few minutes by choosing one place for it and creating a simple entry for each loan you have made.

  1. Choose one place. Pick a notebook, spreadsheet or organiser you already use for appointments and family notes, so the loan record is not lost in a separate system.
  2. List current loans. Write down any money you have lent that has not been fully repaid. If you are unsure of exact amounts, check bank transfers or messages and note that the figure was reconstructed.
  3. Create one entry per loan. Add the borrower, amount, date and agreed terms using the details in the table above.
  4. Add past repayments. Enter each payment already received, with its date and amount, and work out the current outstanding balance.
  5. Set a review point. Choose a regular moment, such as the first weekend of each month, to update the record and check for anything due.
  6. Decide who should know where it is. Tell one trusted person where the record is kept, in case it ever needs to be handed over.

How do you record repayments and keep the balance accurate?

Record each repayment on the day it arrives, with the date, the amount and how it was paid, then subtract it from the previous balance. Updating straight away is the single habit that keeps a payment history reliable.

Example of a simple payment history

Suppose you lent Sam £600 on 3 March 2026, agreeing on £100 per month from April with no interest. The payment history might look like this:

DateRepaymentMethodBalance after paymentNote
3 March 2026—Bank transfer (loan given)£600Terms agreed by text
1 April 2026£100Bank transfer£500On time
2 May 2026£100Bank transfer£400On time
June 2026£0—£400Skipped by agreement
4 July 2026£150Cash£250Extra £50 to catch up

What if a repayment is partial, late or not in money?

Partial, late or non-cash repayments should be recorded exactly as they happen, with a short note explaining any change to the original terms.

  • Partial payment: record the actual amount, for example £60 instead of £100, and update the balance.
  • Late payment: record the real date it arrived, not the date it was due.
  • Payment in kind: if you both agree that, for example, a friend's help with a house move counts as £80 of repayment, note the agreed value and that you both accepted it.
  • Cash: because cash leaves no bank trail, write it down at once and consider sending a short message such as "Thanks, got the £150 today", which also confirms it for the borrower.

Which tracking method suits you best?

The best tracking method for money lent to friends is the one you will actually keep up to date. Each option has different strengths.

MethodGood forThings to keep in mind
Paper notebookPeople who like writing things down and keep one household notebookBalances must be worked out by hand; harder to share or back up
SpreadsheetSeveral loans or regular instalments; automatic balance calculationsNeeds a little setup; keep a backup copy
Notes or organiser you already useKeeping loans next to appointments, questions and family handover notesUse a consistent heading so loan entries are easy to find
Shared document with the borrowerLarger or longer loans where both people want to see the same figuresOnly share what the borrower needs; agree who updates it

Should you write a loan agreement with a friend?

A short written loan agreement is worth having for any amount you would be upset to lose, even between close friends. It does not need to be formal; it simply sets down what you both understood at the start.

A simple agreement can be a message or note that states:

  • the amount lent and the date;
  • whether the money is a loan or a gift;
  • the repayment schedule, such as £100 on the first of each month;
  • whether any interest applies;
  • what happens if a payment needs to be skipped or delayed.

For example: "Lending you £600 today for the car repair. As we said, £100 a month from April, no interest. If a month is tight, just let me know." Ask the borrower to reply confirming. Keep a copy, or a note of where it is, with your loan record.

For larger sums, or loans connected to property or inheritance, rules on written agreements, interest and gifts differ between countries. In those cases it is sensible to check the rules where you live or speak with a qualified adviser.

How can repayment reminders stay friendly?

Repayment reminders stay friendly when they are mainly reminders to yourself, and when any message to the borrower is light, factual and sent at an agreed time.

  1. Remind yourself first. Put a note on your calendar or in your organiser a day or two after each payment is due, so you can check your bank or cash record before saying anything.
  2. Check the record. Confirm whether the payment has really been missed. Many awkward moments come from a payment that arrived but was never written down.
  3. Use a gentle message if needed. For example: "Hi Sam, just updating my notes. I've got £400 left on the car loan. Is the next £100 still okay for this month?"
  4. Record the conversation. Note the date and any new arrangement, such as moving payments to the 15th.

If you agreed at the start that you would send a reminder, the borrower is more likely to see it as helpful rather than pushy.

How does a loan tracker fit with appointments, questions and family handovers?

A loan tracker works best when it lives alongside the other things worth remembering, such as appointments, questions for the doctor or school, and notes for family members who may need to take over. One calm place means one place to check, rather than scattered reminders in different apps and drawers.

Some practical ways to connect them:

  • Use the same review moment. When you look over the coming month's appointments, glance at your loan records too and note any repayments due.
  • Keep questions next to the loan. If you want to ask a friend whether they would prefer a different repayment schedule, write the question in the loan entry so it is ready when you next speak.
  • Include loans in family handover notes. A short line such as "Loan to Sam: details in the household notebook, page 12" lets a partner or relative pick things up calmly if you are away, unwell or simply busy.
  • Link to where the evidence is. Note where the original agreement message or bank transfer can be found, rather than copying sensitive details everywhere.

When should you share your loan record, and with whom?

Share your loan record when it helps someone understand or act on the loan: the borrower, a partner who shares household finances, or a trusted person who may need to handle your affairs. Keep it private otherwise, out of respect for the friend who borrowed.

  • With the borrower: share the payment history and outstanding balance when they ask, after a change to the terms, or once or twice a year on longer loans. A quick "Here's where we are" message keeps both records aligned.
  • With a partner or household member: share it if the money came from shared funds or affects your joint budget.
  • With a trusted person for handovers: tell them where the record is and what it covers, so they can find it if needed.
  • With an adviser: share it if you are getting professional help with larger sums, taxes or estate planning.

Before sharing more widely, remove details the other person does not need, such as the personal reason for the loan.

How do you keep the tracker useful over time?

A tracker stays useful when it is short, current and tidy. A brief monthly check and a clear way to close finished loans are usually enough.

  • Review monthly. Spend a few minutes confirming recent repayments and balances.
  • Close finished loans clearly. When a loan is fully repaid, write "Repaid in full" with the date, and move it to an archive section.
  • Record forgiven amounts. If you decide to let the remaining balance go, note the date and amount, and whether you told the borrower. This prevents later confusion.
  • Keep a backup. Photograph notebook pages or keep a copy of a digital file somewhere safe.
  • Avoid clutter. One line per repayment is enough; long commentary makes the record harder to read.

What should you do if repayments stop?

If repayments from a friend stop, start by checking your record, then talk openly and decide calmly what you are comfortable with. Your tracker gives you the facts so the conversation can focus on solutions.

  1. Confirm the facts. Check your payment history and bank or cash records to be sure the balance is right.
  2. Reach out kindly. Ask how things are and whether the original repayment schedule still works for them.
  3. Agree on a new plan if needed. Smaller amounts, a pause or a new start date are all common. Write the new terms down and ask for a quick confirmation.
  4. Decide your limit. Consider whether you would rather forgive part of the balance than risk the friendship. Whatever you decide, record it.
  5. Seek advice for larger sums. If a significant amount is involved and the conversation does not help, a local advice service or qualified professional can explain your options where you live.

Lending to friends is an act of trust. A simple, honest record of what was lent and what has come back helps protect that trust, and keeping it in one calm place alongside your other everyday notes makes it something you can look after without worry.