Medical Office Supply Inventory Template
For physician offices and urgent care clinics tracking exam gloves, syringes, gauze, specimen cups and paper goods. Records lot numbers, expiry dates and minimum quantities for each supply room.
Works in Excel, Google Sheets (File → Import) and Numbers. No sign-up.
| Item | Category | Lot # | Location | Unit | Qty | Min Qty | Statusƒ | Expiry | Days to Expiryƒ | Unit Cost | Valueƒ | Supplier |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Nitrile Exam Gloves, Medium | PPE | NG24-0817 | Supply Closet A | box of 100 | 36 | 15 | auto | 2027-08-31 | auto | 8.4 | auto | Allied Medical Supply |
| Sterile Gauze Pads 4x4, 12-ply | Wound Care | GZ25-1142 | Exam Room 3 | box of 50 | 12 | 6 | auto | 2027-11-30 | auto | 6.2 | auto | Allied Medical Supply |
| Luer-Lock Syringe 3 ml | Injection Supplies | SY25-0390 | Treatment Room | box of 100 | 8 | 4 | auto | 2027-04-30 | auto | 14.75 | auto | Prairie Clinical Distributors |
ƒ = calculated automatically by formula.
What's included
- Item
- Category
- Lot #
- Location
- Unit
- Qty
- Min Qty
- Status — calculated automatically
- Expiry
- Days to Expiry — calculated automatically
- Unit Cost
- Value — calculated automatically
- Supplier
Tips for using this template
- Check expiry dates monthly and move anything expiring within 90 days to the front of the shelf.
- Record lot numbers when stock arrives; if a manufacturer issues a recall, you can find affected boxes in minutes.
- Set minimums per exam room as well as for the central supply closet so rooms get restocked before clinic starts.
Stop typing deliveries by hand
Every time stock arrives you have to copy the supplier invoice into your sheet. Upload the invoice or packing slip to our invoice to inventory converter and paste SKU, item, quantity and unit cost straight into this template.
More free templates
Small Business Inventory TemplateRestaurant Inventory TemplateReseller Inventory SpreadsheetRetail Store Inventory TemplateWarehouse Inventory TemplateHome Inventory TemplateBar & Liquor Inventory TemplateOffice Supplies Inventory TemplateDental Office Inventory SpreadsheetVeterinary Clinic Inventory TemplateLab Chemical Inventory SpreadsheetFirst Aid Kit Inventory TemplateSpa Inventory TemplateTattoo Shop Inventory SpreadsheetPPE Inventory TemplateJanitorial Supply Inventory Spreadsheet