A real example
A real public loss run packet: Friendswood ISD in Texas, 15 pages, seven carrier layouts, one page scanned from paper.
- 15pages
- 7carrier layouts
- 24policy periods found
- 12claims found
- A fewminutes, start to finish
- 161 of 161filled values matched the original
We checked 182 values line by line against the original PDF. 161 were filled in, and all 161 are correct. 0 are wrong. The other 21 were left blank for a person to check instead of guessed. All 7 printed carrier totals match the claims.
The packet is public: Friendswood ISD posted it with an insurance bid.
All 12 claims in the spreadsheet
Swipe the table sideways to see every column.
| Carrier | Claim number | Date of loss | Total incurred | Source page | Check |
|---|---|---|---|---|---|
| Unnamed carrier | blank | 06/28/2019 | $3,200.68 | 1 | needs a look |
| Catalytic Multi-Carrier Subscription | blank | 06/28/2019 | $1,912.00 | 2 | needs a look |
| CNA | E2F1492821 | 06/26/2019 | $84,201.00 | 3 | needs a look |
| CNA | E2D6050121 | 07/26/2016 | blank | 4 | needs a look |
| AIG Loss Run | 501-168276-001 | 04/17/2015 | $7,378.29 | 7 | |
| AIG Loss Run | 501-091014-001 | 09/24/2014 | $582.86 | 7 | |
| AIG Loss Run | 501-494719-001 | 08/25/2017 | $7,333.08 | 11 | |
| AIG Loss Run | 501-354953-001 | 07/26/2016 | $2,114.05 | 11 | |
| First Specialty Insurance Corporation | 20140017455 | 09/24/2014 | $0.00 | 13 | |
| First Specialty Insurance Corporation | 20150024938 | 04/17/2015 | $1,628.48 | 13 | |
| First Specialty Insurance Corporation | 20171126362 | 08/25/2017 | $0.00 | 13 | |
| Velocity Risk Underwriters | blank | 06/28/2019 | $3,705.58 | 14 | needs a look |
“Blank” means the page did not clearly show the value, so we left it empty. “Needs a look” marks rows where a person should check a blank. The spreadsheet also lists all 24 policy periods and whether each one adds up to the carrier’s printed total.
How it works
- 1Forward the PDFs you already get from carriers.
- 2We read every page, scanned or digital, and pull every policy period and claim.
- 3You get one spreadsheet back. Each number shows the page it came from, and each policy period shows whether its claims add up to the carrier’s total.
Your first 20 loss runs are free. After that, $500 a month for up to 500 packets.
Send a few of yours to keshav@atrislabs.com and I’ll send the spreadsheets back.
Email Keshav