Dental inventory management
- Variance in units (negative is a shortfall)
- -86
- What the shortfall cost you to replace
- $1,075
- Count accuracy, percent of expected found
- 96.4
The arithmetic on these sheets is your own count: units, unit cost and reorder point in, variance and value out. Nothing is estimated and no industry average is applied to your numbers. Where a page states an outside figure it names the document it came from and links to it.
A dental practice holds four kinds of stock in one cupboard and only one of them behaves like ordinary consumables. There are the everyday items nobody thinks about until the last box is open; the dated materials that are worthless the day they expire; the devices that carry identifiers a regulator expects you to be able to produce; and, in practices that hold them, controlled substances with their own inventory rule. A single spreadsheet with a quantity column handles the first and quietly fails the other three. This page is about counting a practice's cupboard so that each kind is counted on its own terms. Everything below assumes a practice with one cupboard and one nurse who ends up responsible for it, because that is what most independent practices actually have.
Open the Inventory spreadsheet template Free to use. No account, no card, no trial clock.
Separate the cupboard into four lists before you count anything
Everyday consumables, dated materials, identified devices, and anything scheduled. They need different columns and different rhythms, and a single list forces all four onto the weakest one. Doing this split once is the difference between a count that takes twenty minutes a week and a project that is abandoned in March. In practice the split is usually easiest by shelf: one shelf becomes one list, and where a shelf holds two kinds the dated items move. Physically arranging the cupboard to match the lists is the step that makes the count survive a change of nurse, because the next person can see the structure without being told it.
Count everyday consumables against usage, not against a feeling
Gloves, bibs, suction tips and cotton rolls run down at a rate that is roughly proportional to chair hours. Count the boxes, enter the units and the cost, and let the reorder point do the thinking. It is the one part of the cupboard where the arithmetic on this site is the whole answer. A useful shortcut is to count per chair: a practice running three chairs consumes roughly three times what one consumes, so a per-chair figure is what tells you whether one surgery is unusually heavy. Enter the whole practice's figures on one sheet and the per-chair sanity check is a division you can do in your head.
Count dated materials by date first and quantity second
Impression material, composites, bonding agents, anaesthetic cartridges and endodontic irrigants are worth nothing after their date. Sort the shelf so the nearest date is at the front and record the date alongside the count. A practice that finds three unopened boxes a quarter past their date is losing real money at its own cost per unit, which is exactly the figure the sheet prices. There is a second reason to record the date rather than only the quantity, which is ordering. A material with four months left is a material you should not be buying more of at a bulk discount, and the discount is exactly what caused the expiry write-off in the first place.
Record identifiers on devices that carry them
Devices distributed in the United States carry a unique device identifier under the FDA's UDI rule, and the reason a practice records it is not paperwork: it is being able to answer, on the day of a recall notice, whether the affected lot is in your cupboard or in a patient. Put the identifier in the line's reference field when you count. The same field does double duty at insurance renewal and at sale of the practice, both of which ask for a schedule of what is held. A cupboard count that already carries identifiers turns each of those into an export rather than an afternoon.
Keep the scheduled cupboard on the rule, not on your own schedule
A practice registered to handle controlled substances takes a new inventory of them under the DEA's inventory rule, and that count is separate from everything above: separate list, separate signature, kept where an inspector can be shown it. Do not fold it into the general count to save time; the general count has a different purpose and a different audience.
Price the gap and take it to the practice meeting
Variance in units is a curiosity; variance in dollars is an agenda item. A count that says 140 units short at an average $1.85 is $259 this quarter and about a thousand a year, which is a conversation about ordering discipline rather than about people. The sheet gives you that number from your own costs.
Stock counts: what people ask before the first one
How often should a dental practice count? Everyday consumables monthly, dated materials monthly with a date sweep, devices at the annual equipment review, and anything scheduled on the schedule the DEA rule sets rather than one you pick. The dated sweep is the one most practices skip and the one that pays for itself fastest. A practical rhythm for a single-site practice is the last Friday of the month for consumables and dated items together, because the date sweep is quick once the shelf is arranged for it, with the device and equipment list picked up at the annual maintenance visit when an engineer is on site anyway.
Who should do the count? Not the person who places the orders, if you can avoid it. This is not about suspicion; it is that the person who ordered knows what should be there and will see it. A nurse who does not order will count what is in front of them, which is the entire point of counting. If the practice is too small for that separation, and many are, the next best control is that the count is entered by one person and reviewed by another, with the variance discussed rather than filed. The review is what makes the number matter.
What do I do about items in an open box? Count the box as the unit and record openings separately, or count to the smallest unit and accept that the count takes longer. Pick one and never change it mid-year. A practice that counted boxes in January and units in April has a variance that measures its own method.
Do hazardous materials need anything extra? The materials in a practice that carry a hazard classification have safety data sheet and labelling duties under the federal hazard communication standard, and the practical overlap with inventory is that the list of what you hold and the list of what you have sheets for should be the same list. Counting is a good time to notice they are not.
Can this replace practice management software? No, and it is not meant to. Practice management software runs the diary and the ledger; this runs the cupboard. What it gives you that the diary cannot is the variance, the value of the gap and a reorder point you set yourself. The two also answer to different people. Practice management software answers to the clinicians and the patients; the cupboard record answers to whoever signs the supplier invoices, and that person usually has no login to the first one.
Will the Dental inventory management fit what you count?
Tell us what you are counting and how you count it today, and we will tell you whether Stocktaka fits before you pay for anything.