Pharmacy stock count with Scanlist
This page opens in Add quantity mode with a Location column suggested and CSV as the first export, for counting packs on shelves and in cupboards. Scan the barcode on each pack; a repeat scan adds 1, and a note on the row can carry the expiry date or batch.
- Name the list after the shelf or cupboard, and set its default Location (Pro) so every row carries it.
- Tap Start scanning and scan each pack. A second pack of the same product adds 1 to its quantity.
- Type the expiry date or batch into the row's note, for example Exp 03/2027, when packs of one product differ.
- Fix a quantity with the minus and plus buttons if a box holds several packs you counted by hand.
- Export the list, open it in Excel and sort or filter the Note column to find the packs that expire first.
What to know
The scanner saves exactly the text the barcode holds, as text, so a code with a 0 at the start stays intact. Many medicine packs carry a 2D Data Matrix that also contains an expiry date and batch number; Scanlist reads the symbol but does not split that text into separate columns, so the whole string lands in the Code column. If you need the expiry as its own column, use the note, or split the text in Excel with a formula once the file is exported.
Count by product, not by pack, when expiries differ: scan, then add the expiry to the note on that row, and use a second row (switch a list to New row each scan) for a batch that expires earlier. Every row carries a Scanned at time, so the file doubles as a record of when each shelf was counted. This is a counting aid, not a pharmacy management or compliance system, so keep your own records where regulations require them. Free scanning is unlimited; three exports a day include 25 rows each, and Pro removes the row limit.
To check the count against what the system says should be on the shelf, Pro Compare reads an expected-stock CSV and lists missing, short, over and extra codes. Export the expected stock from your dispensing or stock system as a CSV with a code and a quantity column, then compare after each count.
Updated · Cosmovex
Questions
Does it read the expiry date from the pack?
No. It reads the barcode and saves its text. A Data Matrix on a pack may contain the expiry inside that text, but Scanlist does not separate it into a column. Type the expiry in the note, or split the text in Excel after export.
Can I count packs that have no barcode?
Type the code or a short name into the box under the scanner and press Add. The row works like a scanned one, with a quantity and a note.
Is the list of stock uploaded anywhere?
No. Codes, quantities and notes stay on your device until you export them. Only an export count with a random browser ID is sent to apply the free limit.
Can two people count different shelves?
Yes. Each phone keeps its own list. Export each as CSV and combine them in Excel, or press Import CSV to continue a list on another phone; quantities add up per code.
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
- 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