Injectable Inventory & COGS Tracker

Injectables are usually your single biggest product cost, and the easiest to under-track. This tracker calculates cost-per-unit from what you actually paid for each lot, then charges that exact cost to every treatment as you log it, so you always know your real margin, not just your revenue.

This Excel/Google Sheets workbook gives you:

• Product Catalog, your master list of injectable products, brands, and how they're measured
• Lot & Inventory Log, every lot you purchase, with expiration date, cost, and live remaining stock
• Treatment Log, every treatment you perform, pulling product cost straight from the lot used
• Margin Analysis, monthly revenue vs. COGS by product category, your real margin picture

Also includes an Expiration & Reorder Alerts tab that flags lots with unused stock nearing expiration, and shows the dollar value at risk.