Download the MTR review checklist
XLSX
MTR review checklist (Excel)
Header block, 6 columns, result drop-down, Fail rows in red and Query rows in amber, frozen header row, filters and a How to use sheet.
CSV
MTR review checklist (CSV)
The example rows as plain CSV (UTF-8), for Google Sheets or any other tool.
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.
What it is for and who uses it
Certificates are checked when material arrives, and again when the record book is compiled. A written checklist makes the first check repeatable and leaves evidence for the second. For the method, see how to review a material test report; for certificate types, see EN 10204 3.1 vs 3.2.
- Goods-in and quality inspectors.
- Quality engineers who accept material for production.
- Document controllers who file certificates in the record book.
Example rows: forged valve body, heat H-1004
| Item | Check | Required | On the certificate | Result | Remarks |
|---|---|---|---|---|---|
| 1 | Certificate type (EN 10204) | Type 3.2 (PS-VAL-001 7.2) | Type 3.1 | Fail | PO requires 3.2. Raise NCR or ask the customer whether 3.1 is acceptable. |
| 2 | Heat number matches the part marking | Heat number on the part = heat on the certificate | H-1004; part marked H-1004 | Pass | |
| 3 | Material specification and grade | ASTM A350 LF2 Class 1 | ASTM A350 LF2 Class 1 | Pass | |
| 4 | Edition of the material specification | Edition named in the PO, if any | Edition not stated | Query | Ask the supplier to confirm the edition. |
| 5 | Product form and size | Forging, size per BOM-BV-0600 item 1 | Forging, size matches | Pass | |
| 6 | Chemical composition | Within the material specification limits, plus any project limits | All elements reported | Pass | Checked against licensed copy of the specification. |
| 7 | Tensile properties (tensile, yield, elongation, reduction of area) | Within the material specification limits | All values reported | Pass | |
| 8 | Impact test temperature and values | Tested at or below the design minimum temperature, −46 °C (PS-VAL-001 3.4) | Charpy at −46 °C, values reported | Pass | Check the average and single minimum values against the specification. |
| 9 | Heat treatment condition | As the material specification requires | Normalized and tempered | Pass | |
| 10 | Hardness, where the project sets a limit | Project hardness limit, if any (PS-VAL-001 4.8 applies only in sour service) | Not reported | Not applicable | Non-sour service per DS-VAL-001 line 22. |
| 11 | Supplementary requirements in the PO | Any supplementary tests named in the PO | None stated | Pass | None ordered. |
| 12 | Signed by the manufacturer's authorised inspection representative | Signature and stamp present | Signed | Pass | |
| 13 | Validated by the purchaser's or third-party inspector (type 3.2 only) | Countersignature for type 3.2 | No countersignature | Fail | Follows from item 1. |
Every example value is invented: the project, customer, purchase order and every document, certificate, heat and report number do not exist. Standards are named but not quoted.
Columns and what to write
| Column | What to write |
|---|---|
| Item | Running number. |
| Check | What to compare. |
| Required (PO / specification) | What the purchase order, specification or material standard requires, with the clause. Check limits against your licensed copy. |
| On the certificate | What the certificate actually states. |
| Result | Pass, Fail, Query or Not applicable (drop-down). Fail rows turn red; Query rows amber. |
| Remarks | Why, and what action follows: query to the mill, NCR, or concession request. |
How to use the template
- Use one copy of the checklist per certificate. Fill in the header: part, certificate number, heat number and the material the PO orders.
- Write down what the purchase order and specification require for each check, with the clause. Read limits from your licensed copy of the material standard; the template does not hold them.
- Copy what the certificate actually says next to each requirement, then set the result.
- Check the heat number on the certificate against the marking on the part, not only against the delivery note.
- Fail rows turn red and Query rows amber. Raise a query to the supplier, a non-conformance, or a concession request for each.
- File the checklist with the certificate in the record book section for material certificates.
Checking a stack of certificates
In OdysseyGPT's Manufacturing QA module, Material Certificate Review (beta) and Material Traceability Check (beta) check certificates against the purchase order and trace each heat to the parts it went into. Every finding cites the page it came from, and your engineers decide what to do with it. These tools are in beta: you can request access, and we onboard each team ourselves.
Want us to run the check for you?
Send up to 20 material certificates and the purchase order. We send back a certificate check report, each finding cited to its page.
