Pharmacy

Millbrae Junction Pharmacy · Pharmacy · Duluth, MN

Umar Nkemelu manages Millbrae Junction Pharmacy, an independent community pharmacy, and uses this to keep every shelf item and back-room supply counted and reordered in time, and to see where stock is lost and why.

Healthcare InventoryDimensions4 tables · 6 views · 1 form · 2 dimension sets · 1 dashboard · 2 drill-downs · 1 digest · 1 notification · 1 agent

Use this template

Stock board

Products

Stocked14

Acetaminophen 500 mg tablets, 100 countMJ-2104OTC pain and fever

Naproxen sodium 220 mg tablets, 50 countMJ-2112OTC pain and fever

Children's acetaminophen suspension, 4 ozMJ-2116OTC pain and fever

Loratadine 10 mg tablets, 30 countMJ-2120Cold and allergy

Throat lozenges, 24 countMJ-2136Cold and allergy

9 more

Reorder soon9

Saline nasal spray, 1.5 ozMJ-2128Cold and allergy

Dextromethorphan cough syrup, 4 ozMJ-2132Cold and allergy

Fiber powder, 30 dosesMJ-2148Digestive

Blood glucose test strips, 50 countMJ-2164Diabetes care

Insulin pen needles 32G, 100 countMJ-2172Diabetes care

4 more

Reorder now6

Ibuprofen 200 mg tablets, 100 countMJ-2108OTC pain and fever

Anti-diarrheal caplets, 24 countMJ-2144Digestive

Fish oil 1000 mg softgels, 90 countMJ-2160Vitamins and supplements

Sterile gauze pads 4 by 4 inch, 50 countMJ-2184First aid

Alcohol prep pads (box of 200)MJ-2216Immunization supplies

1 more

On order2

Cetirizine 10 mg tablets, 45 countMJ-2124Cold and allergy

Prescription label roll (1,000 labels)MJ-2204Pharmacy packaging

Discontinued1

Glass basal thermometer, old modelMJ-2228Home medical

Tables

Products

32 sample rows · 20 columns

Everything on the pharmacy's shelves and in its back room, with counts, par levels and what restocking costs.

Product	Item code	Department	Kept in	Sold by	On hand	Par level
Acetaminophen 500 mg tablets, 100 count	MJ-2104	OTC pain and fever	Front shelf A	bottle	30	24
Adhesive bandage assortment, 100 count	MJ-2180	First aid	Front shelf A	box	28	20
Adult 50+ multivitamin tablets, 100 count	MJ-2156	Vitamins and supplements	Front shelf C	bottle	13	12
Alcohol prep pads (box of 200)	MJ-2216	Immunization supplies	Back counter	box	4	8
Amber prescription vials, 20 dram (case of 500)	MJ-2196	Pharmacy packaging	Stockroom	case	9	6
Antacid chewable tablets, 96 count	MJ-2140	Digestive	Front shelf C	bottle	22	14
Anti-diarrheal caplets, 24 count	MJ-2144	Digestive	Front shelf C	box	5	10
Blood glucose test strips, 50 count	MJ-2164	Diabetes care	Back counter	box	17	20
Cetirizine 10 mg tablets, 45 count	MJ-2124	Cold and allergy	Front shelf B	box	9	20
Child-resistant vial caps (case of 500)	MJ-2200	Pharmacy packaging	Stockroom	case	4	6
Children's acetaminophen suspension, 4 oz	MJ-2116	OTC pain and fever	Front shelf A	bottle	19	16
Dextromethorphan cough syrup, 4 oz	MJ-2132	Cold and allergy	Front shelf B	bottle	14	14

20 more rows

Stock adjustments

36 sample rows · 8 columns

Every time stock leaves the books without a sale: expired, damaged, returned, recalled or corrected.

Adjustment	Adjustment number	Product	Reason	Units removed	Value written off	Adjusted on
Returned for credit, Vaccine refrigerator temperature logger	MJ-A4893	Vaccine refrigerator temperature logger	Returned to wholesaler	1	$38	Oct 16, 2026
Shelf count correction, Cetirizine 10 mg tablets	MJ-A4875	Cetirizine 10 mg tablets, 45 count	Count correction	2	$15.60	Oct 15, 2026
Expired lot pulled, Acetaminophen 500 mg tablets	MJ-A4830	Acetaminophen 500 mg tablets, 100 count	Expired, pulled	6	$24.60	Oct 13, 2026
Short on delivery, Sharps container	MJ-A4908	Sharps container, 1 gallon	Short shipment	2	$11.20	Oct 12, 2026
Damaged on receiving, Insulin pen needles 32G	MJ-A4851	Insulin pen needles 32G, 100 count	Damaged in handling	1	$14.90	Oct 10, 2026
Shelf count correction, Alcohol prep pads (box of 200)	MJ-A4872	Alcohol prep pads (box of 200)	Count correction	1	$3.30	Oct 9, 2026
Recall pulled from shelf, Vitamin D3 2000 IU softgels	MJ-A4899	Vitamin D3 2000 IU softgels, 120 count	Recall pulled	5	$28	Oct 8, 2026
Returned for credit, Fiber powder	MJ-A4890	Fiber powder, 30 doses	Returned to wholesaler	2	$17.40	Oct 7, 2026
Expired lot pulled, Adult 50+ multivitamin tablets	MJ-A4827	Adult 50+ multivitamin tablets, 100 count	Expired, pulled	3	$21.30	Oct 6, 2026
Short on delivery, Syringes with 25G needle	MJ-A4905	Syringes with 25G needle, 1 mL (box of 100)	Short shipment	1	$11.20	Oct 4, 2026
Damaged on receiving, Sterile gauze pads 4 by 4 inch	MJ-A4848	Sterile gauze pads 4 by 4 inch, 50 count	Damaged in handling	2	$6.20	Oct 3, 2026
Shelf count correction, Fish oil 1000 mg softgels	MJ-A4869	Fish oil 1000 mg softgels, 90 count	Count correction	2	$16.50	Oct 2, 2026

24 more rows

Wholesalers

6 sample rows · 12 columns

The distributors the pharmacy buys from, with terms and delivery days.

Wholesaler	Sales rep	Rep phone	Rep email	Our account number	Payment terms	Delivers
Boreal Immunization Supply	Henrietta Solheim-Banerjee	(218) 555-0155	henrietta.solheimbanerjee@borealimmunizationsupplyco.com	MJ-82014	Due on receipt	Twice weekly
Harborview Home Medical	Lazarus Quigley-Mensah	(218) 555-0156	lazarus.quigleymensah@harborviewhomemedicalco.com	MJ-82015	Net 30	Weekly
Iron Range Medical Packaging	Gideon Oduya-Pryce	(218) 555-0154	gideon.oduyapryce@ironrangemedicalpackagingco.com	MJ-82013	Net 30	Weekly
Lakehead Health Distribution	Hesper Vandersloot-Nakagawa	(218) 555-0152	hesper.vanderslootnakagawa@lakeheadhealthdistributionco.com	MJ-82011	Net 30	Mon, Wed, Fri
Northstar Pharmaceutical Wholesale	Lorcan Ibekwe-Strand	(218) 555-0151	lorcan.ibekwestrand@northstarpharmaceuticalwholesaleco.com	MJ-82010	Net 30	Daily
Superior Diabetes Supply	Rosalind Achebe-Navarro	(218) 555-0153	rosalind.achebenavarro@superiordiabetessupplyco.com	MJ-82012	Net 15	Twice weekly

Also included

Stock by department and statusDrill-down
Write-offs by month and reasonDrill-down
Monday reorder listDigest
Expiry coming upNotificationWarns the pharmacy manager a month before a product's soonest expiry date.

Counseling practiceAshcombe Commons Counseling4 tables · 6 views · 1 form · 3 dimension sets · 1 dashboard · 1 digest · 1 document · 1 notification · 1 agentImports

Massage therapy clinicOakmere Point Massage Therapy4 tables · 6 views · 1 form · 2 dimension sets · 1 dashboard · 1 digest · 1 notification · 2 stage rule sets · 1 row action · 1 agentImports

Oral surgeryAmberly Row Oral Surgery4 tables · 6 views · 1 form · 3 dimension sets · 1 dashboard · 1 digest · 1 document · 1 notification · 1 agentImports

Speech therapy practiceMoorfield Park Speech Therapy4 tables · 5 views · 1 form · 2 dimension sets · 1 dashboard · 1 drill-down · 1 digest · 1 notification · 1 agentDimensions

Tissue boxes, 2-ply	ACC-1101	Waiting room
Herbal tea assortment	ACC-1102	Waiting room
Decaf coffee pods	ACC-1103	Waiting room
Paper cups, 8 oz	ACC-1104	Waiting room

Unscented massage oil, 1 gallon	OP-3101	Oils and lotions
Lavender massage lotion, 32 oz	OP-3102	Oils and lotions
Arnica muscle rub, 16 oz	OP-3103	Oils and lotions
Peppermint essential oil, 15 ml	OP-3104	Oils and lotions

Absorbable suture, 4-0 poly, 18 in	AOS-2101	Sutures and blades
Black silk suture, 3-0	AOS-2102	Sutures and blades
Scalpel blades, size 15	AOS-2103	Sutures and blades
Surgical round burs, 8 mm	AOS-2104	Sutures and blades

Nitrile gloves, small	CC-1001	Gloves and masks
Nitrile gloves, medium	CC-1002	Gloves and masks
Nitrile gloves, extra small	CC-1003	Gloves and masks
Earloop masks, level 2, box of 50	CC-1004	Gloves and masks

Nasal CPAP mask, small	ASC-2101	Masks and cushions
Nasal CPAP mask, medium	ASC-2102	Masks and cushions
Nasal CPAP mask, large	ASC-2103	Masks and cushions
Nasal pillow mask, medium	ASC-2104	Masks and cushions

Articulation card deck, /s/ and /z/ sounds	MP-101	Therapy tools
Articulation card deck, /r/ sounds	MP-102	Therapy tools
Handheld mirrors, set of 6	MP-103	Therapy tools
Disposable tongue depressors, box of 500	MP-104	Therapy tools

Stock board

Tables

Products

Stock adjustments

Wholesalers

Also included

Related templates