How to Track Expiry Dates in a Clinic Without Sticky Notes

Walk into the supply room of any busy medical or dental clinic and you will see them. Yellow sticky notes on autoclave pouches. Marker scribbles on lidocaine boxes. A laminated FIFO chart taped to the wall, faded from years of cleaning. These are well-intentioned attempts to solve a real problem: tracking expiration dates on hundreds of supply items, by hand, in a clinic that is also trying to see patients.

The sticky note system is a symptom of a process failure, not a solution. This guide describes a reliable, low-effort system for tracking expiry dates across all the supplies a clinic actually uses, with concrete rules for setting up alerts, rotating stock, and dealing with near-expiry inventory.

Why Expiry Tracking Matters More Than You Think

Three reasons, each more expensive than the last.

**Patient safety.** Expired anaesthetics may lose potency. Expired sterilisation indicators may give false readings. Expired bonding agents may bond poorly, leading to clinical failures. Some categories of supply matter more than others, but none of them belong in a patient's mouth or bloodstream past their expiration date.

**Regulatory compliance.** Dental and medical practices are subject to inspection. Health authorities, accreditation bodies, and in some countries dental councils all expect that expired products will not be used. The inspector who finds expired anaesthetic in your drawer does not care that it was an oversight.

**Financial cost.** Industry estimates put expired supply waste at 3 to 8 percent of total supply spend in clinics with no formal tracking. For a practice spending 60,000 euros per year on supplies, that is 1,800 to 4,800 euros going straight to the bin.

Categories of Products and Their Expiry Behaviour

Not all expiring products behave the same way. Group them when designing your tracking.

Short Shelf Life (under 6 months at point of receipt)

These need active rotation and tight tracking:

Medium Shelf Life (6 to 24 months at point of receipt)

The majority of dental and medical consumables fall here:

Long Shelf Life (over 24 months)

Less urgent but should still be tracked:

No Standard Expiry

Some items do not expire in the traditional sense but still age or degrade:

FIFO vs FEFO

Most clinics know FIFO: first in, first out. The first stock received should be the first used. FIFO works for items where every batch has roughly the same shelf life.

For products with significant variance in remaining shelf life, FEFO is better: first expired, first out. The product with the closest expiration date is used first regardless of when it was received.

In practice, run FEFO for high-risk categories (anaesthetics, sterilisation indicators, refrigerated drugs) and FIFO for everything else. The discipline matters more than the precise method.

Five Steps to Set Up Expiry Tracking

This works whether you use a spreadsheet, a clipboard system, or purpose-built software like Asseto. The software makes each step faster and more reliable, but the process is the same.

Step 1: Catalogue Every Product That Has an Expiry Date

Walk through your storage. List every product with an expiration date on its packaging. Group by category as above. This list becomes the universe of items you track.

Resist the urge to track everything. Sterile gauze that lasts five years is not your problem. Anaesthetic that expires in 14 months is.

Step 2: Record Lot and Expiry at Receiving

Every time a delivery arrives, record:

This is the most important moment in the entire system. If you do not capture this data at receiving, you cannot track expiry later. Make it part of the delivery routine. Whoever signs for the box owns the data entry.

Step 3: Set Tiered Alert Thresholds

Different products warrant different alert lead times. A reasonable default:

Asseto handles these automatically. With spreadsheets, you need conditional formatting plus a calendar reminder, plus discipline.

Step 4: Build Daily and Weekly Rotation Habits

Daily: when restocking operatories from central storage, the staff member checks the expiry list and pulls the soonest-expiring lot first.

Weekly: a designated team member spends 15 minutes scanning the supply room for items approaching their 60-day threshold. These get relocated to a use-first area.

Monthly: review write-offs from the previous month. Each expired product is a data point. Patterns reveal over-stocking.

Step 5: Handle Near-Expiry Stock Deliberately

When the system flags a product as approaching expiry, you have options.

**Accelerate use.** Move the product to a higher-volume operatory. Brief the team to use it preferentially.

**Transfer between locations.** If you run multiple sites, the near-expiry product may be useful at a busier location.

**Discount or donate.** Some products can be returned to suppliers or donated to training programmes if not yet expired.

**Write off.** If none of the above work, write the product off cleanly. Document the loss. The data tells you to reduce future orders.

What to Track for Compliance

If your practice is subject to inspection, your expiry tracking should also produce documentation. At a minimum, keep records of:

In Asseto, this is built into the stock movement workflow. Every movement records who, when, what, and how much. Audit reports generate from this data automatically.

In a spreadsheet, you would maintain separate logs and hope they reconcile.

Common Mistakes That Defeat Expiry Systems

Even good systems fail when the team works around them. Watch for these:

**The I-will-log-it-later trap.** A staff member receives a delivery, gets pulled into a patient situation, and never enters the lot numbers. The data is lost. Solution: insist on logging at receiving, not soon.

**The hidden cache.** A clinician keeps a private stock of preferred supplies in their personal drawer. These bypass the system. Solution: clear practice rule that all consumables live in central storage.

**The optimistic discount buy.** Someone buys 50 units of a product because the supplier offered a discount. The practice usually uses 5 per month. 30 of those units will expire before use. Solution: order based on consumption, not discounts.

**The forgotten refrigerator.** Refrigerated supplies require checking that the refrigerator itself is functioning. A refrigerator that drifts above proper temperature can spoil expensive vaccines. Solution: log refrigerator temperature daily, automatically if possible.

Replace Sticky Notes With a Real System

The sticky notes will keep multiplying as long as the underlying process relies on individual memory. Replace memory with a system: log at receiving, set tiered alerts, rotate with discipline, and review monthly write-offs.

Asseto handles every step of this in software designed for clinical environments. The free plan handles a single-location practice. The Pro plan adds the alerts, lot tracking, and compliance reports that make sticky notes unnecessary. Try it and see how your supply room feels when nothing expires unnoticed.