Reinsurance

Property Bordereaux for Reinsurers: Error Catalogue & Fixes

On this page

Last reviewed: November 2026

"It's just another store," the cedent said.

The property bordereau said otherwise: USD 11.8m on one row, against a chain median of USD 1.15m.

Property bordereaux for reinsurers are location-level returns from cedents, listing each risk, its value and its building details.

Errors in property bordereaux for reinsurers flow into pricing, accumulation and the cat exposure returns to reinsurers.

This guide gives you an error catalogue with detection rules and fixes, a triage order and a worked outlier case.

Key Takeaways

  • Test values before locations. A currency or units error moves every row at once.
  • Unknown is a value, not a gap. OED codes 5000 and 1000 mean construction and occupancy are unknown.
  • Compare each row with its peers. A sum insured 10 times the median needs an explanation, not a delete.
  • Rank by value affected. Fix the errors that move the most insured value first.

Which Errors Should a Property Bordereau Check Catch?

A property bordereau check should catch nine errors in four families: location, value, building data, and duplicates or currency.

Field names follow Open Exposure Data (OED), the open exposure format published by Oasis LMF.

ErrorHow it shows upDetection ruleFix
Missing geocodeLatitude and Longitude blank or 0,0Blank, or both values zeroGeocode from address; record Geocoder and AddressMatch
Coarse geocodeCoordinates with one or two decimalsFewer than four decimals, or postcode-level matchRe-geocode to street or building level
Wrong-country pointPoint falls outside the stated countryCoordinates outside the country's boundsCheck for swapped latitude and longitude
Zero sum insuredBuildingTIV of 0 beside a premiumTIV = 0 and premium > 0Request the value; hold the row
Outlier sum insuredOne value far above its peersTIV > 5 times the median for the same occupancyQuery; do not cap or delete
Unmapped codesConstructionCode 5000 or OccupancyCode 1000Share of unknown codes above an agreed limitMap OrgConstructionCode and OrgOccupancyCode to OED
Year built gapYearBuilt 0, blank, 1900 or a future yearOutside 1800 to the current yearRequest it, or band by survey
Duplicate locationsSame address or coordinates twice on a policyRepeated address plus postcode, or identical coordinatesMerge, or confirm separate buildings
Location currency errorLocCurrency missing, or local values marked USDCurrency blank, or value out of line for the countryRestate with the stated exchange rate

The five-times threshold is illustrative. Set it per occupancy with the treaty underwriter.

How do location errors show up on a property bordereau?

Location errors on a property bordereau show up as blank coordinates, coarse coordinates and points in the wrong place.

Precision matters. One degree of latitude is about 111 km, so two decimals place a risk within about 1.1 km.

Four decimals narrow that to about 11 m. OED's GeocodeQuality and AddressMatch fields record how good the match was.

How do sum insured errors show up on a property bordereau?

Sum insured errors on a property bordereau show up as zeros beside premium, values far above peers and whole schedules on one row.

OED splits value into BuildingTIV, ContentsTIV and BITIV.

A cedent putting total insured value in the building field alone distorts every peer test.

Check the total against the policy's declared value, as in exposure to premium reconciliation.

Which building attribute errors weaken a property bordereau?

Building attribute errors that weaken a property bordereau are unmapped codes, unknown defaults and impossible build years.

In the OED construction values, code 5000 means the class is not known. Occupancy 1000 means the same.

Lloyd's Coverholder Reporting Standards include wall and roof construction fields for some property business.

Keep the cedent's original construction code beside the mapped one. That way a wrong mapping can be traced back.

How should duplicate locations and currency be checked on a property bordereau?

Duplicate locations and currency should be checked on a property bordereau before any totals are reported to underwriters.

A duplicate doubles value at one address. Two buildings on one site are not duplicates, so confirm before merging.

LocCurrency is a required OED field. A row without it cannot be converted safely.

Which Property Bordereau Errors Should Be Fixed First?

Property bordereau errors should be fixed in order of the insured value they move.

  1. Currency and units. One wrong currency or a missing "000" changes every row.
  2. Zero and outlier sums insured. These change the amount at risk directly.
  3. Duplicate locations. These double value at one address.
  4. Missing and coarse geocodes. These move accumulation between zones.
  5. Unknown construction and occupancy. These widen the range of modelled loss.
  6. Year built. Useful, but the last to hold up a bordereau.

How Does a Store With 10 Times Its Peers' Value Get Resolved?

A store with 10 times its peers' value gets resolved by querying the row, not by capping or deleting it.

Take an illustrative retail chain of 38 stores ceded on a property quota share.

What did the outlier test show on a store valued at 10 times the chain median?

The outlier test on a store valued at 10 times the chain median flagged store 27: USD 11.8m against a median of USD 1.15m.

That is about 10.3 times the median (11.8 ÷ 1.15). It is well past the five-times threshold.

The other 37 stores total USD 44.4m, so the schedule is USD 56.2m. Store 27 alone is 21.0% of it (11.8 ÷ 56.2).

What did the cedent's reply reveal about the outlier store on the property bordereau?

The cedent's reply revealed that the outlier store was the chain's regional distribution warehouse, coded as a retail shop.

The value was right; the occupancy code was wrong. The cedent corrected it on a resubmitted bordereau.

Had it been a typing error for USD 1.18m, the same test would have caught it. The rule finds the row; the cedent explains it.

How Can a Reinsurer Test Last Year's Property Bordereaux?

A reinsurer can test last year's property bordereaux in six steps, using the catalogue above as the rule set.

  1. Collect four quarters. Use the files as received, not the cleaned copies.
  2. Put them in one layout. Map columns to OED-style names, as in bordereau template mapping.
  3. Run each detection rule. Count rows and total insured value affected per error.
  4. Rank by value. Sort errors by insured value affected, not by row count.
  5. Send the top items. Give the cedent row references and the rule each row failed.
  6. Repeat next quarter. Compare counts to see whether the cedent's data is improving.

Files that feed modelling then need the steps in cat model input preparation.

Resubmitted files go through bordereau resubmission handling.

How Does Insurnest Help With Property Bordereaux for Reinsurers?

Reinsurance Bordereaux Reconciliation does not geocode, map codes or run the location checks above.

It splits premium and claims between reinsurers using the configured participation.

It compares those values with bordereaux, master and settlement records.

It also checks that allocated totals tie back to the bordereaux received.

Mismatches carry a status per reinsurer. Your team decides whether a TIV outlier is a data error.

Key Terms

  • Total insured value (TIV): Building, contents and business interruption value at a location.
  • Geocode precision: How closely coordinates place a risk, often shown by decimal places.
  • OED: Open Exposure Data, an open, model-agnostic exposure format from Oasis LMF.

Sources

Frequently Asked Questions

Which errors should a property bordereau check catch?

A property bordereau check should catch missing or coarse geocodes, zero or outlier sums insured, unknown construction and occupancy codes, year built gaps, duplicate locations and currency errors.

How do location errors show up on a property bordereau?

Location errors on a property bordereau show up as blank or zero coordinates, coordinates with one or two decimals, points in the wrong country and postcode-only addresses.

How do sum insured errors show up on a property bordereau?

Sum insured errors on a property bordereau show up as zero values beside a premium, values ten times their peers, or a whole schedule's value placed on one row.

Which building attribute errors weaken a property bordereau?

Building attribute errors that weaken a property bordereau are cedent codes left unmapped, codes defaulted to unknown, and year built entered as zero, blank or a future year.

Which property bordereau errors should be fixed first?

Property bordereau errors should be fixed in order of value affected: currency and units first, then zero and outlier sums insured, duplicates, geocodes, building codes and year built.

What did the outlier test show on a store valued at 10 times the chain median?

The outlier test on a store valued at 10 times the chain median showed store 27 at USD 11.8m against a chain median of USD 1.15m, about 10.3 times its peers and 21% of the schedule's value.

What did the cedent's reply reveal about the outlier store on the property bordereau?

The cedent's reply revealed that the outlier store was the chain's distribution warehouse, coded as a retail shop. The value was right; the occupancy code was wrong and was corrected on the resubmitted bordereau.

How can a reinsurer test last year's property bordereaux?

A reinsurer can test last year's property bordereaux by putting four quarters in one layout, running each detection rule, ranking errors by value affected and sending the cedent the top items.

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

Reinsurance

Cat Exposure Returns to Reinsurers: Accurate Aggregates

Cat exposure returns to reinsurers need accurate peril aggregates. Use this four-stage checklist on scope, location data, aggregation and sign-off every time.

Read more
Reinsurance

Bordereau Template Mapping: Onboard New Cedent Formats Fast

Bordereau template mapping as a reusable specification: header, field map, code tables, control totals and change log, so new cedent formats onboard cleanly.

Read more
Reinsurance

Cat Model Input Preparation: Clean Cedent Exposure Data

Cat model input preparation cleans cedent exposure schedules before modelling. Follow a worked example, a step-by-step method, key controls and edge cases.

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.