Returns receiving log with Scanlist
This page opens in New row each scan mode with Location and Condition columns suggested, for booking returned goods in. Scan the barcode on each item; every scan is its own row with a time, so you can record the condition of each one separately.
- Name the list with the date or the batch, for example Returns 21 Nov.
- Scan the barcode on each returned item. Each scan is a new row, so two returns of the same product stay two rows.
- Set the Condition (Pro) or type it in the note: New, Opened, Damaged or Missing parts.
- Put the order or return number in the note if it is on the paperwork.
- Export to Excel and sort by condition to decide what goes back to stock and what does not.
What to know
Returns are different from stock counts: two returns of the same product can be in different condition, so a count per code hides what you need to know. In New row each scan mode every item is its own row. With Pro, a Condition column and a default Location can be set once for the list; on free, put the condition in the note.
The export is plain CSV or Excel with the code as text and a Scanned at time, so it opens in any spreadsheet and can be matched to your order system by the code or the note. Items without a barcode can be typed in under the scanner, which gives them a row like any other. Free scanning is unlimited; three exports a day include 25 rows each, and Pro removes the row limit.
If you want to check what came back against what was expected, Pro Compare reads a CSV with a code column and lists missing, short, over and extra codes; quantities are summed per code before they are compared.
Updated · Cosmovex
Questions
Can I record several conditions for one product?
Yes, in New row each scan mode. Each scan is a separate row with its own note or Condition, so three returns of one product with three conditions give three rows.
Is the Condition column available on the free plan?
The Condition column is a Pro custom column. On free, type the condition in each row's note, which is exported as its own column.
Can I attach photos of damage?
No. Rows hold a code, quantity, note and time. Keep damage photos with your own return record and reference them in the note.
How do I match the log to my orders?
Use the code, or type the return or order number in the note, then match in Excel with a lookup. Codes are saved as text so they match what your system exports.
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
- Equipment sign-out
- Event check-in
- Pharmacy stock count
- Parcel dispatch log
- Spare parts bin count
- Lab sample tube log
- Bar stocktake
- Badge attendance
- Order packing check
- Pallet label scanner
- USB scanner to CSV