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.

4 tables · 6 views · 1 form · 7 automations · sample rows included, so it opens looking like a working app

Use this template

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

Forms

Automations

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.

More Healthcare templates

All templates