Med Spa Inventory Reconciliation: Fix Botox and Filler Counts (November 2026)
Med spa inventory reconciliation, step by step: find why Botox and filler counts drift, fix double deductions, and close the month with numbers you trust.
TL;DR
5 key points- 01A unit of Botox or a syringe of filler can leave stock at the chart, at checkout, or both. Counts drift when those two paths use different rules.
- 02Sort every variance into one of five causes before adjusting anything: double deduction, under-deduction, unlogged waste, prepaid purchases and import gaps.
- 03Fix the rule first, then take one physical count by location and lot, then post one adjustment with a written reason.
- 04Never re-save old notes to repair history. That can deduct the same units a second time.
- 05Count injectables weekly. A ten-minute check catches a bad rule in days instead of at month end.
Why Botox and Filler Counts Drift in the First Place
Injectable counts drift because one unit has several places it can be recorded: the treatment chart, the checkout, the supplier receipt and a manual adjustment. When two of those places each take stock out, the count falls twice. When neither does, it never falls at all.
Consumables are easier. A needle is used once and nobody argues about it. A 100-unit vial of neurotoxin is split across several patients, charted in units, billed in units or areas, and sometimes prepaid weeks before it is used. Filler adds syringe-versus-milliliter confusion on top.
Two situations show up again and again with clinics we talk to. In the first, staff chart the dose in the note, then search for the same product and add it again at checkout. The system sees two separate events, so two quantities leave stock. In the second, the chart deducts a fixed quantity per entry, such as one unit, instead of the units actually charted. A 60-unit visit takes one unit out of stock, billing is correct, and the count creeps up month after month.
Most vendor advice for this topic stops at "count regularly" and "link inventory to treatments", as in OptiMantra's inventory reconciliation guide. That is correct and not enough. The part that decides whether you can close the month is knowing which of the five causes below you have.
The Five Causes of an Injectable Variance
Every gap between the system and the fridge falls into one of five buckets, and each one has a different fix. Sorting them first stops you from adjusting a number that a rule change would have corrected.
| Cause | What the count looks like | How to confirm | Fix |
|---|---|---|---|
| Double deduction | System shows less than the shelf | Same patient, same product, a chart entry and a separate checkout line | Charge from the charted dose, not a fresh line |
| Under-deduction | System shows more than the shelf | Charted 60 units, stock fell by 1 | Fix the draw rule so it follows the dose |
| Unlogged waste | System shows more than the shelf | Units drawn exceed units charted | Log waste as its own line |
| Prepaid purchases | Activity log looks like it is missing sales | Purchases that were banked, not yet administered | Reconcile against prepaid balances, not stock |
| Import or receipt gaps | Gap starts on one date | Sales before the first inventory log, or a delivery never entered | Start counting from a known date |
Pull a sample of ten visits from the last two weeks and put each one in a bucket. If eight of ten land in the same row, that is your rule problem. If they spread across rows, expect a process problem as well.
Chart-First and Checkout-First Visits Deduct Differently
A visit that is charted before checkout and a visit that is added straight at checkout can deduct different amounts, which explains why a variance hits some patients and not others. The pattern is predictable once you know to look for it.
Take a neurotoxin visit. If the provider charts 40 units and the system deducts per unit charted, stock drops by 40, and checkout should not take another 40. If the system instead deducts a fixed quantity per chart entry, stock drops by 1, and the clinic only looks right when someone skipped the chart and rang the units up at checkout. Same medication, same patient, different count depending on the order the screens were opened.
To test your own setup, run two visits on purpose with a small quantity, one charted first and one rung up first, and watch the stock activity for each. You are looking for exactly one deduction per administered unit, and nothing else. Do it for a neurotoxin and for a filler, because syringes and units are set up differently.
Our post on Botox pricing per unit explains why units, areas and syringes need different billing logic, which is also why they need different deduction logic.
Log Waste and Partial Vials Separately
A single-dose vial that is opened for one patient cannot be kept for the next, so any units not injected are waste and belong on their own log line. If waste is left unrecorded, the gap between units drawn and units charted lands in your variance every month.
The CDC's injection safety guidance says leftover contents of a single-dose vial should not be kept or pooled for later use. Check the label for your product, since some neurotoxins are labeled for reconstitution and use within a set window, and follow your medical director's protocol on multi-patient use.
A written institutional example helps. Texas Tech's El Paso campus publishes a neurotoxin inventory log policy that starts a log per lot, records lot, expiry and NDC, requires witnessed waste, and audits weekly. A med spa does not need a hospital's paperwork, but the shape is worth copying: per-lot entries, waste on its own line, a second person on the discard and a weekly review.
Waste also shows how well you are working. If one provider's waste runs consistently above the others, the cause is usually reconstitution volume or vial choice, and that is a coaching conversation instead of a stock problem. The injection log template shows the fields each administered dose should carry.
Prepaid Purchases Should Not Touch Stock Until the Dose Is Given
A patient who buys 40 units today and gets 20 now and 20 in three months has paid for product that has not left your fridge. Stock should fall when units are administered, and the unused balance should sit in a prepaid report that you reconcile separately.
This is why an activity log can look like it is missing sales. The purchase exists, the revenue exists, but there is no stock movement because nothing was given. Auditors of your own books should expect that pattern, and your staff should know it is normal. Our guides on package refund and credit policy and patient wallets and banked units explain how to treat the unused balance.
The practical rule is to keep two numbers apart: physical units on hand, and units owed to patients. The first should match the fridge. The second should match the liability on your balance sheet. A month where both reconcile is a clean month.
Know Which Date Your Inventory History Starts
If you moved systems mid-month, sales from before the first inventory movement have no matching stock log, and treating them as a variance will send you chasing numbers that were never wrong. Pick a start date, count everything on that date, and reconcile forward from there.
The same applies to deliveries. A shipment that was received and shelved but never entered looks like a large unexplained surplus or, worse, gets patched with a manual adjustment that hides the real error. Before a count, check that every supplier invoice from the period has a matching receipt.
If you are mid-migration, our guide on what transfers when you switch EMRs lists what history comes across and what does not, which tells you where your reconciliation window should open.
The Month-End Reconciliation, Step by Step
The order matters: freeze the rules, count the physical stock, reconcile the data, then post a single adjustment. Reversing that order is how clinics end up adjusting twice.
- Stop the leak. Confirm the deduction rule is right for each injectable using the two-visit test above. Changing the rule does not repair past visits, so note the date you fixed it.
- Count the physical stock. Record vials, partial vials and syringes by location and lot. Have someone other than the person who orders count it.
- Pull system on-hand for the same moment. Use a timestamp or end-of-day so late checkouts do not move the number.
- Explain the difference. Put each sample visit in one of the five buckets. Waste and receipts first, prepaid balances second, deduction errors last.
- Post one adjustment per product and location. Write the reason, the date of the count and the date the rule changed.
- Do not re-save old notes. Re-saving a historic chart can trigger a fresh deduction for units you already corrected for, so the count falls twice.
- Recount a few products the next week. If the variance returns, the rule is still wrong.
A realistic example, with made-up numbers: the system shows 1,200 units of neurotoxin and the fridge holds 1,000. Waste logs explain 40 units and a late delivery explains 20, leaving 140 units from visits charted before checkout that deducted one unit instead of the dose. One adjustment of 140 units, with that note, closes it. Next month's count is the test.
Accounting follows the same logic. If the balance sheet carries injectables as inventory, the adjustment flows to cost of goods sold, so reconcile before you hand numbers to your bookkeeper. Med spa KPI tracking shows which margin numbers move when product cost changes.
How Decoda Health Handles Injectable Stock
Decoda Health links each medication to a stock item with lot and expiry captured at receipt, and lets you set how much a dose draws from that stock, so charted units can leave inventory when the dose is saved. The inventory page and the medications page show how those pieces connect.
The draw rule is a setting per medication, so review it for every injectable you carry, especially anything sold by the unit. Stock activity shows adjustments, charted doses and checkout deductions, which makes the five-bucket sort quicker than reading receipts. Prepaid items are handled through packages, so a banked purchase is a balance and not a stock movement.
Reconciliation still needs a human with a clipboard. No system can tell you that a vial was dropped or a delivery was left in a hallway. What good software does is make sure the system number is a fair record of what staff did, so any gap you find is real. The earlier injectable inventory tracking guide compares systems, and the consumables inventory guide covers the supplies around the drug.
Final Thoughts on Med Spa Inventory Reconciliation
Do not adjust a number you cannot explain. Run the two-visit test this week, sort ten recent visits into the five buckets, count the fridge once, and post a single adjustment with the reason attached. If a rule was wrong, you will see the same variance come back and know where to look.
Review the deduction setting for every unit-based medication before the next close, and ask any vendor you are evaluating to show a charted visit and a checkout visit producing the same stock movement. Our medical spa software overview lists what else to check, and the chart review guide covers how sign-off catches mismatches. To see how Decoda Health handles it on your own injectables, book a demo.
Frequently Asked Questions
What is inventory reconciliation in a med spa?
Inventory reconciliation is comparing what your system says is on hand with what is physically in the fridge and stockroom, then explaining every difference. For injectables it means matching units charted to patients, units sold at checkout, and units received from suppliers. The goal is a count you can defend at month end, not a perfect zero.
Why does my Botox inventory not match what I charted?
The usual cause is that a unit leaves stock in more than one place. The chart can deduct when the dose is saved, and checkout can deduct again when the same product is sold. If the two paths use different rules, you get double deductions on some visits and under-deductions on others. Prepaid purchases, mid-month imports and manual adjustments add more noise.
How often should a med spa count Botox and filler?
Count injectables weekly and everything else monthly. A short weekly count of neurotoxin vials and filler syringes is a ten-minute job, and it surfaces a bad deduction rule within days instead of at month end. Cold-storage items are few and expensive, so they deserve the most frequent check.
How do I fix inventory after finding a variance?
Correct the cause first, then adjust stock once. Fix the deduction rule or the checkout habit, take a physical count by location and lot, and enter a single adjustment for the difference with a written reason. Do not re-save old notes to force corrections, because that can deduct the same units a second time.
Do I need to track partial vials and wastage?
Yes. A single-dose vial opened for one patient cannot be saved for the next, so the unused units are waste, not leftover stock. Log them as a separate line with a reason. Otherwise the difference between units drawn and units charted shows up as an unexplained variance every month.
Should banked or prepaid injectable purchases reduce stock?
Not at purchase. A patient who prepays for 40 units has not received them yet, so stock should only drop when the units are administered. Treat prepaid balances as a liability on the books and as a separate report, and reconcile them against what is still owed to patients.