Borrowed-Item Tracker: Record Loans and Returns
How do you keep track of borrowed items?
Keep one record for each agreed loan, identifying the item, its owner, who has it, the expected return arrangement and what was actually returned. Record partial returns explicitly instead of ticking off the whole loan. Ask permission before recording or sharing another person's details, keep the record minimal, and use this method only for ordinary belongings such as books and games.
This is Small Loop Fieldbook's proposed household method, with fictional examples. It is not a tested loss-prevention system. It records an agreement; it does not create permission to lend somebody else's property.
What counts as one loan?
Choose an identifiable item or a clearly described bundle. "Book" is too vague when several similar copies circulate. "Blue-cover atlas, owner's name inside" gives both people something to recognize.
For a bundle, record the contents before it leaves. Two books lent together can share a row if their titles are listed separately. A game might need its box, board and agreed contents noted. Do not assume every box contains the same edition or accessories.
Use separate rows when items have different borrowers or return arrangements. Reusing an old row for a new loan erases the distinction between the two events.
Which fields belong in the record?
A notebook can carry the same information as a spreadsheet. Start with these fields and remove anything the participants do not need.
| Field | What to record |
|---|---|
| Loan ID | A short reference, such as L-01 |
| Item and contents | Enough detail to identify what left |
| Owner and borrower | Agreed names or recognizable initials |
| Handed over | Actual date, not the date someone requested it |
| Return arrangement | Agreed date or occasion; write "not agreed" if unresolved |
| Status | Out, partly returned, returned or needs discussion |
| Return detail | What arrived back, when and what remains |
These status names are our proposed labels, not standard software features. Keep a request separate from an actual handover: "Can I borrow it?" does not establish who currently has the item.
Agree who maintains the record. If one person writes it, let the other check the item description and return arrangement. Recording a date unilaterally does not make it an agreed deadline.
How do you record a partial return?
Consider a fictional loan of three named puzzle books. Two come back together; the third is still with the borrower.
Write "partly returned" and identify the two received books. The reconciliation is three lent minus two returned equals one outstanding. Do not mark the row "returned" because a bag has arrived.
When the final book comes back, record that receipt and close the loan. If something different arrives, keep the record open while the people involved clarify it. A note about a discrepancy should describe the item, not assign blame.
A returned object may still need an agreed place at home. The reset-checklist guide covers restoring that ready state; the lending record answers the separate question of whose custody the object is in.
Can a spreadsheet make the record easier to scan?
Yes, if everyone involved can use it. The following Google Sheets options are desk-researched from current computer documentation; no app testing is claimed.
For consistent status wording, select the status cells and choose Insert > Dropdown. Enter the agreed status labels. Google's dropdown guide explains that values outside the list are rejected unless the rule is changed to show a warning. Keep one status per loan.
To inspect outstanding loans, Google's filter guide distinguishes ordinary filters, visible to other people with access, from filter views that apply to your own view. On a computer, Data > Create filter view lets you filter the status column while keeping that view separate.
Filtering hides rows; it does not resolve their loans. Return to the complete list before concluding that a record has disappeared. Keep every item's fields together when arranging the table.
Who should see the list?
Use the smallest audience that serves the agreement. A private note may be enough; a shared file is useful only when participants want shared access.
Google's Drive sharing guidance distinguishes Viewer, Commenter and Editor permissions. For files in My Drive, editors can share and change permissions by default, with owner controls available. Check the actual access settings rather than assuming that an editing invitation stays limited to the original group.
Our privacy rule is to omit addresses, passwords, financial details and explanations of someone's personal circumstances. Agree when closed records can be removed. Do not use the list to monitor movements or score reliability.
What happens when a return arrangement changes?
Ask directly and update the record after agreement. Preserve a short note such as "return at next agreed visit" rather than silently replacing a missed date with a new one. The record should explain the current arrangement without becoming a history of grievances.
Do not extend this casual system to keys, medication, safety equipment or high-stakes property. Follow the relevant authorized arrangements and qualified guidance.
If the record repeatedly goes unused, simplify it with the participants. The friction audit can examine the recording step itself. Keep the focus on an understandable small system: identify the item, confirm the handover and close the actual return.
Sources
- Google Docs Editors Help: Create an in-cell dropdown list.
- Google Docs Editors Help: Sort and filter your data.
- Google Drive Help: Share files from Google Drive.