Pharmacy Stock template
Medicines, stock movements, and prescriptions with checksum-validated NDC drug codes, RxNorm CUIs, and ICD-10 diagnoses, live days-to-expiry and In stock / Reorder / Expiring status formulas, an expiry calendar, and dispensing notifications. Sample data only — not for PHI.
Tables
Suppliers
Supplier, VAT number, Country, Order email, Phone, Lead time (days), Rating, Supplier since, Notes, Medicines, Medicines supplied
Medicines
Medicine, Generic (INN), NDC, RxNorm CUI, Form, Strength, Category, Supplier, Supplier record, Lead time (days), Unit, Unit cost, Sell price, Margin % and 12 more
Stock movements
Reference, Medicine, Medicine record, NDC, Type, Quantity (+/-), Date, Reason, Supplier, Unit cost, Movement value, Handled by, Notes
Prescriptions
Prescription #, Patient, Doctor, Medicine, Medicine record, NDC, Diagnosis (ICD-10), Issued, Quantity, Dosage, Status, Filled on, Price, Days since issue and 1 more
Views
- Stock list (grid)
- By category (kanban)
- Expiry calendar (calendar)
- Movement log (grid)
- Prescriptions (grid)
- Prescription dates (calendar)
Forms
- Record a stock movement
Automations
- Notify on stock movement
- Email pharmacy on new prescription
- New record in “Medicines”
- “Prescriptions” reached “Cancelled”
- Daily sweep — still open in “Prescriptions”
- “Cold chain” was ticked in “Medicines”
- Large value in “Unit cost”
It is a starting point, not a fixed product
Installing the template creates these tables in your own workspace. Rename a column, add a field, change a view or delete a table you do not need — it is an ordinary Appdor app from the first minute, and your existing spreadsheet can be imported into it.