Debt

Track Several Small Loans to Friends in One Table (Canada)

Lent small sums to four friends and lost track? One table with a weekly check keeps every balance visible. Worked example in Canadian dollars.

Editorial illustration for Track Several Small Loans to Friends in One Table (Canada)

When the problem is several small loans rather than one big one, a single table beats separate notes. List each borrower on its own line with the date, the amount lent and the amount repaid, then look at it once a week. Five minutes on a Sunday keeps four loans from turning into four silent grudges.

Why do small loans get forgotten?

C$40 for dinner, C$25 for a ticket, C$120 towards a trip: no single sum feels worth chasing, yet together they add up. Say four friends owe you C$40, C$25, C$120 and C$75. That is 40 plus 25 plus 120 plus 75, or C$260 out in the world. The total is the number you rarely see.

What does the single table look like?

BorrowerDate lentLentRepaid so farOwed
Aisha3 MarchC$40C$0C$40
Daniel11 MarchC$25C$25C$0
Marc20 MarchC$120C$50C$70
Priya2 AprilC$75C$0C$75

The Owed column is lent minus repaid. The total owed is 40 plus 0 plus 70 plus 75, which is C$185. Daniel's line shows as settled, which is satisfying to see.

How often should I look at it?

Weekly is enough, ideally at a fixed time. Use that session to do three things: update any repayment received, note anyone more than a month overdue, and decide whether to nudge. A fixed habit removes the sense that each nudge is a personal decision.

How do I nudge without souring things?

  • Start with the figure, not the grievance: "I have you down for C$70 from the trip."
  • Offer an easy way out: "Could you send half now and half next month?"
  • Keep a copy of your message, with the date, in the table's notes.
  • If a loan has gone quiet for months, decide whether to write it off in your own mind and record that.

What if I am also a borrower somewhere?

Add a second small table: who you owe, how much, and by when. Seeing both sides together is useful, since it shows your true position rather than only what others owe you.

Can an app do this?

Recording a loan, whether open-ended or with a set tenure, with a reminder, is something SpendixAI supports. It is built around India and INR, so it is not a promise for Canadian users; a spreadsheet with a reminder in your calendar does the same job.

When is it time to let a small loan go?

Sometimes a C$25 loan is not worth the friendship it is straining. Decide your own threshold in advance. For example, if a loan under C$50 is three months overdue after two polite nudges, you mark it as written off in the table and stop thinking about it. The record stays, but the weight comes off.

Writing off in your own books is a private decision; it does not forgive anything unless you say so. If you prefer, tell the person it is settled. The point is that you choose, rather than carrying a low-grade irritation for a year.

  • Choose the threshold before you lend, not after.
  • Note the date you decided.
  • Lend less next time to anyone who has left a loan open.

Your Sunday routine

  1. Open the table.
  2. Add repayments received this week.
  3. Recalculate each Owed figure and the total.
  4. Pick one person to nudge, if anyone.
  5. Close the table and move on.

This is about records and habits. Interest and legal questions vary and are not covered here.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports