In short: A certificate of analysis – CoA for short, in German "Analysenzertifikat" – is the manufacturer's batch-specific proof of quality: for exactly one batch it sets the agreed specification against the measured result for every parameter and declares the batch released. Anyone who buys raw materials, ingredients or chemicals receives one with every delivery. Tiro reads such certificates from PDFs and scans and returns them as a table – in the example 13 header fields and 16 parameters in four groups, every row with method, specification, result and assessment.
Below is the complete example: the certificate, the extracted data and the result in the app.
What is a certificate of analysis?
The certificate of analysis is the documented answer to the product specification: before shipping, the manufacturer's quality control tests the batch against the agreed or regulatory requirements – identity, assay, purity, contaminants, and depending on the product microbiology – and confirms the result with the signature of the person authorised for release. It is standard wherever substances go into products: food ingredients and additives, active and excipient pharmaceutical ingredients, industrial chemicals, cosmetic raw materials and food-contact packaging. Without a valid CoA, a regulated goods-in does not accept the batch.
One thing to keep in mind: a manufacturer's CoA is not an independent test – it comes from the manufacturer's own QC laboratory (the example below says so explicitly). That is why many buyers combine the certificate per delivery with their own spot checks at a contract laboratory.
Certificate of analysis, test report, mill certificate, CoC – which is which?
Four documents that show up side by side at goods-in and are easily confused:
| Document | Issued by | What it contains |
|---|---|---|
| Certificate of analysis (CoA) | manufacturer's quality control | analytical results of one batch against the agreed specification, with release |
| Test report / lab report | independent contract laboratory (ISO/IEC 17025) | results of a submitted sample per parameter with method and LOQ, often with a limit assessment |
| Mill test certificate / inspection certificate 3.1 | manufacturer's authorised inspection representative (EN 10204, metallic products) | chemical composition and mechanical properties per heat/batch |
| Certificate of conformity (CoC) | manufacturer | declaration of conformity with a standard or the order, usually without measured values |
The lines blur in practice – some manufacturers have testing done externally and still call the document a CoA, and in lab jargon many a test report is called a certificate of analysis. What matters is what the document does: batch-wise specification against result (CoA), independent measurement of a sample (test report), standardised material proof (mill test certificate 3.1) or a mere declaration (CoC).
What a certificate of analysis contains
The layout differs from manufacturer to manufacturer; the content is remarkably stable:
- Product identification: product name and grade (e.g. "food grade, E330, Ph. Eur./FCC"), for chemicals the CAS number – it makes the product unambiguous where trade names are not.
- Batch identification: batch/lot number (the bridge to the physical goods), manufacturing date, best-before or retest date, quantity delivered.
- Reference to the order: customer, purchase order number, often the delivery note number – this is how goods-in matches the certificate to the delivery.
- The results table, the heart of the document: per parameter the test method (pharmacopoeia, ISO or validated in-house method), the unit, the specification (range, "≤" limit or qualitative requirement) and the result – as a number, as "< limit of quantification" or as "conforms". Often grouped by identity, assay, heavy metals, microbiology.
- Release: overall statement that the batch conforms to the specification, name and signature of the releasing person from quality control, date of issue – today often with the note "electronically generated, valid without signature".
Who receives certificates of analysis – and what has to happen with them
Whoever produces substances writes certificates – whoever buys raw materials from many suppliers receives them: goods-in and quality assurance at food and beverage producers, pharmaceutical and supplement manufacturers, chemical and cosmetics plants. Every batch brings a CoA – from every supplier in a different layout, sometimes a clean PDF, sometimes a scan. Before release, the batch number and the values have to be checked against the company's own specification and filed per batch for audits (IFS, FSSC 22000, GMP); many companies additionally transfer the key values into their ERP or LIMS and trend them per supplier over time. That retyping – and the transcription errors that come with it – is the work that can be automated.
Extracting certificates of analysis: from PDF to batch table
A PDF-to-Excel converter copies the page layout into cells. For a certificate of analysis that means group headings land between the parameters, "≤ 0.05" and "< 0.01" become text in the same column, and header fields such as batch and release are missing entirely. Tiro works with fields instead of layout: you define once which header fields and which columns per parameter you need, and every certificate – whichever supplier it comes from – runs into the same table. Numbers are normalised by default: a 99.8 % assay is a number, the manufacturing date an ISO date – and results below the limit of quantification stay as the printed text while the result-value column stays empty, so Excel never calculates with a quantification limit. The quality assurance page shows the same idea for laboratory test reports; for metallic products there is the mill test certificate 3.1, and scanned certificates work as shown under PDFs & scans.
