
In-house testing: specs, results and automatic pass/fail

Software
A formula is a plan; testing is how you confirm the real product matches it. Every serious supplement operation tests — actives assay, heavy metals, microbiology, moisture, dissolution, allergens — against a specification, and judges each result pass or fail. Done on paper and in spreadsheets, this is slow and disconnected from the formula. Software that manages the test plan, the results, and the automatic pass/fail — and generates the certificate — closes the loop from formula to verified product. Here is how.
Two halves: the spec and the results
Testing has two parts. First, the test plan or specification: which parameters you will test and the acceptable limits for each — the actives within a tolerance, heavy metals below their limits, microbiology within bounds, moisture, pH, dissolution, allergens, organoleptic. Second, the results: the measured values from the lab, entered against the spec.
The spec defines what "good" means; the results are what actually happened. Software holds both, so testing is structured rather than a pile of lab reports compared by eye.
The limits you already have
Much of the spec is already in the formula's world. The active amounts come from the formula. Heavy-metal and contaminant limits, microbiological limits, and format-specific lab limits are the kind of compliance data the system already holds. So building a test spec draws on what is already known about the product — the spec is not invented from scratch but assembled from the formula and its limits.
Automatic pass/fail
The payoff is automatic judgment. Enter a measured value, and the software compares it to the spec and marks it pass or fail — deterministically, with no manual checking of each number against a limit. A heavy-metal result above its limit fails; an actives assay within tolerance passes. The whole test is summarised as pass or fail, with the failing parameters flagged.
This removes the error-prone manual step of eyeballing results against specs, and makes the verdict instant and consistent — which matters when a missed out-of-spec result could mean releasing a bad product.
Tests on a formula or a batch
Testing happens at two points. During R&D, you test a formula to validate it — does this trial actually deliver and stay within limits? At production, you test a batch to release it — does this physical lot pass? The same testing structure serves both: a test attached to a formula version is R&D validation; a test attached to a batch is QC release. One system, two purposes.
The Certificate of Analysis, generated
The output of testing is the Certificate of Analysis — the document stating what was tested, the results, and that the product met its specification. Because the spec and results are structured data, the CoA is generated from them, consistent and complete, rather than assembled by hand. A test specification sheet can be generated the same way. The documentation that proves the product was verified comes straight from the test data.
Because testing requirements and specifications differ by market, product type, and your own quality system, confirm the parameters and limits that apply to your specific products rather than relying on a general summary.
Where Lemoniq fits
Lemoniq manages testing as a test plan plus results: you define the spec — drawing on the formula's actives and the limits the system already holds — enter measured values, and get an automatic, deterministic pass/fail with failing parameters flagged. Tests attach to a formula version for R&D validation or to a batch for QC release, and the Certificate of Analysis and test spec sheet are generated from the data. The loop from formula to verified product is closed in one place.
The takeaway
Testing verifies that the real product matches the formula — a spec defines acceptable limits, results are measured against it, and each is judged pass or fail. Software that holds the spec (built from the formula and its limits), records results, judges pass/fail automatically, and generates the CoA turns testing from a paper exercise into a connected, reliable step. From formula to tested, verified product, with the certificate to prove it.
Lemoniq manages test specs, results, and automatic pass/fail — for formulas and batches — and generates the Certificate of Analysis from the data. We solve this exact problem. See how it works
Share this article
Relevans posts
Welcome back
What are we formulating today, George?



