Library Book Checkout Sheet

Run a school or community library: a catalogue of books, a checkout log with due dates, and automatic overdue days and fines.

Sign in with your Edesy account, then click Use template in the preview to copy the base, with its sample rows, into your workspace.

Category

Trackers

Tables

Books, Checkouts

Fields

22

Views

grid, cards, calendar, form, dashboard

Tables, columns and sample rows

The 2 linked tables in this template, with their real columns, field types and sample rows. Copy the template to edit them in Edesy Tables.

Books

9 fields · 5 sample rows

  • Catalogue (Grid)
  • Covers (Cards)
TitleTextAuthorTextISBNBarcodeGenreSingle selectShelfTextCopiesNumberCoverAttachmentCheckoutsLink to another tableTimes borrowedCount
The God of Small ThingsArundhati Roy9780006550686FictionF-ROY2Ravi Shankar1
SapiensYuval Noah Harari9780099590088Non-fictionNF-9093Neelam Joshi1
Malgudi DaysR. K. Narayan9780143039655Indian classicsF-NAR2Mira Nair1
Harry Potter and the Philosopher’s StoneJ. K. Rowling9781408855652ChildrenC-ROW4Ishaan Verma, Tanya Bose2
The Murder of Roger AckroydAgatha Christie9780007527526MysteryM-CHR1Alex Turner1
Field details
Title · Text
Author · Text
ISBN · Barcode
Genre · Single select
Fiction, Non-fiction, Children, Reference, Mystery, Indian classics
Shelf · Text
Copies · Number
Cover · Attachment
Checkouts · Link to another table
Links to Checkouts
Times borrowed · Count

Checkouts

13 fields · 6 sample rows

  • Loans (Grid)
  • Due dates (Calendar)
  • Check out a book (Form)
  • Circulation (Dashboard)
BorrowerTextBookLink to another tableMember IDTextPhonePhoneEmailEmailChecked outDateDueDateReturnedDateStatusFormulaDays overdueFormulaFineFormulaFine paidCheckboxCondition on returnSingle select
Ishaan VermaHarry Potter and the Philosopher’s StoneSTU-1042+91 98100 221139 Nov 202623 Nov 2026On loan0₹0
Neelam JoshiSapiensSTF-0021[email protected]30 Oct 202613 Nov 2026Overdue6₹30
Alex TurnerThe Murder of Roger AckroydPUB-0305[email protected]25 Oct 20268 Nov 202611 Nov 2026Returned3₹15YesGood
Mira NairMalgudi DaysSTU-1107+91 98450 9988716 Nov 202630 Nov 2026On loan0₹0
Ravi ShankarThe God of Small ThingsPUB-0288+91 99000 1100220 Oct 20263 Nov 20264 Nov 2026Returned1₹5Worn
Tanya BoseHarry Potter and the Philosopher’s StoneSTU-11331 Nov 202615 Nov 2026Overdue4₹20
Field details
Borrower · Text
Book · Link to another table
Links to Books
Member ID · Text
Phone · Phone
Email · Email
Checked out · Date
Due · Date
Returned · Date
Status · Formula
IF({Returned}, 'Returned', IF(AND({Due}, DATETIME_DIFF(TODAY(), {Due}, 'days') > 0), 'Overdue', 'On loan'))
Days overdue · Formula
IF({Due}, MAX(0, DATETIME_DIFF(IF({Returned}, {Returned}, TODAY()), {Due}, 'days')), 0)
Fine · Formula
{Days overdue} * 5
Fine paid · Checkbox
Condition on return · Single select
Good, Worn, Damaged

Form view “Book checkout” asks for: Borrower, Book, Member ID, Phone, Email, Checked out, Due.

Library Book Checkout Sheet: questions

Yes. Copy the template, then import a .csv, .tsv or .xlsx file into any of its tables and map the columns. Delete the sample rows first if you do not need them.

Yes. An automation runs when a record is created, updated or matches a filter, when a form is submitted, on a schedule or when a date arrives, and can update or create records, call a webhook or post to a connected Slack channel.

Related templates