Download the routine test report checklist
XLSX
Routine test report checklist (Excel)
Header block, 7 columns, a result drop-down, Fail rows in red and Query rows in amber, frozen header row, filters and a How to use sheet.
CSV
Routine test report 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.
When to run it
Run the checklist after the test bay has finished and before the report is signed off for the customer. At that point a missing signature or an absent test costs an hour. Once the unit has shipped it costs a site visit. The checklist suits power and distribution transformers, switchgear panels and similar equipment that is tested unit by unit to a contract test list.
- Test engineers, as a self-check before handing the report over.
- Quality engineers, who approve the report and file it in the record book.
- Project engineers, who know which extra tests the customer ordered on this contract.
Which tests count as routine, type or special depends on the equipment and on the standard the contract names, such as the IEC 60076 series for power transformers. Check the governing standard or contract. For background, see transformer testing and electrical equipment manufacturers.
Header block
| Field | Example |
|---|---|
| Project | Example Substation Extension (fictional) |
| Customer | Example Utility Ltd (fictional) |
| Purchase order | PO-EX-6230 (fictional) |
| Equipment | Distribution transformer, serial EX-TR-24017 (fictional) |
| Test standard named in the contract | As stated in the contract (for example IEC 60076-1 for a power transformer) |
| Routine test report | RTR-EX-6230 Rev 0 |
| Test date(s) | 2027-03-09 |
| ITP and contract test list | ITP-EX-6230 Rev B; technical schedule TS-EX-02 section 6 |
| Checklist no. | RTC-EX-6230 |
| Date | 2027-03-11 |
| Prepared by | Test engineer |
| Checked by | Quality engineer |
Example checks: a distribution transformer report
| Item | Area | Check | Checked against | What the report shows | Result | Remarks |
|---|---|---|---|---|---|---|
| 1 | Identification | The report identifies the unit: type, rating and serial number, the same on every sheet | PO-EX-6230 item 1; rating plate drawing RP-EX-6230 Rev A | Serial EX-TR-24017 on sheets 1 to 8; rating as the plate drawing | OK | |
| 2 | Identification | The report names the contract, the test standard with its edition, and the test procedure | PO-EX-6230; test procedure TP-EX-TR-01 Rev A | Standard named without edition or year (sheet 1) | Query | Add the edition the contract names. |
| 3 | Test scope | Every test in the ITP is reported | ITP-EX-6230 Rev B, steps 14 to 21 | Eight tests in the ITP; eight reported | OK | |
| 4 | Test scope | Every test in the contract's test list is reported, including any additional test the customer ordered | Technical schedule TS-EX-02 section 6 | Schedule lists nine tests; item 6.9 is not in the report | Fail | Item 6.9 was ordered as an additional test and is missing from the ITP too. Run it or agree a concession before the report is issued. |
| 5 | Results | Each result is recorded with its guaranteed or specified value alongside, in the same units | Schedule of guarantees TS-EX-02 section 4 (invented contract figures) | No-load loss: specified 1.10 kW, measured 1.07 kW. Load loss: specified 9.50 kW, measured 9.62 kW (sheet 4) | Query | Load loss is above the specified figure. Check the tolerance the contract and the standard it names allow before accepting or rejecting; the report does not state it. |
| 6 | Results | Results are stated at the reference conditions the guarantee uses, and the correction is shown | TS-EX-02 section 4; TP-EX-TR-01 | Reference temperature stated; correction shown on sheet 4 | OK | |
| 7 | Results | The tap position and connection are recorded for each measurement that depends on them | TP-EX-TR-01 | Recorded on sheets 2 to 5 | OK | |
| 8 | Instruments | The instrument ID or serial number is recorded for every test | TP-EX-TR-01; calibration list CL-EX-6230 | IDs given for seven tests; none on sheet 7 | Query | Add the instrument ID to sheet 7 from the test-bay log. |
| 9 | Instruments | Each instrument's calibration was valid on the test date | Calibration list CL-EX-6230 | Power analyser PA-EX-03: due 2027-03-01; test date 2027-03-09 | Fail | Calibration had run out. Raise an NCR; repeat the loss measurements or get the as-found results from recalibration. |
| 10 | Conditions | Ambient and reference conditions are recorded where the test needs them | TP-EX-TR-01 | Ambient and oil temperature recorded on each sheet | OK | |
| 11 | Witness | Witnessed tests are signed by the witness, or a written waiver is attached | ITP-EX-6230 steps 16 and 19 (customer witness) | Customer's inspector signed sheets 1 to 6; sheets 7 and 8 unsigned | Query | Ask the inspector to sign, or attach the waiver. |
| 12 | Deviations | Agreed deviations, concessions and NCRs that affect a test are referenced on the report | Agreed deviation list TDL-EX-6230 Rev A | Item 3 of the deviation list changes one test value; the report does not mention it | Query | Reference TDL-EX-6230 item 3 beside the result. |
| 13 | Deviations | Any repeated test is recorded with the reason and the first result | Quality procedure QP-11 | No test was repeated | Not applicable | |
| 14 | Approval | The report carries a number, revision and date, and is signed by the people the procedure names | TP-EX-TR-01; QP-11 | RTR-EX-6230 Rev 0, dated 2027-03-09; prepared and checked, not approved | Query | Approval signature needed before issue. |
| 15 | Approval | Page count is complete and every attachment listed is attached | Report contents list | Eight sheets and two attachments, all present | OK |
The loss figures in row 5 are an invented contract's specified values and invented measurements. They are not limits from any standard. The row is a query because the report shows a measured value above the specified one without saying what tolerance applies. 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. |
| Area | Identification, Test scope, Results, Instruments, Conditions, Witness, Deviations or Approval. |
| Check | What to confirm on the routine test report. |
| Checked against | The document the report is compared with: the purchase order, the ITP, the contract's test list or schedule of guarantees, the rating plate drawing or the calibration list. |
| What the report shows | What the test report says, with the sheet or page. For results, write the guaranteed or specified value and the measured value side by side, with units. |
| Result | OK, Query, Fail or Not applicable (drop-down). Fail rows turn red; Query rows amber. |
| Remarks | What is wrong or missing, who acts and by when. |
How to use the checklist
- Fill in the header block: the unit and its serial number, the test standard the contract names, the report number and revision, and the ITP and contract test list you will check against.
- Start with identification. The serial number and rating on the report must be the unit's own, on every sheet.
- Lay the report beside the ITP and the contract's test list. Every test in either must appear in the report. Which tests are routine, type or special for your equipment comes from the contract and the standard it names.
- For each result, write the guaranteed or specified value and the measured value side by side in the What the report shows column, with units. Where they differ, the tolerance comes from the contract and the standard; the checklist records the comparison and does not judge it.
- Check the instruments: an ID for every test, and a calibration that was valid on the test date.
- Check that ambient and reference conditions are recorded where the test needs them, and that witnessed tests are signed or waived in writing.
- Check that agreed deviations, concessions and NCRs are referenced beside the results they affect.
- Set the result for each row. Fail rows turn red and Query rows amber. Close each one before the report goes to the customer.
Having the test list and calibration dates read for you
Two of these checks are document comparisons that software can prepare. In OdysseyGPT's Inspection & Testing module, ITP Validator (beta) compares the tests in your ITP with the customer's quality requirements and lists the ones the plan leaves out. Calibration Validity Check (beta) reads the test report and the calibration certificates and flags an instrument whose certificate is missing or had expired on the test date. Each finding points to its source page. A test engineer still reads the results and decides. 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.
