Vessel Schedule Extraction for Marine Reinsurers: Field Spec
On this page
- Key Takeaways
- What Is Vessel Schedule Extraction for Marine Reinsurers?
- Which Fields Belong in a Hull Fleet Schedule for Reinsurers?
- Why Should Vessel Schedules Be Deduplicated by IMO Number, Not Name?
- What Does a Vessel Record Look Like Before and After Cleaning?
- How Should Marine Reinsurers Extract and Test a Vessel Schedule?
- How Does Insurnest Help With Vessel Schedules in Submission Emails?
- Key Terms
- Sources
- Frequently Asked Questions
Last reviewed: November 2026
The hull fleet list had 140 rows. Two were the same bulk carrier, under its current name and last year's name.
Its hull value was counted twice in the accumulation. A third row carried a six-digit IMO number.
Vessel schedule extraction for marine reinsurers is turning a fleet list into one tested record per ship, keyed on the IMO number.
Duplicated or mistyped vessels distort hull accumulations, large-loss scenarios and per-risk layer exposure.
This guide gives you a field-by-field spec, a worked IMO check-digit test, a before-and-after record and dedupe rules.
Key Takeaways
- Key on IMO, never on name. Names, flags and owners change; the IMO number does not.
- Test the check digit. A failed digit is a query, not an automatic rejection.
- Gross tonnage is volume. Do not let deadweight slip into the tonnage column.
- Name the class society. Map abbreviations to one list, flagging non-IACS class.
What Is Vessel Schedule Extraction for Marine Reinsurers?
Vessel schedule extraction for marine reinsurers is the step that turns a fleet list from a hull treaty or facultative submission into clean data.
The list usually arrives as a spreadsheet or PDF table.
Our guide to Excel submission data extraction covers layout problems; this one covers vessel fields.
Which Fields Belong in a Hull Fleet Schedule for Reinsurers?
A hull fleet schedule for reinsurers needs nine core fields, each with a format and a test.
| Field | Format | Valid values | Typical error | Test |
|---|---|---|---|---|
| Vessel name | Text, upper case | Current name only | Prefixes like "M/V", former names in brackets | Strip prefixes; move "ex" names to a separate field |
| IMO number | 7 digits, text | Passes check digit | 6 digits, "IMO" prefix, typo | Length = 7 and check digit passes |
| Flag | Country | One country list | "MT" in one row, "Malta" in another | Lookup against your country table |
| Vessel type | Code list | Bulk, tanker, container and so on | "B/C", "BC", "Bulker" | Map to your type list |
| Gross tonnage | Whole number | Above 0 | Deadweight entered instead | Ratio checks by type; query outliers |
| Year built | 4 digits | 1950 to current year | "'09", build date as text | Convert; age = year now minus build year |
| Hull value | Number plus currency | Above 0 | "12,5m", no currency | Currency stated; decimal mark checked |
| Class society | Code list | IACS member or named other | "LR/BV", blank | Map to the member list below |
| Owner or manager | Text | Named entity | Blank or "TBA" | Query blanks before quoting |
How does the IMO number check digit work?
The IMO number check digit works by weighting the first six digits by 7, 6, 5, 4, 3 and 2 and keeping the last digit of the sum.
IMO CHECK DIGIT
Number : 8 8 1 4 2 7 | 5
Weights : 7 6 5 4 3 2
Products : 56 + 48 + 5 + 16 + 6 + 14 = 145
Last digit of 145 = 5 -> matches the 7th digit: PASS
8814274 -> same sum 145, last digit 5 vs 4: FAIL
Excel (IMO as 7-digit text in B2):
=MOD(MID(B2,1,1)*7+MID(B2,2,1)*6+MID(B2,3,1)*5
+MID(B2,4,1)*4+MID(B2,5,1)*3+MID(B2,6,1)*2,10)
=--MID(B2,7,1)
The python-stdnum documentation uses these same two numbers as valid and invalid examples.
It also notes that many ships carry IMO numbers without a valid check digit. Treat a fail as a query to the broker.
IMO says future numbers may extend to eight digits, so review the length test when that happens.
Why is gross tonnage not the same as deadweight in a vessel schedule?
Gross tonnage is not the same as deadweight in a vessel schedule, because the two measure different things.
Under the Tonnage Convention, gross tonnage is "a function of the moulded volume of all enclosed spaces of the ship".
Deadweight is carrying capacity by weight. A tonnage column mixing the two breaks any size band or rate by size.
Which classification societies count as IACS members?
The classification societies that count as IACS members are the 12 on the IACS member list.
- Europe: Bureau Veritas, Croatian Register, DNV, Lloyd's Register, Polish Register, RINA, Türk Loydu.
- Americas and Asia: ABS, China Classification Society, Indian Register, Korean Register, Nippon Kaiji Kyokai (ClassNK).
Store the society's full name. Flag non-IACS class for the underwriter rather than rejecting it.
Why Should Vessel Schedules Be Deduplicated by IMO Number, Not Name?
Vessel schedules should be deduplicated by IMO number, not name, because the IMO number belongs to the hull for life.
IMO says the number "remains unchanged during the entire life of the ship", even if flag, name, ownership or type changes.
Numbers from ships no longer in service are not reallocated.
Run these two tests on every schedule.
Duplicate IMO : =COUNTIF(B:B,B2)>1
Same name, two IMOs : =COUNTIFS(A:A,A2,B:B,"<>"&B2)>0
A duplicate IMO is one ship counted twice. The same name with two IMO numbers is usually two ships, such as sister vessels, and needs no merge.
Duplicates matter most for accumulation scenarios such as those in marine war, strikes and seizure reinsurance.
What Does a Vessel Record Look Like Before and After Cleaning?
A vessel record before and after cleaning shows each rule from the spec at work. The record below is invented for illustration.
| Field | As received | After cleaning | Rule |
|---|---|---|---|
| Vessel name | m.v. Nordic Star (ex Baltic Dawn) | NORDIC STAR | Prefix removed |
| Former name | (none) | BALTIC DAWN | Moved from brackets |
| IMO number | IMO 951234 | 9512343, broker confirmed | 6 digits: queried, not guessed |
| Flag | MT | Malta | Country table |
| Vessel type | B/C | Bulk carrier | Type list |
| Gross tonnage | 32.5k | 32,500 | Exact figure confirmed |
| Year built | '09 | 2009 | Four digits |
| Hull value | 12,5 m | USD 12,500,000 | Decimal comma; currency confirmed |
| Class society | LR | Lloyd's Register (IACS) | Member list |
| Owner or manager | Blank | Query raised | No quote until answered |
The check digit for 951234 would be 3, but the record waits for the broker. A computed digit can turn a typo into a different real ship.
How Should Marine Reinsurers Extract and Test a Vessel Schedule?
Marine reinsurers should extract and test a vessel schedule with the same routine on every fleet list.
- Map columns to the spec. One target field per source column.
- Normalise. Upper-case names, four-digit years, stated currency, full class names.
- Run the IMO tests. Length and check digit on every row.
- Deduplicate on IMO. Merge true duplicates; keep sister ships apart.
- Check ranges. Gross tonnage, build year and value by vessel type.
- Send one query list. Failed digits, blanks and missing currency together.
Open items join your incomplete reinsurance submissions list until answered.
How Does Insurnest Help With Vessel Schedules in Submission Emails?
Reinsurance Email Intelligence reads marine submission emails with their PDFs, spreadsheets and other supporting files.
It extracts cedent, broker, treaty structure, premium, limits, risk and geography into one view and shows missing items.
It does not validate IMO numbers, map class societies or deduplicate fleets. Those tests stay with your team.
For the wider picture, see AI in marine insurance for reinsurers.
Key Terms
- IMO number: A seven-digit ship identifier, prefixed "IMO", that stays with the hull for life.
- Gross tonnage: A volume-based measure of a ship's enclosed spaces under the 1969 Tonnage Convention.
- IACS: The International Association of Classification Societies, with 12 members.
Sources
- IMO: IMO Identification Number Schemes
- IMO: International Convention on Tonnage Measurement of Ships
- IACS: IACS members
- python-stdnum: stdnum.imo documentation
- Insurnest: Reinsurance Email Intelligence
Frequently Asked Questions
What is vessel schedule extraction for marine reinsurers?
Vessel schedule extraction for marine reinsurers is turning a cedent's or broker's hull fleet list into clean, tested records per ship, keyed on the IMO number, for treaty or facultative analysis.
Which fields belong in a hull fleet schedule for reinsurers?
A hull fleet schedule for reinsurers needs vessel name, IMO number, flag, vessel type, gross tonnage, year built, hull value with currency, classification society and owner or manager.
How does the IMO number check digit work?
The IMO number check digit works by multiplying the first six digits by 7, 6, 5, 4, 3 and 2, adding the results, and taking the last digit of the sum, which must equal the seventh digit.
Why is gross tonnage not the same as deadweight in a vessel schedule?
Gross tonnage is not the same as deadweight in a vessel schedule because gross tonnage measures the moulded volume of enclosed spaces, while deadweight measures carrying capacity by weight.
Which classification societies count as IACS members?
The classification societies that count as IACS members are 12: ABS, BV, CCS, CRS, DNV, IRS, KR, LR, ClassNK, PRS, RINA and Türk Loydu, per the IACS member list.
Why should vessel schedules be deduplicated by IMO number, not name?
Vessel schedules should be deduplicated by IMO number, not name, because IMO says the number stays unchanged even if the ship's flag, name, ownership or type changes.
How should marine reinsurers extract and test a vessel schedule?
Marine reinsurers should extract and test a vessel schedule by mapping each field to the spec, running the IMO check digit, normalising units and class, deduplicating on IMO, then querying failures.
How does Insurnest help with vessel schedules in submission emails?
Insurnest Reinsurance Email Intelligence reads submission emails and attachments into one structured view of risk, limits and geography. It does not validate IMO numbers or deduplicate fleets.

Hitul Mistry
CEO, Insurnest
An InsurTech leader with more than a decade of experience across insurance and technology, focused on solving business problems with the help of technology. Has worked with brokers, insurance carriers, and reinsurance firms across the India, UAE, and US markets.
View LinkedIn profile →