Dietary supplement formulation software that keeps the approved record

What formulation software should hold

A formula is more than a list of ingredients and amounts. The working record also needs ingredient identity, source, potency, overage, serving basis, supplier choice, cost, revision history, and the decisions that approved it. When those facts live in separate files, a change in one place can leave the others behind.

ERRA keeps the formula connected to the ingredient and supplier records it depends on. A released formula version is immutable. Reformulation creates a new version, which preserves the record behind earlier production instead of rewriting it.

The workflow ERRA records

• Create a canonical ingredient record with identity, composition, allergens, third-party program records, country of origin, and supporting documents.
• Connect supplier-specific items, pricing, pack size, minimum order quantity, quote validity, and may-contain allergen facts.
• Build trial and production formula versions with sourcing constraints, overage, proprietary blends, and flavor variants.
• Calculate cost per serving from the formula amount, overage, and current supplier pricing.
• Run deterministic allergen, claim, and release-readiness checks before approval.
• Record named human approvals and keep each decision in the audit trail.

Where a spreadsheet can still be enough

A small team with a handful of stable formulas may be able to govern its work with a carefully controlled spreadsheet and disciplined document storage. The break point usually arrives when several people edit the same formula, supplier facts change, the label is maintained separately, or the team needs to answer which approved version was used for a particular batch.

Software earns its place when it removes duplicate entry and makes the history checkable. It should not turn an unclear process into a more expensive unclear process.

Questions to ask during an evaluation

• Can an approved version be changed in place, or must a new revision be created?
• Does the cost calculation include overage while keeping overage out of the declared label amount?
• Are ingredient and supplier facts inherited by every formula that uses them?
• Can a reviewer see the evidence and the formula change in the same approval record?
• Can the system identify which formula version and supplier lots went into a production batch?
• Can the organization export its records without losing provenance?

Primary sources

• 21 CFR 111.70: specifications
• 21 CFR 111.75: determining whether specifications are met
• 21 CFR 111.205: master manufacturing record requirements

Keep reading