Cosmovex/tools

Count pharmacy and clinic stock by scanning packs, with expiry in the note

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.

  1. Name the list after the shelf or cupboard, and set its default Location (Pro) so every row carries it.
  2. Tap Start scanning and scan each pack. A second pack of the same product adds 1 to its quantity.
  3. Type the expiry date or batch into the row's note, for example Exp 03/2027, when packs of one product differ.
  4. Fix a quantity with the minus and plus buttons if a box holds several packs you counted by hand.
  5. Export the list, open it in Excel and sort or filter the Note column to find the packs that expire first.
pharmacy stock count app clinic stock count scannermedicine stock list scannerscan medicine barcode to excelstock take pharmacy phone
Open Scanlist Free to start · no account

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.