Dental Office Inventory Spreadsheet
For dental practices tracking composites, impression material, anesthetic carpules, bibs and sterilization pouches. Keeps lots, expiry dates and reorder minimums in one place for the whole team.
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Universal Composite, Shade A2, 4 g | Restorative | CP25-A2-118 | Operatory Cabinet | syringe | 6 | 3 | auto | 2027-06-30 | auto | 38 | auto | Brightsmile Dental Supply |
| Self-Seal Sterilization Pouch 3.5x10 | Sterilization | SP25-7741 | Sterilization Center | box of 200 | 9 | 4 | auto | auto | 11.5 | auto | Brightsmile Dental Supply | |
| Patient Bibs, 2-ply, Blue | Disposables | BB25-0019 | Supply Room | case of 500 | 3 | 1 | auto | auto | 29 | auto | Coastal Dental 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
- Track composite and bonding agents by shade and lot; many need refrigeration and have short dating once opened.
- Count sterilization pouches and indicator strips weekly, since every procedure depends on them.
- Assign one team member to review the sheet before the weekly supply order so orders aren't duplicated.
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 TemplateMedical Office Supply Inventory TemplateVeterinary Clinic Inventory TemplateLab Chemical Inventory SpreadsheetFirst Aid Kit Inventory TemplateSpa Inventory TemplateTattoo Shop Inventory SpreadsheetPPE Inventory TemplateJanitorial Supply Inventory Spreadsheet