Equipment sign-out with Scanlist
This page opens in New row each scan mode with Location and Condition columns suggested and CSV as the first export, for a tool crib, an AV store or a site container. Scan the tag when an item goes out and note who took it; scan it again when it comes back and set its condition. Every movement is a timed row, so the export is the sign-out log for the week.
- Name the list after the store and the period, for example Tool crib November, and set the default Location (Pro) to where the items are kept and the default Condition to Good.
- When someone takes an item, scan its tag and write who in the note in a fixed form, for example Out – Sam Austin. Code 128, Code 39, QR and Data Matrix tags are all read.
- When the item is returned, scan the tag again. The new row has its own time; change Condition (Pro) to Scratched or Damaged where needed and note anything that needs repair.
- To see what is still out, sort the list by code: a tag whose last row is an Out note has not come back.
- Export the log as CSV at the end of the week and filter it in the spreadsheet by note to list open loans by person. Pro keeps a named list per store and lifts the 25-row limit.
What to know
A sign-out log is a list of movements, not a count, so each scan has to be its own row with its own time: that is New row each scan. There is no who column, so the note carries the name; keep the wording consistent (Out – name, In – name) and a filter in the spreadsheet shows every open loan per person. The export has Code, Format, Qty, Note and Scanned at plus the Location and Condition columns, which is enough to answer who had the drill on Tuesday and what state it came back in.
Tool crib tags are usually Code 39 or Code 128 on durable labels, QR on laser-etched plates, and Data Matrix on small hand tools. Etched metal reflects the light, so tilt the tag or switch the light off; a worn tag can be typed into the box under the scanner. Leave the Pro duplicate warning off for a sign-out list, because a return is a repeat scan on purpose. Set the list's default Condition to Good so only the exceptions need a change on return.
For a stock check of the store, start a separate list in Add quantity mode (the asset audit page) rather than comparing the movement log, because Compare sums quantities per code and a tool that went out three times would show as over. The movement log and the audit list can both be exported and kept together. Free allows three exports a day of 25 rows each, which covers a small store for a week; a busier crib needs Pro for the row limit, a named list per store and continuous scanning.
Updated · Cosmovex
Questions
How do I know who has an item right now?
Sort the list by code and read the last row for that tag: an Out note with no later In row means it is still out, and the note says who took it. In the export, filter the Note column by Out and remove the codes that also have a later In row.
Can I use the same list for sign-out and return?
Yes, that is the point of New row each scan: the return is a second row for the same tag with its own time and a Condition. Keep one list per store for the week or month, then export it.
Which tags work on tools and equipment?
Code 128, Code 39, QR, Data Matrix, ITF, EAN, UPC and PDF417. Laminated and etched tags reflect light, so tilt them a little; a tag that will not read can be typed instead.
Can two people run the crib from two phones?
Each phone keeps its own list. Export one as CSV and press Import CSV to continue on the other: in New row each scan mode the rows are appended, so the merged list holds every movement from both phones.
Does it tell me what is overdue?
No. It records the time of every scan; open the export in a spreadsheet and filter the Out rows by date to find loans older than you allow. Scanlist has no due dates or reminders.
Is the sign-out log uploaded?
No. The log stays on the phone until you export it. Only an export count with a random browser ID is sent, to apply the free limit.
The free plan covers everything on this page. Scanlist Pro ($5/mo, billed monthly) is described on the Scanlist page.
More ways to use Scanlist
- Scanlist, no preset
- Scan to Excel
- Excel on iPhone
- Scan to Google Sheets
- Retail stocktake
- Inventory count
- Serial numbers
- ISBN batch
- Goods-in receiving
- QR codes to CSV
- Asset audit
- Event check-in
- Pharmacy stock count
- Parcel dispatch log
- Returns receiving log
- Spare parts bin count
- Lab sample tube log
- Bar stocktake
- Badge attendance
- Order packing check
- Pallet label scanner
- USB scanner to CSV