Book Inventory

As on 31 Jul
4,986 titles Generate
Issued Books
Jul 2026
1,150 issues Generate
Returned Books
Jul 2026
1,098 returns Generate
Overdue Books
As on 31 Jul
52 overdue Generate
Lost Books
FY 2026 – 27
18 declared Generate
Fine Collection
Jul 2026
$486 collected Generate
Popular Books
Jul 2026
Top 50 titles Generate
Member Activity
Jul 2026
862 members Generate
⌘K
Quick:
Date: 01 – 31 Jul 2026 Status: Ready Clear all
Report Name Report Type Generated By Generated Date Date Range Format Status Last Updated Actions
Book Inventory Mary WinslerHead Librarian 31 Jul 202606:40 PM As on 31 Jul 2026 Excel Ready 31 Jul 2026
Report Summary
Total Titles4,986
Total Copies6,142
Available Copies4,894
Categories Covered32
Applied Filters
CategoryAll
StatusAll
ShelfAll racks
Include ArchivedYes
Report Statistics
Academic Books1,842
Fiction968
Non-Fiction712
Reference & Digital1,010
Download History
mary.winsler@school.edu
31 Jul 2026 · Excel
accounts@school.edu
31 Jul 2026 · PDF
Scheduled Reports

Monthly on the last day at 06:00 PM · next 31 Aug 2026

Internal Notes

Annual 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 PDF Ready 31 Jul 2026
Report Summary
Books Issued1,150
Unique Members648
Avg Loan Period11 days
Renewals186
Applied Filters
CategoryAll
Member TypeStudents & Staff
ClassAll
Grouped ByCategory
Report Statistics
Fiction412 issues
Academic Books486 issues
Non-Fiction188 issues
Magazines64 issues
Download History
anita.rao@school.edu
31 Jul 2026 · PDF
Scheduled Reports

Weekly every Monday at 07:00 AM · next 03 Aug 2026

Internal Notes

Fiction 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 Summary
Books Overdue52
Members Affected44
Fine Accrued$318
Longest Overdue38 days
Applied Filters
Ageing Buckets1–7, 8–15, 16–30, 30+
CategoryAll
Member TypeAll
Grouped ByAgeing Bucket
Report Statistics
1 – 7 days18 books
8 – 15 days16 books
16 – 30 days12 books
Over 30 days6 books
Download History
anita.rao@school.edu
31 Jul 2026 · Excel
front.office@school.edu
31 Jul 2026 · Excel
Scheduled Reports

Weekly every Friday at 05:00 PM · next 31 Jul 2026

Internal Notes

Used 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 PDF Ready 30 Jul 2026
Report Summary
Fines Raised$564
Fines Collected$486
Fines Waived$60
Outstanding$18
Applied Filters
Fine TypeOverdue & damage
CategoryAll
Payment MethodAll
Include WaiversYes
Report Statistics
Overdue Fines$438
Damage Charges$126
Waived on Appeal$60
Receipts Issued96
Download History
mary.winsler@school.edu
30 Jul 2026 · PDF
accounts@school.edu
30 Jul 2026 · PDF
Scheduled Reports

Monthly on the 1st at 08:00 AM · next 01 Aug 2026

Internal Notes

Reconciled 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 Summary
Titles Ranked50
Total Issues2,486
Top CategoryFiction
Never Issued318 titles
Applied Filters
Ranking ByIssue count
Minimum Issues5
CategoryAll
Include DigitalYes
Report Statistics
Percy Jackson Series186 issues
The Hobbit142 issues
Concepts of Physics128 issues
Sapiens96 issues
Download History
mary.winsler@school.edu
30 Jul 2026 · CSV
Scheduled Reports

Quarterly at period close · next 30 Sep 2026

Internal Notes

Feeds 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 Summary
Active Members862
New Members46
Inactive 90+ Days124
Avg Books / Member1.8
Applied Filters
Member TypeStudents & Staff
ClassAll
ActivityAll
Grouped ByMember Type
Report Statistics
Students742 members
Teaching Staff96 members
Support Staff24 members
Suspended8 members
Download History
anita.rao@school.edu
30 Jul 2026 · Excel
Scheduled Reports

Monthly on the 1st at 08:00 AM · next 01 Aug 2026

Internal Notes

124 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 PDF Archived 28 Jul 2026
Report Summary
Declared Lost18
Damaged — Repairable72
Written Off12
Recovery Value$1,240
Applied Filters
ConditionLost & damaged
CategoryAll
Recovery StatusAll
Include Written OffYes
Report Statistics
Academic Books8 lost
Fiction6 lost
Reference2 lost
Magazines2 lost
Download History
mary.winsler@school.edu
28 Jul 2026 · PDF
Scheduled Reports

Quarterly at period close · next 30 Sep 2026

Internal Notes

Damaged 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 Summary
Books Returned
On-Time Returns
Error StageData extract
Retry Attempts2 of 3
Applied Filters
CategoryAll
Return ConditionAll
Member TypeAll
Grouped ByCategory
Report Statistics
Extract Started01 Jul 2026 · 06:00 AM
Failed AtCirculation join
Records Processed0
Next RetryManual only
Download History
Not generated
Scheduled Reports

Paused after 2 failed attempts · manual run required

Internal Notes

Extract failed while the June circulation log was mid-close. Re-run once the period lock is released.

Showing 1–8 of 26 reports
Report Preview
Report Information
Book Inventory
As on 31 Jul 2026 · Excel
Ready
Preview Summary
Total Titles
4,986
Available
4,894
Total Copies6,142
Categories Covered32
Pages18
File Size642 KB
Included Records
Academic Books
CAT-001 · racks A1 – A6
1,842
Fiction
CAT-003 · racks C1 – C5
968
Non-Fiction
CAT-004 · racks C6 – C8
712
Export Formats
Excel Workbook
Editable catalogue · 642 KB
PDF Document
Formatted for print · 486 KB
CSV File
Raw data for import · 128 KB
Print Preview
Central Library
Book Inventory · 31 Jul 2026
Page 1 of 18
Total Copies6,142
Issued1,248
Available 4,894
Audit Information
Report generated
31 Jul 2026 · 06:40 PM · Mary Winsler
Catalogue locked for the snapshot
31 Jul 2026 · System
Downloaded 2 times
Last on 31 Jul 2026 · Accounts