MedSpa Inventory System | Excel Tracker, Reorder Calculator (Digital Download)

✨ This Medspa inventory system is built for aesthetic clinics that need consistent stock control without guessing, over-ordering, or running out mid day. It standardizes how you set par levels, trigger reorders, and document receiving so supplies stay available and waste stays low. The outcome is fewer stockouts, cleaner ordering, and inventory that feels controlled instead of reactive.
________________________________________
🧩 System/workflow, not a random bundle—designed around a simple weekly rhythm that any trained team member can run consistently. Most basic packs are a single inventory sheet; this system adds QuickFill clinic branding, Start Here routing, a 60 minute implementation map, par level + reorder point logic that calculates available stock and suggested reorder quantity, an auto-generated reorder list, a purchase order workflow with line items and printable PO output, receiving QC with discrepancy logging, LOT/expiration control with “expiring soon” thresholds, and a dashboard that surfaces reorder volume and inventory value.
________________________________________
🔍 What this fixes quickly:
•    Last minute “we’re out” surprises → reorder triggers that flag items at/below your reorder point
•    Over-ordering and tying up cash → suggested reorder quantities tied to par levels and availability
•    Vendors and ordering notes scattered → one vendor directory with account and lead-time context
•    Receiving done inconsistently → checklist + QC logging so errors and shortages get caught
•    Expired product waste → LOT/EXP logging and rotation support for regulated/high value items
•    “Big inventory day” chaos → weekly spot checks plus a monthly full count routine that stays manageable
________________________________________
📦 You receive a complete set of tools, organized by purpose:
•    Inventory master + reorder logic (par levels, reorder points, available stock, suggested reorder qty, reorder status)
•    Auto-generated reorder list (active items flagged “REORDER” in a clean weekly pick list)
•    Purchase order workflow (PO header, line items tied to Item ID, and a formatted print view for recordkeeping)
•    Receiving system (receiving checklist + QC/discrepancy logging plus an in-tracker receiving log)
•    LOT/expiration control (LOT #, EXP date, location, status, and action notes with review fields)
•    Vendor management (vendor directory with contacts, account details, lead times, and ordering notes)
•    Counting tools (weekly spot-check count sheet plus a monthly full count structure)
•    SOP + training routine (inventory SOP checklist plus a one-page weekly inventory rhythm)
•    Print-ready clinic packet (Letter + A4 print sets for consistent in-clinic use)
•    Tracker quick guide (beginner-friendly setup steps and troubleshooting notes)
________________________________________
🛠️ How to use:
1.    Open Start Here, then choose ONE tracker file (Excel or the Google Sheets labeled version).
2.    In SETUP, enter your vendors, categories, and storage locations to power dropdowns.
3.    In INVENTORY_MASTER, add your top 25–50 items first (Item ID, cost, par level, reorder point, and on hand).
4.    Each week, update on hand counts for fast-moving items and work the REORDER_LIST.
5.    Optional (recommended): create POs and add line items so you have a clean order history and printable POs.
6.    When shipments arrive, follow the receiving checklist, log QC/discrepancies, record LOT/EXP when needed, then update on hand.
________________________________________
💻 File types include DOCX (editable templates), print-ready PDF (US Letter + A4), and XLSX trackers; Microsoft Word + Excel are recommended, and Google Sheets is supported (some formatting may display slightly differently). 
________________________________________
🔒 License + Use (Important) :
✔️ Use for your own clinic / practice (single business)
❌ Not for resale, redistribution, or “template bundle” re-packaging
If you operate multiple locations or offer patient materials as a service, you’ll need the appropriate license upgrade :
• “Extended Clinic License Upgrade (Multi‑Location / Multi‑Domain)”
• “Agency / Multi‑Client License Upgrade”
License upgrades are PER PRODUCT. If you buy multiple MedicalSystemsStudio products, purchase the matching quantity of license upgrades.
👉 Important notes :
- Digital download only (no physical product shipped).
- Due to the nature of digital products, returns/exchanges are not available.
- Provided for general business use and should be reviewed/approved for your clinic’s specific requirements and local regulations.