
Annual Report
Docs + Word6 pages
FeaturedFree
Small loans between people who like each other go wrong when nobody remembers the amount. This IOU tracker works in both directions. People lists everyone you lend to or borrow from, and shows what each owes you, what you owe them and the net. Loans holds each loan with a code, direction, amount and due date, and works out the amount repaid and the amount left, then labels the loan Open, Paid or Overdue. Repayments logs every payment against a loan code and fills in the name for you.
Six sample loans show the mix: concert tickets lent to a friend and partly repaid, a car repair borrowed from an uncle, a loan paid in full and two that are past due. Spell each name the same way on People and Loans, because the totals match on the name. Overdue loans turn red, which means a glance down the Loans tab shows who needs a friendly reminder.
Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.
Start on the People tab: replace the sample rows with your own.
Keep the formula columns as they are; they fill in as you type.
Read the How to use tab for tips. For Excel, download the .xlsx file instead.
Note who borrowed, how much, on what day and when it should be repaid, then log every repayment. A balance column makes the amount outstanding obvious.
Yes. A record protects the friendship because both sides can check the amount instead of arguing about memory. It takes under a minute per loan.
Yes. Each loan has a direction, either I lent or I borrowed. The People tab shows both amounts and a net figure for each person.

Docs + Word6 pages
FeaturedFree
Excel
FeaturedFree
Sheets + Excel5 tabs
Free
Sheets + Excel5 tabs
FreeSheets + Excel6 tabs
FreeSheets + Excel5 tabs
FreeSheets + Excel5 tabs
Free
Sheets + Excel5 tabs
Free
Sheets + Excel12 tabs
FreeSheets + Excel5 tabs
FreeSheets + Excel6 tabs
FreeSheets + Excel7 tabs
Free
Sheets + Excel5 tabs
Free
Sheets + Excel5 tabs
FreeSheets + Excel5 tabs
Free