OdysseyGPT

Free template

Manufacturing record book (MRB) index template (Excel and CSV)

An index for the final data book: each section, the requirement behind it, the documents filed, which tags and heats they cover, and what is still missing.

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

The short answer

An MRB index lists every section of the manufacturing record book (final data book) with the requirement behind it, the documents filed, the tags and heats they cover, and their status. This free Excel template uses typical sections for engineered equipment and turns missing items red, so gaps show before handover.

Key Takeaways

  • Use the customer's own index when it gives one; the example sections are only a starting point.
  • Record which tags and heats each document covers, so a missing certificate shows up.
  • Not applicable needs a reason and the customer's agreement.
  • The example has 12 sections for an invented ball valve order (PO-EX-3105).

Download the MRB index template

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

Invented example rows for PO-EX-3105 (some columns omitted)
SectionContentRequired byDocument no.CoversStatusRemarks
1Index, certificate of conformity and inspection release noteVDRL E01MRB-EX-3105; IRN-EX-3105All tagsReceivedRelease note to be signed by customer inspector.
2Final approved drawings and datasheetsVDRL A01, A02GA-BV-0600; DS-BV-0600All tagsAccepted
3Material certificates and traceability record for pressure-containing partsVDRL C01; PS-VAL-001 7.2MTR-BV-SET; TR-MAP-3105Heats H-1001 to H-1004ReviewedHeat H-1004 certificate is 3.1; PO asks for 3.2. Query raised.
4Welding records: weld map, WPS, PQR, welder qualificationsPS-VAL-001 8.3Not applicableNo pressure-retaining welds on this design. Confirm with the customer.
5NDE reports and operator qualificationsITP-BV-01 step 4NDE-3105-01 to -06Bodies S/N 001-006MissingReports for S/N 005-006 outstanding.
6Heat treatment recordsMaterial specificationOn MTRsHeats H-1001 to H-1004ReviewedIncluded in section 3 certificates.
7Pressure test reportsITP-BV-01 steps 7-8PT-3105-001 to -006S/N 001-006Received
8Functional and torque test reportsITP-BV-01 step 9FT-3105-001 to -006S/N 001-006Received
9Coating inspection reportsITP-BV-01 step 10CI-3105-01All tagsReceived
10Calibration certificates for test instrumentsTP-BV-02 section 5CAL-0412; CAL-0413-AcceptedValid on the test dates.
11Non-conformance reports and approved concessionsQP-01 section 10NCR-118; concession CON-07S/N 004Received
12Installation, operation and maintenance manualVDRL D01IOM-BV-0600All tagsReviewedAwaiting 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

ColumnWhat to write
SectionSection number in the record book. Follow the customer's index if it gives one.
ContentWhat the section holds.
Required byVDRL code, PO clause or specification clause that asks for it.
Document no.Number of the document or set filed here.
RevRevision filed. It should be the final accepted revision.
SourceWho produces it: own works, sub-supplier, test house or inspector.
Covers tags / heatsWhich tags, serial numbers or heats it covers, so gaps show.
StatusMissing, Received, Reviewed, Accepted or Not applicable (drop-down). Missing rows turn red.
PagesPage count, for the final index.
RemarksGaps, and what is needed to close them.

How to use the template

  1. 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.
  2. Add one row per section, and name the VDRL code, PO clause or specification clause that asks for each.
  3. As documents arrive, record the document number, revision, source and which tags or heats each covers.
  4. 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.
  5. Use Not applicable only with a reason in Remarks, and confirm it with the customer.
  6. 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.

Get the free MRB readiness report

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 goes in a manufacturing record book index?

Each section of the book, the requirement that asks for it, the documents filed with their numbers and revisions, the tags or heats they cover, and their status. Typical sections cover certificates of conformity, approved drawings, material certificates, welding, NDE, heat treatment, test reports, coating, calibration, NCRs and manuals.

Is there a free MRB index template in Excel?

Yes. This XLSX template has a blank index, a filled-in example for an invented valve order 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