Inventory day is one of those tasks that should take an hour and consistently takes four.
Not because your team is slow. Not because your systems are broken. Because there is not just one number to check — there are four. What you ordered. What you received. What your POS says you have. And what is actually sitting on the shelf. Those four numbers almost never match, and tracking down the reason why is where the entire morning disappears.
Most aesthetic practice owners have accepted this as an unavoidable cost of running a product-based business. It is not. It is a data problem, and AI is very good at solving data problems.
Here is the workflow that cuts medical spa inventory reconciliation from four hours to thirty minutes — including the exact prompts to use.
The standard inventory process goes something like this: someone does a physical count and writes the numbers down. Someone else checks the POS. A third person pulls the invoices from the last sixty days. Then someone — usually you — sits down and manually compares three sources of information across dozens of line items, looking for discrepancies that could mean a receiving error, a data entry mistake, or product that walked out the door.
That last step is where the time goes. Not the counting. The comparing.
AI does not get tired of comparing. It does not lose its place halfway down a spreadsheet. Hand it three documents and ask it to find the gaps, and it will surface every discrepancy in seconds, formatted in a table, with a column for the variance on every line.
The only thing standing between your current process and this one is an export from your POS system — something every major platform in the aesthetic industry can do in under two minutes.
AI cannot log into your POS system directly. It reads the files you give it. That means this workflow requires you to export your inventory data as a spreadsheet or CSV before you begin. If you have never done this, your POS provider has a tutorial — it is typically under Reports or Inventory in your dashboard.
Common POS systems used in aesthetic practices and their inventory export paths:
- Mangomint: Reports > Inventory > Product Inventory Report > Download Excel
- Boulevard: Reports > Inventory On-Hand Report > Download/Export
- Aesthetic Record: Inventory > Your Inventory > Options > Download CSV or Download Excel
- Jane App: Reports > Inventory > three-dot menu > Export to Excel/CSV > Download
- Vagaro: Reports > Inventory Summary > Run Report > Export
If your system is not listed here, search “[your POS name] inventory export CSV” and you will find the exact steps.
On the patient data question — inventory reconciliation involves zero patient information. No names, no treatment records, no identifying details of any kind. This is one of the cleanest, most straightforward AI use cases available to a medical spa, with no HIPAA considerations to navigate. You can proceed without hesitation.
Step 1: Export your current inventory from your POS.
Pull a full product inventory report for your current stock levels. Export it as a CSV or Excel file. This becomes your “what the system thinks you have” document.
Step 2: Gather your recent invoices or purchase orders.
Pull invoices from your vendors for the last 60 to 90 days. These arrive from Allergan, Galderma, Revance, Merz, your skincare distributors, and any other suppliers. Most come by email as PDFs. Download them and have them ready.
If you keep purchase orders on your own side, pull those instead — or use both. The goal is a record of what was ordered and what was invoiced.
Step 3: Complete your physical count.
This step does not change. Someone still walks the shelves with a count sheet. The difference is that instead of a handwritten clipboard number you then manually enter somewhere, you are building a structured document you will upload alongside the others. A simple spreadsheet with product name and physical count quantity is enough.
Step 4: Upload all three to ChatGPT or Claude and run the analysis.
Open ChatGPT (any paid plan with file uploads) or Claude. Upload your POS export, your invoices, and your physical count sheet. Then use the prompts below.
Use these in order. Each one builds on the previous output.
Prompt 1 — Reconciliation
“I am going to give you three documents: (1) an inventory export from my POS system showing current stock levels, (2) my vendor invoices or purchase orders from the last 60 days, and (3) a physical count I completed today. Please compare all three and identify any discrepancies. Specifically, I need to know: where the POS quantity does not match my physical count, and where products appear on invoices but are not correctly reflected in the POS. Present your findings in a table with four columns: Product Name, POS Quantity, Physical Count, and Variance. Flag any item with a variance greater than two units.”
Prompt 2 — Root Cause Analysis
“Based on the discrepancies you found, what is the most likely explanation for each one? For each item with a variance, give me a one-sentence assessment of whether this looks like a receiving error, a POS entry error, a timing issue where a recent delivery may not yet be entered, or a shrinkage concern. Keep it to one line per product.”
Prompt 3 — Reorder Recommendations
“Based on my physical count and the ordering frequency visible in my invoices, which products appear to be running low relative to a typical reorder cycle? Flag any product where current stock levels suggest I may run out before my next order would normally arrive. List them in order of urgency.”
That third prompt is the one that tends to surprise people the most. You are not just reconciling what you have — you are getting a forward-looking reorder signal based on your own data patterns, without building a single formula in a spreadsheet.
Once AI has produced your reconciliation table, your root cause notes, and your reorder list, your job is to review and act, not to figure out what the numbers mean. That is the shift. You go from spending four hours building the analysis to spending thirty minutes reviewing it.
Save the output as a Google Doc. Use it as the agenda for a quick team conversation about any receiving discrepancies. Place your reorders. Update your POS where entry errors are identified.
Then save Prompt 1 through Prompt 3 in your Prompt Library — the section inside your AI Operating Manual where your best prompts live. The next time inventory day arrives, the entire setup takes five minutes instead of starting from scratch.
This is how incorporating AI into your aesthetic practice can make you more efficient and save you money, one system at a time.
Subscribe to Our Newsletter
Stay up-to-date with our email newsletter to receive important updates, news, and offers!
About the Author
Daniela Woerner is the founder of Addo Aesthetics and creator of the Growth Factor® Framework, a proven system that’s helped hundreds of spa owners build profitable, systemized businesses. With 20 years in the aesthetics industry, she transforms overworked service providers into confident Spa CEOs through strategy, systems, and soul-led support. Daniela is also the host of Spa Marketing Made Easy, a top-ranked podcast with over 1 million downloads, where she shares real-world strategies to help spa professionals grow with clarity and confidence.