Dear Mr. Manoj, If you are using koha and also the books are barcoded then your work will become quite easy to complete stock verification. I will suggest you to follow the below process to find the exact records missing and complete the verification. First - Take any laptop and attach the barcode reader with it. Second - Ask your staff on a rotation basis to scan the barcodes in excel sheets i.e. *stock verification.* Third - Once the scanning of all books is completed, you will have the list of all physical books available with you. Fourth - Now, you have to check the items issued in koha. Pull the reports of all issued books and also the list of other books with status (damaged, write off etc.) and add these accession numbers to your* stock verification excel list. * Fifth - Now you will have a complete list of verified books. *Here your actual job starts to find the missing books. * 1. First, you pull the complete accession numbers list from koha in the excel file. Ensure, your accession numbers are in *COLUMN A* 2. Secondly, copy the accession numbers from your stock verification excel sheet and paste it in the first excel sheet (pulled from koha) in *COLUMN C* to match the records and find the missing. 3. Now, you have to add the formula in the *COLUMN B. * *= vlookup(A1,C:C,1,FALSE)* 4. It will match column A to column C and show the result in *COLUMN **B*. Here, the records which are not found will show #NA. 5. Just, filter it and this is your missing list. 6. Ask the staff to search it again. If found good else* "YOUR STOCK VERIFICATION LIST is WITH YOU"* Hope it helps you to complete stock verification. If you wish, you can write me at dptripathi79@gmail.com (I don't suggest you upload the verified list in koha for stock verification unless / until you are comfortable with the Koha database). Thanks DP Tripathi Dear Professionals, Myself Manoj Kumar , a college Librarian from Kerala Our library has more than 33000 books, barcoded and our LMS is Koha . Which is the best method to do stock Verification considering all aspects like new technology, keeping social distancing, ease of doing with less physical labour comparingly, and need of additional hardware or software etc.. I am seeking guidance from those who successfully done Stock Verification in their libraries or planning to do so in the near future. Thanks in advance Manoj ************************************** *Dhanwantari Prakash Tripathi* MA (ECO), MLISc, HDISM, ECDL Ph.D. (Pursue) Commonwealth Fellow, University of East London ************************************** Deputy Librarian, Central Library Dr. B. R. Ambedkar NIT Jalandhar Jalandhar, Punjab - 144011 ************************************** *M - +91-8895296796* *U - www.dptripathi.co.in http://www.dptripathi.co.in/* *T* - *http://t.me/librarianguide http://t.me/librarianguide* *O - http://orcid.org/0000-0001-6748-9670 http://orcid.org/0000-0001-6748-9670 * ************************************** -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.