Forum Discussion
Excel formula to identify unreturned uniform
1. Create SKU numbers for the items:
https://businesszeal.com/how-to-create-sku-number-for-product
2. Create a Receipt form with an associated receipt number for them to sign what they borrowed
(Complete with prices that they have to pay if the item is damaged) with a check out and a check in Date and Signature (theirs and yours) and Time Stamp, with the SKU numbers of the items listed within the receipt
3. Scan these receipts so you can print them and not lose them.
4. Print another receipt when they return the items (with a different receipt number)
5. record the check out receipt numbers as well as the check in receipt numbers in your spreadsheet
You can create a spreadsheet receipt for that automatically assigns receipt number based on year, month day, hour, minute that way just by looking at the receipt number it will already inform you what to look for and where to look.
You can save these receipt as a csv file into a folder where you can do a power query by folder so all your records are dynamically created and integrated when following the process so there's no extra work, when you're done with the check out process so will your recording process.
The process is they email the request to you by filling out the form (they will do most of the work for you and you have a record for the request, and when they have returned the items you will email them their signed receipt so you have a record of the check out process as well.
You can email them once their request has been fulfilled to come pick up their items. Set a timeline when they should make the request either 2 days from the time they need the items or whatever timeline you decide.