DEA-Compliant Inventory With Lot-Level Precision

Q: Is Moonshot Clinic inventory tracking DEA compliant?

Yes. Moonshot Clinic tracks every controlled substance transaction (receive, dispense, waste, adjust, destroy) in an immutable audit log enforced by a PostgreSQL trigger that prevents edits or deletions. Lot numbers, NDC codes, expiration dates, performer and witness identities, and before/after quantities are recorded for every transaction. The 2-year minimum retention meets DEA 21 CFR 1304 requirements.

Lot tracking, mg-level dose deduction, FEFO dispensing, and an immutable transaction log that passes DEA inspection. Replace your spreadsheets.

moonshotclinic.com

Inventory management showing controlled substance lots, quantities, and transaction history

Lot Management

Track Every Vial by Lot, NDC, and Expiration

When inventory arrives, log it with the lot number, NDC code, expiration date, quantity, and cost. Each lot is tracked independently so you know exactly which vials are on your shelf, when they expire, and what you paid for them. The supplier directory stores DEA numbers and license information for every vendor.

Individual lot tracking with lot number, NDC, and expiration date
Supplier directory with DEA numbers and license info
Cost tracking per lot for margin analysis
Active, quarantined, expired, and destroyed lot statuses
Near-expiry alerts before drugs hit their expiration window

Drug catalog with NDC codes, unit types, and supplier information

Dose Tracking

Deduct the Exact mg Dose at the Point of Charting

When a provider charts an injection, they select the lot and enter the dose in milligrams. The system deducts the exact amount from that lot's remaining quantity. This matters for multi-dose vials like testosterone cypionate where you dispense partial vials across multiple patients over weeks. No more back-calculating usage from vial counts.

mg-level dose input during chart note signing
Lot selection dropdown with FEFO-sorted options
Automatic deduction from selected lot on note sign
Prior-dispense check prevents double deduction on re-sign
Lot number denormalized into signed note for permanent record

Chart note signing with lot selection and mg dose input for controlled substance

Audit Trail

Every Transaction Is Immutable and DEA-Ready

The transaction log records every inventory event: receive, dispense, waste, adjust, count, and destroy. A PostgreSQL trigger blocks any attempt to update or delete transaction records. Each entry captures the performer, witness (required for controlled substance waste), timestamp, and the quantity before and after. The 2-year minimum retention meets 21 CFR 1304 requirements.

Immutable transaction log enforced at the database level
Transaction types: receive, dispense, waste, adjust, count, destroy
Performer and witness identity recorded on every transaction
Before/after quantity snapshots for complete chain of custody
2-year minimum retention per DEA 21 CFR 1304

Immutable transaction audit trail showing dispensing history with performer and witness

Reconciliation

Physical Counts With Variance Tracking

Run routine counts, biennial inventories, or spot checks. The system compares your physical count against the expected quantity for each lot and flags variances. Discrepancies get a resolution workflow so you can document the reason before closing the count session. No more handwritten count sheets that sit in a drawer.

Routine, biennial, and spot count session types
Expected vs. actual quantity comparison per lot
Variance flagging with resolution documentation
FEFO rotation ensures oldest stock gets dispensed first
Expired lot filtering prevents dispensing past-date inventory

Standard inventory view with quantity tracking and reorder alerts

Inventory FAQ

Common questions about inventory tracking in Moonshot Clinic.

Is Moonshot Clinic inventory tracking DEA compliant?

Yes. Every controlled substance transaction (receive, dispense, waste, adjust, destroy) is recorded in an immutable audit log enforced by a PostgreSQL trigger that prevents edits or deletions. Lot numbers, NDC codes, expiration dates, performer and witness identities, and before/after quantities are recorded for every transaction. The 2-year minimum retention meets DEA 21 CFR 1304 requirements.

Does the system support mg-level dose tracking?

Yes. When a provider charts a dispensed drug, they select the specific lot and enter the dose in milligrams. The system deducts the exact mg amount from that lot's remaining quantity. This is critical for multi-dose vials like testosterone cypionate where you need to track partial-vial usage across multiple patients.

Can I generate audit reports for DEA inspections?

Yes. The immutable transaction log provides a complete chain of custody for every lot. You can view all transactions filtered by drug, lot number, date range, or transaction type. Physical count sessions with variance tracking let you document biennial inventories and spot counts. Every transaction includes the performer, witness, timestamp, and quantity before and after.

DEA-Compliant Inventory With Lot-Level Precision

Track Every Vial by Lot, NDC, and Expiration

Deduct the Exact mg Dose at the Point of Charting

Every Transaction Is Immutable and DEA-Ready

Physical Counts With Variance Tracking

Inventory FAQ

Related Features

E-Prescribing

Clinical Charting

Analytics

See Inventory Tracking in Action