Batch Tracking for Injectables: Lot Numbers, FEFO, and Fractional Dosing

What batch tracking means for injectables

Every vial of Botox, every syringe of filler, every biostimulator that arrives at your practice has two things printed on it that most practices ignore after the chart is signed: a lot number and an expiration date.

Batch tracking — sometimes called lot tracking — means connecting those two identifiers to everything that happens downstream: what the product cost when you bought it, how much was used in each visit, what’s left in stock, and when it expires.

Most medspas do a version of this for regulatory reasons. If a patient has an adverse reaction to a Botox treatment, you need to know which lot was used. That’s compliance tracking — and it lives in the patient chart.

Margin tracking is the next step: using those same lot identifiers to track unit cost, consumption, and remaining inventory in real time. Almost no practices do this. The ones that do see their cost picture completely differently from the ones that don’t.

Lot numbers: more than a compliance checkbox

When you order Botox, you don’t always pay the same price per unit. Pricing varies by supplier, by order size, by timing, and by whether you’re buying from a distributor or direct. A lot you purchased in January at $6.00 per unit might sit alongside a lot purchased in March at $6.80 per unit.

Both lots look identical in the fridge. But they have different costs — and if you don’t track which lot you draw from at each visit, you can’t calculate accurate COGS.

Averaging across lots gives you an approximation. It might be close — or it might not be, depending on how much prices have shifted and which lots you drew from most heavily in a given month. Lot-level tracking eliminates the approximation entirely. The cost of what was used in each visit comes directly from the purchase record of the lot it came from.

This matters most when prices are volatile — which, in the injectable market, is more often than not.

What FEFO means — and what happens without it

FEFO stands for First-Expired, First-Out. It means using the batch closest to its expiration date before opening a newer lot, regardless of which arrived first.

This is the correct rotation method for injectables because expiration dates vary across lots. A shipment of filler that arrived last week might expire in eight months. A shipment from the month before might expire in five. If you open the newer shipment first — because it’s sitting at the front of the shelf — the older lot ages toward expiry in the background.

Without FEFO enforcement, this happens constantly. A new lot arrives, gets opened because it’s convenient, and the existing lot gets pushed back. Weeks later, someone discovers product that expires in two weeks. You either rush to use it or write it off.

The cost of expired injectable product is straightforward: it’s 100% waste. You paid for it, you can’t use it, and it doesn’t appear in any visit record. Without lot tracking, you don’t even know which lot expired until you physically count the fridge — and by then, the cost is already absorbed.

With FEFO enforced by software, the system selects the correct lot at each visit automatically — the one expiring soonest — and sends alerts as expiration dates approach. The expired product problem doesn’t disappear, but it becomes visible early enough to act on.

Fractional dosing: where most medspa COGS falls apart

A 100-unit vial of Botox is almost never used on a single patient in a single visit. More commonly, it’s drawn across multiple appointments: 40 units for one patient, 35 for another, 25 for a third.

Fractional dosing tracking records exactly how much was drawn from the vial at each visit — to the unit, or the milliliter — and assigns the proportional cost from that lot to each visit record.

Patient A used 40 units from a lot that cost $6.50/unit: COGS = $260. Patient B used 35 units from the same lot: COGS = $227.50. Patient C used the remaining 25 units: COGS = $162.50.

That’s the only way to know the real cost of each appointment.

What happens without fractional tracking? One of a few things, none of them accurate:

• The full vial gets assigned to one patient. Patient A’s appointment shows $650 in product cost. Patients B and C show $0. The total is correct across the vial; the per-visit numbers are fiction.
• The cost gets averaged across the month. Total product spend divided by total visits gives a rough per-visit COGS. It smooths the variation completely and tells you nothing about individual service margins.
• Partial vials get written off as waste. Any unused portion becomes a write-off — even if it’s used in a subsequent visit. The cost disappears into a waste account that nobody examines closely.

In each scenario, the per-visit COGS is wrong. And if per-visit COGS is wrong, margin per visit is wrong — which means every pricing and performance decision built on that data is built on fiction.

What shrinkage looks like without batch tracking

Injectable shrinkage is the gap between what you purchased and what you can account for in visit records. It has several sources: provider overuse, spillage, expired product, unrecorded samples, and outright recording errors.

Without lot-level tracking, shrinkage is invisible until you conduct a physical inventory count and compare it to purchase records. That reconciliation typically happens monthly at best — and it produces a number (the variance) without any explanation of where the gap came from or which visits contributed to it.

With lot tracking and fractional dosing records, the shrinkage calculation runs continuously. At any point, you can see the opening stock of a lot, add the units received in subsequent purchases, subtract the units recorded as used in visits, and arrive at the expected remaining stock. Compare that to what’s physically in inventory and the gap is your shrinkage — with a clear trail of exactly where it diverged.

In a practice doing $500,000 per year in injectable revenue, 5% shrinkage is $25,000 in unaccounted product cost annually. That’s not an edge case — it’s a common outcome for practices without granular inventory tracking, and it compounds quietly until a physical count forces the reconciliation.

What good batch tracking looks like end-to-end

The full workflow, when it works correctly, looks like this:

1. Product arrives. Each lot is logged: lot number, expiration date, quantity received, unit cost from the purchase order. This is the cost basis for every future COGS calculation from that lot.
2. A visit is scheduled. The system identifies the correct lot to use for the product — the one expiring soonest — and makes it available for the appointment record.
3. The visit happens. Fractional usage is recorded: how many units, how many mL, drawn from which lot. The visit record carries the real COGS from the lot’s unit cost.
4. Inventory updates automatically. The lot’s remaining stock decreases by the amount used. The lot stays open until exhausted, then closes with a complete usage history.
5. Expiration alerts fire proactively. Days or weeks before a lot expires, an alert surfaces — giving you time to prioritize its use before it becomes waste.
6. Shrinkage is visible in real time. Expected stock versus actual stock is always calculable from the lot records. The gap is shrinkage — and it has a timestamp and a dollar amount, not just a month-end total.

This is the operating standard that makes true margin visibility possible. Without it, you’re always estimating — and in an injectable-heavy medspa, estimation is where margin goes to disappear.