OdysseyGPT

Free template

Calibration certificate checklist template: what to verify behind a test report (Excel and CSV)

One row per instrument used in a test: ID against the test report, laboratory and accreditation, traceability, calibrated range against the value measured, validity on the test date, and as-found and as-left results.

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

The short answer

A calibration certificate checklist verifies each instrument behind a test report: the ID or serial number matches the report, the laboratory meets the accreditation required, traceability to a national standard is stated, the calibrated range covers the value measured, and the certificate was valid on the test date. This free Excel template records each check.

Key Takeaways

  • Copy the instrument ID from the test report, then find the certificate. Not the other way round.
  • Validity is judged on the test date, not on the day you review the record.
  • Range and accuracy rules come from the test procedure or code; the template records the check.
  • The example has 6 instruments behind the pressure tests on an invented valve order (PO-EX-3105).

Download the calibration certificate 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

A test report is only as good as the instruments behind it. Customers and inspectors ask for the calibration certificate of every gauge, recorder and transducer named on a pressure or performance test report, and they check each one against the test date. This checklist runs the same check first. For the background, see calibration certificates for test reports.

  • Test engineers, before a witnessed test and when the report is written.
  • Quality engineers who review test reports for the record book.
  • Customer and third-party inspectors reviewing a supplier's test records.

This is a checklist for reviewing certificates, not a blank calibration certificate. A calibration laboratory issues the certificate in its own format.

What to verify on each calibration certificate

  • Identity: the certificate names the same instrument ID or serial number as the test report.
  • Laboratory: who calibrated it, and whether it holds the accreditation the purchase order or procedure asks for, with the calibration inside its accredited scope.
  • Traceability: the certificate states traceability to a national or international standard and identifies the reference standards used.
  • Range: the value measured in the test sits inside the calibrated range, and range and accuracy meet the rule in the test procedure or code.
  • Dates: the test date falls between the calibration date and the due date.
  • Results: as-found and as-left values are recorded, so you can tell whether earlier tests were affected.

Requirements differ between customers and codes. Check the purchase order, the test procedure and the governing code for what applies to your order.

Header block

Header block fields, with the invented example values
FieldExample
ProjectExample Gas Compression Station, Phase 2 (fictional)
CustomerExample EPC Contractor Ltd (fictional)
Purchase orderPO-EX-3105 (fictional)
Equipment / packageTrunnion-mounted ball valves, 6 in, ASME Class 600
Test report(s)PTR-EX-0871-01 to -06; functional test report FTR-EX-0871
Test date(s)2027-01-20
Test procedureTP-BV-02 Rev B; TP-BV-04 Rev A
Calibration requirementPS-VAL-001 9.2; TP-BV-02 section 5
Checklist no.CALC-EX-3105
Date2027-01-22
Prepared byQuality engineer
Checked byTest engineer

Example rows: instruments behind a valve pressure test

Invented example rows for PO-EX-3105 (some columns omitted)
ItemInstrument and useID / serial no.Calibrated rangeValue in the testDue dateValid on test dateAs-found / as-leftResultRemarks
1Pressure gauge, shell testPG-EX-1140 to 250 bar154 bar (TP-BV-02)2027-02-14YBoth recordedOK
2Pressure gauge, high-pressure seat testPG-EX-1150 to 160 bar113 bar (TP-BV-02)2027-02-02YBoth recordedOKDue 13 days after the test. A retest after 2027-02-02 needs a new certificate.
3Pressure recorder, shell and seat testsPR-EX-0210 to 250 bar154 bar (TP-BV-02)2027-05-03YBoth recordedQueryIn-house certificate. Confirm PS-VAL-001 9.2 accepts in-house calibration, and attach the certificate of the reference gauge used.
4Pressure gauge, low-pressure gas seat testPG-EX-1310 to 10 bar6 bar (TP-BV-02)2027-01-15NBoth recordedFailDue date passed 5 days before the test. Raise an NCR, recalibrate, and agree with the customer whether the test is repeated.
5Pressure transducer, test benchPT-EX-0520 to 400 bar154 bar (TP-BV-02)2027-04-09YBoth recordedQueryCertificate gives serial PT-EX-025; the test report gives PT-EX-052. Confirm which instrument was used and correct the record.
6Torque transducer, operating torque checkTQ-EX-008200 to 2000 N·mAbout 900 N·m (TP-BV-04)2027-12-01YAs-left onlyQueryCheck torque is inside the laboratory's accredited scope. Ask for the as-found results.

The file also has columns for certificate number, ID match, laboratory, accreditation, traceability, range suitability and calibration date. Row 4 shows a gauge whose due date passed before the test, and row 5 a serial number that does not match the test report. 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.

Columns and what to write

ColumnWhat to write
ItemRunning number.
Instrument and useThe instrument and the measurement it made in the test.
ID / serial no. (test report)The instrument ID or serial number written on the test report.
Certificate no.The calibration certificate number and its date of issue.
ID on certificate matchesY, N or Check: the certificate names the same ID or serial number as the test report (drop-down).
Calibration laboratoryWho calibrated it: an external laboratory or your own.
Accreditation as requiredY, N or Check: the laboratory holds the accreditation the PO or procedure asks for, and the calibration is inside its accredited scope (drop-down).
Traceability statedY, N or Check: the certificate states traceability to a national or international standard and identifies the reference standards used (drop-down).
Calibrated rangeThe range and points the certificate covers, with units.
Value measured in the testThe value the instrument measured, from the test report or procedure.
Range and accuracy suit the testY, N or Check: the measured value sits inside the calibrated range, and the range and accuracy meet the rule in the test procedure or code (drop-down).
Calibration dateDate of calibration on the certificate (YYYY-MM-DD).
Due dateNext calibration due date, from the certificate, the sticker or your calibration register (YYYY-MM-DD).
Valid on test dateY, N or Check: the test date falls between the calibration date and the due date (drop-down).
As-found / as-leftBoth recorded, As-left only or Not recorded (drop-down). As-found results show whether earlier tests were affected.
ResultOK, Query or Fail (drop-down). Fail rows turn red; Query rows amber.
RemarksWhat is wrong or missing, and the action.

How to use the template

  1. Fill in the header block: the test reports this checklist sits behind, the test dates, the test procedure and the clause that sets the calibration requirement.
  2. Add one row for every instrument named on the test reports. Copy the ID or serial number from the test report, not from the certificate.
  3. Find the calibration certificate for each instrument and check it names the same ID or serial number.
  4. Check who calibrated it. Where the PO or procedure asks for an accredited laboratory, check the accreditation and that the calibration is inside the accredited scope. Check the certificate states traceability to a national or international standard.
  5. Compare the calibrated range with the value measured in the test. The rule for range and accuracy comes from the test procedure or code; the template records the check.
  6. Enter the calibration date and due date, and check the test date falls between them. If the certificate gives no due date, take it from your calibration register and say so.
  7. Record whether as-found and as-left results are given. An instrument found out of tolerance puts earlier tests in doubt.
  8. Set the result. Fail rows turn red and Query rows amber. Close each one before the test report goes into the record book.

Checking calibration from the documents

In OdysseyGPT's Inspection & Testing module, Calibration Validity Check (beta) reads the test reports and calibration certificates and flags instruments whose certificates are missing, out of date on the test date or do not match. 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 ITP and the customer's quality requirements. We send back what is covered, what is missing and what still needs evidence before the FAT.

Get the free ITP and FAT readiness 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 a calibration certificate show?

The instrument's ID or serial number, the laboratory, the calibration date, the results with their measurement uncertainty, the reference standards used and a traceability statement, and who authorised it. Your purchase order or procedure may ask for more, such as accreditation or as-found results.

Does a calibration certificate have to show a due date?

Not always. Some laboratories leave the next due date off the certificate unless the customer asks for it. In that case take the due date from your calibration register or the instrument's label, and record where it came from.

What if an instrument was out of calibration on the test date?

Treat the test result as in doubt. Raise a non-conformance, have the instrument calibrated and look at the as-found results, then agree with the customer whether the test is accepted or repeated. Check what the purchase order and procedure require.

Is this a calibration certificate template?

It is a checklist for reviewing calibration certificates behind a test report, free as XLSX and CSV. It is not a blank certificate: the laboratory that calibrates an instrument issues the certificate in its own format.

References

Creative Commons Attribution 4.0 International

Creative Commons

Visit source

Related Pages