For underwriting teams
An underwriting workbench for loss runs
LossRunReports gives underwriters and underwriting assistants the same loss summary for every submission, whatever the carrier format: claims in one schema, totals reconciled, five years by policy year and line, loss ratio from earned premium, large losses, open reserves and valuation age. Underwriters spend their time on judgment instead of retyping.
The same view for every submission
Twenty carriers print loss runs twenty ways. Underwriting decisions should not depend on which layout arrived.
5-yr loss ratio
27.7%
Frequency
2.4 / yr
Open reserves
$61,500
Every loss run attached to a submission is read into one claims table: claim number, date of loss, report date, claimant, cause, status, paid indemnity, medical and expense, reserves, recoveries and incurred. Cause of loss is mapped to one taxonomy, so a rear-end collision is the same cause whichever carrier coded it.
From that table the workbench builds the five-year summary by policy year and line: claim count, frequency, severity, loss ratio, large losses above your threshold and open reserves. Charts and figures are the same on every account, so comparisons across submissions are fair.
The method behind each number is explained on the loss run analysis page.
Checks you would otherwise do by hand
Every submission is checked before an underwriter opens it.
Valuation age
Reports older than 90 days are marked, with the date and the carrier.
Missing years
Policy terms in the five-year window without a report or a no-loss letter.
Duplicate claims
The same loss reported by two carriers after a mid-term change.
Totals reconciled
Extracted claims compared with totals printed on each report.
How underwriting teams use it
| Team | Typical use |
|---|---|
| Carrier underwriting | A consistent loss summary on every new and renewal submission, attached to the file for the referral or peer review |
| Program administrators | Program-level view of frequency and large losses across insureds, with normalized claims exported to the program system |
| Underwriting assistants | Prepare the loss summary and gap list before the underwriter opens the submission |
| MGA and wholesale desks | Triage the inbound queue by score, see the intake flow on the MGA page |
The underwriter narrative is drafted from the claims: large losses with dates and amounts, trends by year, open reserves and what could still develop. It is a starting point the underwriter edits, not a decision.
Desks that receive broker submissions in volume can use MGA mode, described on MGA submission intake. Workers comp underwriters get medical, indemnity and expense kept apart, see loss runs for workers comp.
Results move into your systems through XLSX, CSV and PDF exports, or through the REST API and webhooks on Enterprise, with SSO, audit log export and retention controls for compliance teams.
Documents are encrypted in transit and at rest, claimant names and FEINs carry field-level encryption, and documents are never used to train AI models. See security.
Consistency across the team
Two underwriters reading the same loss runs should see the same numbers. Manual spreadsheets rarely make that true.
When each assistant builds the loss summary by hand, definitions drift. One includes expense in incurred, another does not. One counts a reopened claim twice. One uses written premium for the loss ratio. Referral reviews then argue about the numbers instead of the risk.
With one schema and one calculation, the summary on every file follows the same rules: incurred including expense with recoveries shown separately, earned premium for loss ratio, one large loss threshold per program and valuation age on every report.
Peer reviews and audits get easier too. Each number traces back to the claim rows behind it, and each claim row traces back to the page of the carrier report it came from. The audit log records who viewed and exported each file.
If you also need the application data, the ACORD forms extraction reads ACORD 125, 126, 130 and 140 into the same account.
Questions from underwriters
Does the workbench make underwriting decisions?
No. It organizes and checks the loss data and drafts a narrative. Pricing, appetite and the decision stay with the underwriter.
How do you handle carriers that report incurred net of recoveries?
Recoveries are kept in their own column and incurred is recalculated the same way for every carrier, so figures are comparable across reports.
Can we set our own large loss threshold?
Yes, per team or program. Large losses are listed separately and the summary can show figures with and without them.
Can we get the normalized claims into our rating tool?
Yes, by export or through the REST API and webhooks on the Enterprise plan.
What happens when a carrier report is a poor scan?
The page is read with text recognition, and any figure that cannot be read with confidence is marked for review instead of guessed. Totals reconciliation also catches misreads, because a wrong digit makes the claims stop adding up to the carrier total. The reviewer sees the source page next to the extracted row and corrects it in place.
Is loss ratio based on written or earned premium?
Earned premium for the same period as the losses, imported per policy term.
See your own loss run read in under a minute
Upload one carrier report or use our sample. No account needed for the first read.