OdysseyGPT

Free template

Material test report (MTR) review checklist template (Excel and CSV)

A checklist for one mill certificate at a time: certificate type, heat number and marking, grade, chemistry, mechanical and impact tests, heat treatment, supplementary requirements and signatures.

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

The short answer

An MTR review checklist compares one material certificate with the purchase order and specification, line by line: certificate type, heat number against the part marking, grade, chemistry, mechanical and impact results, heat treatment and signatures. This free Excel template records the requirement, what the certificate says and the result for each check.

Key Takeaways

  • One checklist per certificate, filed with it in the record book.
  • Read limits from your licensed copy of the material standard; the template does not hold them.
  • Check the heat number against the marking on the part, not only the delivery note.
  • The example has 13 checks on an invented certificate for heat H-1004.

Download the MTR review checklist

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

Invented example rows for one certificate on PO-EX-3105
ItemCheckRequiredOn the certificateResultRemarks
1Certificate type (EN 10204)Type 3.2 (PS-VAL-001 7.2)Type 3.1FailPO requires 3.2. Raise NCR or ask the customer whether 3.1 is acceptable.
2Heat number matches the part markingHeat number on the part = heat on the certificateH-1004; part marked H-1004Pass
3Material specification and gradeASTM A350 LF2 Class 1ASTM A350 LF2 Class 1Pass
4Edition of the material specificationEdition named in the PO, if anyEdition not statedQueryAsk the supplier to confirm the edition.
5Product form and sizeForging, size per BOM-BV-0600 item 1Forging, size matchesPass
6Chemical compositionWithin the material specification limits, plus any project limitsAll elements reportedPassChecked against licensed copy of the specification.
7Tensile properties (tensile, yield, elongation, reduction of area)Within the material specification limitsAll values reportedPass
8Impact test temperature and valuesTested at or below the design minimum temperature, −46 °C (PS-VAL-001 3.4)Charpy at −46 °C, values reportedPassCheck the average and single minimum values against the specification.
9Heat treatment conditionAs the material specification requiresNormalized and temperedPass
10Hardness, where the project sets a limitProject hardness limit, if any (PS-VAL-001 4.8 applies only in sour service)Not reportedNot applicableNon-sour service per DS-VAL-001 line 22.
11Supplementary requirements in the POAny supplementary tests named in the PONone statedPassNone ordered.
12Signed by the manufacturer's authorised inspection representativeSignature and stamp presentSignedPass
13Validated by the purchaser's or third-party inspector (type 3.2 only)Countersignature for type 3.2No countersignatureFailFollows 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

ColumnWhat to write
ItemRunning number.
CheckWhat 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 certificateWhat the certificate actually states.
ResultPass, Fail, Query or Not applicable (drop-down). Fail rows turn red; Query rows amber.
RemarksWhy, and what action follows: query to the mill, NCR, or concession request.

How to use the template

  1. Use one copy of the checklist per certificate. Fill in the header: part, certificate number, heat number and the material the PO orders.
  2. 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.
  3. Copy what the certificate actually says next to each requirement, then set the result.
  4. Check the heat number on the certificate against the marking on the part, not only against the delivery note.
  5. Fail rows turn red and Query rows amber. Raise a query to the supplier, a non-conformance, or a concession request for each.
  6. 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.

Get the free certificate check

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 should be checked on a material test report?

That the certificate type matches the order, the heat number matches the part marking, the grade and product form are right, chemistry and mechanical results meet the specification, impact tests were done at the required temperature, heat treatment is stated, supplementary requirements are covered and the certificate is signed.

Is there a free MTR review checklist in Excel?

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

References

Creative Commons Attribution 4.0 International

Creative Commons

Visit source

Related Pages