Reading a property schedule from a spreadsheet into the application
Nobody building a property spreadsheet is thinking about an ACORD 139. Locations arrive in whatever columns the person who manages them uses, while the target is fixed: building value apart from contents, construction class, year built, protection class, and business income. What goes wrong is arithmetic and duplication. A total that does not tie to the rows beneath it, or one location entered twice under two spellings of a street. Any value the reading changes rather than moves belongs on the face of the output.
A certificate request arrives as a sentence in an email, and answering it correctly requires deciding which endorsements the policy actually grants.
The agency management system is the record, and a standardised download feed keeps parts of it current. The feed is positional flat file in origin, its coverage varies by carrier and by line of business, and a policy that arrives without matching an existing record lands in a queue somebody clears by hand.
- Excel
- Indio
- Applied Epic
When this is the wrong thing to build
Pick something else if the schedule arrives as a photograph of a printed list, or if the insured will only give values as one total for the account. Neither gives you rows, and inventing rows to fill an ACORD 139 is worse than typing the ones you were handed.
The constraint that shapes it
Producing a quote or binding coverage happens under a licence that is issued per state and per line, and separately under a carrier appointment, so a person can be licensed without being appointed. More on how this sector works.
A file arrives. The fields come back typed and checkable. Read what this shape is, or start from one of these.
- Reading dates out of a ratified contract
- Abstracting a commercial lease into dated fields
- Filling an MLS input sheet from the listing agreement
- Turning a docket entry into a calendar
- Turning a delivered transcript into a usable set of cites
- Coding a filing fee to the matter that will repay it
- How do I get an insured spreadsheet of locations onto an ACORD 139?
- What does an underwriter need per location on a statement of values?
- Why do total insured values not match the sum of the locations?
- Can a statement of values be built from a property manager export?
- What is the difference between ACORD 139 and ACORD 140?
Back to insurance agencies, or see how this is priced and scoped.