Reinsurance

Vessel Schedule Extraction for Marine Reinsurers: Field Spec

On this page

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.

FieldFormatValid valuesTypical errorTest
Vessel nameText, upper caseCurrent name onlyPrefixes like "M/V", former names in bracketsStrip prefixes; move "ex" names to a separate field
IMO number7 digits, textPasses check digit6 digits, "IMO" prefix, typoLength = 7 and check digit passes
FlagCountryOne country list"MT" in one row, "Malta" in anotherLookup against your country table
Vessel typeCode listBulk, tanker, container and so on"B/C", "BC", "Bulker"Map to your type list
Gross tonnageWhole numberAbove 0Deadweight entered insteadRatio checks by type; query outliers
Year built4 digits1950 to current year"'09", build date as textConvert; age = year now minus build year
Hull valueNumber plus currencyAbove 0"12,5m", no currencyCurrency stated; decimal mark checked
Class societyCode listIACS member or named other"LR/BV", blankMap to the member list below
Owner or managerTextNamed entityBlank 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.

FieldAs receivedAfter cleaningRule
Vessel namem.v. Nordic Star (ex Baltic Dawn)NORDIC STARPrefix removed
Former name(none)BALTIC DAWNMoved from brackets
IMO numberIMO 9512349512343, broker confirmed6 digits: queried, not guessed
FlagMTMaltaCountry table
Vessel typeB/CBulk carrierType list
Gross tonnage32.5k32,500Exact figure confirmed
Year built'092009Four digits
Hull value12,5 mUSD 12,500,000Decimal comma; currency confirmed
Class societyLRLloyd's Register (IACS)Member list
Owner or managerBlankQuery raisedNo 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.

  1. Map columns to the spec. One target field per source column.
  2. Normalise. Upper-case names, four-digit years, stated currency, full class names.
  3. Run the IMO tests. Length and check digit on every row.
  4. Deduplicate on IMO. Merge true duplicates; keep sister ships apart.
  5. Check ranges. Gross tonnage, build year and value by vessel type.
  6. 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

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

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 →
ShareLinkedInX

Read our latest blogs and research

Featured Resources

AI

AI in Marine Insurance for Reinsurers: Game-Changer

See how ai in Marine Insurance for Reinsurers improves underwriting, claims, and risk intelligence with explainable, regulatory-safe AI.

Read more
Reinsurance

Marine War, Strikes, and Seizure: Reinsurance in Contested Waters

Marine war and seizure reinsurance covers vessels and cargo in contested waters. Explore structures, accumulation, pricing, and analytics for reinsurers.

Read more
Reinsurance

Excel Submission Data Extraction: Clean Cedent Spreadsheets

Excel submission data extraction turns messy cedent spreadsheets into clean underwriting data. See the common traps, key checks and a 6-step fix for reinsurers.

Read more

Meet Our Innovators:

We aim to revolutionize how businesses operate through digital technology driving industry growth and positioning ourselves as global leaders.

circle basecircle base
Pioneering Digital Solutions in Insurance

Insurnest

Empowering insurers, re-insurers, and brokers to excel with innovative technology.

Insurnest specializes in digital solutions for the insurance sector, helping insurers, re-insurers, and brokers enhance operations and customer experiences with cutting-edge technology. Our deep industry expertise enables us to address unique challenges and drive competitiveness in a dynamic market.

Get in Touch with us

Ready to transform your business? Contact us now!

We respond within one business day.