Stock Verification Tool Guide
Learn how to use the LISWALA Stock Verification Tool to verify library collections using the Full Accession Register, Physical Scans, and Excluded Books files.
Stock Verification Tool Guide
Stock Verification is completed in 5 simple steps.
Only 3 files are uploaded. The last 2 steps generate and show your results.
Upload your complete Library Accession Register using the provided template.
Full Accession Register Validated
Review validation results before proceeding.
All barcodes are valid — no duplicates or formatting issues detected.
Barcode Cleaning Preview (First 4 Records)
Automatic whitespace & character trim| Original Value | Cleaned Value | Validation Status |
|---|---|---|
| LIB001 | LIB001 | Valid |
| LIB002 | LIB002 | Valid |
| LIB003 | LIB003 | Valid |
| LIB004 | LIB004 | Valid |
What happens?
The system checks your file for errors, duplicate barcodes, blank values, and formatting issues.
Next
Review the validation result and click Continue.
Upload the file containing all books physically scanned on the shelves.
Physical Scans Validated
Review validation results before proceeding.
All scanned barcodes are valid — no duplicates or formatting issues detected.
What happens?
The system checks the scanned barcodes and validates the file.
Next
Review the result and click Continue.
Upload books that are intentionally not on the shelves, such as Issued, Lost, Transferred, or Withdrawn books.
Excluded Books Validated
Review validation results before proceeding.
All barcodes are valid — no duplicates or formatting issues detected.
What happens?
The system validates the excluded-book list.
Next
Review the result and click Continue.
Remember the 3 Files
Full Accession Register
Books you should have
Physical Scan File
Books you physically found
Excluded Books
Books intentionally not on shelves
That's all the files you need to upload.
After all 3 files are validated, run the verification.
Ready for Verification
All 3 files are ready.
Comparison Engine
Reconcile accession register, scans & exclusions
Click Run Comparison Engine to get your final verification results.
View your verification results and download the required reports.
Available in Library
Physically verified on shelves
Current Missing
Unaccounted on shelf scans
Previously Missing (Still Missing)
Unlocated across multiple audits
Excluded Found in Scan
Scanned on shelf despite exclusion
Previously Excluded Found
- Previously Lost22
- Previously Withdrawn12
Issued Books
Active circulation loans
Extra Books
Found on shelf; missing in Master
Switch between Dashboard Summary and Detailed Reports to view or export results.
Summary Observations
- 1Most of the expected collection was successfully accounted for during verification.
- 2Some previously missing books were found during the current scan.
- 385 books marked as previously missing remain unaccounted for on shelves.
Recovery Statistics
Audit HistoryExcluded Books Breakdown
1,482 Total Non-Shelf ItemsPercentage of the expected collection accounted for through the verification process.
Complete Workflow
Fast summary of the complete stock verification process.
That's it!
Upload 3 files → Verify each file → Run Comparison Engine → Get your results → Download reports.
You May Also Need
Based on your current workflow, these tools might be helpful.