A pharmacy stock count: each item with its batch and expiry.
Counting a pharmacy is more than counting boxes: the same item can sit in two batches with different expiry dates, and one may be close to expiring. This template gives you a line per batch with its number and expiry date, an expected column to fill from your records, then the count you actually make and the difference. It has sample rows with generic names, and the quantities are illustrations only.
Sample rows: Pharmacies
Examples only; prices are blank for you to fill.
| Item | Batch no. | Expiry date | Expected | Counted | Difference |
|---|---|---|---|---|---|
| Paracetamol 500 mg, strip | B-2401 | 2027-03 | 40 | ||
| Paracetamol 500 mg, strip | B-2509 | 2028-01 | 60 | ||
| Amoxicillin 500 mg, box | A-2506 | 2027-08 | 25 | ||
| Children's cough syrup | S-2412 | 2026-12 | 18 | ||
| Lubricating eye drops | E-2503 | 2027-05 | 22 | ||
| Saline solution 500 ml | N-2507 | 2028-06 | 50 | ||
| Antibiotic ointment | M-2410 | 2027-01 | 15 | ||
| Vitamin D, box | V-2508 | 2028-02 | 30 | ||
| Medical masks, box | K-2502 | 2029-02 | 35 |
Common questions
Why count each batch separately?
Because a gap can vanish when batches are added together: a shortage in one and a surplus in another cancel out. By batch you also see which sells first and which to pull before it expires.
What do I do with an expired item?
Pull it off the shelf at once, enter the quantity as found in the counted column, then dispose of it as your health authority requires. Never sell it or hide it, and record the difference so the shortfall in sellable stock has a reason.
How often should I count?
A full count once or twice a year, and a quick monthly count of the top sellers and the items nearing expiry. Pick a quiet day and print the template beforehand.In Dashing items have batches with expiry dates and the oldest sells first.
More free tools
- PharmaciesA retail pharmacy POS: nearest expiry sold first, a card for what expires within 30 days, cycle counts that do not stop selling, supplier quotes compared, works offline.
- Stock count sheetA ready stock-count sheet in Arabic, Kurdish and English: code, item, expected, counted, and the difference with its dinar value computed for you. Excel and CSV, free.
- Purchase orderA ready purchase order for a supplier: item, unit, quantity, unit cost, totals computed, and a Received column for what actually arrived. Arabic, Kurdish, English. Free.