Library Reports
Book Inventory
As on 31 JulIssued Books
Jul 2026Returned Books
Jul 2026Overdue Books
As on 31 JulLost Books
FY 2026 – 27Fine Collection
Jul 2026Popular Books
Jul 2026Member Activity
Jul 2026- Toggle columns
- Sort by
| Report Name | Report Type | Generated By | Generated Date | Date Range | Format | Status | Last Updated | Actions | ||
|---|---|---|---|---|---|---|---|---|---|---|
|
Book Inventory — Full Catalogue
As on 31 Jul 2026
|
Book Inventory | Mary WinslerHead Librarian | 31 Jul 202606:40 PM | As on 31 Jul 2026 | Excel | Ready | 31 Jul 2026 | |||
Report SummaryTotal Titles4,986
Total Copies6,142
Available Copies4,894
Categories Covered32
Applied FiltersCategoryAll
StatusAll
ShelfAll racks
Include ArchivedYes
Report StatisticsAcademic Books1,842
Fiction968
Non-Fiction712
Reference & Digital1,010
Download Historymary.winsler@school.edu31 Jul 2026 · Excelaccounts@school.edu31 Jul 2026 · PDFScheduled ReportsMonthly on the last day at 06:00 PM · next 31 Aug 2026 Internal NotesAnnual stock verification scheduled for 15 Sep 2026. This snapshot is the opening baseline. |
||||||||||
|
Issued Books — July 2026
01 – 31 Jul 2026
|
Issued Books | Anita RaoLibrarian | 31 Jul 202605:15 PM | 01 – 31 Jul 2026 | Ready | 31 Jul 2026 | ||||
Report SummaryBooks Issued1,150
Unique Members648
Avg Loan Period11 days
Renewals186
Applied FiltersCategoryAll
Member TypeStudents & Staff
ClassAll
Grouped ByCategory
Report StatisticsFiction412 issues
Academic Books486 issues
Non-Fiction188 issues
Magazines64 issues
Download Historyanita.rao@school.edu31 Jul 2026 · PDFScheduled ReportsWeekly every Monday at 07:00 AM · next 03 Aug 2026 Internal NotesFiction remains the highest circulating category, consistent with the June figures. |
||||||||||
|
Overdue Books — Ageing
As on 31 Jul 2026
|
Overdue Books | Anita RaoLibrarian | 31 Jul 202609:20 AM | As on 31 Jul 2026 | Excel | Ready | 31 Jul 2026 | |||
Report SummaryBooks Overdue52
Members Affected44
Fine Accrued$318
Longest Overdue38 days
Applied FiltersAgeing Buckets1–7, 8–15, 16–30, 30+
CategoryAll
Member TypeAll
Grouped ByAgeing Bucket
Report Statistics1 – 7 days18 books
8 – 15 days16 books
16 – 30 days12 books
Over 30 days6 books
Download Historyanita.rao@school.edu31 Jul 2026 · Excelfront.office@school.edu31 Jul 2026 · ExcelScheduled ReportsWeekly every Friday at 05:00 PM · next 31 Jul 2026 Internal NotesUsed for the weekly reminder run. Fiction accounts for 24 of the 52 overdue titles. |
||||||||||
|
Fine Collection — July 2026
01 – 31 Jul 2026
|
Fine Collection | Mary WinslerHead Librarian | 30 Jul 202604:50 PM | 01 – 31 Jul 2026 | Ready | 30 Jul 2026 | ||||
Report SummaryFines Raised$564
Fines Collected$486
Fines Waived$60
Outstanding$18
Applied FiltersFine TypeOverdue & damage
CategoryAll
Payment MethodAll
Include WaiversYes
Report StatisticsOverdue Fines$438
Damage Charges$126
Waived on Appeal$60
Receipts Issued96
Download Historymary.winsler@school.edu30 Jul 2026 · PDFaccounts@school.edu30 Jul 2026 · PDFScheduled ReportsMonthly on the 1st at 08:00 AM · next 01 Aug 2026 Internal NotesReconciled with the accounts fine register. The $60 waiver relates to receipt RCP-2026-0514. |
||||||||||
|
Popular Books — Top 50
01 Apr – 31 Jul 2026
|
Popular Books | SchedulerAutomated | 30 Jul 202606:00 AM | 01 Apr – 31 Jul 2026 | CSV | Scheduled | 30 Jul 2026 | |||
Report SummaryTitles Ranked50
Total Issues2,486
Top CategoryFiction
Never Issued318 titles
Applied FiltersRanking ByIssue count
Minimum Issues5
CategoryAll
Include DigitalYes
Report StatisticsPercy Jackson Series186 issues
The Hobbit142 issues
Concepts of Physics128 issues
Sapiens96 issues
Download Historymary.winsler@school.edu30 Jul 2026 · CSVScheduled ReportsQuarterly at period close · next 30 Sep 2026 Internal NotesFeeds the acquisitions shortlist. 318 titles have not been issued this year and need review. |
||||||||||
|
Member Activity — July 2026
01 – 31 Jul 2026
|
Member Activity | Anita RaoLibrarian | 30 Jul 202603:35 PM | 01 – 31 Jul 2026 | Excel | Ready | 30 Jul 2026 | |||
Report SummaryActive Members862
New Members46
Inactive 90+ Days124
Avg Books / Member1.8
Applied FiltersMember TypeStudents & Staff
ClassAll
ActivityAll
Grouped ByMember Type
Report StatisticsStudents742 members
Teaching Staff96 members
Support Staff24 members
Suspended8 members
Download Historyanita.rao@school.edu30 Jul 2026 · ExcelScheduled ReportsMonthly on the 1st at 08:00 AM · next 01 Aug 2026 Internal Notes124 members inactive for over 90 days. Reading-drive shortlist to be shared with class teachers. |
||||||||||
|
Lost & Damaged Books
01 Apr – 31 Jul 2026
|
Lost Books | Mary WinslerHead Librarian | 28 Jul 202611:05 AM | 01 Apr – 31 Jul 2026 | Archived | 28 Jul 2026 | ||||
Report SummaryDeclared Lost18
Damaged — Repairable72
Written Off12
Recovery Value$1,240
Applied FiltersConditionLost & damaged
CategoryAll
Recovery StatusAll
Include Written OffYes
Report StatisticsAcademic Books8 lost
Fiction6 lost
Reference2 lost
Magazines2 lost
Download Historymary.winsler@school.edu28 Jul 2026 · PDFScheduled ReportsQuarterly at period close · next 30 Sep 2026 Internal NotesDamaged titles sit in the Rare & Archived repair queue. Binding vendor review due in August. |
||||||||||
|
Returned Books — June 2026
01 – 30 Jun 2026
|
Returned Books | SchedulerAutomated | 01 Jul 202606:02 AM | 01 – 30 Jun 2026 | Excel | Failed | 01 Jul 2026 | |||
Report SummaryBooks Returned—
On-Time Returns—
Error StageData extract
Retry Attempts2 of 3
Applied FiltersCategoryAll
Return ConditionAll
Member TypeAll
Grouped ByCategory
Report StatisticsExtract Started01 Jul 2026 · 06:00 AM
Failed AtCirculation join
Records Processed0
Next RetryManual only
Download History—Not generatedScheduled ReportsPaused after 2 failed attempts · manual run required Internal NotesExtract failed while the June circulation log was mid-close. Re-run once the period lock is released. |
||||||||||



