Med Spa Inventory Software: Comparison & Reconciliation Guide

Updated September 19, 2026. Vendor-authored operational guide by Prospyr. Examples are invented; this is not a drug-handling protocol.

What is the best way to compare med spa inventory software?

Compare how each system handles the same product from receipt to use, sale, adjustment and physical count. Record quantities in an explicit unit, require a reason for discrepancies and verify the export. A long feature list cannot tell you whether a vial, a treatment unit and a retail item are being counted consistently.

The right choice depends on how your practice sells and uses inventory. A spreadsheet can support a small controlled count; it becomes harder to maintain when multiple staff, locations and clinical workflows change stock simultaneously.

Compare approaches before comparing vendor names

Prospyr is one connected option: its inventory feature describes unit-level injectable tracking, appointment-linked usage and stock reduction for invoiced products, tied to the same patient record as its aesthetic EMR. Have the team demonstrate the exact configuration you need. For vendor-specific evaluation, use the comparison library; confirm current capabilities and contract terms directly rather than relying on a universal ranking.

How do you reconcile expected stock with a physical count?

For a defined product, location, unit and cutoff time:

Expected closing stock = opening stock + receipts + transfers in − sales/clinical usage − documented waste − transfers out + approved net adjustments.

Variance = physical count − expected closing stock. A negative variance means fewer units were counted than expected. It does not, by itself, establish theft or identify a person responsible.

Use either a signed net adjustment or separate positive/negative adjustment columns; do not include the same movement twice. Confirm whether an invoice and its related treatment usage represent one deduction or two distinct movements.

Worked example

An invented item opens with 100 units. The practice receives 50, records 20 units sold, 30 used in treatment and five wasted. With no other movements, expected stock is 95 units. A physical count of 92 creates a −3-unit variance. Pause and check the count, cutoff, units, receipts and duplicated/missing movements before approving any adjustment.

Do not convert a physical stock example into instructions for preparing, storing or reusing medication. Follow the actual product labeling and practice-approved clinical policies.

A count your team can repeat

1. Set a cutoff and choose whether movements stop or are logged separately during the count.
2. Define the product, lot where applicable, location and unit of measure. Keep unopened containers and partial quantities distinguishable.
3. Record opening balances and all movement categories from the same period.
4. Perform the physical count under your review process; recount discrepancies before changing the ledger.
5. Investigate the variance, record supporting internal references and assign a reviewer.
6. Approve any adjustment under your policy and retain the original count and explanation.

The inventory reconciliation answer and fillable workbook below provide planning fields for this process. Use internal references only; keep identifiable patient information in the clinical system.

Reorder planning without a guessed “perfect” quantity

A basic illustrative reorder threshold is expected usage during supplier lead time plus safety stock. At eight units per day, five days of lead time and ten units of safety stock, the threshold is 50 units. Real planning also needs open orders, shelf life, supplier variability and cash constraints. This example is not a recommended stocking level.

Bring these scenarios to the demo

• Receive a product and confirm the unit used for purchasing versus treatment.
• Record a sale and its related clinical use; prove the stock is not deducted twice.
• Reverse or correct a mistaken movement while preserving review history.
• Transfer stock between locations and show both sides of the movement.
• Count an item with a variance and export the movements supporting it.
• Review a lot/expiration workflow if your practice requires one; confirm which fields and alerts are actually available.

Ask about import cleanup, opening balances, training, recurring costs and integration support. See Prospyr's inventory workflow using fictional stock and transactions.