NorthCore Labs

Med spa inventory and lot tracking: the Friday vial count is the margin report, if anyone keeps it.

Med spa inventory tracking is the weekly count of what was bought, what was charted and what is on the shelf, with the lot number on every unit. Bought minus charted minus on hand is waste, and waste priced at the invoice is the line that moves margin. Lot numbers recorded per patient at the chair answer the recall question in one query. The count takes a fixed slot on a Friday and feeds the margin report: cost of goods per treatment, by provider, with waste on its own line. What the chart must record, and for how long, is a question for your medical director and counsel.

Updated 2026-10-26

CalculatorWhat does one treatment leave you?

Cost of goods is the product plus everything that touched the patient

Cost of goods for one treatment is the product used plus every consumable that touched the patient, priced from the supply invoice. For neurotoxin that is units drawn, diluent, syringes and gloves. For filler it is the syringe, the cannula or needle, numbing and gauze. For an IV it is the bag, the tubing set, the catheter, the additive by the dose drawn, and disposal. The full cost list, with time and room added, is in the unit economics guide. This page is the inventory side: where the product line on that list comes from, and how to keep it honest week to week.

Vial yield is units charted, never units on the label

A vial has a number of units on the invoice. The number that matters is units charted against it before it is discarded under the window your medical director sets. Say a vial holds 100 units on the invoice and the chart shows 84 drawn before the window closed. In this illustrative example the yield is 84 percent, and 16 units were paid for and never sold. Divide the invoice price by the units charted, and the cost per unit on the margin report is the one the practice is living with. The same arithmetic runs for a filler syringe opened and not finished, if your medical director's policy discards it.

Waste has three causes, and the log names each one

  • Opened for a no-show: a vial opened for a chair that canceled, and the units unused inside the window. The fix is upstream: open against a patient in the room, not a name on the calendar.
  • Drawn and not charted: units drawn that never reached the chart, because the chart was written from memory after the last patient left. The fix is charting units at the chair, before the next patient.
  • Expired on the shelf: product that aged out before it was opened, because the order was sized to a promotion instead of to next month's charted usage. The fix is ordering from the count.

Each cause gets its own line on the waste log: date, product, lot, units, cause, provider. Over a month the log shows which cause is costing the money, and the fix for each is different.

Lot numbers answer the recall question in one query

Every unit that goes into a patient came from a box with a lot number on it. The operational rule is that the lot is recorded against the patient and the treatment at the chair, in the chart, at the time it is used. What the chart must hold, and for how long, is your medical director's call, with counsel; requirements vary by state. The reason to do it is the recall question. If a manufacturer recalls a lot, the practice will be asked for every patient who received it, with dates, and the question is how long that list takes to produce. A practice that tracks lots in the chart has that list in minutes. A practice that tracks lots on a receiving sheet in the back room has to read every chart from the receiving date forward. What to do with the list once you have it is your medical director's decision, with counsel.

The Friday count fills five columns

ColumnWhere it comes fromWhat it catches
Bought this weekSupply invoices, by product and lotAn order placed for a promotion that never ran
Charted this weekUnits and syringes on the chart, by providerUnits drawn and never written down
On hand, countedThe shelf and the fridge, counted by hand, by lotThe vial that walked, and the one that expired
Waste, loggedThe waste log, by causeWhich cause is costing the money
VarianceLast week on hand, plus bought, minus charted, minus waste, minus this week on handAnything the other four columns did not explain

Priya and Dana do the count every Friday before the weekend order goes in. A variance that is not zero is Monday's first question. The order comes from the count: next week's charted usage plus a reserve, minus what is on hand, oldest lot used first.

The margin report the count feeds

Cost of goods per treatment on the margin report comes from this sheet. Invoice price divided by units charted gives the cost per unit, and consumables per treatment come from the cost list. The month's waste is spread across the month's treatments on its own line. By provider, the report shows whose units drawn match whose units charted, and whose waste log is longest. By treatment, it puts the product line beside the price, so the margin the practice believes it makes on tox or filler is the margin the count supports. A margin report without the count is a price list with a guess under it.

How to start the count this Friday

  1. Print last month's supply invoices and write the product, lot, units and price per unit on one sheet.
  2. Count the shelf and the fridge by lot, and write it in the on-hand column.
  3. Pull units charted for the month from the record system, by provider, and write the total.
  4. Subtract. What is left is the month's waste and variance, priced at the invoice. Start the waste log on Monday so next month's number has causes beside it.

What to do next

NorthCore's Know your numbers solution puts the count sheet and waste log beside revenue by treatment and provider, variance on its own line; the lot-per-patient lookup stays in your record system. Results in 90 days, or we keep working until you have them.

Have this built for your practice.

Know your numbers is the solution this guide belongs to, one of ten jobs in the system we build and run on the software you already use. Scoped in writing. Results in 90 days, or we keep working until you have them.

Questions people ask.

How do I calculate cost of goods for a neurotoxin treatment?

Invoice price for the vial divided by the units charted against it, times the units Jess received. Add the diluent, syringes and gloves from the cost list, and a share of the month's waste. The unit economics guide on this site adds the provider's time and the room.

Do med spas have to track lot numbers?

What the chart must record, and for how long, is a question for your medical director and counsel; requirements vary by state. Operationally, the lot recorded per patient at the chair is what lets the practice answer a recall in one query instead of a week of chart reading.

How often should a med spa count inventory?

Weekly, on a fixed day, before the order goes in. A monthly count leaves four weeks of unexplained variance and no way to tell a no-show vial from an uncharted draw. A fixed slot on a Friday is the cost.

Can the inventory count run from the record system automatically?

Partly. Units charted and the lot per patient stay in the record system, invoices come from the supplier, and the on-hand count is a person at the fridge with a clipboard. NorthCore's Know your numbers solution takes the count sheet and the invoice totals you enter and shows the variance and the waste line beside revenue the same day.

Bring the system into your practice.

Walk us through how the practice runs today. We show you what we would build first and how fast. If nothing here fits, we say so on the call.

No card, no contract
A calendar invite and a Zoom link the moment you book.
Prefer email?
admin@northcorelabs.io
NorthCore Labs LLC
7901 4th St N, Ste 300, St. Petersburg, FL 33702