How to track books you lend to friends
The system only needs to answer two questions: who has the book, and is it back?
Lending a book is easy. Remembering the loan six months later is the difficult part.
What to record
For an active loan, I would record the borrower, the date the book left, and a short note when context matters. Add a promised or expected return date only when you and the borrower have actually agreed on one.
BOOK: The Power Broker BORROWER: Maya LOANED: 14 March 2026 NOTE: For her New York project RETURNED: —
Active loan and lending history are different
An active-loan field describes the book's current state: available or lent, and to whom. Lending history records earlier events. The first helps you recover a book; the second tells you what happened over time.
If you only care where the book is now, clear the borrower and loan date when it returns. If the history matters, close the loan with a return date and keep the completed event.
Reminders without over-managing your friends
A reminder is useful for valuable books, books needed by a particular date, or loans that have genuinely gone quiet. Not every paperback needs a due-date workflow.
What happens when the book is returned?
Mark the loan returned, record the date if you keep history, and put the book back in its cataloged shelf location. If it comes back damaged or annotated, a brief copy note may be worthwhile.
Shelf addresses and loans describe the same physical copy at different moments. The guide to tracking shelf locations explains how to give the returned book an unambiguous home.
Shared household or loan to a friend?
A book in another room is not necessarily lent. For a shared household, a broad location such as “Sam's room” may be more natural than creating a loan every time someone carries a book upstairs.
Use lending status when responsibility has temporarily passed to another person. Use shelf location when the book remains part of the household's ordinary arrangement.
Spreadsheet and app approaches
In a spreadsheet, add columns for loan status, borrower, loan date, return date, and note. Filter for rows whose status is “Lent.” This is transparent and entirely adequate if you remember to update it.
A library app can make the same workflow quicker and may preserve history or send reminders. When choosing one, check whether lending is attached to your specific copy and whether the data can be exported. The broader guide to choosing a home-library cataloging app covers those questions.