Download the MRB index template
XLSX
MRB index (Excel)
Header block, 10 columns, status drop-down, Missing rows in red, frozen header row, filters and a How to use sheet.
CSV
MRB index (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
The record book is often tied to the final payment, and it is usually put together in a rush after shipment. An index kept from the start of the order shows what is missing while there is still time to get it. For what goes in each section, see the manufacturing record book guide. The vendor document register template maps each document to its MRB section as the order runs.
- Document controllers who compile the book.
- Quality engineers who check certificates and reports before they are filed.
- Project managers waiting on the final payment.
Example rows: record book for a valve order
| Section | Content | Required by | Document no. | Covers | Status | Remarks |
|---|---|---|---|---|---|---|
| 1 | Index, certificate of conformity and inspection release note | VDRL E01 | MRB-EX-3105; IRN-EX-3105 | All tags | Received | Release note to be signed by customer inspector. |
| 2 | Final approved drawings and datasheets | VDRL A01, A02 | GA-BV-0600; DS-BV-0600 | All tags | Accepted | |
| 3 | Material certificates and traceability record for pressure-containing parts | VDRL C01; PS-VAL-001 7.2 | MTR-BV-SET; TR-MAP-3105 | Heats H-1001 to H-1004 | Reviewed | Heat H-1004 certificate is 3.1; PO asks for 3.2. Query raised. |
| 4 | Welding records: weld map, WPS, PQR, welder qualifications | PS-VAL-001 8.3 | Not applicable | No pressure-retaining welds on this design. Confirm with the customer. | ||
| 5 | NDE reports and operator qualifications | ITP-BV-01 step 4 | NDE-3105-01 to -06 | Bodies S/N 001-006 | Missing | Reports for S/N 005-006 outstanding. |
| 6 | Heat treatment records | Material specification | On MTRs | Heats H-1001 to H-1004 | Reviewed | Included in section 3 certificates. |
| 7 | Pressure test reports | ITP-BV-01 steps 7-8 | PT-3105-001 to -006 | S/N 001-006 | Received | |
| 8 | Functional and torque test reports | ITP-BV-01 step 9 | FT-3105-001 to -006 | S/N 001-006 | Received | |
| 9 | Coating inspection reports | ITP-BV-01 step 10 | CI-3105-01 | All tags | Received | |
| 10 | Calibration certificates for test instruments | TP-BV-02 section 5 | CAL-0412; CAL-0413 | - | Accepted | Valid on the test dates. |
| 11 | Non-conformance reports and approved concessions | QP-01 section 10 | NCR-118; concession CON-07 | S/N 004 | Received | |
| 12 | Installation, operation and maintenance manual | VDRL D01 | IOM-BV-0600 | All tags | Reviewed | Awaiting customer return. |
The file also has columns for revision, source and page count. 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 |
|---|---|
| Section | Section number in the record book. Follow the customer's index if it gives one. |
| Content | What the section holds. |
| Required by | VDRL code, PO clause or specification clause that asks for it. |
| Document no. | Number of the document or set filed here. |
| Rev | Revision filed. It should be the final accepted revision. |
| Source | Who produces it: own works, sub-supplier, test house or inspector. |
| Covers tags / heats | Which tags, serial numbers or heats it covers, so gaps show. |
| Status | Missing, Received, Reviewed, Accepted or Not applicable (drop-down). Missing rows turn red. |
| Pages | Page count, for the final index. |
| Remarks | Gaps, and what is needed to close them. |
How to use the template
- Ask the customer for its record book index at kickoff. If it gives one, use its sections and order instead of the example sections here.
- Add one row per section, and name the VDRL code, PO clause or specification clause that asks for each.
- As documents arrive, record the document number, revision, source and which tags or heats each covers.
- Set the status. Missing rows turn red. Check that every tag and every heat has its certificates and reports before you mark a section Accepted.
- Use Not applicable only with a reason in Remarks, and confirm it with the customer.
- When every row is Accepted or Not applicable, fill in page counts and issue the index as the front of the record book.
Checking the record book against the order
In OdysseyGPT's Handover & MRB module, MRB Readiness Check (beta), MRB Traceability Verification (beta) and MRB Compiler (beta) check the record book against the customer's document requirements, trace heats and serial numbers through it, and compile the index. 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 your MRB index and the customer's document requirements. We send back an MRB readiness report: what is in place, what is missing and what does not match.
