OdysseyGPT

Free template

Certificate of conformance (CoC) template (Excel and CSV)

A one-page certificate form: supplier, purchase order and specification in the header, a table of the items certified with drawing revisions and serial numbers, a statement and a signature block.

By Ademola Afolabi, Founder, New Odyssey Ltd · Last reviewed:

The short answer

A certificate of conformance (CoC) is the supplier's signed statement that the items shipped meet the purchase order and the specifications and drawings it names. This free Excel template is a certificate form with a header block, a table of the items certified, an example statement and a signature block.

Key Takeaways

  • Name the purchase order revision, and the revision of every drawing and specification the items were made to.
  • List serial, heat or batch numbers, so the certificate can be tied to the parts.
  • State agreed deviations and approved concessions on the certificate; do not certify full conformance where one applies.
  • The statement in the file is example wording. Use the wording your contract or quality system requires.

Download the certificate of conformance template

Both files are free under CC BY 4.0, with no form to fill in. The XLSX opens in Excel, Google Sheets, LibreOffice and Numbers. The CSV carries the table only; the header block is in the XLSX. The statement and signature block are also in the XLSX only.

What it is for and who uses it

Most purchase orders for engineered equipment ask for a certificate of conformance with each shipment, and it is usually one of the first pages of the manufacturing record book. It does not replace the records behind it. Where the order asks for material certificates or test reports, those are still needed.

  • Quality managers and quality engineers, who sign it.
  • Document controllers, who file it in the record book.
  • Receiving inspectors on the customer's side, who check it against the delivery.

If the customer supplies its own certificate form, use that form. Check the purchase order for who must sign and what the certificate must state.

Header block

Header block fields, with the invented example values
FieldExample
Certificate no.CoC-EX-3105-01
Date of issue2027-02-05
SupplierExample Valve Manufacturer Ltd (fictional)
Supplier works / addressExample Works, Example Town (fictional)
CustomerExample EPC Contractor Ltd (fictional)
ProjectExample Gas Compression Station, Phase 2 (fictional)
Purchase order / revisionPO-EX-3105 Rev 1 (fictional)
Supplier order no.JOB-EX-0871
Governing specificationPS-VAL-001 Rev 2
Agreed deviations and concessionsTDL-EX-2291 Rev B
Inspection release noteIRN-EX-3105-01
Delivery note / packing listDN-EX-3105-01

Example: items certified on valve order PO-EX-3105

Invented example rows (some columns omitted)
PO itemDescriptionQuantityDrawing / revisionSpecification / standardSerial / batch nos.Supporting recordsDeviation / concession
1Ball valve, trunnion-mounted, 6 in, ASME Class 600, RF flanged, gear operated6 eaGA-BV-0600 Rev BPS-VAL-001 Rev 2; DS-VAL-0600 Rev B; API 6DBV-0871-001 to BV-0871-006Pressure test reports PTR-EX-0871-01 to -06; material certificates in MRB-EX-3105EX-03 (RPTFE seat inserts); EX-08 (tests to API 6D)
2Ball valve, floating, 2 in, ASME Class 600, RF flanged, lever operated4 eaGA-BV-0200 Rev APS-VAL-001 Rev 2; DS-VAL-0200 Rev A; API 6DBV-0872-001 to BV-0872-004Pressure test reports PTR-EX-0872-01 to -04; material certificates in MRB-EX-3105EX-08 (tests to API 6D)
5Commissioning spares: seat and seal kits1 lot (10 kits)Spare parts list SPL-BV-01 Rev AMR-VAL-001 Rev 1 section 6Batch SB-2291Elastomer batch certificate EC-2291None

The file also has Tag(s), Part / model no. and Remarks columns. Every example value is invented: the project, customer, bidders, purchase order, prices and every document, certificate, serial and report number do not exist. Standards are named but not quoted.

Statement and signature block

Example statement

We certify that the items listed above were manufactured, inspected and tested in accordance with the purchase order and the specifications and drawings listed, and that they conform to those requirements, except for the agreed deviations and concessions referenced. The supporting records are held on file and are available on request.

Example wording only. Use the statement your contract, customer or quality system prescribes, and check what the purchase order asks the certificate to state.

Signature block fields, with the invented example values
FieldExample
Authorised signatory (name)Quality manager (fictional)
PositionQuality manager
Signature(signed by hand or electronically)
Date2027-02-05

Columns and what to write

ColumnWhat to write
PO itemThe purchase order line the row certifies.
DescriptionWhat was supplied, as the purchase order describes it.
Tag(s)Equipment tag numbers, where the order uses them.
QuantityQuantity shipped under this certificate, with unit. Say so in Remarks if it is a part shipment.
Part / model no.Your part, figure or model number.
Drawing / revisionThe drawing or datasheet the item was made to, with the revision that applied.
Specification / standardThe specifications and standards the order names for the item, with revision or edition. Name them; do not quote them.
Serial / heat / batch nos.Serial numbers, or heat, lot or batch numbers, so the certificate can be tied to the parts.
Supporting recordsThe test reports, material certificates or record book sections that back the statement.
Deviation / concession ref.Agreed deviations and approved concessions that apply to the item, or None.
RemarksPart shipments, shelf life, storage conditions or anything else the receiver needs.

How to use the template

  1. Check what the purchase order asks for: who must sign, the statement wording, and whether the customer supplies its own certificate form. If it does, use that form.
  2. Fill in the header block: certificate number, supplier, customer, purchase order and revision, governing specification, and the agreed deviation list or concessions.
  3. Add one row per purchase order line shipped under this certificate, with quantity, drawing and revision, and the specifications the order names.
  4. Enter the serial, heat or batch numbers, so the certificate can be tied to the parts and to their records.
  5. List the supporting records and any agreed deviation or approved concession for each row. Write None where there is none; do not leave it blank.
  6. Replace the example statement with the wording your contract or quality system requires.
  7. Have the person your quality system authorises sign and date it, after the final inspection is released. Issue one certificate per shipment and file a copy in the record book.

Checking the record book behind the certificate

OdysseyGPT does not issue certificates of conformance. In its Handover & MRB module, MRB Readiness Check (beta) compares the record package with the customer's required index and reports missing documents, wrong revisions and unsigned records, and MRB Compiler (beta) assembles the book. Every finding cites the page it came from, and your engineers decide what to do with it. Tools marked beta are open on request, and we onboard each team ourselves.

Want us to run the check for you?

Send your MRB index and the customer's document requirements. We send back an MRB readiness report: what is in place, what is missing and what does not match.

Get the free MRB readiness report

New templates by email (optional)

Your download does not depend on this.

We use your email only for this. See our privacy policy.

Frequently asked questions

What is a certificate of conformance?

A signed statement from the supplier that the delivered items meet the purchase order, its specifications and drawings. It identifies the order, the items, the documents they conform to and any agreed deviations.

What should a certificate of conformance include?

The supplier, the customer, the purchase order and its revision, each item with quantity and serial or batch numbers, the drawings and specifications with their revisions, any agreed deviations or concessions, the statement, and a dated signature from an authorised person. Check the purchase order for anything more.

Is a certificate of conformance the same as a material test certificate?

No. A certificate of conformance is a statement about the order. A material test certificate, such as an EN 10204 type 3.1, reports test results for a named heat or batch. Where the order asks for both, one does not replace the other.

Who signs a certificate of conformance?

Someone the supplier's quality system authorises to release product, often the quality manager or a delegate. Check whether the purchase order names who must sign or asks for a customer or third-party countersignature.

Is there a free certificate of conformance template in Excel?

Yes. This XLSX template has a blank certificate form, a filled-in example for an invented valve order and a How to use sheet. A CSV of the item table is also free under CC BY 4.0.

References

Creative Commons Attribution 4.0 International

Creative Commons

Visit source

Related Pages