WorkflowCommercial Lines Underwriting

Schedule of Values Validation

Schedule of values validation that puts every location on the map, checks its COPE data and its value, and leaves the decision to the underwriter

Every location geocoded and its COPE gaps flagged before the property is priced.

See one case, screen by screen ↓
demo48%of rebuild cost insured at one Baytown warehouse — $9.8M against $20.35M, flat since 2019
demo10questionsto the broker in one email, each with its evidence attached
target1hourto a clean, geocoded 42-location schedule
target100%of locations placed on the roof before the account is priced
In short

What is Schedule of Values Validation?

Checking every location on a broker’s schedule of values before the account is priced: that the address places on the right building, that the COPE data — construction, occupancy, protection, exposure — agrees with property records, permits and surveys, and that the building value is in line with what it costs to rebuild. Schedule of Values Validation does those checks with six agents and leaves each decision to the underwriter.

How to choose AI solutions for insurance →

Updated

The problem

Why property is priced on a schedule nobody believes

A commercial property renewal arrives as the broker’s schedule of values: a spreadsheet in the broker’s own layout, three tabs, thirty-odd columns, the year built buried in the notes. Construction, occupancy, sprinkler and year built fields are blank or wrong, addresses are partial, and building values have been rolled forward for years while the cost to rebuild kept rising.

Before anyone can price it, an underwriting assistant re-keys it into the carrier’s layout, the cat modelling analyst geocodes it and finds locations dropped on a ZIP centroid, and the underwriter chases the broker for the gaps in several separate emails. The under-valued buildings are the quiet risk: under a coinsurance clause, a building carrying half the limit the clause requires is paid about half of a partial loss. Today those are often found at the claim, not at the quote.

estimated≈2.5daysto scrub and geocode a 42-location schedule by hand
typical2–4hoursto clean a single small, complex SOV
typical66%of rebuild cost actually insured, on average, in a 2025 UK study
Where a 42-location schedule’s hours goestimated
By hand20 days
With the solution1 days
  • Re-keying the broker’s layout into ours6 → 0.1 d
  • Geocoding and fixing addresses4 → 0.3 d
  • Checking COPE against records, permits and surveys5 → 0.3 d
  • Checking values against rebuild cost3 → 0.1 d
  • Writing the questions to the broker2 → 0.2 d

Estimated split, in working hours, for one 42-location schedule — about 2.5 days by hand (our estimate), about an hour with the solution (the target).

How it works

How a schedule moves

Six agents read, place, check and value every location on the schedule; the underwriter decides.

What comes in
Schedule in5 sources · broker SOV, property data, hazard maps, last year's schedule, surveys
Agents at work
Schedule readerany layout, 24 fields
Then
Geocoderto the roof
Property data checker
Valuation checkervs rebuild
Then
Hazard mapperflood, coast
Then
Broker query writerone email
A person decides
Property underwriterfixes pins, decides
What comes out
Clean schedule
Questions to the broker
Model-ready exposure file
One case, step by step

One Gulf Coast renewal, from spreadsheet to model-ready file

Harlow & Vane sends the Tidewater Crest Logistics renewal: 42 warehouses, cold stores and truck terminals from Victoria, Texas to Pensacola, Florida, TIV $989.49M, effective 1 November. Here is what happens next, screen by screen, in the working solution.

  1. 01Morning

    Every schedule that came in, on one screen

    Elena Marsh · Senior property underwriter

    Elena opens Accounts: seven schedules, each a stripe of its locations coloured clean, fixed by an agent, needs you or agents reading. Tidewater Crest Logistics — 42 locations, $989.5M TIV, quote due Fri 23 Oct — is marked Ready for you.

  2. 02Earlier, at 06:10

    Six agents read, place, check and value every row

    The agents

    The schedule reader maps the broker’s 31 columns across three tabs to the 24 standard fields. The geocoder drops every pin on the map, then the property data checker and the valuation checker work through each location while the pins change colour.

    “Valuation checker · value per sq ft against rebuild cost for construction, occupancy and area · 5 under 80% · 1 over 130%”

  3. 03Done

    The schedule map: which rows to stop believing

    Elena Marsh · Senior property underwriter

    Green is clean, amber the agents fixed, red needs her. Of 42 locations, 22 are clean, 12 were fixed by an agent and 8 need Elena. Beside the map, the COPE table shows each location’s construction, occupancy, protection and exposure, with suspect values outlined, value per square foot and a bar against rebuild cost. TIV moves from $989.49M submitted to $1,001.71M checked.

    On the map, without anyone looking for it: “Baytown · insured at 48% of rebuild”.

  4. 04Location 23

    A cold store that landed on a ZIP centroid

    Geocoder

    2215 Calcasieu Channel Rd is not in the address file, so it matched only the 70601 ZIP centroid, in flood Zone X. The geocoder searched the parcels on the channel road and found a 96,000 sq ft cold store 5.6 km west, on the ship channel, in Zone AE. It shows the old pin hollow, with a dotted line to its best match — and does not move it on its own.

    “Agents’ best match · cold store, 96,000 sq ft · drag pin 23 here”

  5. 05One drag

    She moves the pin onto the building

    Elena Marsh · Senior property underwriter

    Elena moves pin 23 onto the cold store. It re-geocodes to the roof, the hazard mapper re-runs, and the row, the flood zone and the exposure file update together. Needs you drops to 7.

    “Pin 23 moved to the roof · 5.6 km west · flood Zone X → Zone AE, BFE 8 ft · exposure file updated”

  6. 06Next

    Colour the map by value, not just data quality

    Elena Marsh · Senior property underwriter

    One switch recolours every pin by insured value against rebuild cost: under 60%, 60–80%, 80–130% and over 130%. The comparison uses the checked area and occupancy, so a wrong square footage or a missed freezer cannot hide an under-valued building.

  7. 07Location 17

    Baytown: insured at 48% of rebuild

    Valuation checker

    4410 Port Road is a 212,000 sq ft tilt-up distribution warehouse, masonry non-combustible, built 1998, ESFR sprinklered. The schedule carries $9.8M — $46 per sq ft. Rebuilding it in the Houston area costs about $96 per sq ft, $20.35M. The value has been $9.8M on every schedule since 2019 while the area cost index rose 45%.

  8. 08Location page

    What the broker said, what the agents found, and where

    Elena Marsh · Senior property underwriter

    The location page shows the rebuild build-up (212,000 sq ft × $96 × 1.00 for the Baytown area), the building value on each schedule beside the cost index, every field with its source, and the agents’ run on this location. Elena decides: accept the checked value or keep the broker’s.

    “With 90% coinsurance the building limit of $9.80M is 54% of what is required: a $4.0M partial loss would be paid at about $2.14M, before the deductible.”

  9. 09Drafted

    Ten questions, one email, every one with its evidence

    Broker query writer

    One email to Megan Cole at Harlow & Vane, copied to Raj Patel: the Pasadena sprinklers the 2025 survey found in the office only, the Beaumont freezer addition, the Gentilly row counted twice, five building values under 80% of rebuild. The 12 small corrections the agents made are listed, not asked. Beside it: what the answers change — +$29.99M of building value on the five under-valued locations, −$17.77M for the duplicate, $34.71M into flood Zone AE.

    “Untick a question to leave it out. Nothing goes until you send it.”

  10. 10Ready for modelling

    A model-ready exposure file, unknowns kept unknown

    Tomás Rivera · Catastrophe modelling analyst

    The exposure file shows total insured value by flood zone and by distance to the coast, submitted beside checked, how precisely each location is placed, and the fields the model reads. Floor elevation is known for 6 of 41 locations, so the other 35 go as unknown and the model uses its neutral assumption — never a favourable value.

    “Unknowns stay unknown — never coded as a credit.”

Who it’s for

Built for everyone who touches a property schedule.

The same renewal, seen by the five people who carry it — what their week looked like, and what it looks like now.

EM
Elena MarshSenior property underwriter · authority to $750M TIV
Underwriter
Before
“I can’t price a schedule I don’t believe.” Prices Gulf Coast renewals on whatever survived the scrub.
Now
Opens a map that shows which rows to stop believing, fixes pins by dragging them and decides each finding with its source in view.
RP
Raj PatelUnderwriting assistant · schedules and broker follow-up
Underwriting assistant
Before
“Thirty-one columns, three tabs, and the year built is in the comments.” Re-keys every schedule into the carrier layout.
Now
Confirms a column mapping the agents already made, using last year’s for this broker, and chases one email of answers.
TR
Tomás RiveraCatastrophe modelling analyst · receives exposure files
Cat modelling analyst
Before
“Seven locations on a ZIP centroid and the flood answer is fiction.”
Now
Receives a file with every location’s placement shown, pins still to fix named, and blanks sent as unknown.
GW
Grace WhitfieldRisk engineer · surveys and recommendations
Risk engineer
Before
“My report says the warehouse isn’t sprinklered. The SOV still says yes.”
Now
Her survey page is cited against the schedule row, and the broker is asked about it in the same email as everything else.
DO
Daniel OkoyeVP Commercial Property · co-signs above $750M TIV
Co-signer
Before
Co-signs every account above $750M TIV on the values the broker’s schedule gives him.
Now
Sets the value thresholds himself — the 80% under-insured flag is his — and every change to them is versioned and logged.
Built on the engine

6 agents. Each with one job, and hard limits.

Six agents read, place, check and value every location on the schedule; the underwriter decides.

Schedule reader

Reads any broker spreadsheet layout and maps its columns to the 24 standard fields, using last year’s confirmed mapping for that broker first; normalises construction and occupancy codes.

  • Never fills a blank with a guess — a blank stays blank and is flagged
  • Shows the broker’s value beside every change
Geocoder

Standardises each address and places it on the roof, then the parcel; flags ZIP-centroid and intersection matches, suggests the right building and finds two rows on one parcel.

  • Never moves a pin silently — before and after are shown
  • Low-precision matches go to the underwriter
Property data checker

Compares each row’s COPE fields, area, year built and roof with property data, building permits, risk engineering surveys and last year’s schedule.

  • Proposes; never overwrites the broker’s value
  • Every difference carries its source passage
Valuation checker

Compares value per square foot with the cost to rebuild that construction and occupancy in that area, and finds values rolled forward unchanged.

  • Never changes a limit
  • Uses the checked area and occupancy, not the broker’s
Hazard mapper

Adds flood zone and base flood elevation, distance to the coast, wind tier and protection class to each placed location.

  • Reads published hazard layers only
  • Re-runs when a pin moves
Broker query writer

Drafts one email of questions for the broker, each with its evidence, and leaves out what the agents already fixed.

  • Never sends — the underwriter sends
  • Plain language; no internal codes
Property underwriter

Decides every finding. The agents propose; a named person decides.

Ask in plain words

Ask about any location, in plain words

Ask about any location, value or question on the schedule — or tell it what to change. Every answer cites its source.

Why is Baytown insured at 48% of rebuild?

Because its value has not moved since 2019. 4410 Port Road is a 212,000 sq ft tilt-up distribution warehouse. Rebuilding it in the Houston area costs about $96 per sq ft, $20.35M; the schedule carries $9.8M, $46 per sq ft — the same figure on all eight schedules since 2019, while the area cost index rose 45%. With 90% coinsurance, a partial loss would be paid at only about half.

Which locations would move in the flood model?

Two. Location 23, Lake Charles, was on the 70601 ZIP centroid in Zone X; the building is on the ship channel, Zone AE with a base flood elevation of 8 ft — $34.71M of value. Location 28 is location 27 counted twice, so $17.77M in Zone AE comes out.

Draft the questions for Harlow & Vane

Ready: 10 questions in one email to Megan Cole — five building values under 80% of rebuild, the Pasadena sprinklers, the Beaumont area, the Pensacola freezer, the Mobile construction and the Gentilly duplicate. The 12 small fixes are not asked. Nothing is sent until you press send.

Refer any location under 60% of rebuild to Daniel Okoye

Done. New rule: “Any location below 60% of rebuild is referred to Daniel Okoye.” On this account it catches location 17 (48%); across your open accounts, 3 more. It applies from today and is logged as version 7 of the settings.

Every screen

The working solution, as it ships.

13 screens from the working solution, on its sample data. Pick one to see it large.

The schedule mapEvery location a pin coloured by how far the agents trust its data, with the COPE table, value per square foot and insured-vs-rebuild bar beside it.
AccountsEvery schedule of values that came in, one stripe per account, one cell per location, with quote due dates and status.
Agents at workThe run plays on the map: pins drop as the geocoder places them, then change colour as each check lands.
A pin to fixA location on a ZIP centroid shows hollow, with a dotted line to the building the agents think it is.
Pin moved to the roofMoved onto the cold store, location 23 goes from flood Zone X to Zone AE, and the exposure file updates.
Insured vs rebuildThe map coloured by insured value against rebuild cost: under 60%, 60–80%, 80–130% and over 130%.
Insured at 48% of rebuildThe Baytown warehouse: $9.80M insured against $20.35M to rebuild, $9.8M on every schedule since 2019.
The location pageInsured vs rebuild, the coinsurance effect, the value on each schedule beside the cost index, every field with its source, and the decision.
The cleaned schedule41 locations in the carrier’s layout, 24 fields; each cell changed from the broker’s file is marked, with what the broker sent.
2025 schedule vs 2026Rows matched across years by parcel: new, sold, duplicated, and building values that have not moved while rebuild costs rose.
Questions for the brokerOne email, every question with its evidence, and what the answers change to the TIV — nothing goes until the underwriter sends it.
Model-ready exposure fileTIV by flood zone and distance to the coast, submitted beside checked, placement precision and the fields the model reads.
Your rulesUnder- and over-insured flags, rebuild cost tables, placement needed before pricing, co-signature and the people on the team.
Governance

The underwriter decides, and every decision is on the record.

Every checked value cites its sourceEach difference names the property record, building permit, survey page, rebuild cost table or prior-year row it came from. Click it to read the passage.
Agents propose, the underwriter decidesEvery finding is accepted or overridden by the underwriter. The broker’s value is never overwritten by an agent, and no agent changes a limit.
A moved pin is on the recordNo pin moves silently. A pin moved by hand is logged with its before and after coordinates, and the hazard checks re-run on the new place.
Unknown stays unknownA blank field is never sent to the catastrophe model as a favourable value. It goes as unknown, so the model uses its neutral assumption.
Nothing reaches the broker unsentThe questions are a draft until the underwriter sends them. Accounts above $750M TIV need the co-signature of the VP Commercial Property.
Every step on the activity trailEach agent step and each human decision is recorded with who, what and when — from the schedule upload to the questions drafted — and every change to the settings is versioned.
Configuration

Your property team’s rules, not ours

Thresholds, cost tables and who signs are settings — versioned and logged — not a project.

SettingDefaultChoose from
Flag as under-insured below80% of rebuildAny share, in 5% steps
Flag as possibly over-insured above130% of rebuildAny share, in 10% steps
Rebuild cost tablesKestrel Point cost tables, Oct 2026Your cost tables · a valuation service
Flag a value not moved for3 schedules or more2 · 3 · 5 schedules or more
Placement needed before pricingRoof or parcelRoof only · Roof or parcel · Street or better
Blank fields that stop pricingConstruction, occupancy, year built, sprinkler, areaOn · Off
Questions go to the brokerOnly when the underwriter sends themOn · Off
Co-signature above$750M TIV$500M · $750M · $1B TIV
Connections

Works with the data you already buy and keep

Broker schedules of valuesany spreadsheet layout, any number of tabs
Property and building datathird-party records, county records and building permits
Geocoding and hazard dataaddress file, parcels, flood zones, coast distance, protection class
Prior-year schedulesmatched to this year by parcel, not by row number
Inspection and risk engineering reportssurvey findings cited page by page
Catastrophe modellinga model-ready exposure file, and the cleaned schedule in your layout
What it changes

The difference, in numbers.

Every figure is labelled: a target the solution is built to, an estimate, a typical published result, or a proven one.

target
1hour
to a clean, geocoded 42-location schedule
By hand≈ 2.5 days
With agents≈ 1 hour
target
100%
of locations placed on the roof before the account is priced
41 of 41
on the roof, none on a ZIP centroid
typical
66%
of rebuild cost actually insured, on average, in a 2025 study
66% insured
average, UK 2025

“demo” = seen in the working solution, on its sample account data · “target” = the design goal, measured in the live solution · “estimated” = our estimate · “typical” = published figures (Ping Data, the cost of manual SOV processing — 2–4 hours for a small complex SOV; RebuildCostASSESSMENT.com via Insurance Business, 2025 — UK properties insured at 66% of rebuild cost on average). People, companies, brokers and buildings named on this page are fictional — characters and sample data in the working solution.

Questions

What property underwriting teams ask us.

What is schedule of values validation?

Checking every location on a broker’s schedule of values before the account is priced: that the address places on the right building, that the COPE data — construction, occupancy, protection, exposure — agrees with property records, permits and surveys, and that the building value is in line with what it costs to rebuild. Schedule of Values Validation does those checks with six agents and leaves each decision to the underwriter.

Can it read our brokers’ spreadsheets as they come in?

Yes. The schedule reader reads any spreadsheet layout and any number of tabs, and maps the broker’s columns to the 24 standard fields, using last year’s confirmed mapping for that broker first. In the demo it maps 31 columns across three tabs. A blank stays blank and is flagged; it is never filled with a guess.

How does it find under-insured buildings?

The valuation checker compares each building’s value per square foot with the cost to rebuild that construction and occupancy in that area, using your rebuild cost tables. It flags values under 80% of rebuild, over 130%, and values rolled forward unchanged for three schedules or more — all thresholds you set. It works on the checked area and occupancy, so a wrong square footage cannot hide an under-valued building.

Does it geocode every location to the roof?

The geocoder places each address on the roof, then the parcel. ZIP-centroid and intersection matches are flagged, with the building it believes is right, and go to the underwriter, who moves the pin onto the building. The flood zone, distance to the coast and protection class update with it.

Does the AI change the broker’s values or our limits?

No. The agents propose; the underwriter accepts the checked value or keeps the broker’s for every finding. No agent overwrites the broker’s value, changes a limit or sends anything to the broker, and every step is on the activity trail.

What goes to the catastrophe model?

A model-ready exposure file with the checked locations, how precisely each is placed, and any pins still to fix named at the top. Unknown fields such as floor elevation are sent as unknown, never coded as a favourable value.

Can we set our own thresholds and approvers?

Yes. The under-insured and over-insured flags, the rebuild cost tables, how long a value may stay unmoved, the placement needed before pricing, the fields that stop pricing when blank and the TIV above which a co-signature is needed are all settings. Every change is versioned and logged.

How long does it take to go live?

The Agentic Solution Engine builds and deploys it from your requirements and documents — your schedule layout, rebuild cost tables, underwriting guidelines and a sample of past schedules — and it goes live once every quality gate has passed. We will walk you through it on your own schedules first.

See it on
your schedules.

We’ll run Schedule of Values Validation on a few of your own past schedules of values.