How to Clean a Schedule of Values
A schedule of values is the property exposure backbone of a commercial insurance submission. A clean SOV makes underwriter review easier; a messy one creates questions before pricing even begins.
Start with location completeness
Every location should have enough address detail to identify where the exposure sits. At minimum, check street address, city, state or province where relevant, country, and location identifier. Missing address data weakens catastrophe review, territory allocation, and underwriting confidence.
Check TIV and value fields
Total insured value should be numeric and positive. If building, contents, stock, and business interruption values are separate, confirm whether the TIV field is a sum or a separate declared value. Inconsistent value logic is one of the quickest ways to make a property submission hard to trust.
Occupancy and construction matter
A schedule with addresses and values but no occupancy or construction detail is incomplete from an underwriting perspective. Occupancy helps underwriters understand the business activity. Construction helps them understand fire, catastrophe, and damage vulnerability. Missing fields do not always block a quote, but they nearly always create follow-up.
Find duplicate locations
Duplicate locations can inflate values or create confusion about whether a location is intentionally split by building, coverage, tenant, or entity. Before renewal, review repeated address patterns and decide whether they represent true separate exposures or duplicate rows.
Review concentration
Concentration is the share of total insured value sitting in one country, state, city, or site. If one territory holds most of the TIV, explain it clearly in the submission. Concentration does not automatically mean the risk is bad, but unexplained concentration makes the underwriting story weaker.
Use the free SOV cleaner
The ToolDox Schedule of Values Cleaner checks common SOV issues in your browser: missing addresses, missing country or state fields, weak occupancy and construction data, duplicate locations, invalid TIV values, and concentration by territory.