Herbalist Inventory Tracker + Formula Cost Calculator — Google Sheets for Apothecary & Herb Businesses
Finally track your herbs, formulas, and harvests in one place — without building it yourself.For herbalists, apothecaries, and home medicine makers who are tired of losing track of what's in stock, what's expiring, and what a batch actually costs to make.You've got dried herbs going untracked on your shelf. You don't know if that root powder expires next month or next year. You're guessing your formula costs — and probably undercharging. And your wildcrafting harvest notes exist on scattered scraps of paper.This tracker fixes all of that. Six interconnected Google Sheets tabs cover everything: herb inventory by form, formula recipe cost calculator, wildcrafting harvest log with sustainability tracking, expiry dashboard with color-coded alerts, supplier reorder queue, and a one-glance overview dashboard.→ HERB INVENTORY TAB — Track every herb by form (dried, tincture, oil, capsule, powder, fresh). Auto-flags expiring stock in red/orange/yellow. Auto-flags when quantity drops below your reorder threshold.→ FORMULA RECIPE LOG — Enter your ingredients with cost per unit. Total batch cost and cost-per-unit calculate automatically. Suggested retail price auto-calculates at your chosen markup multiplier.→ WILDCRAFTING HARVEST LOG — Record each harvest with location, plant population density, and % taken. Built-in ethical guardrail: flags if you've harvested more than 10% of a population.→ EXPIRY TRACKER DASHBOARD — Auto-populated from your inventory. Shows what's expired, urgent, and expiring soon with plain-English action suggestions.→ SUPPLIER REORDER LIST — Pre-filled with top herb suppliers. Auto-populates reorder queue from your inventory.→ OVERVIEW DASHBOARD — At-a-glance metrics: total inventory value, items needing reorder, formula count, and harvest log summary.✓ Herbalists building their apothecary product line✓ Home medicine makers tracking dozens of herbs✓ Wildcrafters who want ethical harvest documentation✓ Small-batch herbal product sellers pricing formulas correctlyGoogle Sheets file — works on desktop and mobile. Opens on the free Google Sheets plan. No macros, no add-ons, no subscriptions. Just download and go.Get instant access.A 6-tab Google Sheets herbalist OS covering herb inventory by form, formula batch cost calculation, wildcrafting harvest logging with ethical sustainability tracking, expiry alerts, supplier reorder queue, and an overview dashboard. Built for herbalists, apothecaries, and home medicine makers who want to move from scattered paper notes to a functional tracking system.
Get it → pattybun.gumroad.com