Download the calibration certificate checklist
XLSX
Calibration certificate checklist (Excel)
Header block, 17 columns, Y/N/Check drop-downs, Fail rows in red and Query rows in amber, frozen header row, filters and a How to use sheet.
CSV
Calibration certificate 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
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
| Field | Example |
|---|---|
| Project | Example Gas Compression Station, Phase 2 (fictional) |
| Customer | Example EPC Contractor Ltd (fictional) |
| Purchase order | PO-EX-3105 (fictional) |
| Equipment / package | Trunnion-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 procedure | TP-BV-02 Rev B; TP-BV-04 Rev A |
| Calibration requirement | PS-VAL-001 9.2; TP-BV-02 section 5 |
| Checklist no. | CALC-EX-3105 |
| Date | 2027-01-22 |
| Prepared by | Quality engineer |
| Checked by | Test engineer |
Example rows: instruments behind a valve pressure test
| Item | Instrument and use | ID / serial no. | Calibrated range | Value in the test | Due date | Valid on test date | As-found / as-left | Result | Remarks |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Pressure gauge, shell test | PG-EX-114 | 0 to 250 bar | 154 bar (TP-BV-02) | 2027-02-14 | Y | Both recorded | OK | |
| 2 | Pressure gauge, high-pressure seat test | PG-EX-115 | 0 to 160 bar | 113 bar (TP-BV-02) | 2027-02-02 | Y | Both recorded | OK | Due 13 days after the test. A retest after 2027-02-02 needs a new certificate. |
| 3 | Pressure recorder, shell and seat tests | PR-EX-021 | 0 to 250 bar | 154 bar (TP-BV-02) | 2027-05-03 | Y | Both recorded | Query | In-house certificate. Confirm PS-VAL-001 9.2 accepts in-house calibration, and attach the certificate of the reference gauge used. |
| 4 | Pressure gauge, low-pressure gas seat test | PG-EX-131 | 0 to 10 bar | 6 bar (TP-BV-02) | 2027-01-15 | N | Both recorded | Fail | Due date passed 5 days before the test. Raise an NCR, recalibrate, and agree with the customer whether the test is repeated. |
| 5 | Pressure transducer, test bench | PT-EX-052 | 0 to 400 bar | 154 bar (TP-BV-02) | 2027-04-09 | Y | Both recorded | Query | Certificate gives serial PT-EX-025; the test report gives PT-EX-052. Confirm which instrument was used and correct the record. |
| 6 | Torque transducer, operating torque check | TQ-EX-008 | 200 to 2000 N·m | About 900 N·m (TP-BV-04) | 2027-12-01 | Y | As-left only | Query | Check 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
| Column | What to write |
|---|---|
| Item | Running number. |
| Instrument and use | The 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 matches | Y, N or Check: the certificate names the same ID or serial number as the test report (drop-down). |
| Calibration laboratory | Who calibrated it: an external laboratory or your own. |
| Accreditation as required | Y, 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 stated | Y, N or Check: the certificate states traceability to a national or international standard and identifies the reference standards used (drop-down). |
| Calibrated range | The range and points the certificate covers, with units. |
| Value measured in the test | The value the instrument measured, from the test report or procedure. |
| Range and accuracy suit the test | Y, 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 date | Date of calibration on the certificate (YYYY-MM-DD). |
| Due date | Next calibration due date, from the certificate, the sticker or your calibration register (YYYY-MM-DD). |
| Valid on test date | Y, N or Check: the test date falls between the calibration date and the due date (drop-down). |
| As-found / as-left | Both recorded, As-left only or Not recorded (drop-down). As-found results show whether earlier tests were affected. |
| Result | OK, Query or Fail (drop-down). Fail rows turn red; Query rows amber. |
| Remarks | What is wrong or missing, and the action. |
How to use the template
- 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.
- 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.
- Find the calibration certificate for each instrument and check it names the same ID or serial number.
- 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.
- 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.
- 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.
- Record whether as-found and as-left results are given. An instrument found out of tolerance puts earlier tests in doubt.
- 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.
