A practical answer / sources and examples

How do you reconcile inventory in a med spa?

Prepared by Prospyr · Reviewed 2026-09-19

Get the free workbook →

The short answer

Choose a product, location, unit and cutoff time. Calculate expected closing stock from opening balance and recorded movements, then compare it with a physical count. Investigate the difference and obtain the required review before approving an adjustment.

Keep the unit and period consistent

Add receipts and transfers in to opening stock; subtract sales, clinical usage, documented waste and transfers out; include approved net adjustments. Avoid counting a sale and its related treatment movement twice.

Preserve the variance and explanation

Variance equals physical count minus expected stock. A negative number means less was counted than expected, not proof of theft. Recount, review cutoffs and check movements before adjusting the ledger.

Your practical checklist

  1. Define item, location, unit and cutoff.
  2. Confirm opening stock and movement categories.
  3. Count physical stock and recount discrepancies.
  4. Investigate units, timing and duplicated or missing entries.
  5. Record reviewer, approved action and internal evidence references.

A worked example

Invented stock: 100 opening + 50 received − 20 sold − 30 used − 5 wasted = 95 expected units. A count of 92 gives a −3-unit variance to investigate. This is not guidance on preparing, storing or reusing any medication.

Illustrative workflow example; not a patient case or individualized recommendation.

Mistakes to avoid

  • Mixing vials, milliliters and treatment units without an approved conversion.
  • Changing balances before investigating the count.
  • Putting identifiable patient data in the worksheet.

Official sources and review scope

Prepared by Prospyr from the cited primary sources. These are educational workflow resources, not individualized clinical, coding, legal or tax advice. No clinician, certified-coder or attorney review is claimed. Confirm current code instructions, payer terms and applicable law for the actual service and date. CPT is a registered trademark of the American Medical Association; this is not a substitute for a licensed current code set.

Related questions

Connect your practice workflows.

Prospyr brings charting, digital intake, inventory and practice operations together. Insurance billing is on Prospyr's roadmap but is not available today. Prospyr supports your aesthetic practice's clinical and business workflows now. If you bill payers, keep a separate claims solution in place and discuss your requirements with our team before switching.

See Prospyr for your practice →