Medical supply inventory: par levels, expiry dates and a system that fits a clinic
Medical supply inventory for a clinic: a supply list to copy, how to set par levels, an expiry routine, recall checks and what the tools cost.
Start from the inventory template
Know what's in stock and reorder in time.
On this page
Medical supply inventory is a list of every supply your clinic keeps: where it sits, how many you hold, how many you should hold (the par level), and each lot’s expiry date. A spreadsheet can run it for one practice. Software pays off when several people order, or short-dated items start expiring on the shelf.
This guide is for whoever orders supplies at an outpatient clinic, dental office, urgent care or surgery center. You get a supply list to copy, par level math, an expiry routine, a recall check and what the main tools cost. It covers supplies only: nothing about a patient belongs on this list.
How we researched this: in November 2026 we checked every price, plan and feature on each vendor’s own pages, and every rule on the FDA’s, CDC’s and federal regulations’ pages. Prices change often, and several vendors only quote on request.
| Your clinic | Start with |
|---|---|
| One practice, one or two people ordering | A spreadsheet, laid out as below |
| Short-dated stock, several people counting | A tool with lots and expiry dates, or an app you build |
| You order mostly from one distributor | That distributor’s web inventory tool |
| A dental office on practice software | The supply list inside the software |
| A hospital with many units and billing links | A supply system built for health systems |
| You want your own list, your own words | An app you build with GoodTaco |
Skip to tools and prices. Already keep your list in Excel? Upload it on our spreadsheet to app page, no account needed to try, and GoodTaco builds an app from it, with your records in a built-in database.
What should a medical supply inventory list include?
One line for each item and its storage spot, so someone else can count it:
- Item number and name. Your own number, such as MS-101, and the name on the box, with the size.
- Where it is. The room or cabinet. The same item in two places gets two counts.
- Unit. Each, box of 100 or case. Count in the unit you open.
- Reorder at and fill up to. The two par numbers, explained below.
- On hand. What you counted, not what you think is there.
- Lot and expiry. Printed on the box. Each lot gets its own line.
- Vendor and days to deliver.
When someone takes a box out, the note says the room or the kind of procedure, never the patient. Controlled substances and sample medications have their own logs, and vaccines have their own storage rules (CDC). Keep them off this sheet unless your compliance lead says otherwise.
How do you set par levels for medical supplies?
A par level is the quantity you want on the shelf for an item. Clinics use the word for the level that triggers an order, or for the level you fill back up to. Write down both: reorder at and fill up to.
- Reorder at = daily use × days an order takes to arrive + safety stock.
- Fill up to = reorder at + how much you want to order each time. Shelf space and expiry dates cap it.
- To order = fill up to − what’s on hand (and what’s already on order).
An example, with invented numbers. A clinic uses 2 boxes of medium nitrile gloves each open day. The supplier delivers 4 open days after an order, and you want 2 days of safety stock, 4 boxes. Reorder at is 2 × 4 + 4 = 12 boxes. You order every two weeks, 10 open days × 2 = 20 boxes, so fill up to is 12 + 20 = 32. At 12 you order 32 − 12 = 20 boxes. By the time the order arrives you’re down to 4, so the shelf tops out at 24, not 32.
Three habits keep the numbers honest:
- Take daily use from your last three months of orders, not a guess.
- Keep fill up to low on short-dated items. A high par on something that expires turns cash into waste.
- Review every quarter, and when visits change.
How do you track expiry dates and lot numbers?
Record the lot and the expiry date for every lot as it arrives, and use the soonest-expiring lot first. That routine is called first expired, first out. It isn’t the same as first in, first out: a later delivery can expire sooner than the one already on the shelf.
- Copy both from the box. The FDA says a device label can carry a lot or batch number and an expiry date (FDA, UDI basics).
- Read month-and-year dates as the last day of the month. The CDC does this for vaccines (CDC). Check each maker’s instructions.
- Put the soonest date in front, and new stock behind it.
- Flag the dates at 90 days out and again at 30.
- Take expired stock out at once, and don’t count it as on hand.
- Look weekly. The CDC asks clinics to rotate vaccine stock at least weekly and after each delivery. A weekly look at the 90-day list does the same for supplies.
If your clinic runs nonwaived lab tests under the Clinical Laboratory Improvement Amendments (CLIA), reagents and other supplies must, as appropriate, be labeled with preparation and expiration dates and not used past them (42 CFR 493.1252). That section doesn’t cover labs that run only waived tests, so check your certificate type.
Here is that routine on one shelf, with three example lots from the Lots tab below.
How often should you count medical supplies?
Count a busy cabinet weekly, a closet of slow items monthly, and anything before you order it. The CDC counts vaccines at least monthly and before each order, checking expiry dates during the count (CDC). Here is a 15-minute weekly routine. Print this page to use it.
☐ Look at the 90-day list and move those lots to the front. ☐ Pull anything expired, and write down how many. ☐ Count the fast-moving items in each cabinet, with two people on the busiest. ☐ Fix any count that’s off the same day, with a note on why. ☐ Order what’s at or under its reorder level. ☐ Receive deliveries: lot, expiry date, quantity, then the new stock behind the old.
How do you keep a medical supply inventory in a spreadsheet?
Use two tabs, Items and Lots. Items adds up the lots that haven’t expired and tells you what to order. Lots works out days left and a status. Both work in Excel and Google Sheets, and our guide to inventory management in Excel covers the basics.
You type these columns. On Items: ID, Item, Location, Unit, Reorder at and Fill up to. On Lots: Item, Lot, Expires and Qty. The formulas fill in On hand and To order on Items, and Days left and Status on Lots. An example, as of November 13, 2026, with made-up lots:
| Item | On hand | To order |
|---|---|---|
| MS-101 Nitrile gloves, supply closet | 24 | 0 |
| MS-102 Syringe 3 mL, exam room 2 | 5 | 5 |
| MS-103 Sterile gauze, procedure room | 20 | 0 |
| MS-104 Saline flush, exam room 1 | 10 | 0 |
| MS-105 Strep A test kit, lab shelf | 3 | 3 |
| Lot | Days left | Status |
|---|---|---|
| MS-101 L2408, 14 boxes, exp 6/30/2027 | 229 | OK |
| MS-101 L2501, 10 boxes, exp 1/31/2028 | 444 | OK |
| MS-102 S9915, 3 boxes, exp 12/31/2026 | 48 | Within 90 days |
| MS-102 S0147, 2 boxes, exp 8/31/2027 | 291 | OK |
| MS-103 G7731, 20 boxes, exp 3/31/2029 | 869 | OK |
| MS-104 F2988, 2 boxes, exp 10/31/2026 | -13 | Expired |
| MS-104 F3320, 4 boxes, exp 12/15/2026 | 32 | Within 90 days |
| MS-104 F4102, 6 boxes, exp 6/30/2027 | 229 | OK |
| MS-105 T1180, 1 kit, exp 11/30/2026 | 17 | Use first |
| MS-105 T1226, 2 kits, exp 2/28/2027 | 107 | OK |
Days left is the expiry date minus today: in Lots E2, =C2-$H$1, with =TODAY() in H1. Type a date such as 11/13/2026 in H1 to match the example. The rest go in the cell named on each line. Fill down, and dates are month, day, year.
Lots F2, status:
=IF(D2=0,"",IF(C2<$H$1,"Expired",IF(C2<=$H$1+30,"Use first",IF(C2<=$H$1+90,"Within 90 days","OK"))))
Items G2, on hand without expired lots:
=SUMIFS(Lots!D:D,Lots!A:A,A2,Lots!C:C,">="&Lots!$H$1)
Items H2, to order:
=IF(G2<=E2,F2-G2,0)
Any empty cell, lots expiring within 90 days:
=COUNTIFS(Lots!C:C,">="&Lots!$H$1,Lots!C:C,"<="&Lots!$H$1+90,Lots!D:D,">0")
Any empty cell, expired lots still on the shelf:
=COUNTIFS(Lots!C:C,"<"&Lots!$H$1,Lots!D:D,">0")
A month-and-year date as its last day:
=EOMONTH(DATE(2027,3,1),0)
Here two items need an order, three lots expire within 90 days and one expired lot sits on a shelf. On hand skips expired lots, so MS-104 shows 10 boxes, not 12. Color Status with conditional formatting, and take any order already in off To order by hand.
How do you check a recall against your lot numbers?
Keep the lot number in your list, then compare it with each recall notice. The FDA lists recalls on its Recalls, Market Withdrawals, & Safety Alerts page and the most serious device recalls on its device recalls and early alerts page. The Medical Device Recall Database searches by product name, recalling firm, recall date and recall number, not by lot number. The FDA offers email sign-ups too (FDA recall resources).
- Sign up for the FDA emails.
- Find the product by name and maker, then read the lot numbers in the notice.
- Search your Lots tab for each lot number, with Ctrl+F or Command+F.
- If a lot matches, pull it from every room, mark it so nobody uses it, and follow the notice’s instructions.
- Write down what you found, what you did and the date.
A lot you never recorded can’t be searched, so write it down the day the box arrives.
What changes at a surgery center?
Implants, sutures and sterile packs all carry lots and expiry dates, so they belong on this list with a par level like any other supply. Three things differ from an office clinic:
- Stock follows cases. Case carts are pulled from preference cards, so set par by procedure: cases a week × items per case. When a surgeon changes a card, change the par the same day.
- Count by cart and shelf, not only by cabinet.
- Loaner and consigned implants aren’t yours. Mark them as the vendor’s and keep them out of your stock value.
One firm line: anything that ties a lot to a patient, such as which implant lot went into which case, stays in the clinical record. If a recalled lot was an implant, that record, not this sheet, shows who received it. This list is shelf stock only.
Which medical supply inventory system fits a clinic?
It depends on how many people count, how many lots expire, and whether the tool must link to billing. Priced tools run from $19 to $79 a month for a five-person clinic in the first year, and Sortly’s Ultra plan costs more after its first-year discount. Where five people count and order:
| Tool | Price, November 2026 |
|---|---|
| SalesBinder | Bronze $19 a month (5 users, 5,000 records) |
| GoodTaco (our product) | Free to start; Pro $49 a month includes 10 users |
| Sortly | Ultra $74 (5 users); billed yearly, first year 50% off, $149 before |
| Zoho Inventory | Premium $79 (5 users); billed yearly, per organization |
| FlexScanMD, eTurns | No price shown; a demo or trial |
| Henry Schein Medical, BD Pyxis | No price shown |
Who each suits, from their own websites:
- Practice software. Open Dental’s supply list holds a stock level, on-hand quantity and price for each supply, and its pages don’t mention expiry dates or lot numbers (Open Dental). It suits a dental office that wants one place to order.
- Your distributor’s tool. Henry Schein Medical describes a web inventory system with par levels (min/max) and suggested orders (Henry Schein Medical). It suits a clinic that buys mostly from one distributor.
- FlexScanMD and eTurns. FlexScanMD covers lot numbers, expiry dates, minimum and maximum quantities and barcode counts (FlexScanMD). eTurns’ medical page lists lots, expiry dates, min/max levels, RFID and electronic shelf labels, with a 30-day free trial (eTurns). Both suit a practice with many short-dated lots.
- Sortly, Zoho Inventory and SalesBinder. General inventory apps. Sortly items can carry an expiry date with alerts (Sortly). Zoho’s batch tracking starts at the Premium plan, with a Batch Details report you can filter by expiry date (Zoho FAQ, report). SalesBinder lists expiry dates as an item detail (SalesBinder).
- BD Pyxis. Its supply technologies use scanning, RFID or push-to-take, help manage par levels and report across a whole health system (BD). They are built for health systems; ask BD whether they fit a small clinic.
Free plans are small: Zoho’s covers 1 user and 50 orders a month, and Sortly’s holds 100 items. Which would we look at first? For one clinic with one or two people counting, the spreadsheet above costs nothing and shows whether you need more.
Can you build your own medical supply inventory app?
Yes, when a spreadsheet has run out and a clinic tool is more than you need. It opens in a browser on a phone or a computer, as a web link, as our guide to an inventory app without code explains.
The inventory management template tracks items by quantity in each location, with stock changes and purchase orders. Its sample is a plumbing and heating shop, so you rename things: locations become cabinets and rooms. You get:
- An item for each supply. SKU, category, unit, cost, the supplier’s part number, Reorder at, Fill up to, Usual order size and the count in each location.
- Four buttons on every item. Take out, Receive, Move and Count, each with an optional note, the signed-in person’s name and a time. Undo takes back your own change for 15 minutes. The note is for the room or procedure, never a patient.
- An overview of what needs ordering, listed by supplier, with what’s already on order.
- Suppliers and orders. Each supplier has a lead time. Build a purchase order from what’s low, then receive it, in part if only some arrives.
- Look-only access. Set a person to Viewer in the Users tab, and they can look stock up but not change it.
Ask GoodTaco to add lots and expiry dates. Start with this:
Turn this into a medical supply inventory app: rename locations to cabinets and rooms, and use units like box, case and each.
Then ask for the lots:
Add lots to every item: a lot number, an expiry date and a quantity for each lot. Add a page that lists lots expiring in the next 90 days, soonest first, and show expired lots in red.
Next, ask for a recall page where you type a lot number and see every matching lot, and a printable count sheet for each cabinet.
Keep your medical supply records in GoodTaco
Picture a clinic with a supply closet, two exam-room cabinets and a lab shelf. On Friday the medical assistant counts exam room 2, taps Count on the syringes and sees five boxes against a reorder level of six. The overview lists them under their supplier, with the strep A test kits. The practice manager builds one order, and when it arrives, each box goes in as a Receive.
GoodTaco builds apps like this in minutes. You change them by chatting, and every version is saved with one-click rollback. Two ways to start:
- Start from your spreadsheet. Upload your Items and Lots tabs. GoodTaco brings your supplies in, turns columns of repeated choices such as location and unit into dropdowns and rebuilds the formulas it can reproduce exactly.
- Or start from the inventory management template, with the Take out, Receive, Move and Count buttons and orders. Rename the sample records or clear them, then ask for lots and expiry dates.
Staff sign in through your GoodTaco workspace, or you invite them to a private app. Keep it to supplies. GoodTaco is free to start. Paid plans start at $9 a month, and Pro at $49 a month includes 10 users; bigger teams talk to us about Enterprise.
Know what’s on every shelf and when to reorder. Start free, no credit card needed.
Frequently asked questions
What should a medical supply inventory include?
For each supply: an item number, a name, where it is kept (room or cabinet), the unit it is counted in (each, box or case), the reorder level and the fill-up level, how many are on hand, the lot number, the expiry date and the vendor. Keep supplies only. Patient names and record numbers don't belong on the list.
What is a par level in medical supplies, and how do you set one?
A par level is the quantity you want on the shelf for an item. Some clinics use it for the level that triggers an order, and others for the level they fill back up to, so write down which you mean. A common reorder level is daily use times the days an order takes to arrive, plus a safety buffer. For example, 2 boxes of gloves a day, 4 days for delivery and 4 boxes of safety stock gives a reorder level of 12 boxes.
How do you track expiration dates on medical supplies?
Record the lot number and expiry date of every lot when it arrives, keep the soonest-expiring lot in front, and look at a list of lots expiring in the next 90 days every week. The method is called first expired, first out. In a spreadsheet, a days-left formula and a status column do the work, and expired stock is removed and left out of what you count as on hand.
How do you check a recall against your lot numbers?
Sign up for the FDA's recall emails and check its recall pages when a notice arrives. The FDA's databases search by product, firm and date, not by lot, so find the product first, then compare the lot numbers in the notice with the lot column in your list. If a lot matches, pull it from use and follow the notice's instructions. FDA labels can print a lot or batch number and an expiry date, so write both down when stock arrives.
How much does medical supply inventory software cost?
From free to a few hundred dollars a month, and some vendors quote on request. In November 2026, SalesBinder's Bronze plan was $19 a month for 5 users, Zoho Inventory's Premium plan, the first with batch tracking, was $79 a month billed yearly for 5 users, and Sortly's Ultra plan was $74 a month billed yearly for 5 users in its first-year discount, $149 before it. FlexScanMD, eTurns and the distributor tools show no price on the pages we checked. GoodTaco's Pro plan is $49 a month and includes 10 users.
Can I use a spreadsheet for medical supply inventory?
Yes, for one clinic with one or two people who count and order. Use one sheet of items with reorder levels and one of lots with expiry dates, and let formulas work out what is on hand, what to order and what expires soon. It stops working when several people edit at once, when nobody can say who took stock out, or when a lot expires unnoticed.
How often should a clinic count its supplies?
Count fast-moving items weekly or before each order, and everything on a regular schedule such as monthly. The CDC asks clinics to count vaccines at least monthly and before each order, check expiry dates during the count, and rotate stock at least weekly. Many clinics copy that rhythm for short-dated supplies.
Start from the inventory template
Get your own copy of a working inventory app with sample records, ready to make yours. Free to start.
Use the template, free