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.
Built from real-world business experience by the ExcelGurukul team. 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.