Tracking who has which book is the whole job of a lending library. Everything else, the catalogue, the shelving, the labels, exists to make this one thing reliable. For a small, high-trust library you can do it well without barcodes, without fines, and without making borrowers create accounts.
The trick is getting one idea right.
The copy is the thing you track
A loan is not against a title, it is against a copy. If your library owns three copies of the same book, "who has it" is the wrong question. The right question is "who has copy two", because copy one and copy three might be on the shelf.
So the unit you track is the physical copy. Each copy is either on the shelf or out with a named borrower, and a loan ties one copy to one person with a date. Get that right and the system can always answer how many copies are available and exactly who has the rest.
This is the single thing a spreadsheet gets wrong, because it gives each title one row and cannot say one copy is out while another is in.
What you record for a loan
A small library needs very little per loan.
- Which copy went out.
- Who took it.
- When it is due back.
That is enough to run circulation. When the copy comes back, the loan closes and the copy returns to available. You do not need fines, deposits or a membership system for any of this to work in a library where the librarian knows the borrowers.
Borrowers are just names
In a small high-trust library, a borrower does not need an account. They are a name attached to a loan, recorded by the librarian. That keeps the desk fast and means there is nothing for a borrower to sign up for before they can take a book.
A read-only login is something you can add later, only if a borrower wants to check their own loans and due dates from home. It is never required, and it never lets them do anything but look. The default stays a name on a loan.
Do you need barcodes?
No. Barcodes only speed up identifying a copy at the desk. For a few hundred books, finding the title and clicking lend is fast enough, and a scanner is a convenience you can add if the queue ever justifies it. Tracking who has what does not depend on hardware, it depends on treating each copy as its own item.
Tracking loans with Your Book Nest
Your Book Nest is built around copies and loans. You record a book once, say how many copies you hold, and each copy is lent and returned on its own. At any moment the catalogue shows how many copies are available and who has the others.
Borrowers stay as names until you choose to give one a read-only login. There are no fines, no deposits and no barcode requirement. It is free for up to 100 books, and the home page is a live demo you can try with no sign-up.