Lending a little money to family or friends is normal — forgetting about it is what causes friction. This free Lent & Borrowed Money Tracker keeps every informal loan in one place, so you always know who owes you, who you owe, and when it's due.
How to use it: add a row whenever money changes hands, mark it Lent or Borrowed, set a due date, and update the status as repayments come in. The notes column is handy for partial repayments or the reason for the loan. Filter by status to see what's still outstanding.
This template is designed for individuals managing loans, credit cards or repayment plans who want a clear view of their debt situation — without the need for expensive specialist software.
The Lent Borrowed Money Tracker is part of our Personal Finance & Budgeting collection — downloaded 11 times and counting. Built from real-world experience by the ExcelGurukul team and tested across multiple industries and roles.
Yes, it's a free download with no sign-up.
Yes — a Type column marks each entry as Lent or Borrowed.
Yes; set the status to Partially Paid and note the amount in the notes column.
Yes, it opens and edits in both Excel and Google Sheets.