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.
HealthcareInventoryDimensions4 tables · 6 views · 1 form · 2 dimension sets · 1 dashboard · 2 drill-downs · 1 digest · 1 notification · 1 agent
Use this templateStock board
ProductsStocked14
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 moreReorder 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 moreReorder 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 moreOn 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 columnsEverything 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 columnsEvery 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 3, 2026 |
| Shelf count correction, Cetirizine 10 mg tablets | MJ-A4875 | Cetirizine 10 mg tablets, 45 count | Count correction | 2 | $15.60 | Oct 2, 2026 |
| Expired lot pulled, Acetaminophen 500 mg tablets | MJ-A4830 | Acetaminophen 500 mg tablets, 100 count | Expired, pulled | 6 | $24.60 | Sep 30, 2026 |
| Short on delivery, Sharps container | MJ-A4908 | Sharps container, 1 gallon | Short shipment | 2 | $11.20 | Sep 29, 2026 |
| Damaged on receiving, Insulin pen needles 32G | MJ-A4851 | Insulin pen needles 32G, 100 count | Damaged in handling | 1 | $14.90 | Sep 27, 2026 |
| Shelf count correction, Alcohol prep pads (box of 200) | MJ-A4872 | Alcohol prep pads (box of 200) | Count correction | 1 | $3.30 | Sep 26, 2026 |
| Recall pulled from shelf, Vitamin D3 2000 IU softgels | MJ-A4899 | Vitamin D3 2000 IU softgels, 120 count | Recall pulled | 5 | $28 | Sep 25, 2026 |
| Returned for credit, Fiber powder | MJ-A4890 | Fiber powder, 30 doses | Returned to wholesaler | 2 | $17.40 | Sep 24, 2026 |
| Expired lot pulled, Adult 50+ multivitamin tablets | MJ-A4827 | Adult 50+ multivitamin tablets, 100 count | Expired, pulled | 3 | $21.30 | Sep 23, 2026 |
| Short on delivery, Syringes with 25G needle | MJ-A4905 | Syringes with 25G needle, 1 mL (box of 100) | Short shipment | 1 | $11.20 | Sep 21, 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 | Sep 20, 2026 |
| Shelf count correction, Fish oil 1000 mg softgels | MJ-A4869 | Fish oil 1000 mg softgels, 90 count | Count correction | 2 | $16.50 | Sep 19, 2026 |
24 more rows
Wholesalers
6 sample rows · 12 columnsThe 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 |
Views
Expiry calendar
ProductsOctober 2026
Sun
Mon
Tue
Wed
Thu
Fri
Sat
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
Forms and booking
Log a stock adjustment
FormLog a stock adjustmentWhat a technician fills in when stock is pulled, damaged, returned or corrected.
What happened, in a few words? *
Which product was it? *
What is the reason? *Expired, pulledDamaged in handlingCount correctionReturned to wholesalerRecall pulledShort shipment
How many units came off the shelf?
What is the cost of those units?
Who is writing it up?
Record the adjustmentDashboards
Stock and losses
ProductsProducts by stock status
- Stocked14
- Reorder now6
- On order2
- Reorder soon9
- Discontinued1
Stock value by department
- OTC pain and fever$312.05
- Cold and allergy$364.85
- Digestive$161.20
- Vitamins and supplements$253.80
- Diabetes care$573.60
- First aid$77.10
- Home medical$119.30
- Pharmacy packaging$599.80
Counts due each week
- Oct 18, 202614
- Oct 25, 202618
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.
Related templates
- Counseling practiceAshcombe Commons Counseling4 tables · 6 views · 1 form · 3 dimension sets · 1 dashboard · 1 digest · 1 document · 1 notification · 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
- Pediatric dentistryCopperbrook Crossing Pediatric Dentistry5 tables · 8 views · 1 form · 2 dimension sets · 1 dashboard · 1 drill-down · 1 document · 1 notification · 1 row action · 1 agentImports
- Acupuncture clinicOakmere Green Acupuncture4 tables · 7 views · 2 forms · 2 dimension sets · 1 dashboard · 1 digest · 1 notification · 1 stage rule set · 1 agentForms
- Audiology clinicJuniperwell Heights Hearing Center3 tables · 5 views · 1 form · 1 dimension set · 1 booking page · 1 digest · 1 notification · 1 stage rule set · 1 agentCalendar
- Behavioral health clinicPinecrest Gate Behavioral Health4 tables · 7 views · 2 forms · 2 dimension sets · 1 booking page · 1 portal · 1 dashboard · 1 digest · 1 stage rule set · 1 agentClient portals